Excel + Google Sheets template

Small Business Bookkeeping (Income/Expense)

Your whole business, on one honest P&L.

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 6-tab Excel and Google Sheets workbook for sole proprietors and micro-businesses who want clean income and expense books without paying for accounting software. 2 you type into, 1 that fills itself in and 3 you set once. $11.98 once, no subscription.

  • Income Log Date, source/client, category, amount, payment method, invoice ref.
  • Expense Log Date, vendor, category dropdown, amount, payment method, receipt?, tax-deductible?.
  • Monthly Summary Income, expense, net by month.

Filed under bookkeeping & accounting.

Get it on Etsy → See what's inside $11.98 on Etsy · one-timeCurrently 40% off
Tested before release Never password locked One payment Free updates
[ demo loop placeholder: 20–30s screen recording: entering data, dashboard recalculating ]

Type into the highlighted cells, watch every number update itself.

Sound familiar?

Before
Shoebox of receipts.
No P&L visibility.
Dread at tax time.
After
Two logs (income and expenses) feed a monthly summary that always matches reality.
Deductible spending is tallied separately, so tax prep starts from a number, not a shoebox.
Net profit by month, on a dashboard you'll actually check.
1.0 · The workbook

What's inside, tab by tab

You only ever type in the highlighted input cells, everything else fills itself in.

You type here Calculates itself Set once, never again Reference
Tab 1Start HereSet once, never again

A one-page setup guide inside the workbook. Enter your basics once: five minutes, done.

Tab 2Income LogYou type here

Date, source/client, category, amount, payment method, invoice ref.

Tab 3Expense LogYou type here

Date, vendor, category dropdown, amount, payment method, receipt?, tax-deductible?

Tab 4CategoriesSet once, never again

Editable income + expense category lists in Settings.

Tab 5Monthly SummaryCalculates itself

Income, expense, net by month.

Tab 6SettingsSet once, never again

Currency, date format and category lists. Change them once and the whole workbook follows.

Built like software, priced like a spreadsheet

Auto-calculating formulas

Enter your data; totals, flags and the dashboard update instantly.

Zero formula errors

Checked cell by cell before release. Find one and you get a fix plus a refund.

Locked formulas, highlighted inputs

Formula cells are protected. You can only type where typing is safe.

Excel AND Google Sheets

Both versions in every purchase. No converting, no broken references.

Printable summaries

Clean report pages for your records, your accountant, or your next meeting.

Instant download

Delivered by Etsy the moment you pay. Free updates to this template forever.

2.0 · Getting started

How it works

2.1
Buy on Etsy

Secure checkout through Etsy, no account needed here.

2.2
Download instantly

The Excel file and the Google Sheets link arrive immediately.

2.3
Make a copy, start typing

Type into the highlighted cells, every formula updates itself.

3.0 · Before you buy

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 built natively, not converted: every formula, highlight and protection works the same.

Is this a one-time purchase?

Yes. $11.98 once. You keep the files forever and get free updates to this template.

What’s the refund policy?

Digital downloads on Etsy are generally final, but if the template doesn’t work as described and we can’t fix it for you, you get your money back. Just email support@elecart.us.

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.

$11.98, once, 40% off. Yours forever, with free updates.

Get it on Etsy →
Tested before release Never password locked One payment Free updates

Also in Small Business

Small Business Bookkeeping (Income/Expense)
$11.98 · one-time · 40% off
Get it on Etsy →