CheapBankConvertCheapBankConvert home

Single Entry Bookkeeping From Your Bank Statement

By CheapBankConvertPublished October 17, 2026

Single entry bookkeeping records each business transaction once, as money in or money out, in a running list. When all business money passes through one bank account, the bank statement can supply that list: copy each row, label it income, expense or excluded, and total the labels. It suits a small, simple business until loans, stock or staff appear.

What is single entry bookkeeping?

Single entry bookkeeping is a method that writes each transaction down one time, with its date, a description, an amount and a category. It tracks income and expenses, which is what a profit figure and a tax return need. It does not track what the business owns or owes in a separate set of accounts.

The IRS describes the method in its guide for new businesses, Publication 583 on starting a business and keeping records. It says a single-entry system is based on the income statement, the profit or loss statement, and that it is the simplest system to maintain, though not suitable for everyone. The same guide notes that double entry has built-in checks and balances.

That contrast is the whole trade. In double entry, every transaction touches two accounts, so the books must balance and many errors show themselves. In single entry, one row is one fact. It is quicker to keep and easier to understand, and it relies on you to catch mistakes.

What the method leaves out

A single entry record has no balance sheet. It will not tell you, on its own, how much clients owe you, what you owe suppliers, or what equipment the business holds. For a freelancer paid on the spot with a laptop and a phone, that missing piece is small. For a shop with stock and supplier credit, it is large.

The bank statement as your single entry record

A bank statement can serve as the single entry record when every business payment and receipt goes through that one account. The statement already lists each transaction once, with a date and an amount. Your job is to add a category and remove anything that is not business income or a business expense.

This only works under a few conditions:

  • One account, used only for the business. If personal spending runs through it, you must sort those rows out every month.
  • Few cash sales. Cash that never reaches the bank never reaches the statement. Record cash takings yourself and deposit them, or they are missing from the books.
  • Receipts kept alongside. The statement shows that money left. The receipt or invoice shows what it was for, which is what supports a deduction.

The statement also gives you a free check. Its opening balance, plus deposits, minus withdrawals, equals its closing balance. If your ledger rows for the month add up to the same change in balance, you have not dropped or doubled anything.

Cash takings in a statement-based ledger

Cash is the gap in this setup, and Publication 583 hints at the fix: its description of single entry includes a daily summary of cash receipts and monthly summaries of receipts and payments. For a business that takes some cash, that means a small extra habit. Write the day's cash total on a sheet or in a notes app each evening, then deposit the cash whole rather than spending some of it first.

Deposited whole, the cash shows up on the statement as one row that matches your daily notes. Spent before it reaches the bank, it vanishes from the books, and so do the purchases it paid for. If you do pay for something from the till, keep the receipt and add a ledger row for both the takings and the expense by hand.

Columns for a single entry ledger built from statement rows

A single entry ledger built from statement rows needs six columns: date, description, money in, money out, category and a reference to the receipt or invoice. The first four come off the statement. The last two you add. Separate in and out columns make the ledger easy to read on paper or screen.

Column Filled from Example value
Date Statement posting date 2026-09-12
Description Statement text PAYPAL TRANSFER
Money in Statement deposits column 640.00
Money out Statement withdrawals column
Category Your list Sales
Reference Your invoice or receipt number INV-0217

Keep the category list short, perhaps eight to twelve names. The list should match the expense lines on your tax form closely enough that a yearly total per category drops straight onto the return.

Getting the rows in is the slow part if your bank gives you only a PDF. CheapBankConvert, which is not open yet, is built to turn a PDF statement into a CSV or Excel file with date, description, amount and balance columns, so the first four columns arrive filled; the CheapBankConvert homepage has the early prices.

A worked month in a single entry ledger

A worked month shows the method end to end: copy the statement rows, mark each as income, expense or excluded, then total the first two. Excluded rows are money that moved but was neither earned nor spent by the business, such as an owner transfer.

The table is an example for a freelance designer. All figures are made up.

Date Description In Out Category
09-02 CLIENT A PAYMENT 1,800.00 Sales
09-05 ADOBE SUBSCRIPTION 59.99 Software
09-09 TRANSFER TO PERSONAL 1,000.00 Owner draw (excluded)
09-12 PAYPAL TRANSFER 640.00 Sales
09-18 OFFICE DEPOT 84.20 Supplies
09-23 REFUND OFFICE DEPOT 12.50 Supplies (refund)
09-30 MONTHLY SERVICE FEE 12.00 Bank fees

Now total it:

  1. Income: 1,800.00 + 640.00 = 2,440.00.
  2. Expenses: 59.99 + 84.20 + 12.00 − 12.50 = 143.69.
  3. Profit for the month: 2,440.00 − 143.69 = 2,296.31.
  4. Excluded: the 1,000.00 owner draw.

Check the bank side too. Money in on the statement was 2,452.50, money out was 1,156.19, so the balance rose by 1,296.31. Profit of 2,296.31, minus the 1,000.00 draw, is the same 1,296.31. The ledger matches the bank.

Notice where the refund went. It reduces supplies rather than counting as income. Twelve such months, totalled by category, make the yearly figures; building a profit and loss from bank statements shows that summary step in a spreadsheet.

Loans, refunds and owner money in single entry records

Loans, refunds and owner money are the rows that single entry gets wrong most often, because each one moves cash without being income or an expense. Treating them like ordinary rows inflates either income or spending, and the profit figure moves with it.

  • Loan proceeds. A business loan deposited into the account is not income. Mark it excluded. The repayments are partly interest, which is an expense, and partly principal, which is not. Your lender's statement shows the split.
  • Owner money in. If you top up the account from personal savings, that deposit is not a sale. Mark it excluded.
  • Owner draws. Money you move out for yourself is not a business expense for a sole proprietor. Mark it excluded.
  • Refunds. Net a supplier refund against the expense it reverses. Net a refund you give a client against sales.
  • Equipment. A large purchase such as a computer may need to be deducted over several years rather than all at once. Flag it so you or your preparer can treat it properly.

A simple test catches most slips. At the end of each month, add your income and subtract your expenses and excluded money out, then add excluded money in. The result should equal the change in the bank balance, as in the worked month.

Have you outgrown single entry bookkeeping?

You have outgrown single entry bookkeeping when the business holds things the method cannot track: unpaid invoices that matter, supplier credit, stock, loans, staff or several accounts. At that point you need to see what you own and owe, and double entry, usually through accounting software, does that.

Some signs come early. You cannot say, without digging, which clients still owe you money. You have more than one bank account or card for the business and keep losing track of transfers between them. Payroll is about to start. A lender has asked for a balance sheet. Any one of these is reason enough to move.

A halfway step before full double entry

There is a middle path for a business that has outgrown the pure method in only one way. If unpaid invoices are the problem, keep a simple invoice list beside the ledger: number, client, amount, date sent, date paid. When a payment lands on the statement, mark the invoice paid. If a loan is the problem, keep the lender's yearly statement with the books and copy the interest figure into the ledger. These lists fill the specific gap without changing how you record everything else.

The halfway step stops being enough when there are several such lists to keep in step, because keeping them in step is the job double entry was designed to do.

Moving does not mean throwing the ledger away. Your categorized rows become the starting history in the new system, and many tools import a CSV file of past transactions. Before choosing, compare the costs: the cheapest way to do bookkeeping sets a spreadsheet, free apps and paid software side by side. If you only want to track spending patterns rather than file accounts, importing a bank statement into a budgeting app may be all the tool you need.

All posts in Bookkeeping on a shoestring