Hi reader,

Please read below to see the following updates since our last email in January 2024 and other important information about using our site -
  1. Updated calculations
  2. Prime time for these calculations
  3. New videos
  4. New in calculators
You can now view copies of these emails on our website at Main Menu/User Update Emails.

Also, we often add new content or update existing content in response to user requests. So please feel free to let us know what you need and if it has general appeal we will be happy to assist you.
Lodgement Dashboard - BAS (2023)
The import ATO data routine was overwriting formulas in the 3 reporting level columns in that worksheet, resulting in a failure to match any of those levels with the relevant activity statements on the dashboard. That issue has now been fixed.

BAS JobPapers (2024)
We've made some minor formatting changes and added links to YouTube videos on sheets containing instalment variation calculators.

Hire Purchase Calculators (2023 and later)
With the exception of the Hire Purchase Summary and Hire Purchase Payout calculators, each calculator can now be used for any contract date on or before the year end of that calculator. e.g. For a contract beginning on 15/02/19 you can now use the 2023 or 2024 calculator. Previously you had to navigate back to the file for the financial year during which the contract began (2019 in our example).

The Journal worksheet now reconciles journals with the schedule.
Annual Accounts
Annual Accounts (JobPapers)
Full set of workpapers by entity type.
Division 7A Loan
Div 7A Calculator
Div 7A Loan Register
Distributable Surplus
All calcs & agreement.
Summary, multiple loans.
Calculate surplus.
Hire Purchase
HP Monthly Standard
HP Monthly Structured
HP Fortnightly
HP Weekly
HP Payout
HP Summary
Hire purchase schedules for any situation, as well as payout calculations and a summary of multiple HP balances for the GL.
Rental Property
Rental Income - Stand
Rental Income - Pte Use
Rental Income - Foreign
Rental Income - Recon
Calculate rental income, excl private use, convert foreign income & exps, reconcile with return.
Tax Planning
Tax Planning
Project profit, calculate taxable income, apply tax planning measures, calculate tax saved.
The new videos below have been uploaded to YouTube. You can access these videos either from our website at Main Menu/Videos or click on the links below to be taken to our YouTube channel -

GST & FBT Instalment Variations

PAYG Instalment Variations

Lodgement Dashboards

Division 7A Loans
We have started adding links to our YouTube videos in relevant calculations. Keep a lookout for this YouTube logo at the top of the relevant worksheet.
We have also started adding this image in the top blue banner of our spreadsheets.

When clicked, it will open a new email in your default email program addressed to our support email address and a description of the calculator with any version number if applicable will be inserted in the subject line.

This will streamline any contact with us, make clear which file is the subject of your message and make it easier for you to send us feedback.

Please feel free to use this button to request help or send any suggestions you might have in relation to any of our existing calculators.
Please let us know if you need any assistance or have any suggestions for new or improved content.

Dennis Coleman
Accountants Desktop