How to Do Monthly Bookkeeping for a Small Business (Step-by-Step Checklist)

You started a business to do the work you’re good at — not to spend Sunday nights guessing what a charge from three weeks ago was for. But here’s the thing about bookkeeping: it’s only painful when it’s a once-a-year panic. Turned into a short monthly routine, it becomes 45 minutes you barely notice, and it hands you two things that are genuinely valuable — books that are ready for tax time and a clear number for whether you actually made money this month.

This guide gives you a repeatable monthly bookkeeping routine you can run in a spreadsheet, a copy-ready checklist, and a full worked example with real numbers so you can see exactly what “closing the month” looks like. No accounting degree required.

Why monthly beats “I’ll sort it out at tax time”

The owner who reconstructs a year of receipts every March pays for it three ways. They lose deductions they can’t prove, they overpay an accountant to untangle the mess, and — the quiet one — they run the entire year blind, with no idea month to month whether the business is ahead or behind. Monthly bookkeeping fixes all three. You capture every deduction while the receipt still exists, you hand your accountant clean totals, and you always know your number.

The routine below is built around one principle: enter little and often, close once a month. During the month you just log things as they happen. At month-end you do a single, structured pass — the “close” — that turns raw entries into numbers you can trust.

The monthly bookkeeping checklist

Here’s the whole routine on one page. Print it, or keep it open beside your spreadsheet. The rest of the article walks through each step with an example.

Weekly (5 minutes):

• [ ] Log every payment received into the income tab
• [ ] Log every business expense, with category and payment method
• [ ] Snap or save receipts for anything over your receipt threshold

Monthly close (30–60 minutes):

1. [ ] Gather statements — download your business bank and credit card statements for the month
2. [ ] Record all income — confirm every deposit is logged, matched to an invoice where relevant
3. [ ] Record and categorize all expenses — every business charge assigned to a category
4. [ ] Update your invoices — mark which are paid, which are outstanding, which are overdue
5. [ ] Reconcile — match your recorded transactions to the bank/card statement, line by line, until they agree
6. [ ] Set aside tax money — move a percentage of profit into a separate tax savings pot
7. [ ] Review your profit & loss — read income minus expenses for the month, and note the trend
8. [ ] Flag anything odd — an uncategorized charge, a client who hasn’t paid, a category that spiked

That’s it. Eight steps, once a month. Now let’s do a real one.

A worked example: closing the month of March

Meet Dana, who runs a one-person web-design business. Here’s her March, closed step by step.

Step 1 — Gather statements

Dana downloads two PDFs: her business checking statement and her business credit card statement for March. Everything business-related flows through those two accounts (more on why that matters below), so these two documents contain every transaction she needs to account for.

Step 2 — Record all income

She lists every payment that landed in March:

Note she records income when the money actually arrives (cash basis) — the method most small businesses use. Invoice #020 was sent in March but hasn’t been paid yet, so it’s not income this month. It goes on the invoice tab as outstanding instead.

Step 3 — Record and categorize expenses

Every business charge gets a category. Consistent categories are what make tax time trivial, because you (or your accountant) can total each one in seconds.

Step 4 — Update invoices

Dana marks #018, #019, and #021 as paid (they became her income above). Invoice #020 for $1,500, sent March 18 with 14-day terms, is still unpaid — she flags it as outstanding and notes it’s due April 1. This is the number she’ll chase next.

Step 5 — Reconcile

Dana adds up what her records say flowed through each account and compares it to the statement’s ending balance. If her records show the account should end at $8,140 and the bank agrees, she’s reconciled. If they don’t match, there’s a missing or duplicated transaction to hunt down. Reconciling every month is what guarantees the books reflect reality — it’s the step most beginners skip and later regret. (There’s a full walkthrough of this in the reconciliation article linked below.)

Step 6 — Set aside tax money

Dana’s rule of thumb is to park 25–30% of her profit for taxes. Her March profit is $4,500 − $728 = $3,772. She moves 25% of that — about $943 — into a separate tax savings account. When quarterly estimated taxes come due, the money is already waiting instead of coming out of an already-spent checking account.

Step 7 — Review profit & loss

Dana compares March’s $3,772 to February’s $2,900 — she’s up, driven by the Bright Dental project. This one number, read every month, is the difference between running a business and just being busy.

Step 8 — Flag anything odd

She notices “Software & subscriptions” appears twice and totals $75 — worth a glance to make sure she isn’t paying for a tool she stopped using. She also flags invoice #020 to chase on April 2 if it’s still unpaid. Close done. Total time: about 40 minutes.

The tabs that do this for you

Every step above maps to a place to put the data. If you build your own spreadsheet, you’ll want, at minimum:

• An income tracker for money received
• An expense tracker with a fixed category list (use dropdowns so the same category is never typed three different ways)
• An invoice log that shows what’s paid, outstanding, and overdue
• A reconciliation area to match records against the statement
• A dashboard that totals income, expenses, and profit automatically, and a tax summary that groups expenses by category for filing

The one rule that keeps a bookkeeping spreadsheet trustworthy: pick your categories once and never freestyle them. A category list of 15–25 items, applied consistently, is worth more than any formula. It’s what lets the dashboard and tax summary total correctly without you checking every row.

Common mistakes that break your books

Mixing business and personal spending. The fastest way to make bookkeeping miserable is to run business costs through your personal card. Give the business its own account and card so your statements are your books. If you’ve already been mixing them, there’s a way to untangle it — see the linked guide.

Waiting until you’re behind. A month of missed logging is an evening of catch-up. A year is a nightmare. If you’re already behind, don’t try to fix it in one sitting; work backward one month at a time.

Recording invoices as income. Sending an invoice isn’t the same as getting paid. On cash basis, income is money received. Keep sent-but-unpaid invoices on the invoice tab, not the income tab, or your revenue will look higher than your bank account.

No consistent categories. “Software,” “Subscriptions,” and “SaaS” as three separate categories for the same thing will scatter your totals. One name per category, chosen up front.

The faster route: a ready-built bookkeeping spreadsheet

You can build all of this yourself, and if you enjoy spreadsheets, go for it. But wiring up the income and expense tabs, an invoice log with aging, a reconciliation that actually balances, a dashboard, and a tax summary keyed to IRS categories — with every formula correct — is a few hours of fiddly work before you’ve logged a single transaction.

Our Small Business Bookkeeping Spreadsheet has all of it built and tested: an Income Tracker, an Expense Tracker with 25 pre-built IRS Schedule C categories, an Invoice Log, a Cash Flow tab, a Reconciliation tab, a Dashboard, a Tax Summary, and a Client Directory — 836+ auto-calculating formulas doing the math for you. You open it, follow the checklist above, and your close takes minutes.

Whichever route you take, the principle doesn’t change: log little and often, close once a month, and read your profit every single time. Do that, and bookkeeping stops being the thing you dread and becomes the thing that tells you how your business is really doing.

Read next

• How to catch up on a year of messy small business bookkeeping
• How to separate business and personal expenses when you’ve been mixing them
• How to reconcile your business bank account with your bookkeeping spreadsheet
• How to tell if your small business is actually profitable from your bookkeeping

Featured on ReadySheetGo: Small Business Bookkeeping Spreadsheet Template — A complete 9-tab bookkeeping system with 836+ auto-calculating formulas and 25 pre-built IRS Schedule C categories. Track income, expenses, invoices, and cash flow, then print a tax-ready summary at year end. Works in Microsoft Excel and Google Sheets. $17.99 (currently $10.79 with the LAUNCH40 sale). Instant digital download — no waiting, no software to install.