Bookkeeping & Income Tracking

Small Business Bookkeeping: A Simple System You Can Keep

A step-by-step guide to small business bookkeeping: choose cash or accrual, separate your accounts, set up categories, record weekly, keep IRS-ready records and read a monthly P&L.

Short answer: small business bookkeeping is the habit of recording every dollar that comes in or goes out of the business, sorting it into a few consistent categories and keeping the paperwork that proves it. A system that works for most owners has six parts: a separate business account, a short list of income and expense categories, a weekly recording session, an organized folder of receipts and invoices, a monthly check against the bank statement, and a monthly profit and loss report you actually read.

This guide walks through each part in the order you would set it up. It is written for sole proprietors, freelancers and small teams in the United States who keep their own books, often in a spreadsheet, and want a routine that holds up at tax time. It explains how bookkeeping works; it is not tax or legal advice, and a tax professional should confirm anything that affects your return.

What bookkeeping covers (and what it does not)

Bookkeeping is the record: what you sold, what you spent, what you own, what customers owe you and what you owe others. Accounting and tax preparation use that record to produce financial statements and returns. If the record is complete and consistent, everything built on it is easier and cheaper; if it is not, an accountant has to rebuild it first.

For a small business, the record usually comes down to four streams:

  • Income — sales, client payments, refunds you issued and any other money the business earns.
  • Expenses — what the business pays to operate: supplies, software, advertising, contract labor, rent, fees.
  • Money owed — invoices customers have not paid yet and bills you have not paid yet.
  • Assets — equipment and other items you bought for the business and will use for more than a year.

First decision: cash method or accrual method

Your accounting method decides when a transaction is recorded. The IRS describes the two main methods in Publication 583, Starting a Business and Keeping Records:

  • Cash method: you report income in the year you receive it and generally deduct expenses in the year you pay them.
  • Accrual method: you generally report income in the year you earn it and deduct expenses in the year you incur them, whether or not money has changed hands yet.

Most very small service businesses find the cash method simpler, because the books follow the bank account. Businesses that carry inventory have additional rules to consider. Two points from the IRS guidance matter for anyone keeping their own books: the method you use for your books should be the same one you use to figure taxable income, and changing methods later generally requires IRS approval. If you are unsure which method applies to you, settle it with a tax professional before you start, not after a year of records.

Step 1: Separate business money from personal money

Open a checking account used only for the business, and if you use a card for business purchases, keep that one for business too. Publication 583 says plainly that you should keep your business account separate from your personal checking account. The practical reasons are easy to see:

  • Your bank statement becomes a ready-made list of business transactions to record and check.
  • You stop sorting personal groceries out of business supplies every month.
  • When you pay yourself, it shows as one clear transfer instead of dozens of mixed purchases.

If a personal card is ever used for a business purchase, record it as a business expense paid by the owner and keep the receipt with your business records.

Step 2: Set up a short list of categories

Categories turn a long list of transactions into numbers you can use. Keep the list short enough that you never hesitate when choosing one. A good starting point for many small businesses:

Type Example categories
Income Product sales, service income, other income, refunds issued
Cost of goods sold Materials, packaging, shipping to customers, platform fees per sale
Operating expenses Advertising, software and subscriptions, office supplies, contract labor, professional fees, rent, utilities, phone and internet, travel, bank fees
Not an expense Owner draws or transfers, loan principal, equipment purchases tracked as assets

Sole proprietors file business income and expenses on Schedule C, so it saves time to name your expense categories in a way that maps cleanly onto the expense lines of that form. Whatever you choose, use the same category for the same kind of cost every time; a category list that changes every few months makes year-over-year comparisons meaningless.

Step 3: Record every transaction the same way

Whether you use a spreadsheet or software, each transaction needs the same small set of details. Capture them once and you will rarely need to go back to the receipt.

Field Why it matters
Date Places the transaction in the right month and tax year.
Customer or vendor Lets you see who your best customers and biggest costs are.
Description A few words you will still understand next April.
Amount Recorded as money in or money out, without mixing signs.
Category Chosen from your fixed list in Step 2.
Payment method or account Needed to match the entry against the bank or card statement.
Document reference An invoice number or receipt file name, so proof is one search away.

