Home · Templates · Bookkeeping Tracker
What did you really make this year?

Bookkeeping Tracker

Type your sales and your expenses. The dashboard deducts platform fees and puts your tax share aside, and shows what is really left: your real profit, this year and month by month.

Excel + Google Sheets Income · Expenses · Invoices Any currency No subscription
$6.99 · Instant download
Excel file + Google Sheets version + quick start guide + video tutorial
Bookkeeping Tracker dashboard: real profit this year after platform fees and tax set-aside, month by month
Take the tour

Inside the Bookkeeping Tracker

Setup

Ready in about 5 minutes

Currency, the day your year starts, your tax set-aside rate. Then check the platform fees: Etsy, Shopify, PayPal, Stripe and Gumroad are pre-filled, and you can add up to 12 platforms. Only the yellow cells, everything else is automatic.

1 / 5
Ready in about 5 minutes
Income and expenses

Type the sale, the file does the rest

One line per sale, one per expense, with dropdowns for categories and platforms. The fee and the net received are computed on every sale. Room for 3,000 income entries and 3,000 expenses, 20 income and 30 expense categories.

2 / 5
Type the sale, the file does the rest
Invoices

Never chase an invoice too late

Paid or Pending is the only column you touch. Overdue invoices light up on their own with the days late, and the dashboard shows what is waiting, what is late, and who is next.

3 / 5
Never chase an invoice too late
What-if and fees

See the future before you decide

"Sell 10% more", "cut 100 a month": two cells in Setup, and the new real profit appears, tax included. Platform fees are ranked so you see what each one really costs you, and your top expenses too.

4 / 5
See the future before you decide
Dark mode

Light and dark, both included

The same dashboard in two versions. Use the one that fits your screen and your eyes, no setting to change.

5 / 5
Light and dark, both included
What you get

Everything in the download

Excel file (.xlsx), formulas built and tested
Google Sheets version, ready to copy
Quick start guide (PDF)
Light and dark dashboards
Free updates to this template
The Bookkeeping Tracker on a computer and on a phone
Compatibility

Works where you work

Excel 2016 or newer on Windows and Mac, and Google Sheets in any browser. No add-ins, no macros, nothing to install. On your phone, the dashboard reads cleanly in the Excel and Sheets apps.

THE MODULIS PROMISE

Every formula is visible, nothing is hidden.
Tested with real numbers before going on sale.
If something does not work, write to us and we fix it.

Bookkeeping Tracker · $6.99
Instant download · Excel + Google Sheets · Bookkeeping tool, not tax advice
More from Modulis

Another question, another file

Personal FinanceExcel + Google Sheets

Debt Payoff Tracker

When will you be debt-free? Your date, your month by month plan and the interest you save.

$6.99
Bookkeeping Tracker · $6.99
Excel + Google Sheets · Instant download
Get it on Etsy