This is when you need our Tax Calculator Addin for Excel - which enables you to use excel to calculate pre-judgment interest on hundreds or thousands of transactions.
Interest is calculated at the Reserve Bank of Australia Cash Rate (as at 31 December and 30 June) plus 4%.
Below is a quick 1 minute video of how the =PreJudgeInterest(DateFrom, HearingDate, Amount) works.
[jwplayer config="myplayer" mediaid="3656"]
Our TaxCalculator Addin for Excel is only $39 and available for instant download.
It also includes all the tax rates from 1985 to 2013 plus discount tables and CPI rates.
You can find out more and order here.