Small Business Bookkeeping Spreadsheet 2027 - Income, Expenses, Profit & Tax + Payments Due (Excel & Google Sheets)

Keep your business books in one simple spreadsheet - income, expenses, profit, tax and money owed, all updated automatically.

NEW IN THIS VERSION: Payments Due tracker

• Every unpaid invoice in one list

• Marked Paid, Due this week or OVERDUE automatically

• Dashboard shows how much customers still owe you

WHAT'S INCLUDED (2 files)

• Small_Business_Bookkeeping_2027_EXAMPLE.xlsx - filled with a sample year so you can see how it works

• Small_Business_Bookkeeping_2027.xlsx - blank, ready for your business

TABS

• How To Use - simple step-by-step guide

• Settings - year, tax %, mileage rate, your own categories

• Dashboard - income, expenses, profit, margin, money owed + monthly chart

• Income - 500 rows: customer, category, sales tax

• Expenses - 1,000 rows: 21 categories, business-use %

• Mileage - trips with deduction worked out

• Payments Due (NEW) - unpaid invoices, overdue, due this week

• Profit & Loss - every category, month by month

• Tax Summary - year totals, quarterly tax to set aside, missing receipts

HOW IT WORKS

1. Type your business name, year and categories on Settings

2. Add each sale, receipt, trip and invoice in the yellow cells

3. Dashboard, Profit & Loss, tax and money owed update by themselves

WORKS IN: Microsoft Excel, Google Sheets (File > Import) and Apple Numbers.

Instant download. Example numbers are samples only. A record-keeping tool, not tax advice.

Personal / single-business use. Please do not resell or share.

Images made by me from the real spreadsheet; some design help from AI tools.