Small Business - Template 77
Small Business Bookkeeping Spreadsheet
Know what came in, what went out, what is still owed and what you need to earn next.
Microsoft Excel◆Google Sheets◆.xlsx files
Enter each transaction once, then use the linked dashboards to review a month, a quarter, a year, five years, a custom date range or three periods side by side. The same workbook keeps your VAT record with Flat Rate and Standard views, an invoice chase list, a rolling 13 week cash flow forecast and break-even pricing together, across twelve linked tabs and 39 charts. You get a blank workbook, a sample workbook filled with a worked business example, and a four page setup guide, with room for 1,600 transactions and 60 invoices.
What's inside · 12 tabs
- Bookkeeping Setup - your currency, start date, categories and monthly profit goals
- Transactions Log - income and expenses in one place, with dropdowns
- Monthly Dashboard - income, expenses, profit, margin and category breakdowns
- Quarterly & Annual Dashboards - three months side by side, and the full year with goal progress
- 5 Year Dashboard - five full years of income, expenses and profit
- Custom Dashboard - any date range you choose
- Comparison Dashboard - three periods side by side, with margin
- VAT & Tax Tracker - a VAT record from your log, with Flat Rate and Standard views
- Invoices & Chasing - outstanding invoices, overdue totals and a chase list
- Cash Flow Forecast & Break Even - a rolling 13 week forecast, break-even revenue and product margins
In Motion
Log it once, review it any way.
Add a transaction and the monthly, quarterly, annual and five year dashboards, the VAT record and the cash flow all update.
Pairs Beautifully With
