Antique Dealer Accounting Spreadsheets

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 www.vitaltax.uk

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