DIY bookkeeping for a small business means you record every dollar in and out yourself, usually from your bank statements, a spreadsheet and a folder of receipts. For a one-person business with under a hundred transactions a month, it costs nothing but an hour or two a month, as long as you keep the habit going.
What does DIY bookkeeping for a small business cover?
DIY bookkeeping for a small business covers four jobs: recording each transaction, putting it in a category, checking the records against the bank, and producing totals you can file taxes from. Payroll, sales tax filings and the tax return itself are separate jobs. Many owners who keep their own books still pay a preparer for the return.
It helps to see the jobs as a short chain, because each one feeds the next:
- Recording. Every deposit, card charge, transfer and fee gets a row with a date, a description and an amount.
- Categorizing. Each row gets a label such as supplies, software, travel or sales. The labels should match the lines your tax form asks for, so year-end totals map straight across.
- Checking. The rows for a month should add up to the change in the bank balance for that month. If they do not, something is missing or doubled.
- Reporting. Monthly and yearly totals by category give you a profit figure and the numbers for your return.
The IRS does not require any particular software for this. Its IRS recordkeeping guidance for small businesses says you may choose any recordkeeping system suited to your business that clearly shows your income and expenses. A spreadsheet fed from bank statements meets that description, provided you keep the documents that back up each entry.
What DIY bookkeeping does not cover is judgment on unusual items. Buying a vehicle, taking on a loan, hiring a first employee or selling equipment all raise questions that a spreadsheet will not answer for you. Those are good moments to pay for an hour of advice rather than to guess.
A free DIY bookkeeping kit: statements, one sheet and a receipt folder
A free DIY bookkeeping kit has three parts: the statements your bank already gives you, one spreadsheet in Excel, Google Sheets or Numbers, and a cloud folder for receipt photos. You do not need accounting software to start. Everything in the kit costs $0 if you already own a phone and a computer.
The statements
Your bank statement is the spine of the system. The IRS page on what kind of records a business should keep notes that for most small businesses, the business checking account is the main source for entries in the books. Download each month's statement as soon as it closes, for every account the business uses, including any card.
Many banks also offer a CSV download of recent transactions. When yours does, use it: the rows arrive ready for a spreadsheet. When you only have PDFs, you either type the rows or convert the file.
The sheet
One workbook with one tab per year is enough. The columns that matter are date, account, description, amount, category and a note. Keep money out as negative numbers and money in as positive numbers, so a simple sum gives you the net change. A ready layout with these columns and the formulas filled in is in the bookkeeping spreadsheet template for one-person firms.
The receipt folder
A folder in the cloud storage you already have, with one subfolder per month, holds photos of receipts and invoices. Photograph a paper receipt the day you get it, and save emailed receipts as PDFs into the same folder. Name each file with the date and amount so it lines up with a statement row later.
The monthly DIY bookkeeping routine from bank statements
The monthly DIY bookkeeping routine takes each closed statement, turns it into spreadsheet rows, labels every row, checks the total against the balance, and files the receipts. Doing it once a month, in one sitting, is easier to keep up than daily entry. Seven steps cover it, in this order.
- Download the statements. Pull last month's statement for every business account on the same day each month, such as the 5th.
- Get the rows into the sheet. Paste a CSV export, type the rows, or convert the PDF.
- Clean the rows. Delete repeated header lines, make sure amounts are numbers rather than text, and give every row the account name.
- Categorize. Label each row. Most rows repeat from month to month, so the second month goes much faster than the first.
- Check the balance. Opening balance plus the month's rows should equal the closing balance printed on the statement. A gap means a missing or doubled row.
- Match receipts. For each expense over a threshold you choose, such as $75, confirm a receipt photo exists in the month's folder.
- Write down the month's totals. Income, expenses and profit for the month go on a summary tab, so the year builds itself.
Step 2 is where most of the time goes when your bank only gives PDFs. CheapBankConvert is a pay-per-statement converter, currently in early access, that turns a PDF statement into CSV or Excel with date, description, amount and balance columns. Its early price is $2.99 for a statement of up to 10 pages, with the first 2 pages previewed free, and nothing renews. The CheapBankConvert homepage has the current list.
Once a quarter, add one more step: read the category totals and ask whether anything looks wrong. A sudden jump in software spending often turns out to be a subscription you meant to cancel. A full method for that review is in how to do a spending audit with three statements, which works just as well on business accounts as personal ones.
How many hours does DIY bookkeeping take a month?
DIY bookkeeping takes most one-person businesses between one and three hours a month, depending on how many transactions there are and how the rows reach the spreadsheet. Typing rows by hand is the slowest step. Categorizing gets faster after the first two months, because the same vendors keep coming back.
The table below is an example for a business with 60 transactions a month across one checking account and one card. The minutes are illustrative estimates, not measurements, so time your own first month.
| Step (example) | Rows typed by hand | Rows from CSV or a converter |
|---|---|---|
| Download statements | 5 minutes | 5 minutes |
| Get rows into the sheet | 45 minutes | 5 minutes |
| Clean the rows | 10 minutes | 5 minutes |
| Categorize 60 rows | 20 minutes | 20 minutes |
| Check the balance | 10 minutes | 5 minutes |
| Match receipts | 15 minutes | 15 minutes |
| Write the month's totals | 5 minutes | 5 minutes |
| Total | 110 minutes | 60 minutes |
At an example value of $30 an hour for your own time, the typed version costs about $55 of time a month and the imported version about $30. Over a year that gap is roughly $300 of your hours. You can work out your own hourly figure with what is my time worth per hour.
Compare that with paying someone. Rates vary by region and by how tidy the records are, and how much a bookkeeper costs for a small business walks through the quote models and what pushes them up. For many tiny businesses, an hour a month of your own time is still the cheapest option by a wide margin.
DIY bookkeeping mistakes that end up costing a bookkeeper's fee
The DIY bookkeeping mistakes that cost the most are the quiet ones: mixing personal spending into business rows, skipping the balance check, and letting months pile up. None of them breaks anything on the day. Each one turns into hours of untangling at tax time, often paid at a bookkeeper's hourly rate.
Mixing personal and business rows. If groceries and client lunches run through the same account, every row needs a decision, and the decisions get harder to make months later. Tag each row business or personal as you go, and keep personal rows out of the business totals.
Skipping the balance check. A month that does not reconcile hides a missing row. One missed deposit understates income; one doubled expense overstates deductions. Both can cause trouble if the return is ever questioned.
Letting months stack up. Three months behind feels manageable. Nine months behind, with a box of faded receipts, is the point where owners pay for a cleanup. Ten minutes a week stops the backlog from forming.
Inventing categories as you go. "Office", "office stuff" and "supplies" spread one kind of spending across three labels, and the yearly totals stop meaning anything. Pick a short list once and stick to it.
Throwing away statements once the rows are in. The spreadsheet is your summary. The statements and receipts are the evidence behind it. Keep both, in the same place, for as long as the tax rules require.
When DIY bookkeeping stops being the cheap choice
DIY bookkeeping stops being the cheap choice when the hours it takes are worth more than the fee to hand it off, or when the work needs judgment you do not have. Payroll, inventory, sales tax across several states, and loans with interest to split out are common tipping points.
Watch for these signs:
- Bookkeeping takes more than about four hours a month, and those hours could go to paid work instead.
- You hire an employee. Payroll comes with deadlines and filings that carry penalties when missed.
- You hold inventory. Tracking stock and the cost of goods sold adds a layer that a simple cash sheet does not handle well.
- A lender, buyer or partner wants financial statements prepared to a standard you cannot produce from a spreadsheet.
- You keep falling behind even with a routine, which usually means the system no longer fits the business.
Paying for help does not have to mean handing everything over. Some owners keep the monthly routine and pay a bookkeeper to review the year once before the return goes in. That review costs a few hours rather than a monthly retainer, and the clean spreadsheet you kept all year is what keeps it short.