Small Business Bookkeeping (Income/Expense)
Your whole business, on one honest P&L.
A bookkeeping spreadsheet for sole proprietors and micro-businesses who want clean income and expense books without paying for accounting software.
Small Business Bookkeeping (Income/Expense) is a 9-tab Excel and Google Sheets workbook. 3 you type into, 4 calculated from those and 2 you set once. No macros, so it opens without a security warning.
- Dashboard Income and expenses for the month you pick, the sales tax to set aside, and owner draws for the period.
- Dashboard (Dark) The same dashboard in a dark theme, for screens that are easier on the eyes at night.
- Income Log Date, source or client, category, location, amount excluding tax, sales tax collected, payment method and invoice reference.
Filed under bookkeeping & accounting.
All 9 tabs, exactly as they look in the file. Click a tab to look inside.
Sound familiar?
What's inside, tab by tab
You only ever type in the highlighted input cells. Everything else is calculated from what you type.
| Tab | What you do | What it does |
|---|---|---|
| Tab 1Start Here | Set once, never again | A one-page setup guide inside the workbook. Enter your basics once, in about 5 to 10 minutes. |
| Tab 2Dashboard | Calculated for you | Income and expenses for the month you pick, the sales tax to set aside, and owner draws for the period. |
| Tab 3Dashboard (Dark) | Calculated for you | The same dashboard in a dark theme, for screens that are easier on the eyes at night. |
| Tab 4Income Log | You type here | Date, source or client, category, location, amount excluding tax, sales tax collected, payment method and invoice reference. |
| Tab 5Expense Log | You type here | Date, vendor, category, location, amount, type, payment method, receipt reference and whether it is deductible. |
| Tab 6Monthly Summary | Calculated for you | Income, expenses, net and a running net by month, with sales tax collected alongside. |
| Tab 7Year-End Report | Calculated for you | Totals by income category, and income, expenses and net month by month. Built to hand over. |
| Tab 8Date Fixer | You type here | Paste dates that came out of a bank export as text and it shows you which ones Excel has misread, then hands back clean ones. |
| Tab 9Settings & Lists | Set once, never again | Income categories, expense categories, payment methods, entry types and locations. Change them once and every dropdown follows. |
Want one quick number first? The free break-even calculator finds the sales you need to cover fixed costs. It runs in your browser, no sign-up.
Good to know
Categories matched to Schedule C lines
If you file Schedule C, the Year-End Report tab lists each expense category next to the Schedule C line it usually belongs on, for example Marketing on line 8, Supplies on line 22, Utilities on line 25 and other expenses on line 27b, taken from the IRS 2025 Schedule C (Form 1040). Your accountant can copy the totals across line by line. The mapping is a guide: check it with whoever files for you.
What a spreadsheet does and does not replace
A spreadsheet can replace accounting software if you keep single-entry books: one line per payment in, one line per cost out. This file holds 500 income rows and 500 expense rows, totals them by month and quarter, and prints a year-end report. It does not connect to your bank, does not do double-entry, and has no balance sheet. If your accountant needs a balance sheet, or your year runs past 500 payments in either log, software is the better fit.
Quarterly estimated tax is a separate job
This file keeps income, expenses and sales tax, and totals them by quarter, but it does not estimate the income tax you owe. If you pay estimated tax four times a year, the 1099 / Schedule C Self-Employed Tax Spreadsheet works out what to set aside each quarter and tracks the payments you make.
Built like software, priced like a spreadsheet
Enter your data; totals, flags and the dashboard update instantly.
Checked cell by cell before release. Find one and we will fix it.
Formula cells are protected. You can only type where typing is safe.
Both versions in every purchase. No converting, no broken references.
Clean report pages for your records, your accountant, or your next meeting.
Delivered by Etsy the moment you pay. Free updates to this template forever.
How it works
Secure checkout through Etsy, no account needed here.
The Excel file and the Google Sheets link arrive immediately.
Type into the highlighted cells and every total is calculated from what you typed.
Questions, answered
Do I need a paid Excel version?
Any desktop Excel from 2016 onward works, including Microsoft 365. If you don’t have Excel at all, use the included Google Sheets version. It’s free.
Does it fully work in Google Sheets?
Yes. The Google Sheets version is made from the same file as the Excel one and checked in Google Sheets before release. Every formula uses functions that work the same in both.
Is this a one-time purchase?
Yes. One payment, no subscription. You keep the files forever and get free updates to this template.
What does it not do?
It does not connect to your bank or accounting software, and it does not import statements: you type your entries in. It is not tax advice.
What’s the refund policy?
Refunds follow Etsy’s rules for digital downloads. If a template doesn’t work as described, email support@elecart.us and we will fix it.
What if I get stuck?
Email support@elecart.us and the person who built the template answers, usually within one business day. Etsy Messages works too.
How much data can it handle?
Input tabs are sized generously and tested with full sample data: enough for years of typical use. Need more room? Duplicate the file per year, or email support for an extended version.
Your whole business, on one honest P&L.
$4.79, once, 70% off until Nov 28. Yours forever, with free updates.
Get it on Etsy →
