ELSE COURT

Home › Small Business › Small Business Bookkeeping Spreadsheet for Excel & Google Sheets

The Bookkeeping Tracker spreadsheet for Excel and Google Sheets, an income and expense dashboard for small businesses. A preview shows income, expenses, net income, net margin, cash in accounts, sales tax collected and charts by month.

Small Business Bookkeeping Spreadsheet for Excel & Google Sheets

Keeping your books does not have to mean accounting software. The Bookkeeping Tracker lets you record each payment you receive and each cost you pay, with a category and the account it went through.

The Dashboard shows income against expenses by month, net income, net margin, cash in your accounts, your top expense categories and your biggest expenses. Change the year on the Start Here tab and every report follows, so you can keep several years in the same file.

It is a digital download for Excel and Google Sheets, made for freelancers, makers and small shops that keep their own records.

View on Etsy

Digital download. Works in Excel and Google Sheets. Nothing is shipped.

What this spreadsheet tracks

Who it's for

How it works

  1. Add your accounts with their opening balances, and choose the year on Start Here.
  2. Record each payment received on the Income tab and each cost on the Expenses tab.
  3. Pick a category and an account for every entry.
  4. Open the Dashboard and the summaries to see your numbers by month and by year.

See inside

Bookkeeping dashboard with 8 summary tiles and charts for income against expenses by month, net income by month, the top 8 expense categories, income by category, account balances and a table of the 8 biggest expenses, plus a needs-attention panel.Expenses tab listing date, vendor, description, category, account, amount, a Deductible? label and a data check column. Expenses marked Review are highlighted in yellow.Accounts tab with account name, type, opening balance, money in, money out and balance, above the Categories tab with 15 income categories and 30 expense categories that can be renamed.Monthly Summary with every income and expense category by month from January to December, with yearly totals per category, total income, total expenses and net income.Annual Summary with income and expenses by category and share of total, quarterly income, expenses and net income, and a breakdown of expenses by Deductible? label (Yes, Review, No, Not set).Start Here tab with business name, year to report, today's date, a short explanation of how the tracker works, seven setup steps, a color code and a list of the tabs.List of the 8 tabs included in The Bookkeeping Tracker and three steps: download, add accounts and entries, then read your numbers. Record-keeping tool, no macros, no subscription, digital download.

Frequently asked questions

Is this accounting or tax software?

No. It is a record-keeping and tracking spreadsheet. It does not replace an accountant or give tax advice.

How many entries does it hold?

Up to 1,200 income entries and 2,000 expense entries per file.

Does it work in Google Sheets?

Yes. The PDF guide includes a link to make your own Google Sheets copy. The Excel and Google Sheets versions are separate files.

Is there an example file?

Yes. A second Excel file is filled with example data so you can see how everything works.

The Bookkeeping Tracker is also one of the five tools in the Small Business Spreadsheet Bundle.

Read the guide

A laptop on a wooden desk beside shipping boxes, showing a small business bookkeeping dashboard with income and expense charts.
How to Track Small Business Income and Expenses in a SpreadsheetWhat to record for every sale and cost, which categories to use and a short monthly routine for a small business.

More in Small Business

The Inventory Tracker spreadsheet for Excel and Google Sheets, a stock, reorder and inventory value tracker for small businesses. A preview shows the dashboard with units on hand, inventory value at cost, low stock and the items closest to running out.
Inventory Tracker Spreadsheet for Small BusinessKeep track of stock, reorder levels and item movements.
The Pricing Calculator spreadsheet for Excel and Google Sheets, a product cost, price and profit margin dashboard for small businesses. A preview shows margins, cost per unit, monthly profit and the products priced below the target margin.
Product Pricing Calculator SpreadsheetWork out costs and prices for your products and build a price list.
The Invoice Tracker, an invoice and payment tracker spreadsheet for Excel and Google Sheets. A preview of the dashboard shows what is outstanding, what is overdue, what is due in 7 days, what was collected this month and the clients who owe the most. Tabs: Invoices, Payments, Clients, Invoice, Items, Dashboard.
Invoice Tracker Spreadsheet for Excel & Google SheetsTrack invoices, payments and overdue amounts in one clear dashboard.
The Order Tracker, an order management spreadsheet for Excel and Google Sheets. A preview of the dashboard shows open orders, what is overdue, what to ship next and orders by status, channel and month. Tabs: Orders, Customers, Order Sheet and Dashboard.
Order Tracker Spreadsheet for Small BusinessFollow customer orders from new to completed and see what is still open.
Small Business Spreadsheet Bundle: 5 separate Excel and Google Sheets tools. Preview of the Bookkeeping Tracker, Pricing Calculator, Inventory Tracker, Invoice Tracker and Order Tracker dashboards in a cascade, with the title 5 Small Business Tools.
Small Business Spreadsheet Bundle (5 Templates)Bookkeeping, pricing, inventory, invoices and orders together in one bundle.

Ready to get organized?

View on Etsy