How to Do Your Bookkeeping in Excel (Free Template Included)

You started a small business, money is finally coming in, and now everyone tells you that you need bookkeeping software. But you are not sure you want to pay a monthly fee for something you barely understand yet. Good news. For a lot of brand new and very small businesses, a simple spreadsheet is honestly enough to keep clean, tax ready books.

This guide gives you the whole system. We will cover when a spreadsheet really works, how to build one in about half an hour, the monthly routine that keeps it accurate, and the formulas that do the math for you. At the end, you can grab our free template so you do not have to build any of it from scratch.

When a Spreadsheet Is Genuinely Enough

Let us be straight with you, because plenty of people will not be. A spreadsheet works great when your business is simple. Here is the honest test. If you can say yes to most of these, a spreadsheet is fine for now:

• You use one business bank account (a separate account just for the business, not your personal checking).
• You have fewer than about 50 transactions a month (each deposit or expense counts as one).
• You do not carry inventory (products you buy and hold to resell later).
• You do not run payroll (paying W-2 employees with taxes withheld).

Think about a mobile detailer in Apache Junction who just went full time. He takes cash and Venmo, has a handful of supply runs to the auto parts store, and maybe 30 transactions a month. A spreadsheet is perfect for him. Now picture a growing Mesa contractor who invoices customers, pays two helpers, and buys materials on account. He has already outgrown a spreadsheet and needs real software. Same effort, very different needs.

On cost, a spreadsheet is free. QuickBooks Online runs anywhere from about $35 to $100 a month depending on the plan. That is $420 to $1,200 a year. The real question is not just dollars, it is your time. If a spreadsheet keeps you organized in 15 minutes a week, it is buying you both money and peace of mind while you are small.

Set Up Your Spreadsheet in 30 Minutes

You only need four tabs (the separate pages inside one spreadsheet file). Here is the layout:

• Transactions. Every dollar in and out, one row each.
• Categories. Your short list of income and expense buckets.
• Monthly P&L. Your profit and loss (a summary of income minus expenses).
• Dashboard. A few big numbers at a glance.

Pick 10 to 15 categories that match tax time

Do not get fancy. Pick categories that line up with how taxes are reported so year end is easy. A common set: Sales income, Advertising, Car and truck, Supplies, Tools and equipment, Insurance, Rent, Software and subscriptions, Bank and merchant fees, Meals, Phone and internet, Contract labor, and Owner draw (money you take out for yourself). If you want to see how these map to a real tax form, read what is a Schedule C.

Set up your columns

On the Transactions tab, use these columns in order: Date, Description, Amount, and Category. Make the Category column a dropdown list so you pick from your set every time instead of typing "gas," "fuel," and "Gasoline" three different ways. In Excel that is Data, then Data Validation, then List, pointed at your Categories tab. Consistent spelling is what makes the formulas work later.

The Monthly Routine That Keeps It Honest

A spreadsheet is only as good as your habit. Here is the rhythm that works:

1. Log in to your bank and download the month as a CSV file (a plain spreadsheet export). Every bank has this button.
2. Paste the rows into your Transactions tab, or type them in if you only have a few.
3. Pick a category for every single row. No blanks allowed.

Tie your total to the bank (a mini reconciliation)

Reconciliation just means proving your records match the bank. Once a month, check that your spreadsheet's running cash total equals your actual bank balance on the same date. If your sheet says $8,420 and the bank says $8,205, you are missing $215 somewhere, usually a fee or a transaction you forgot to enter. Find it before you move on. This one habit catches almost every mistake.

Formulas That Do the Work for You

You do not need to be an Excel wizard. Two formulas carry the whole thing.

SUMIFS to total each category

SUMIFS adds up numbers that meet more than one condition. To total all your Supplies spending in a month, it looks like this: =SUMIFS(Transactions!C:C, Transactions!D:D, "Supplies", Transactions!A:A, ">="&DATE(2026,7,1), Transactions!A:A, "<="&DATE(2026,7,31)). In plain words, that says "add up the Amount column where the Category is Supplies and the Date falls in July." Copy that formula down your P&L tab, swapping the category name for each row, and your totals fill in by themselves.

An automatic P&L that updates as you type

Because your P&L tab pulls from your Transactions tab, it recalculates the moment you add a new row. Total income at the top, each expense category below, and a simple subtraction for net profit (income minus all expenses). A Queen Creek online seller can add today's sale and instantly see her profit for the month climb. If reading a P&L is new to you, this line by line guide makes it click.

Flag anything uncategorized

Use conditional formatting to highlight blank category cells in red. Select the Category column, choose Conditional Formatting, then Highlight Cells, then Blanks. Now a missed entry glows red until you fix it. No more mystery money at year end.

Grab the Free GGS Template

You do not have to build any of this. Our free Excel template on the GGS resources page already has all the tabs, the SUMIFS formulas, the automatic P&L, and a clean dashboard wired up and ready.

Making it yours takes about 10 minutes. Rename the categories to fit your business, set your start date, and paste in your first bank download. That is it. It pairs with our video walkthrough so you are following along, not guessing. If you would rather stay in a familiar spot, the full template rundown lives right here too.

Signs You Have Outgrown the Spreadsheet

A spreadsheet is a great starting point, not a forever home. It is time to move up when you start:

• Invoicing customers and chasing who still owes you.
• Hiring help and running payroll.
• Taking card payments through Square or Stripe.
• Crossing roughly 100 transactions a month.

Moving to QuickBooks Online is where a clean spreadsheet pays off. Your categories and history transfer over neatly, so the switch is smooth instead of a scramble. If your books are already messy, our QuickBooks cleanup guide shows the fix.

Here is the honest part. Building the sheet is easy. Doing it right every single month, tying it to the bank, and keeping categories clean takes time and know how that most owners would rather spend running their business. That is exactly what we do. GGS handles the whole thing for you, every month, so your books are always current and your profit is always clear. If you want it off your plate, see how we help or book a free intro call. You will text a real person, not a ticket.