Castan

How to do bookkeeping for a business: seven steps, in Excel, and how long to keep records

Bookkeeper leads this guide

Published 14 November 202612 minute read

Every outside fact read on 14 November 2026
On this page

The short answer

To do the bookkeeping for a business, do seven things: open a bank account used only for the business, choose the cash or the accrual method, set up a short list of categories, record every sale and every cost, keep the document that proves each one, reconcile the books to the bank statement every month, and close each month with a profit and loss statement.

In the US the law does not, except in a few cases, require any specific kind of records: you can choose any system suited to your business that clearly shows your income and expenses (IRS Publication 583, revised December 2024, page reviewed 30 April 2026). People search for this as “small business bookkeeping”, and the steps are the same whether the books live in a spreadsheet, in software or on paper. This is a guide and not tax advice; the rules quoted are the US and UK ones.

The seven steps

Bookkeeping for a business, step by step
StepWhat to doWhy it matters
1. A separate accountOpen a checking account for the business and use it for the business only. Pay business costs from it and deposit every receipt into it.The IRS calls it one of the first things to do when you start, and the account then becomes the main source of the entries in your books. In the UK a company’s banking must be separate from its owner’s (GOV.UK, read on 14 November 2026).
2. A methodChoose cash, where money counts when it arrives and when it leaves, or accrual, where income counts when you earn it and a cost when you incur it.The method decides which month and which tax year each amount lands in. In the US you choose it when you file your first income tax return.
3. CategoriesWrite a short list of income and cost categories, a chart of accounts, and give every entry exactly one of them.Categories that follow the lines of your tax return, Schedule C for a US sole proprietor, cut the work at tax time (Aspire’s guide to bookkeeping in Excel, published 15 July 2026).
4. Every transactionRecord each sale and each cost with its date, its amount, the other party and its category.The IRS advises recording transactions daily, and your books must show your gross income as well as your deductions and credits.
5. The proofKeep the document behind each entry: sales slips, paid bills, invoices, receipts, deposit slips and canceled checks, filed by year and by type of income or cost.The documents support the entries in your books and on your tax return. A statement proves that a payment was made; the invoice or receipt shows what it was for.
6. A monthly reconciliationWhen the bank statement arrives, check that it and your books agree, entry by entry, and correct what differs.The IRS says to reconcile the account each month: it confirms how much money you have, and it catches bank charges you did not record and errors on either side.
7. A monthly closeTotal the month into a profit and loss statement, list who owes you and whom you owe, and set aside the tax due on the profit.Financial statements are prepared from good records, and they help when you deal with your bank or your creditors.

What the monthly close produces is in our guide to the profit and loss statement, and the invoices that feed the books are in how to write an invoice.

Cash or accrual

Under the cash method you report income in the tax year you receive it and usually deduct a cost in the year you pay it. Under an accrual method you generally report income in the year you earn it, even if the payment comes later, and deduct a cost in the year you incur it, whether or not you have paid it (IRS Publication 583). The SBA, the US agency that supports business owners, gives the example: a sale made in January and paid in February, for $200, goes on January’s books under accrual and on February’s under cash (SBA, read on 14 November 2026).

The two methods side by side
What changesCash methodAccrual method
When income is recordedWhen the money arrivesWhen you earn it, usually the date of the invoice
When a cost is recordedWhen you pay itWhen you incur it, usually the date of the bill
What it is good at (SBA)Shows cash flow clearly and is easier to understandGives an immediate snapshot of the business and can reduce the tax burden
Where it falls short (SBA)Limited predictive value and less long-term clarityMore complex to manage, and the figures can deceive
A rule to knowThe default for UK sole traders and partners since the 2024 to 2025 tax year (GOV.UK, read on 14 November 2026)Generally required in the US for purchases and sales when you must account for inventory, with exceptions in IRS Publication 538

If you send invoices and wait weeks to be paid, cash-method books show a poor month when you did good work and a rich one when the money lands, so read them beside a list of what customers owe you. Whichever method you choose, keep to it: in the US you must use the same method for your books and your taxable income, and once it is set up you generally need the IRS’s approval to change it (IRS Publication 583).

Single-entry or double-entry

A single-entry system records the flow of income and costs once each: a daily summary of what came in, and monthly summaries of receipts and payments. The IRS calls it the simplest to maintain and a practical system for a business that is starting out. A double-entry system records every transaction twice, as a debit in one account and a credit in another, so the totals must agree and an error shows itself: paying $780 of rent is a debit to rent expense and a credit to cash. Its accounts show assets, debts and net worth as well as income and costs, where single-entry is built on the profit and loss alone. The same publication notes that recordkeeping software is relatively easy to use and asks for hardly any knowledge of bookkeeping (IRS Publication 583).

How to do bookkeeping in Excel

