1 / 22

Income, expenses and profit for small business

Bookkeeping Spreadsheet

Know where your business money goes, without learning accounting software. Log what comes in and what goes out, and it works out your profit, your monthly Profit & Loss and what to set aside for taxes.

SpreadsheetExcel + Google Sheets8 tabsInstant download

$15.99 one time, buy direct

Buy direct · $15.99

Instant download: the spreadsheet (.xlsx) and the free 8-page Quick Start Guide (PDF), right after you pay.

Buy on Etsy · $17.99

35% off on Etsy: code SAVE35

Try the free demo

Pay once, no subscription
No macros, no add-ons
Works in Excel, Google Sheets and LibreOffice Calc
Free 8-page Quick Start Guide (PDF) included

What's in the Bookkeeping Spreadsheet

Dashboard

Income, expenses, net profit, profit margin, what to save for taxes, what's still to save, sales tax held and business miles, plus a monthly chart and your top 5 expense categories.

Income log

One row per payment, with client, category and payment method. Sales tax collected gets its own column, so it never counts as income.

Expenses log

One row per purchase or bill, with a Tax deductible? Yes/No column and a Receipt saved check mark.

Mileage log

One row per business trip. Check round trip and the miles double. The deduction uses your own rate.

Profit & Loss

Every category, every month, plus the year, with net profit and profit margin.

Tax Set-Aside

Each quarter's profit times your set-aside %, what you actually saved, and what's still to save.

Your own categories

Comes with 5 income categories, 17 expense categories and 5 payment methods. Rename, add or delete any of them and the dropdowns update by themselves.

Built to catch mistakes

A Check column on every log row flags a missing date, a date typed as words, a date from another year, a missing category or a missing amount.

Set up in 3 steps

Fill in Start Here
Type your business name, the year, your tax set-aside % and your mileage rate.
Log as you go
One row per payment, purchase or business trip.
Everything else calculates
Your profit, Profit & Loss, taxes to save and charts fill in on the Dashboard.

Watch the how-to

The 2-minute how-to video, start to finish.

Plus the free 8-page Quick Start Guide (PDF) comes with your purchase.

Who it's for

Anyone who wants simple, clear books.

FreelancersConsultantsSalonsCleanersCraftersTutorsPhotographersOnline shopsSide hustles

Money logged under a category that isn't on your list shows up as Not in my list on the Profit & Loss, so nothing goes missing
The Dashboard tells you how many rows need a look
Formulas are protected in Excel, so a stray keystroke can't break them
You type in the cream boxes and the log rows; the light-blue cells calculate for you

What you get, how you get it and what you need

What you get

The Small Business Bookkeeping spreadsheet (.xlsx) with 8 linked tabs
The free 8-page Quick Start Guide (PDF) with real screenshots
A one-time purchase, no subscription

How you get it

Buy direct: right after you pay, you land on your download page with the spreadsheet and the guide.
On Etsy: open Purchases in a web browser and click Download Files. The Etsy phone app can't download files.
Open it in Excel, or upload it to Google Drive and save it as a Google Sheet.

What you need

Microsoft Excel (desktop), Google Sheets or LibreOffice Calc
No macros and no add-ons

Good to know

It keeps your records organized. It isn't tax or legal advice: the set-aside is a savings guide, not a tax bill, and your tax pro has the final word on what you owe and what you can deduct.
One file tracks one year. Start a fresh copy for each new year.
Room for 500 rows each on Income, Expenses and Mileage.
Google Sheets removes the locks when it imports, so type only in the cream boxes and the log rows.
It's a digital download. Nothing is shipped.

Reviews

The Bookkeeping Spreadsheet doesn't have reviews yet.

Our Etsy shop has 150 reviews with a 4.8-star average.

Read all our reviews on Etsy →

Questions

Do I need to know accounting?

No. Log what comes in and what goes out, and the spreadsheet works out your profit, your monthly Profit & Loss and how much to set aside for taxes.

Does it work in Google Sheets?

Yes. Upload it and save it as a Google Sheet. Sheets removes the locks when it imports, so type only in the cream boxes and the log rows. It also works in Microsoft Excel (desktop) and LibreOffice Calc.

How does it handle sales tax?

Sales tax collected goes in its own column on the Income tab, so it never counts as income. The Dashboard shows the sales tax held.

Does it tell me what I owe in taxes?

It shows what to set aside each quarter: profit times your set-aside %. That's a savings guide, not a tax bill, and your tax pro has the final word on what you owe.

Can I change the categories?

Yes. Rename, add or delete any of them and the dropdowns update by themselves, with room for up to 15 income categories, 25 expense categories and 8 payment methods.

What about next year?

One file tracks one year. Start a fresh copy for each new year.

How do I get it after I buy?

Buy direct and you land on your download page right after you pay, with the spreadsheet and the free Quick Start Guide. On Etsy, open Purchases in a web browser and click Download Files.

Can I try it before I buy?

Yes. Try the free demo right in your browser before you buy.