Small Business Bookkeeping Spreadsheet (Income, Expenses and P&L)
Log each sale or expense once and your profit & loss and dashboard fill in. Excel and Google Sheets. Record-keeping only, not tax advice.
$12 on its own, or get it with 8 more business tools in the Self-Employed & Small Business Bundle for $29.
Works in Google Sheets and Excel · Instant download · Nothing shipped
What you get
Real screenshots of the actual tabs, taken from the same .xlsx file you download. All numbers are example data.
Who this is for
- You freelance or run a small service business and enter income and expenses yourself.
- You want a profit and loss and deductible-expense totals to hand to your tax preparer.
- You track one business for one year per file.
Who it's not for
- Not for you if you want bank sync. You enter transactions yourself.
- Not for you if you need accounting software features like payroll or sending invoices.
- Not for you if you want tax advice. It's a record-keeping tool.
Need more than one?
This sheet is one of the 9 in the Self-Employed & Small Business Bundle. Get all 9 business tools for $29 (about $80 if bought one by one).
Get the bundle on Payhip – $29 See what's in the bundle
Need the home and the business sets? The Everything Bundle (what's inside) has all 22 (21 spreadsheets + the website template) for $39, about $149 if bought one by one.
Instant download. Works in Google Sheets and Excel (the website template is plain HTML/CSS).
Instant digital download, sold through Gumroad. Good for: bookkeeping, expense tracker, income tracker, small business, profit and loss, google sheets, excel template, self employed, tax deductions, bookkeeping sheet.
2 separate spreadsheets (.xlsx files) in one zip: Small Business Bookkeeping Tracker v2, Small Business Bookkeeping Tracker. Each works in Excel and Google Sheets (import the .xlsx) and opens on a Start Here tab with a short how-to.
How it works
- Download the zip after checkout and unzip it.
- Open each .xlsx in Excel, or upload it to Google Drive and open it with Google Sheets.
- Delete the example rows and type in your own numbers.
Previews and the files use example data only.
What's inside
- Transactions: room for 1,500 entries, with dropdowns for type, category, payment method and "deductible?". Date and amount checks help catch typos.
- Profit & Loss: monthly and yearly totals for each category, net profit, and a check that warns you if any row is missing a category.
- Dashboard: year-to-date income, expenses, net profit and profit margin, a monthly table, your top 5 expense categories and an income-vs-expenses chart.
- Tax Summary: totals of the expenses you marked deductible, by category, to hand to your tax preparer.
- Setup: your business name, the tax year, and up to 10 income and 20 expense categories that you can edit.
- A Start Here tab and a quick-start README.
Good to know
- This is a record-keeping tool. It is not accounting software and it is not tax advice. It doesn't connect to your bank, so you enter transactions yourself.
- It tracks one business and one year per file. Make a copy for each new year.
- The previews show the included example data. Delete it before you start.
- License: for personal use or your own business. Do not resell it.
Previews
Works in Google Sheets and Excel · Instant download · Nothing shipped
Try the free break-even calculator (profit per sale and sales needed) →
Try the free profit and loss calculator →
Try the free markup vs. margin calculator →
Try the free owner pay calculator →
Try the free price increase calculator →
Try the free sales tax calculator →
Frequently asked questions
Which apps does it open in?
Excel 2016 or newer (including Microsoft 365 and Excel for the web) and Google Sheets: upload the .xlsx to Google Drive, then open it with Google Sheets.
What happens after checkout?
Gumroad emails you a receipt right after checkout; click View content in it to open your download page. You download a .zip with the .xlsx file(s) and a short how-to. It's an instant digital download; nothing physical ships.
Can I edit it?
Yes. Nothing is locked: rename categories, add rows, change colors and type over the example data.
Does it connect to my bank or send reminders?
No. It's a spreadsheet, not an app: you type in your own numbers and nothing is synced or sent.
Are the numbers in the previews real?
No. Previews and the file use example data only. Delete the example rows and add your own.
Can I get a refund?
It's a digital download, so if something doesn't open or work, reply to your Gumroad receipt and I'll help fix it. Refund requests are handled under Gumroad's refund policy. If you bought it on Payhip, message the shop there.
Is this financial advice?
No. It's an organizing and planning tool with example numbers, not financial, tax, legal or medical advice.
Works in Google Sheets and Excel · Instant download · Nothing shipped
Free guides that use this sheet
- How to Track Owner Draws in a Small Business
- How to Record Cash and Card Sales in Your Books
- How to Organize Business Receipts (Simple System)
- Small Business Year-End Bookkeeping Checklist
- How to Reconcile a Business Bank Account Each Month
- Simple Profit and Loss Statement for a Small Business
- How to Sort Small Business Expenses Into Categories
- Separate Business and Personal Money for a Side Hustle
Pairs well with
Freelancer Invoice + Client Tracker ($9)
Track what you've billed and what's still owed.
Not ready to buy? Start with the free Starter Budget Sheet.
See all Cedar & Ledger templates