Antique Dealer Accounting Spreadsheets


Simplify your antique dealer bookkeeping, margin scheme VAT return and  year end accounts preparation.
Maintain your accounting records digitally, as required by HMRC’s new MTD rules for VAT-registered businesses.

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 & VAT spreadsheet for antique dealers using the Margin VAT System . This second hand antiques dealer accounts template will simplify your bookkeeping, VAT return and year end accounts preparation.

  • Easy-to-use bookkeeping & accounts spreadsheet includes clear step-by-step instructions
  • The spreadsheets are set up to record one accounting year
  • Choose the version for financial year end you need to record, for example – the 2023 version is for any financial year ending in 2023
  • Designed for antique dealers using the VAT margin scheme and/or global accounting VAT margin scheme
  • Includes a sales & purchase invoice generator
  • Includes a stock book page as required by HMRC
  • Can be easily adjusted for any future changes in VAT rates!
  • No bookkeeping experience required
  • Calculates the VAT due for each antique sale, either for items eligible for the margin scheme, or those where VAT must be accounted for using the normal VAT rules
  • VAT page will automatically calculate the VAT 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


VAT data can be submitted to HMRC under the new MTD system using bridging software, such as the system available from

Pages include :

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

Note – the video shows the similar spreadsheet set up for second hand car dealers, but many features are shared with the antiques dealer version