Used Car Dealer Accounting Spreadsheets (Australia)

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