Weekly Bookkeeping Routine for a Small Business (20 Minutes)

Bookkeeping gets painful when you do it once a year. Twenty minutes a week keeps your numbers current, makes tax time easier, and shows you whether the business is actually making money. Here is a simple routine for a small business, freelancer, or side hustle. General information, not tax or accounting advice.

Before you start: a one-time setup

• Separate account. Use one bank account (and card) only for the business. It makes every later step faster. (Step-by-step: Separate Business and Personal Money for a Side Hustle.)
• One ledger. A spreadsheet with columns for date, description, category, money in, money out, and a receipt note is enough for most small businesses.
• A short category list. For example: sales, materials, shipping, fees, software, advertising, vehicle, office, owner draw. Keep it to 8–12 so you use it consistently. (How to Sort Small Business Expenses Into Categories shows how to pick them and total each one monthly.)
• A receipt spot. One folder (paper or a phone photo album) for the week's receipts. How to Organize Business Receipts (Simple System) has a naming and folder setup.

Starting from scratch? Here is how to set up a small business bookkeeping spreadsheet with income, expenses, P&L and tax set-aside tabs.

The weekly routine (same day each week)

1. Log money in (5 min). Add each sale, payout, or client payment from the past week. Note the source (shop, client name, invoice number).
2. Log money out (5 min). Add every business expense from your bank and card statements. Pick a category for each.
3. Match receipts (3 min). Check that each expense has a receipt or a note. File them.
4. Check unpaid invoices (2 min). List anything overdue and send a polite reminder. (How to Follow Up on a Late Invoice (Example Numbers) has example wording.)
5. Reconcile (3 min). Compare the ledger's running balance to the bank balance. If they differ, find the missing entry now, while the week is fresh. Once a month, do the fuller check in How to Reconcile a Business Bank Account Each Month.
6. Set aside for taxes (2 min). Move a fixed share of this week's profit to a separate savings account. Many people start somewhere around 25–30%; ask a tax professional what fits your situation.

A worked week

Money in: $720. Money out: $80. Profit for the week: $640. At a 25% set-aside, about $160 goes to the tax savings account.

Once a month (add 10 minutes)

• Total each category and compare it to last month.
• Look at your top three expenses. Is each one still worth it?
• Check profit, not just sales. A busy month with high costs can earn less than a quiet one. Simple Profit and Loss Statement for a Small Business shows a simple monthly layout.

At the end of the year, the Small Business Year-End Bookkeeping Checklist covers the extra checks before tax time.

Common mistakes

• Mixing personal and business spending on one card.
• Logging only sales and forgetting fees, shipping, and small software charges. If you take cash and cards, How to Record Cash and Card Sales in Your Books shows how to log gross sales and card fees separately.
• Waiting until the end of the quarter to find missing receipts.
• Treating the tax set-aside as spending money.

If you want a head start: the Small Business Bookkeeping Spreadsheet ($12) has the ledger, categories, and monthly profit and loss summary already set up, so the weekly routine is just filling in rows.

Try the free break-even calculator (profit per sale and sales needed) →

Try the free owner pay calculator →

Related template: read about the small business bookkeeping template

See all Cedar & Ledger templates

Also see: Freelancer invoice

Also see: Small shop inventory count