Set a fixed time each week, even 20 minutes, to record the week’s transactions. Small weekly sessions are far easier than reconstructing a whole quarter from memory and bank downloads.

Step 4: Keep the documents that support each entry

An entry in your books is only as good as the document behind it. Publication 583 lists the kinds of supporting documents the IRS expects, including:

  • Gross receipts: bank deposit slips, receipt books, invoices, credit card charge slips and Forms 1099-MISC or 1099-NEC you receive.
  • Expenses: canceled checks, account statements, credit card slips, invoices and petty cash slips.
  • Assets: purchase and sales invoices, real estate closing statements and canceled checks.

A simple folder structure is enough: one folder per tax year, with sub-folders for income, expenses and assets, and file names that start with the date and vendor (for example 2026-03-14 hosting-company invoice.pdf). Scan paper receipts when you record them so nothing fades in a drawer.

How long to keep records

The IRS says to keep records as long as they may be needed for the administration of any provision of the tax code, and ties most periods to the period of limitations for the return. The main periods in Publication 583:

Situation Keep records for
General rule (you owe additional tax and the other cases do not apply) 3 years
You did not report income that is more than 25% of the gross income shown on the return 6 years
You claim a loss from worthless securities or a bad debt deduction 7 years
A fraudulent return, or no return filed No time limit

Records for assets such as equipment are generally needed until the period of limitations expires for the year you dispose of the asset, and employment tax records follow their own rules. If in doubt, keep the record and ask your tax professional before you delete anything.

Step 5: Reconcile with your bank statement every month

Reconciling means checking that your books and the bank agree. Once a month, take the bank and card statements and tick off each transaction against your records. Anything on the statement that is missing from your books gets recorded; anything in your books that never cleared the bank gets investigated. When both sides match, the ending balance in your records equals the statement balance, and you can trust the reports built on them.

Reconciliation is also where most errors surface: a duplicate entry, a sale recorded twice, a subscription you forgot to cancel. Catching them monthly keeps each fix small.

Step 6: Read a monthly profit and loss report

A profit and loss report (P&L, or income statement) summarizes a period in a few lines:

  • Revenue — total income for the month.
  • Cost of goods sold — the direct costs of what you sold.
  • Gross profit — revenue minus cost of goods sold; dividing it by revenue gives your gross margin.
  • Operating expenses — the costs of running the business regardless of sales.
  • Net profit — gross profit minus operating expenses.

Look at three things each month: whether net profit is positive, which expense category grew the most, and how this month compares with the same month last year once you have a year of data. Remember that profit is not the same as cash. A month can show a profit while the bank balance falls, because customers have not paid yet, you bought equipment, or you moved money to yourself. Keep an eye on both the P&L and your cash balance. For a line-by-line walkthrough with a worked example, see how to read a profit and loss statement.

Plan for taxes during the year

Good books make tax time a reporting exercise instead of a research project, but they also help during the year. According to Publication 583, sole proprietors generally have to make estimated tax payments if they expect to owe $1,000 or more in tax when they file their return, using Form 1040-ES. Your monthly P&L gives you the profit figure you need to estimate those payments. Many owners move a share of each payment received into a separate savings account so the money is there when a payment is due; the right share depends on your situation, which is a conversation to have with a tax professional.

A routine you can keep

Every week (15–30 minutes)

  • Record all sales and expenses since last week with the seven fields above.
  • Save receipts and invoices into this year’s folder with dated file names.
  • Send any invoices that are due and note payments received.

Every month (about an hour)

  • Reconcile the business bank account and card against your records.
  • Review the monthly P&L and your cash balance.
  • Follow up on unpaid invoices and review recurring subscriptions.
  • Set aside money for taxes based on the month’s profit.

Every quarter and every year

  • Check estimated tax payments against your year-to-date profit.
  • At year end, export your records, back up the folder and hand your tax professional a clean P&L and the supporting documents.

Spreadsheet, software or bookkeeper?

