IPAddr

To update the lookup tables in Ausbroker or Rent Master you need to go to the EDIT menu then OTHER files then LOOKUP TABLES. Select the table that you want to change from the drop down combo box. Enter the table details from the relevant table shown below. Note that for the water usage tables you don't need to (and can't) enter the last two columns as they are calculated automatically for you.

Sometimes it is useful to use the DELETE WHOLE TABLE button to delete ALL of the existing data for one fee type prior to entering the new data. This is true if the values in the UP TO column have changed from the old version of the fees to the new version.

It is a good idea to print out the current tables PRIOR to changing them. Then if you make a mistake you can always go back and re-enter the original data from your printed list. You can print the tables by clicking on the REPORTS menu then OTHER MASTER REPORTS then FEES LOOKUP TABLES.


This information is put up here for the benefit of our users and we cannot guarantee that it is up-to-date and/or accurate however wewill do our best to keep it up to date AND accurate. We don't get notified when the fees change though so we rely on one of our customers letting us know what needs to be updated and when. You can get further information direct from the source by going to these web sites...


Select The Table to View
Top
BAD: Bank Debits Tax
EMERG: Emergency Services Levy
FHREB: First Home Buyers Rebate
FID: Financial Institutions Duty
RGDIS: Registration of Discharge
RGMOR: Registration of Mortgage
RGTRN14: Registration of Transfer (July 2014)
RGTRN15: Registration of Transfer (July 2015)
RGTRN16: Registration of Transfer (July 2016)
SDMOR: Stamp Duty on Mortgage
SDTRN: Stamp Duty on Transfer
WTR01: Water Charges 2001/2002
WTR02: Water Charges 2002/2003
WTR03: Water Charges 2003/2004
WTR04: Water Charges 2004/2005
WTR05: Water Charges 2005/2006
WTR06: Water Charges 2006/2007
WTR07: Water Charges 2007/2008
WTR08: Water Charges 2008/2009
WTR09: Water Charges 2009/2010
WTR10: Water Charges 2010/2011
WTR11: Water Charges 2011/2012
WTR12: Water Charges 2012/2013
WTR13: Water Charges 2013/2014
WTR14: Water Charges 2014/2015
WTR15: Water Charges 2015/2016
WTR16: Water Charges 2016/2017
Bottom

Top
(Any tax is a BAD tax - but this ones for the Bank Debits Tax!)
BADBank Debits Tax
Max AmtRatePer QtyCorrection
$100.00$0.00$1.00$0.30
$500.00$0.00$1.00$0.70
$5,000.00$0.00$1.00$1.50
$10,000.00$0.00$1.00$3.00
$99,999,999.99$0.00$1.00$4.00

Top
Note that this is a much simpler calculation and table than most of them.
EMERGEmergency Services Levy
Max AmtRatePer QtyCorrection
$99,999,999.00$0.001675$1.00$50.00

Top
Note that this calculates the REBATE and not the stamp duty due.
At this stage this hasn't been updated because I can't work out their formula.
FHREBFirst Home Buyer's Rebate
Max AmtRatePer QtyCorrection
$12,000.00$1.00$100.00$0.00
$30,000.00$2.00$100.00-$120.00
$50,000.00$3.00$100.00-$420.00
$80,000.00$3.50$100.00-$670.00
$130,000.00-$42.00$1,000.00$5,490.00
$99,999,999.99$0.00$100.00$0.00

Top
Note that there is no more FID so entering these details disables the FID calculation.
FIDBank F.I.D.
Max AmtRatePer QtyCorrection
$99,999,999.99$0.00$1.00$0.00

Top
RGDISRegistration of Discharge (01-Jul-2013)
Max AmtI/RatePer/QtyCorrc'Tn
$99,999,999.99$1.00$148.00

Top
RGMORRegistration of Mortgage (01-Jul-2013)
Max AmtI/RatePer/QtyCorrc'Tn
$99,999,999.99$1.00$148.00

Top
RGTRN14Registration of Transfer (July 2014)
RGTRNRegistration of Transfer
Max AmtI/RatePer/QtyCorrc'Tn
$5,000.00$10,000.00$152.00
$20,000.00$10,000.00$167.00
$40,000.00$10,000.00$184.00
$99,999,999.99$75.50$10,000.00-$119.50

Top
RGTRN15Registration of Transfer (July 2015)
RGTRNRegistration of Transfer
Max AmtI/RatePer/QtyCorrc'Tn
$5,000.00$10,000.00$155.00
$20,000.00$10,000.00$171.00
$40,000.00$10,000.00$188.00
$99,999,999.99$77.50$10,000.00-$123.50

Top
RGTRN16Registration of Transfer (July 2016)
RGTRNRegistration of Transfer
Max AmtI/RatePer/QtyCorrc'Tn
$5,000.00$10,000.00$157.00
$20,000.00$10,000.00$174.00
$40,000.00$10,000.00$191.00
$99,999,999.99$79.00$10,000.00-$127.00

If we haven't updated this table for the current rates then you can just change them yourself. Initially put ZERO into the "Corrc'tn" box on the last line. Then do a settlement quote for $100,000 and see what Ausbroker says the fee is and compare it to the actual fee. Whatever the difference between the two fees goes into this box (and it's always a negative number).

