Explaining a Settlement Adjustment Sheet
A Settlement Adjustment Sheet is used by your Conveyancer or Lawyer when working out council and water rate proportions.
When settlement fall due your conveyancer will have to adjust on current Council and Water Rates as well as any allowances which will need to be made by the vendor to you.
Below is an explanation of how each adjustment is made to ensure that you pay your share and the vendor pays his share.
As you can see from the below example, there are two columns. One “Payable by Purchaser” and one “Payable by Vendor”. For the purpose of this example the settlement date is 22 June 2016.
Payable by Purchaser Collum
Up first is your purchase price, less your deposit (normally 10%) which you paid to the agent which gives you a balance. In this example the price is $690,000.00 less $69,000.00 which was paid to the agent, leaving a balance of $621,000.00 due on settlement.
Payable by Purchaser
Purchase Price (inc GST & any other consideration) $690,000.00
Less Deposit $69,000.00
Council Rates are for the period 1 July to 30 June each year. From this example you can see that the council rate for the year are $1,407.08. In the current council year, i.e. from 1.7.2016 to 30.06.2016 there are 366 days in the year.
As settlement is on 22 June 2016, that only leave us 8 days in the current council year, therefore we take the yearly amount of the rates $1,407.08 divide it by 366 days in a year and multiply it by 8 days left – which equals $30.76. This amount is the amount you allow to the vendor as the new owner.
Current Council Rates For Period 1/07/2015 to 30/06/2016 – 366 days $1407.08
Purchaser allows 8 days For period 22/06/2016 to 30/06/2016 $30.76
Water Rates are for the current quarter. The quarters are as follows:
- 1 July – 30 September
- 30 October – 31 December
- 1 January – 31 March
- 1 April – 30 June
In this example the current quarter is 1/4/2016 to 30/06/2016 where there is 91 days in the quarter. As settlement is on 22 June 2016 that only leaves 8 days in the current water rate quarter, these 8 days are the 8 days in which you will own the property until the next water rate for the next quarter is struck.
Therefore, we take the quarterly rate of $177.91, then divide it by 91 days and then multiply it by 8 – which will equal $15.64. This amount is the amount you allow to the vendor for water rates as the new owner.
Current Water/Sewerage Rates For Period 1/04/2015 to 30/06/2016 – 91 days Purchaser allows 8 days$177.91 Adjusted as Paid For period 22/06/2016 to 30/06/2016 $15.64 $15.64
As the vendor will no longer own the property from 22 June 2016 and water reads are only done every quarter (3 months) the vendor has used water in his time that he has owned the property, therefore, the vendor must give you, the purchaser, an allowance towards water so that when the final quarterly bill is issued to you, you are able to pay the previous water usage. Your Conveyancer will order a special certificate which provides us with details on:
- When the meter was last read;
- The vendors daily average in kilolitres; and
- The dollar amount per kilolitre – which Sydney Water charge $2.276 per kL
Therefore, to work out the water usage if the last reading was done on 02/06/2016 we calculate the usage to the settlement date of 22 June 2016, there is 20 days. We take the 20 days, multiply is by 0.068 kL (daily average) then multiply it by the daily amount that Sydney Water charge which is $2.276 which will equal $3.10 – this amount is payable by the vendor to you.
Water Usage Last meter reading 2/06/2016 Daily Average = 0.068 kL Vendor allows 20 days For period 2/06/2016 to 22/06/2016 $3.10
Vendor allowance for Discharge of Mortgage
If the vendor has a mortgage it will need to be discharged (taken off) on settlement. Normally, your bank that is lending you the money will charge you this fee as they have to pay this fee to the titles office. Therefore, the vendor is allowing you the amount of $136.30 so when your bank lodges your loan documents at the titles office they will have the vendors mortgage taken off at the same time.
Vendor allows for Discharge of Mortgage $136.30
Finalisation of funds due to be paid
To finalise the funds we have to add both columns up.
- Payable by the purchaser – balance of funds due $621,000, plus council rates $30.76, plus water rates $15.64 = $621,046.40
- Payable by vendor – Water usage $3.10 plus discharge of mortgage fee $136.30 = $139.40
Then to finalise we take the amount payable by purchase which is $621,046.40 take away amount payable by vendor $139.40 = $620,907.00 – which then becomes the amount due on settlement.
Totals 139.40 $621,046.40 Less Amount Payable by Vendor $139.40$139.40 AMOUNT DUE ON SETTLEMENT $620,907.00