TidySheetHouse
Small Business Bookkeeping Spreadsheet
Log a sale or a purchase in seconds and get your profit and loss statement and dashboard automatically.
A small business bookkeeping spreadsheet for freelancers, makers, online sellers and side hustles. Log each sale or purchase, pick a category, and your income and expense tracker, profit and loss statement and dashboard update by themselves. Works in Microsoft Excel AND Google Sheets. No accounting software needed.
What You Get
- Small-Business-Bookkeeping-Tracker.xlsx — your template, ready to fill in
- DEMO file — a full sample year, so you can see every chart filled in first
- Quick start PDF — opening it in Excel or Google Sheets takes one minute
5 Tabs
- Start Here — 4 simple steps inside the file
- Setup — business name, currency, year, tax set-aside %, monthly profit goal; 6 income + 18 expense categories ready, rename or add your own (dropdowns follow)
- Transactions — 2,000 ready rows with dropdowns; the category decides income vs expense automatically
- Profit & Loss — automatic monthly statement: every category × 12 months, totals, net profit, margin, tax set-aside, goal progress
- Dashboard — 10 KPI cards (totals, margin, tax to set aside, best month, goal progress…), income vs expenses chart, “where the money goes”, quarterly summary, top 5 expenses and a profit trend
Why This One
- Excel and Google Sheets — many templates work in only one
- No formulas to write, nothing to break — yellow cells are yours, the rest calculates
- Undated — switch the year on Setup and use it again next year
- Profit & Loss and Dashboard print on one page
- Flags transactions that are missing a category, so nothing slips through
- Built for freelancers, makers, Etsy & online sellers, service businesses and side hustles
How It Works
- Download instantly after purchase
- Open in Excel, or upload to Google Drive and open with Google Sheets (free Google account)
- Fill in Setup once, then log your transactions — your P&L and dashboard update instantly
Inside the file
These images are drawn from the real workbook, so what you see is what you download.
Questions
- Is this a subscription?
- No. You pay once, and the files are yours to keep and reuse.
- Does it work in Google Sheets?
- Yes, in Google Sheets and in Excel.
- Do I need accounting skills?
- No. You log your sales and purchases; the formulas do the rest.
- Can I use it next year?
- Yes. Change the year on the Setup tab.
- Designed by me with the help of digital tools, including AI — then tested formula by formula
- Digital product — nothing will be shipped
- Set it up on a computer in Excel or Google Sheets (not tested in Apple Numbers). The Etsy app can't open downloads — use etsy.com › Purchases
- Requires Microsoft Excel 2010+ / Microsoft 365, or a free Google account
- Record-keeping template, not tax or accounting advice
- Questions? Send me a message — happy to help
More templates
2027 Budget Spreadsheet
Budget by paycheck: every payday of 2027 with the bills it has to cover, plus sinking funds and a debt-free date.
Seller Profit & Fee Tracker for Etsy Shops
See every fee on every order, your real profit per product, and the price you need to hit your margin.
Undated Teacher Planner Spreadsheet
Set your first day of school once: calendars, weekly plans, gradebook and attendance date themselves.
Wedding Planner & Budget Spreadsheet
Guest list, RSVPs, seating, caterer counts, budget and vendor payments in one simple file.
Couples Budget Spreadsheet
Split shared bills fairly, even when your incomes differ, and see who owes whom each month in plain words.
Cleaning Business Pricing Calculator
Quote homes and commercial jobs from your real costs and see your margin before you say a number.
Cleaning Business Bundle
The pricing calculator and the bookkeeping tracker together: price every job and track every dollar.