Food Store Accounting Spreadsheets

• Simple accounting spreadsheets for butcher, bakery, deli shop etc
• Full instructions included
• 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
• No bookkeeping experience required, simply record till sales, bankings & payments/expenses
• 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 your food shop bookkeeping
• Expenses sheet contains drop-down menus makes categorising expenses very quick & straightforward
• Provides you with a detailed trading profit & loss account
• 3 spreadsheets are included : one designed for the special flat-rate retail VAT scheme, one for the retail cash VAT scheme and one for non-VAT registered food shops

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

• Daily shop takings
• Bank & cash receipts
• Shop expenses sheet
• Profit & Loss account (automatically generated)
• Quarterly VAT return summary (automatically calculated)