Tax Money 2027

Help your small business clients stay ahead of their tax obligations and avoid unexpected cash flow problems with our Tax Money Calculator.

This practical Microsoft Excel workbook helps businesses maintain an up-to-date estimate of their future BAS, income tax and other tax-related payments, so they can identify how much money needs to be set aside to meet these obligations.

Just because the money is in the bank doesn’t mean it’s available to spend.

By recognising tax liabilities as they arise, rather than waiting until payment is due, your clients can make more informed decisions about their available funds and avoid spending money that will ultimately be needed to meet their tax obligations.

Cash flow is the lifeblood of every business, and unexpected tax payments can place significant pressure on even profitable businesses. Many small business owners lack the time, resources or expertise to accurately forecast their tax liabilities and need practical assistance from their accountant.

Give your clients the tools to manage their tax cash flow more effectively.

The Tax Money Calculator offers two flexible approaches:

  • Manage it within your practice – Maintain and update your clients’ projected tax liabilities as part of your ongoing accounting and advisory services.

  • Let your clients manage it themselves – Set up the workbook with the appropriate opening balances and provide it to your clients so they can regularly enter their own financial information and monitor their future tax commitments.

A simple but valuable cash flow management tool that helps your clients plan ahead, avoid unexpected tax bills and make better financial decisions, while creating opportunities for your practice to provide ongoing advisory services.

WARNING: this file is not compatible with Excel version 2019 and prior and cannot be used with the cloud-based version of Excel, or Excel for Mac, or Google Sheets. 

To access all of our content
$1,465.00 P.A. for 5 users!
Monthly plans available

Description

Features

The Process


  • Start at the beginning of any tax period during the financial year
  • Enter unpaid amounts at the start date
  • Add a one-line sumary for each BAS before the start date to estimate income tax YTD
  • From the start date, enter a summary of sales and purchases for your BAS by date ranges that suit the needs of your business
  • Enter PAYG Withholding by pay day
  • Enter actual figures when the related form(s) have been prepared and actuals will replace estimates
  • Enter payments when made and actuals are reduced accordingly
  • See a real-time estimate to the date of your last entry of “tax money” needed for future payment.

Tax Money Monitored


  • BAS – GST
  • BAS – PAYGI
  • Income tax (at EOFY)
  • PAYGW
  • FBT
  • Add 2 more user-defined taxes

The Outcome


A summary of all taxes are brought together in one screen showing for each tax for each tax period –

  • Estimates
  • Actuals
  • Payments
  • Tax Money (the balance)

Licencing


This product is available for unlimited use within your practice and by your client base.

Screenshot – Settings

Screenshot – Prior Year

Screenshot – Current Year Estimates

Screenshot – Current Year Actuals

Screenshot – Payments

Screenshot – Tax Money

TAX MONEY 2027

SITE TOUR