Small Business Bookkeeping Spreadsheet | Google Sheets Income Expense & Profit Tracker | Sales Tax and 1099-K

I run a small digital shop and tutor on the side, and for the longest time my "bookkeeping" was a mess of Etsy payouts, e-transfers, and PayPal deposits with receipts buried in my inbox. When tax season came, I could not have told you what I actually made, what I owed, or how much to set aside. I tried the big accounting apps and they were expensive and far more than I needed. So I built the tool I actually wanted: one clean Google Sheet that tracks every dollar in and out and tells me, in plain numbers, how my business is really doing.

This is that spreadsheet, built for US sellers, freelancers, and self-employed owners.

WHAT IT DOES:
Type in a sale or an expense and everything updates on its own. The dashboard shows your income, expenses, profit, sales tax collected, and how much to set aside for taxes, all at a glance. No formulas to build, no accounting degree required.

WHAT'S INSIDE (9 connected tabs):
- Start Here — enter your business, state, and settings in minutes
- Dashboard — income, expenses, net profit, tax set-aside, and charts, all live
- Income — log every sale by state, with sales tax tracked
- Expenses — categorize spending the way your Schedule C expects
- Invoices — see what you have billed and who still owes you
- Clients — a simple contact list with total spend
- Mileage — log trips and it values them automatically
- Sales Tax & 1099-K — sales tax by state, plus a 1099-K reconciliation
- Profit & Loss — a clean month-by-month view of the whole year

BUILT FOR US TAXES:
This is the part most templates miss. Your expense categories already mirror the IRS Schedule C, so numbers transfer straight over at tax time. A running set-aside estimate shows what to hold back for quarterly estimated taxes. The Sales Tax tab totals what you collected by state, and the 1099-K reconciliation lets you match the gross your platforms report against your own records, with a plain reminder that all income is taxable whether or not a form arrives.

WHY I LOVE IT:
It runs like software but stays simple. Automatic calculations, live charts, a clean minimalist layout you will not dread opening, and a tax section that finally made sense to me.

WHO IT'S FOR:
Etsy shop owners, freelancers, tutors, makers, creators, and any US small or solo business owner who wants to feel calm and in control at tax time instead of panicked.

HOW IT WORKS:
1. Buy and download instantly
2. Open the access file and click the link to make your own copy in Google Sheets
3. On the Start Here tab, enter your business name and state
4. Log each sale on the Income tab and each expense on the Expenses tab
5. Watch the Dashboard, Sales Tax, and Profit & Loss tabs update themselves

WHAT YOU GET:
- A one-page PDF with your instant link to copy the Google Sheet
- The full bookkeeping spreadsheet, yours to keep and reuse every year
- Works in Google Sheets (free) and downloads to Excel if you prefer
- Use it on your computer, tablet, or phone

IMPORTANT:
This is a digital download, so no physical item is shipped and all sales are final. It is an organizing tool to help you understand your numbers, not tax advice. Tax rules and thresholds change, so please confirm current figures with a CPA or accountant. If anything is unclear or a file will not open, message me and I will make it right.

Wishing you clean books and a calm tax season.
- Sophia, Aligned & Organised