Restaurant VAT or GST Accounting Spreadsheets

       *** NEW FOR 2027 ***
       Versions now available :
            Sole traders –  spreadsheets  include page to generate quarterly data for submitting to HMRC (using bridging                                                 software ie Vitaltax)

           Limited companies & partnerships – standard version

• Simple restaurant accounting & VAT/GST spreadsheets include 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
• NO bookkeeping experience required, simply record till sales, bankings & payments/expenses
• VAT/GST page will automatically calculate the VAT or 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 your restaurant 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 for UK: one designed for the special flat-rate retail VAT scheme, one for the retail cash VAT scheme and one for non-VAT registered restaurants
• New versions available set up for Australian GST
• Sole trader version automatically generates quarterly data for MTD ITSA submissions (using bridging software such as the Excel Add-in available from www.vitaltax.uk). 
• 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 restaurant takings
• Bank & cash receipts
• Restaurant expenses sheet
• Profit & Loss account (automatically generated)
• Quarterly VAT or GST return summary (automatically calculated)