Used Car Dealer Accounting Spreadsheets (Australia)


Simplify your dealership bookkeeping, Australia GST return and  year end accounts preparation. Easy Dealer accounting software for less than the price of a tank of fuel!

All spreadsheets are designed using Microsoft Excel 2003, and will run on all later versions of Excel.
If you do not have Microsoft Excel, then the spreadsheets are compatible with the FREE OpenOffice software, available from

Easy-to-use bookkeeping & GST spreadsheet for used car dealers in Australia. This dealer accounts template will simplify your dealership bookkeeping, GST return and year end accounts preparation.

  • Easy-to-use bookkeeping & accounts spreadsheet includes clear step-by-step instructions
  • Choose your financial year end date (financial year end date can be changed to any date in the chosen spreadsheet)
  • Designed for used car dealers using the GST margin scheme
  • For car dealers with other sources of income – vehicle repairs, vehicle hire etc
  • Includes a sales & purchase invoice generator
  • Includes a stock book page
  • Can be easily adjusted for any future changes in GST rates!
  • No bookkeeping experience required
  • Calculates the GST due for each car sale, either for vehicles eligible for the margin scheme, or those where GST must be accounted for using the normal GST rules
  • GST page will automatically calculate the GST due for each quarter
  • The layout, formulas & also the ‘predictive text’ feature of Excel will help reduce the time you need to spend on record-keeping
  • Drop-down menus makes categorising expenses very quick & straightforward
  • Provides you with a guide to your trading profit
  • Two spreadsheets included to cater for additional revenue streams if needed.


Pages include :

  • Stock book & margin calculator
  • Sales & purchase invoice generators
  • Monthly sales list
  • Bank & cash receipts
  • Payments & expenses
  • Profit & Loss account
  • GST return summary