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.

Example rows
DatePaid to or received fromDescriptionCategoryIncomeExpenseReceipt?
2026-01-03Bright DentalWebsite build, invoice 104Sales$2,400.00Yes
2026-01-05AdobeCreative Cloud, monthlySoftware$59.99Yes
2026-01-09StripeCard fees, DecemberBank and card fees$71.60Yes
2026-01-14Coastal RealtyLogo designSales$850.00Yes
2026-01-20WeWorkDay pass, client meetingRent$35.00Yes
2026-01-28Own car62 business milesVehicle$44.95Log
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 service
Questions

Still wondering?

Ask anything else on a free 30-minute call.

Book a call
Do 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.

Get started

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.

Get a free quote

Your name, plus an email or a phone number, whichever you prefer.

A sentence or two is plenty. Please don't include Social Security numbers, bank or card numbers, or tax documents here.

Thanks. This is a design preview, so nothing was sent.