eg: FOR 2011 if you look at the difference in the fees between $100,000 and $110,000 it's $651.00 - $582.00 = $69.00 so on the last line the RATE is $69.00. Now, if you put in a rate of $69.00 / $10,000 with $0.00 correction and do a settlement quote for $100,000 then Ausbroker will show a fee of 10 x $69.00 = $690.00 but the correct fee for $100,000 in 2011 is only $582.00 (which is $108.00 less than $690.00) and so you now now what the correction figure is for the last line (it's -$108.00) so if you make the last line $69.00 / $10,000 -$108.00 and you go and do another settlement quote for $100,000 you will now get the correct figure of $582.00


Top
SDMORStamp Duty on Mortgages
Max AmtRatePer QtyCorrection
$10,000.00$0.25$100.00$0.00
$99,999,999.99$0.35$100.00-$10.00

Top
SDTRNStamp Duty on Transfer
Max AmtRatePer QtyCorrection
$12,000.00$1.00$100.00$0.00
$30,000.00$2.00$100.00-$120.00
$50,000.00$3.00$100.00-$420.00
$100,000.00$3.50$100.00-$670.00
$200,000.00$4.00$100.00-$1,170.00
$250,000.00$4.25$100.00-$1,670.00
$300,000.00$4.75$100.00-$2,920.00
$500,000.00$5.00$100.00-$3,670.00
$99,999,999.99$5.50$100.00-$6,170.00

Top
Note that you can't enter the last two columns as they are automatically calculated.
WTR012000/01 Res. Water Charges
Max AmtRatePer QtyCorrection
125.00$0.361.00$0.00
99,999,999.00$0.911.00-$68.75

Top
Note that you can't enter the last two columns as they are automatically calculated.
WTR022001/02 Res. Water Charges
Max AmtRatePer QtyCorrection
125.00$0.381.00$0.00
99,999,999.00$0.941.00-$70.00

Top
Note that you can't enter the last two columns as they are automatically calculated.
WTR032002/03 Res. Water Charges
Max AmtRatePer QtyCorrection
125.00$0.401.00$0.00
99,999,999.00$0.971.00-$71.25

Top
Note that you can't enter the last two columns as they are automatically calculated.
WTR042003/04 Res. Water Charges
Max AmtRatePer QtyCorrection
125.00$0.421.00$0.00
99,999,999.00$1.001.00-$72.50

Top
Note that you can't enter the last two columns as they are automatically calculated.
WTR052004/05 Res. Water Charges
Max AmtRatePer QtyCorrection
125.00$0.441.00$0.00
99,999,999.00$1.031.00-$73.75

Top
Note that you can't enter the last two columns as they are automatically calculated.
WTR062005/06 Res. Water Charges
Max AmtRatePer QtyCorrection
125.00$0.461.00$0.00
99,999,999.00$1.061.00-$75.00

Top
Note that you can't enter the last two columns as they are automatically calculated.
WTR072006/07 Res. Water Charges
Max AmtRatePer QtyCorrection
125.00$0.471.00$0.00
99,999,999.00$1.091.00-$77.50

Top
Note that you can't enter the last two columns as they are automatically calculated.
WTR082007/08 Res. Water Charges
Max AmtRatePer QtyCorrection
125.00$0.501.00$0.00
99,999,999.00$1.161.00-$82.50

Top
Note that you can't enter the last two columns as they are automatically calculated.
WTR092008/09 Res. Water Charges
Max AmtRatePer QtyCorrection
120.00$0.711.00$0.00
520.00$1.381.00-$80.40
99,999,999.00$1.161.00-$220.80

Top
Note that you can't enter the last two columns as they are automatically calculated.
WTR102009/10 Res. Water Charges
Max AmtRatePer QtyCorrection
120.00$0.971.00$0.00
520.00$1.881.00-$109.20
99,999,999.00$2.261.00-$306.80

Top
Note that you can't enter the last two columns as they are automatically calculated.
WTR112011/12 Res. Water Charges
Max AmtRatePer QtyCorrection
120.00$1.281.00$0.00
520.00$2.481.00-$144.00
99,999,999.00$2.981.00-$404.00

Top
Note that you can't enter the last two columns as they are automatically calculated.
WTR122012/13 Res. Water Charges
Max AmtRatePer QtyCorrection
120.00$1.931.00$0.00
520.00$2.751.00-$98.40
99,999,999.00$2.981.00-$218.00

Top
Note that you can't enter the last two columns as they are automatically calculated.
WTR132013/14 Res. Water Charges
Max AmtRatePer QtyCorrection
120.00$2.421.00$0.00
520.00$3.451.00-$123.60
99,999,999.00$3.731.00-$269.20

Top
Note that you can't enter the last two columns as they are automatically calculated.
WTR142014/15 Res. Water Charges
Max AmtRatePer QtyCorrection
120.00$2.321.00$0.00
520.00$3.321.00-$120.00
99,999,999.00$3.591.00-$260.40

Top
Note that you can't enter the last two columns as they are automatically calculated.
WTR152015/16 Res. Water Charges
Max AmtRatePer QtyCorrection
120.00$2.351.00$0.00
520.00$3.361.00-$121.20
99,999,999.00$3.631.00-$261.60

Top
Note that you can't enter the last two columns as they are automatically calculated.
WTR162016/17 Res. Water Charges
Max AmtRatePer QtyCorrection
120.00$2.271.00$0.00
520.00$3.241.00-$116.40
99,999,999.00$3.631.00-$319.20

Note that SA Water may quote the water rates as $2.35 for the first 30kl per quarter and then $3.36 for any further kl up to 130kl per quarter but we store the details per annum and so 30kl per quarter becomes 120 kl per annum with exactly the same rate. So you don't need us to be able to work out what to enter - it's quite simple.

For information on water charges direct from "the horse's mouth" Go to:

or Pricing Information