Simple bookkeeping spreadsheet
A simple bookkeeping spreadsheet is one list of every dollar in and out, with a category on each line. This free template suits a side business, freelancer or brand new company: record the date, who, what and the amount, and the sheet keeps the running total, so tax time is a sort and a sum.
Updated November 2026
What does the template look like?
Type one row per entry. Totals add themselves in Excel. Here it is with sample figures, so you can see how it fills in.
| Date | Paid to or received from | Description | Category | Income | Expense | Receipt? |
|---|---|---|---|---|---|---|
| 2026-01-03 | Bright Dental | Website build, invoice 104 | Sales | $2,400.00 | Yes | |
| 2026-01-05 | Adobe | Creative Cloud, monthly | Software | $59.99 | Yes | |
| 2026-01-09 | Stripe | Card fees, December | Bank and card fees | $71.60 | Yes | |
| 2026-01-14 | Coastal Realty | Logo design | Sales | $850.00 | Yes | |
| 2026-01-20 | WeWork | Day pass, client meeting | Rent | $35.00 | Yes | |
| 2026-01-28 | Own car | 62 business miles | Vehicle | $44.95 | Log | |
| Total | $3,250.00 | $211.54 |
Is a spreadsheet good enough for bookkeeping?
For a side business or a new freelancer, yes. The IRS doesn't require software, only records that are accurate and complete. A spreadsheet starts to strain once you have employees, inventory, sales tax in more than one place, or more than a hundred transactions a month. That's the point to move to QuickBooks Online or Xero, with bank feeds.
Which categories should I use?
Start with the lines on Schedule C: advertising, car and truck, contract labor, insurance, legal and professional, office, rent, repairs, supplies, taxes and licenses, travel, meals, utilities and wages. If you use the same names all year, your return is a matter of adding up each category. The chart of accounts template has a fuller list.
What should I keep with it?
Receipts, bank and card statements, invoices and a mileage log. Reconcile the totals to your bank statements every month so nothing is missed.
Sources
General information, not tax advice for your situation.
Want your books off your plate?
One accountant keeps them current, every month.
See our bookkeeping serviceDo I need separate bank accounts?
It helps a lot. A separate business account makes the spreadsheet match the bank, and keeps personal spending out.
How do I record owner draws?
Not as an expense. Leave them out of this sheet or add them in a separate column, since they don't change profit.
What profit do I pay tax on?
Income less allowable expenses. Self-employment tax and income tax both use it. Our 1099 tax calculator shows the estimate.
Tell us what's messy. We'll tell you what it takes.
Tell us what you need and get a fixed price before any work starts. No pressure and no contract.