B&B (non-VAT/GST) Bookkeeping Spreadsheets


Easy-to-use bookkeeping spreadsheets for B&B’s and guest houses.

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

  • Simple accounting spreadsheets for non-VAT/GST registered B&B’s or guest houses
  • 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 sales income, bankings & payments/expenses
  • The layout, formulas & also the ‘predictive text’ feature of Excel will help reduce the time you need to spend on your B&B bookkeeping
  • Sales invoice generator enables you to create an invoice – at the press of a button – from data entered on the income page
  • Expenses sheet contains drop-down menus makes categorising expenses very quick & straightforward
  • Provides you with a detailed trading profit & loss account


Pages include :

  • Income sheet
  • Bank & cash receipts
  • Sales invoice generator
  • B&B expenses sheet
  • Profit & Loss account (automatically generated)