AnalystBuilt home Etsy shop

Small Business Finance

Small Business Bookkeeping

Income & expense tracker, monthly profit & loss, tax set-aside and a tax-time Year Summary

Small Business Bookkeeping: For freelancers & small businesses · P&L, tax set-aside, receipt check
For freelancers & small businesses · P&L, tax set-aside, receipt check
  • Small Business Bookkeeping: For freelancers & small businesses · P&L, tax set-aside, receipt check
  • Your month at a glance: Pick a month: profit, year to date and what needs attention
  • Books that tell you what to fix: Missing receipts, unknown categories and bad dates get flagged
  • Tax set-aside, month by month: Covered or short each month · pay-by dates for each quarter
  • Profit & loss, done for you: Gross profit, expenses and net profit — by month and category
  • Tax-time summary, one page: Totals grouped like Schedule C lines — ready for your tax preparer
  • Your categories, your rules: Owner draws, loans & tax payments stay out of your profit
  • See where your money goes: Top expenses, missing receipts, month vs last month, books health

from $12 on Etsy

Price on Etsy may vary (sales, your currency).

View on Etsy
  • Google Sheets + Excel versions included
  • Instant digital download, nothing is shipped
  • Sample data and a Start Here tab
  • One-time purchase, no subscription

Works in Google Sheets (free Google account) and Microsoft Excel 2016 or newer.

Bookkeeping that tells you what to fix. Log what comes in and what goes out, and this spreadsheet does the rest: a monthly profit and loss, a tax set-aside so tax bills never surprise you, missing-receipt alerts, and a one-page Year Summary for tax time.

What's inside

  • Start Here

    Quick guide and settings: business name, currency, fiscal year start, tax set-aside rate, receipt threshold

  • Dashboard

    Pick any month: income, expenses and net profit with year to date, a 12-month chart, "What needs attention", tax set-aside by quarter, top expenses and income, missing receipts, month vs previous month

  • Income

    Log every payment you receive (1,000 rows, drop-down categories and payment methods)

  • Expenses

    Log everything you pay, with a Receipt? column (1,000 rows)

  • Categories

    Your own income and expense categories, each with a type and an optional tax group

  • Monthly Profit & Loss

    Income, cost of sales, gross profit, operating expenses, net profit and margins by month and by category

  • Tax Reserve

    How much to set aside each month and quarter, what you've set aside, pay-by dates and Covered / Short / Due soon / Past due status

  • Year Summary

    One printable page: totals by tax group, by payment method, receipt coverage and the year's P&L

Why you'll like it

  • Tells you what to fix: a Check column on every row flags missing dates, wrong amounts, unknown categories and missing receipts, and the Dashboard lists what needs attention
  • Never lose a receipt: set your own threshold and see the biggest expenses still missing one
  • Tax set-aside: monthly and quarterly amounts with optional pay-by dates, so you know if you're on track
  • Automatic monthly P&L by category, fiscal-year aware, with a month selector and year to date
  • Tax-time Year Summary grouped like common US Schedule C headings, ready to hand to your tax preparer
  • Owner draws, loans and tax payments are kept out of your profit (and never flagged for a receipt)
  • Any currency; sample data included so you see it working (clearing it takes a minute)
  • Built by a data analyst — every number is a formula you can trace. No subscription, no app

How you get it

  1. Download on Etsy

    Buy the template on Etsy, then download START-HERE.pdf and the Excel .zip from your Purchases.

    How to download

  2. Make a copy

    Click MAKE A COPY in the PDF: your own Google Sheet is saved to your Google Drive. Prefer Excel? Open the .xlsx.

    How to make your copy

  3. Start

    Follow the Start Here tab. Type in the cream cells; the gray cells do the math for you.

    Clearing the sample data

You receive:

  • START-HERE.pdf — Google Sheets link + quick guide
  • small-business-bookkeeping-excel.zip — Excel version

Good to know

  • Also in the Small Business Finance Starter bundle with Cash Flow Forecast & P&L, Invoice & Receivables Tracker and Pricing Calculator: all four for less than the price of three.
  • Need stock tracking too? The Small Business Finance Complete bundle adds the Inventory & COGS Tracker to all four.
  • Cash basis: income is recorded when money arrives, expenses when you pay.
  • Best used on a computer; you can view it in the Google Sheets app on your phone.
  • The tax set-aside is a savings rule you choose; tax groups are a sorting aid.
  • For use in one business. Please do not resell or share the files.

Not tax or legal advice.

Designed by me with the help of AI tools.

View Small Business Bookkeeping on Etsy

More in Small Business Finance