Antique Dealer Accounting Spreadsheet for year ending in 2020

Antique Dealer Accounting Spreadsheet, Using the Margin VAT System for 2020 year ends

• Easy-to-use bookkeeping spreadsheet includes clear step-by-step instructions
• Set up to record your financial year ending in 2020 (financial year end date can be changed to any date in 2020)
• Designed for antique dealers using the VAT margin scheme
• Includes a sales & purchase invoice generator
• Includes a stock book page as required by HMR&C
• Can be easily adjusted for any future changes in VAT rates!!
• No bookkeeping experience required
• Calculates the VAT due for each sale item, 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 & lose account

• 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 :

• Sales invoice generator
• Purchase invoice generator
• Stockbook & margin calculator
• Quarterly sales list
• Bank & cash receipts
• Expenses & payments
• Profit & Loss account
• VAT return summary

Click here for Antique Dealer Accounting Spreadsheet for year ending in 2018
Click here for Antique Dealer Accounting Spreadsheet for year ending in 2016

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 www.openoffice.org