Try “wedding”, “budget”, “etsy” or “invoice”.

Bookkeeping Spreadsheet & Profit and Loss Tracker: shown on a laptop and a tablet

1 / 9

Bookkeeping Spreadsheet & Profit and Loss Tracker

Every sale, expense and mile in one place, with sales tax and bank reconciliation.

$6.30$9-30%$9

Buy now

Fall Sale: 30% off at checkout, ends Nov 15.

–Days––Hours––Min––Sec

A small business bookkeeping spreadsheet and bookkeeping template for Google Sheets and Excel. Log income, expenses mapped to IRS Schedule C lines, mileage at the IRS rate for each date, sales tax and transfers, then reconcile up to six bank and card accounts and read monthly, quarterly, annual and 5-year dashboards. It doubles as a tax deduction tracker and a general ledger.

Format: Excel + Google Sheets · PDF guide
License: Personal & Business

Made for you if…

  • You run a sole proprietorship or single-member LLC and want your books in a spreadsheet, not accounting software
  • You sell in more than one place, like a shop, a marketplace and in person, and collect sales tax in some of them
  • You want a clean Schedule C deduction summary to hand your tax preparer every year

What you’ll get done

  • Every sale, expense and business mile in one place, with each expense tied to its Schedule C line
  • Every bank and card account reconciled each month, with uncleared checks and deposits accounted for
  • Profit and margin for any month, quarter, year or date range, compared with last year and across five years

What’s inside

  1. 01Small Business Bookkeeping Spreadsheet (.xlsx, blank) for 5 years: 2,000 income rows, 2,000 expenses, 1,000 drives, 6 accounts, 8 sales tax jurisdictions
  2. 02Example file filled in for a two-person pottery studio in Portland, Oregon, January 2022 to September 2026
  3. 03Tabs: Setup, Income Tracker, Expense Tracker, Mileage Tracker, Monthly, Quarterly, Annual, 5-Year, Custom and Comparison dashboards, Sales Tax Tracker, Bank Accounts (reconciliation and transfers) and General Ledger
  4. 0415-page PDF guide, including how to open it in Google Sheets
  5. 05Prints on US Letter paper

Goes well with

Frequently Asked Questions

Does it work in Google Sheets?

Yes. Your PDF guide has a link that makes your own Google Sheets copy in one click, with no upload needed. It also works in Excel 2019 or later and Microsoft 365.

Does it track tax deductions?

Yes. Every expense category is mapped to a line of IRS Schedule C, which you can change. The Annual Dashboard totals what you spent and what is deductible on each line, adds your mileage deduction and payment fees, and estimates your Schedule C net profit. It is a planning tool, not tax advice.

Can I reconcile my bank account with it?

Yes. For each account, type the statement date and ending balance and list any uncleared checks or deposits. The Bank Accounts tab shows Reconciled in green, or the exact difference in red.

How is it different from the Side Hustle Income and Expense Spreadsheet?

That one covers one year of a side hustle and estimates the tax to set aside. This one keeps full books for an established business: five years, up to six bank and card accounts, sales tax, bank reconciliation, a general ledger and dashboards for any period.

Is it a download or a subscription?

A one-time download. You pay once, keep the files and use them for as long as you like.