There is no single right tool; the right one is the one you will keep up to date.

Spreadsheet Accounting software Bookkeeper
Best for Freelancers and small businesses with a modest number of transactions and no payroll Growing businesses, bank feeds, payroll or sales tax to manage Owners who would rather pay than spend the time, or whose books have fallen behind
Learning curve Low if the template is clear Moderate: accounts, rules, reconciliation screens Low for you, but you still supply documents
Ongoing cost No subscription for a file you own Usually a monthly subscription A fee for the bookkeeper’s time
Main risk Manual entry errors and skipped weeks Paying for features you never set up Less day-to-day familiarity with your own numbers

A spreadsheet is a sensible start if you have a modest number of transactions, no employees and no inventory to value. When you add payroll, start collecting sales tax, or find yourself spending hours a week on entry, it is usually time to move to software or bring in a bookkeeper.

If you start with a spreadsheet, our step-by-step guide to building a bookkeeping template in Excel shows the sheet layout, drop-down lists and formulas, including a bank reconciliation check. For a deeper look at the trade-offs, read bookkeeping spreadsheet vs accounting software.

Common mistakes to avoid

  • Mixing personal and business spending in one account, then trying to separate it at year end.
  • Recording only expenses and treating bank deposits as income without checking what they are; transfers and loans are not income.
  • Changing categories mid-year, which breaks comparisons.
  • Skipping reconciliation, so small errors compound for months.
  • Throwing away receipts once the expense is recorded.
  • Confusing profit with cash and spending money that is already owed in taxes.

Frequently asked questions

Can I do my own bookkeeping as a small business owner?

Yes. Many sole proprietors and freelancers keep their own books with a spreadsheet or software. The essentials are a separate account, consistent categories, a weekly recording habit, organized documents and a monthly reconciliation. Use a tax professional to confirm your accounting method and to prepare or review your return.

Do I need double-entry bookkeeping?

Not necessarily for day-to-day decisions in a very small business; a single list of income and expenses can tell you whether you made money each month. Double-entry systems, which most accounting software uses behind the scenes, become more useful as you add loans, inventory, payroll or several accounts, and when you need a full balance sheet.

How often should I update my books?

Weekly is a good rhythm for recording, with a monthly reconciliation and review. The longer the gap, the harder it is to remember what a transaction was for.

What is the difference between bookkeeping and accounting?

Bookkeeping is recording and organizing transactions. Accounting interprets those records: preparing financial statements, planning taxes and advising on decisions.

Is a spreadsheet enough for taxes?

It can be, as long as it is complete, categorized consistently, reconciled with your bank statements and backed by the supporting documents. What matters to the IRS is that your records are accurate and can be verified, not the tool you used to keep them.

Where to go next

For more on recording income and expenses and choosing a ledger layout, see our bookkeeping and income tracking guides, or browse every topic in small business finance. We are also building a Small Business Income and Expense Tracker for Excel that follows the routine in this guide; it is marked as coming soon and is not on sale yet. If you have a question about formats or downloads, our FAQ covers the basics.

Source used for IRS rules in this guide: IRS Publication 583, Starting a Business and Keeping Records. Rules can change; check the current version of the publication or ask a tax professional before acting on them.

Bookkeeping & Income Tracking · November 4, 2026

Bookkeeping Spreadsheet vs Accounting Software: How to Choose

A practical comparison of keeping your books in a spreadsheet or in accounting software: what each does well, where each breaks down, the signs it is time to switch and how to move without losing history.

Read guide
Bookkeeping & Income Tracking · November 4, 2026

How to Read a Profit and Loss Statement: A Line-by-Line Guide

Read a profit and loss statement from top to bottom: what each line means, how to calculate gross, operating and net margin, how to compare periods and what the report does not tell you.

Read guide
Bookkeeping & Income Tracking · November 4, 2026

Bookkeeping Template in Excel: How to Build One Step by Step

Build a working bookkeeping template in Excel from a blank workbook: a transactions table with drop-downs, a SUMIFS monthly summary, profit lines and a bank reconciliation check.

Read guide