A spreadsheet is a legitimate set of books when it clearly shows your income and your costs. The layout below gives each job its own sheet and makes the transactions sheet the only place anything is typed. It is adapted from Aspire’s guide to bookkeeping in Excel, published 15 July 2026, with the reconciliation taken from the IRS’s sample record system.

A bookkeeping workbook, sheet by sheet
SheetColumnsWhat it is for
CategoriesCategory, type (income or cost), line of the tax returnThe chart of accounts. The transactions sheet picks from this list through data validation, so a category is never spelled two ways.
TransactionsDate, description, category, money in, money out, account or card, reconciledOne row for each movement of money. Every other sheet reads from this one.
Profit and lossThe categories down the side, the months across the topA SUMIFS formula adds up each category for each month from the transactions sheet; income less costs is the profit on the last row.
ReceivablesCustomer, invoice date, amount, due date, paid dateWho owes you and what is overdue, which a list of transactions does not show.
ReconciliationThe statement balance, deposits and payments not yet on the statement, the adjusted balanceThe monthly check that the workbook and the bank agree.
A transactions sheet, five rows in
DateDescriptionCategoryMoney inMoney outAccountReconciled
2 November 2026Invoice INV-2026-014, Acme Coffee Co.Service revenue$1,650Business checkingYes
3 November 2026Design software, monthly planSoftware$55Business cardYes
5 November 2026Rent, NovemberRent$780Business checkingYes
9 November 2026Contractor, logo workContractors$400Business checkingNo
12 November 2026Card processing feesPayment fees$48Business checkingNo

A workbook like this holds up while the business is on the cash method, has one bank account or two cleanly separated, records under roughly a hundred transactions a month, has no payroll and works in one currency; past that, the same guide advises moving to accounting software. The IRS’s own sample system for a sole proprietor has the same parts on paper: a daily and a monthly summary of cash receipts, a journal of payments with a column for each frequent cost, an annual summary and a bank reconciliation.

In the UK a spreadsheet is not always enough on its own. Sole traders and landlords whose qualifying income was over £50,000 in the 2024 to 2025 tax year have had to use Making Tax Digital for Income Tax since 6 April 2026; over £30,000 in 2025 to 2026 it applies from 6 April 2027, and over £20,000 in 2026 to 2027 from 6 April 2028 (GOV.UK, updated 26 March 2026). Their records must be created in software that works with the scheme, and a spreadsheet has to be digitally linked to it, for instance through linked cells or a CSV import (GOV.UK, guide updated 16 October 2026).

Doing your own bookkeeping from home

You can keep your own books from a kitchen table. Electronic records are held to the same rules as paper ones: they have to be complete, legible and retrievable for as long as the paper would have been kept (IRS Publication 583). What makes it work is a rhythm more than a tool.

  • Every week, half an hour: record the week’s sales and costs, file each receipt or invoice beside its entry, send the invoices that are ready and chase the ones that are late.
  • Every month: reconcile to the bank statement, total the month, and look at three numbers: the profit, the cash in the bank and what customers owe you.
  • Every quarter: set aside or pay the tax due on the profit so far, and check that the categories still fit the business.
  • Every year: hand the closed books and the documents to whoever prepares your return, and archive the year.

If the business itself runs from your home, the home is part of the books. In the US the simplified method for a home office multiplies $5 by the square feet used regularly and exclusively for the business, up to 300 square feet, which makes $1,500 at most (IRS Publication 583). In the UK a self-employed person who works from home 25 hours or more a month can claim a flat £10 a month for 25 to 50 hours, £18 for 51 to 100 and £26 for 101 or more, in place of working out the business share of the household bills (GOV.UK, read on 14 November 2026). And when the books take more of your time than they are worth, the SBA’s advice is to weigh a bookkeeper, who handles the day-to-day at a lower cost, against a certified public accountant, who costs more and brings formal accounting training.

How long to keep the records

How long business records must be kept
Where and whatHow longSource
United States, most records3 years after the return was filedIRS, page reviewed 30 June 2026
United States, when income left off a return is more than 25% of the gross income shown6 yearsIRS, page reviewed 30 June 2026
United States, a claim for a bad debt deduction or worthless securities7 yearsIRS, page reviewed 30 June 2026
United States, employment tax recordsAt least 4 years after the tax is due or paid, whichever is laterIRS, page reviewed 30 June 2026
United Kingdom, sole traders and partnersAt least 5 years after the 31 January submission deadline of the tax yearGOV.UK, read on 14 November 2026
United Kingdom, limited companies6 years from the end of the company financial year the records relate toGOV.UK, read on 14 November 2026

Two more rules sit beside the table. In the US there is no limit when no return was filed or the return was fraudulent, and records about property are kept until the limitation period ends for the year you dispose of it. In the UK a company that does not keep accounting records can be fined £3,000 by HMRC, and its director can be disqualified. When the tax period has passed, check before you shred: the IRS points out that an insurer or a creditor may ask for records for longer. Elsewhere, your own tax authority’s page is the one to read.

