← All articles

Monthly Bookkeeping Checklist for Small Business (Free Excel Template)

Nine steps to close each month without accounting jargon, plus a free spreadsheet for income, expenses, helpers, and receipts.

Monthly bookkeeping is easier when it is a short routine instead of a year-end rescue. The goal is not to become an accountant. It is to make sure every dollar in and out has a date, an amount, and a clear explanation while you still remember it.

The IRS says your recordkeeping system should clearly show income and expenses. It does not require a particular app. A spreadsheet can work if you use it consistently, keep supporting documents, and review it against your real accounts.

The nine-step monthly bookkeeping checklist

1. Record every way customers paid you

Add cash jobs, checks, bank transfers, card payments, Venmo, Zelle, Cash App, and processor deposits. Do not treat the bank statement as the full revenue record if some money never reached that account.

2. Record every business expense

Bring together purchases from the business card, bank account, payment apps, and cash. If you paid a business expense personally, record it clearly so your owner activity does not get mixed with ordinary operating expenses.

3. Match the bank and card statements

Compare your entries with each monthly statement. Every withdrawal should have a purpose, and every deposit should either be income, an owner contribution, a loan, or another clearly identified item.

4. Categorize expenses consistently

Use a small, stable list of categories. Common Schedule C lines include advertising, contract labor, insurance, legal and professional services, office expense, repairs, supplies, travel, meals, utilities, and wages. Ask your preparer about anything unclear rather than guessing.

5. Review helpers and contractors

Keep the helper's name, date, amount, payment method, and work performed together. Ask a qualified professional about worker classification and current reporting requirements; a payment total alone does not decide either.

6. Check supporting documents

Make sure receipts, invoices, statements, and notes support your entries. Add a business-purpose note when the reason is not obvious, especially for travel and meals.

7. Review money in, money out, and net

Subtract money out from money in and compare the result with recent months. A large change may be real, but it can also reveal a missing cash job, a duplicate expense, or an item entered in the wrong month.

8. Review your tax reserve

Consider moving money to a separate savings account for future taxes. The right amount depends on your business, location, other income, and tax situation, so confirm a suitable approach with a qualified tax professional.

9. Resolve questions and close the month

Do not carry an unexplained pile into next month. Make a short question list, resolve what you can, and mark the month complete. If new information arrives later, correct the record rather than hiding the change.

A simple monthly example

Suppose your records show $8,450 from bank deposits, $1,125 from cash and payment apps, and $4,280 of expenses. Your complete money-in total is $9,575, not $8,450. Net before owner draws and tax is $5,295. That one combined view is why off-bank income belongs in the same monthly routine.

Download the free Excel template

The workbook below includes the nine-step checklist, a monthly entry sheet with useful dropdowns, two clearly labeled fictional examples, and a read-me page. Delete the examples before using it for your own business.

When a spreadsheet stops being enough

A spreadsheet works when one owner enters a modest number of transactions and closes the month consistently. The LedgerFast Year Book turns that same routine into 12 guided month sheets with running totals and a year-end PDF or Excel packet for $99 per tax year.

Disclaimer

This checklist and workbook are general educational recordkeeping aids, not tax, legal, or accounting advice. LedgerFast does not prepare or file tax returns. Requirements depend on your facts and can change; confirm decisions with the IRS and a qualified professional.

Frequently asked questions

What bookkeeping should a small business do every month?

Record all income and expenses, match entries to statements, categorize expenses consistently, check receipts, review helpers paid, inspect monthly totals, resolve unknown items, and close the month.

Can I do monthly bookkeeping in Excel?

Yes. A spreadsheet can work for a straightforward small business if it clearly shows income and expenses, includes cash and app payments, and is reviewed consistently against statements and supporting records.

How long should monthly bookkeeping take?

A simple business with current records may close a month in 20 to 45 minutes. It takes longer when receipts, cash income, or explanations have been left until year end.

Related reading

Put the checklist into one book.

Fill in one simple sheet each month, watch the year add up, and download a clean year-end packet. $99 per tax year.

Start Your Year Book →
Checking