Small Business Bookkeeping Spreadsheet | Sorbet Books Income and Expense Tracker for Excel and Google Sheets | Profit and Loss, Budget, Invoice and Tax Template

Bookkeeping that adds itself up

Sorbet Books is a colourful, beginner-friendly bookkeeping spreadsheet for small businesses. You type each payment once. The workbook handles the rest: tax, net amounts, monthly and yearly totals, charts, budgets, account balances, invoices, a Profit & Loss report and a five-year comparison.

No accounting background needed. If you can type a date and an amount, you can keep proper books.

Who it’s for

• Etsy sellers, makers and online shop owners
• Freelancers, consultants, coaches and creatives
• Salons, cleaners, tutors, photographers and other service businesses
• Side hustles that need real records before tax time

Why it’s different

• Works in Excel 2010 or newer and Google Sheets. No brand-new Excel needed, no Google-only formulas.
• 13 connected tabs. Budget, invoices, quarterly tax, mileage, account balances, P&L and year compare are all built in.
• Multi-year in one file. Keep logging year after year. Change one setting to view any year.
• Your year, your tax. Any currency, any tax name (VAT, GST, Sales Tax, HST), any start month, and a choice of tax-inclusive or tax-added amounts.
• Sample file + blank file. Explore a fully worked example first, then start fresh.
• A 23-page illustrated guide with screenshots, troubleshooting and FAQs.

What’s inside

• Start Here: 5-step quick start, colour key and clickable links to every tab
• Setup: business details, currency, tax rate, profit goal for each month, 20 income categories, 30 expense categories and 12 accounts
• Income log: 1,500 rows with category and account dropdowns, optional tax rate per row, refunds as negative amounts and a category highlighter
• Expense log: 1,500 rows with receipt tracking (missing receipts flagged in pink) and an automatic tax-deductible column
• Monthly dashboard: pick any month, switch Total / Net / Tax, 6 summary cards with change from last month, 3 charts, category tables, week by week cash flow and a profit goal tracker
• Annual dashboard: 7 summary cards, 4 charts (including running profit vs goal), month by month cash flow and income / expense grids by category
• Budget planner: monthly limits per category, money left, % used with traffic-light colours and year-to-date progress
• Accounts: live balance for each bank account, card, wallet and cash pot, with a transfers log and chart
• Invoices: who owes you money, with automatic Paid, Part paid, Open, Due soon and Overdue status, days late and average days to get paid
• Tax summary: tax collected vs paid by quarter, an income tax savings pot and a list of deductible expenses
• Mileage log: trips, round-trip doubling and automatic deduction by month
• Profit & Loss: a print-ready statement for the full year, any quarter or any single month
• Year Compare: five financial years side by side with growth and a trend chart

How it works

1. Fill in Setup once: name, currency, tax rate and your categories.
2. Log money in on Income and money out on Expenses.
3. Open Monthly or Annual and watch every total, chart and goal update.

What you get

• Sorbet-Books-SAMPLE.xlsx (filled with example data)
• Sorbet-Books-BLANK.xlsx (ready for your business)
• Sorbet-Books-User-Guide.docx (illustrated step-by-step guide)

File format and requirements

• .xlsx workbook for Microsoft Excel 2010 or newer (Windows or Mac) and Excel for Microsoft 365
• Google Sheets: upload the file to Google Drive and open it. A free Google account is all you need
• Works on desktop, laptop and tablet. A larger screen is best for the dashboards
• No macros, no add-ins, no subscriptions

Make it yours

Rename categories and accounts, change the currency symbol, set a different goal for busy months and recolour any tab to match your brand. Dashboards and reports are set up to print neatly.

Digital download

This is a digital product, so nothing gets shipped. Your download links appear straight after checkout and in your order email. If anything doesn’t work as described, get in touch and we’ll help.

Sorbet Books helps you keep tidy records. It isn’t tax or legal advice, so check with an accountant or your tax office for your returns. For use in your own business. Please don’t resell or share the files.