How Castan keeps the books

Castan builds and runs your company with you, from the first website to the monthly investor update. It is an AI, and its bookkeeper does the recording with you. Connect Stripe and payments, invoices and customers arrive on their own, so revenue needs no entry. Costs reach the expense ledger three ways: you add one by hand with its date, vendor, amount and category; you paste a bank export and Castan sorts the money that went out into sixteen categories, from hosting and payment fees to payroll, rent and taxes, for you to review before anything is saved; and a recurring cost, rent or a salary or a subscription, is entered once and posts itself every month. The Statements tab sets out the profit and loss on the cash basis with the months as columns and the invoiced revenue beside the collected, and downloads it as a file for whoever prepares your return. At the top of Financials are cash on hand, runway, what is expected in the next thirty days and what customers owe, with the late part marked, and every number traces to a payment, an invoice or an expense row. The bookkeeper also chases late invoices with your approval: how invoice follow-ups work in Castan.

Questions people ask

Can I do my own bookkeeping?

Yes. In the US the law does not require any specific kind of records, only a system that clearly shows your income and expenses, and the IRS notes that recordkeeping software is relatively easy to use (Publication 583, revised December 2024). Keep a separate account, record every transaction, keep the documents and reconcile each month; bring in a bookkeeper or an accountant when the books take more of your time than they are worth.

Can I do bookkeeping in Excel?

Yes, while the business is simple: a transactions sheet with the date, description, category, money in and money out, a list of categories, and a profit and loss built with SUMIFS. Aspire’s guide of 15 July 2026 puts the ceiling at roughly a hundred transactions a month, one currency and no payroll. In the UK, sole traders above the Making Tax Digital threshold must create their records in compatible software, with any spreadsheet digitally linked to it (GOV.UK, guide updated 16 October 2026).

Should I use cash or accrual accounting?

Cash is simpler and shows the money you actually have: income counts when it arrives and a cost when you pay it. Accrual counts income when you earn it and a cost when you incur it, and in the US it is generally required for purchases and sales when you must account for inventory (IRS Publication 583, revised December 2024). For UK sole traders and partners the cash basis has been the default since the 2024 to 2025 tax year (GOV.UK, read on 14 November 2026).

How long do I need to keep business records?

In the US, generally 3 years after the return was filed, 6 when income of more than 25% of the gross shown was left off, 7 for a bad debt claim, and at least 4 years for employment tax records (IRS, page reviewed 30 June 2026). In the UK, at least 5 years after the 31 January deadline for sole traders and partners, and 6 years from the end of the financial year for limited companies (GOV.UK, read on 14 November 2026).

Sources

  1. 1IRS: Publication 583, starting a business and keeping records, revised December 2024, page reviewed 30 April 2026any system that clearly shows income and expenses; a separate business account; the cash and accrual methods and changing between them; single and double entry; supporting documents; monthly reconciliation; the sample record system; the simplified method for a home office
  2. 2IRS: how long should I keep records, page reviewed 30 June 20263, 6 and 7 years; employment tax records for at least 4; no limit without a return or with a fraudulent one; property; reasons other than tax
  3. 3IRS: what kind of records should I keep, page reviewed 3 August 2026the business checking account as the main source of entries; supporting documents by type
  4. 4GOV.UK: business records if you’re self-employed, read 14 November 2026what to keep; the cash basis as the default from 2024 to 2025; at least 5 years after the 31 January deadline
  5. 5GOV.UK: company and accounting records, read 14 November 2026separate banking; the accounting records a company must keep; 6 years; the £3,000 fine
  6. 6GOV.UK: find out if and when you need to use Making Tax Digital for Income Tax, updated 26 March 2026qualifying income over £50,000 from 6 April 2026, £30,000 from 6 April 2027 and £20,000 from 6 April 2028
  7. 7GOV.UK: use Making Tax Digital for Income Tax, create digital records, guide updated 16 October 2026what a digital record is; digital links, among them linked cells in spreadsheets and CSV import
  8. 8GOV.UK: simplified expenses if you’re self-employed, working from home, read 14 November 202625 hours a month or more; flat rates of £10, £18 and £26 a month
  9. 9SBA: manage your business, manage your finances, read 14 November 2026the January sale paid in February; what each method is good at; a bookkeeper and a certified public accountant compared
  10. 10Aspire: bookkeeping in Excel, a practical guide, published 15 July 2026categories that follow Schedule C; the transactions sheet and its columns; data validation; SUMIFS for the profit and loss; a receivables sheet; when a spreadsheet stops being enough
  11. 11Castan: the bookkeeper and Financials

Prices and terms at other companies change over time. Every figure on this page carries the day it was read, and the page it was read on is linked above. If one has moved since, write to hello@castan.ai and the page is corrected. General information, not tax, legal or accounting advice.