How to Maintain a Cash Book by Hand

A cash book is nothing more than a record of money in and money out. To maintain a cash book by hand, you write down each transaction as it happens, note the date and amount, and track your running balance. That's the core of it. No spreadsheet formulas, no login credentials, no subscription fees. Just clarity on where your money is.

For a freelancer or small business owner, a hand-written cash book is often enough to start. But as your business grows, the method itself becomes a bottleneck. Pages fill up. Balances drift. A receipt gets lost. This post walks you through the proper way to do it, and shows you when a simpler tool makes sense.

The Essential Structure of a Cash Book

A hand-written cash book has five columns: date, description, money in, money out, and balance. That's it.

When you receive cash or a bank transfer, you write it in the money-in column. When you spend, it goes in money-out. The balance column always shows what you have left. Every single entry updates the balance.

Here's a real example. Say you start Monday with 500 in the bank. You invoice a client for 1,200 on Monday afternoon and they pay the same day. Your entry looks like this:

Date: 11 Oct | Description: Invoice 45, client payment | Money In: 1,200 | Money Out: (blank) | Balance: 1,700

On Tuesday you buy supplies for 80. New balance: 1,620. Wednesday you pay yourself 400. Balance: 1,220.

That's the method. The balance in the final column at any moment tells you exactly how much cash you have. If it ever goes negative, you're spending more than you're earning.

Write clearly. Use one line per transaction. Never cross out; if you make a mistake, draw a single line through it and write the correct entry on the next line. This makes it easy to spot what changed and when.

Choosing the Right Format and Medium

You have three choices: a ruled notebook, a printed ledger, or a spreadsheet.

A ruled notebook is the cheapest and quickest to start. Any A4 or A5 notebook works. Draw five columns with a ruler at the top of the first page, and you're done. The downside: handwriting takes time, space fills up fast, and finding a specific transaction means flipping through pages.

A printed ledger (a cash book pad designed for this purpose) has pre-drawn columns and multiple pages bound together. You can buy one online or at a stationery shop for a few pounds or dollars. It looks more professional and saves you the setup time. The same speed and space limits apply.

A spreadsheet (Excel, Google Sheets, or LibreOffice) is a hybrid. You type entries instead of writing them. A formula calculates the balance automatically. You can sort by date, search by description, and print clean pages. The catch: you need a device with you, or you have to write down transactions and type them later. Spreadsheets also offer no protection if you accidentally delete a column.

Many people start with a notebook or ledger because it feels immediate and permanent. There's a real advantage to that: you can't accidentally lose a day's worth of entries to a crashed laptop.

If you choose a notebook, keep it on your desk or in your bag at all times. Write entries the same day. At the end of each week, review the balance and count your actual cash or bank balance to check it matches. If it doesn't, find the error before you move on.

Recording Transactions Correctly

Every transaction needs a date and an amount. Add a short description so you know what it was for when you read it weeks later.

"Cash received" is not enough. "Cash received, client ref SM47" is better. "Invoice 102 paid by Sarah Mitchell, web design project" is best.

For money out, note what you spent it on and why: "Office stationery for September", "Rent for workshop", "Accountant consultation". This makes it much easier to spot overspend in any category later, and it helps if you need to explain a transaction to your accountant or a tax authority.

Record transactions in date order. If you're writing them by hand at the end of the day, sort them by the time they happened. This matters because your running balance is only correct if every entry is in the right sequence.

If you make a mistake, don't erase or write over it. Draw one line through the wrong entry and write the corrected version on the next line with a note like "Correction: amount should be 50, not 5". This leaves an audit trail. Anyone reading your book later can see what you originally wrote and what you changed.

Keep receipts. The cash book is a summary; the receipt is proof. Staple or clip receipts to the notebook, or store them in a folder with the same date reference. When a balance doesn't match your actual cash, the receipts help you find what you missed.

Tracking Running Balance and Catching Errors

The balance column is your lifeline. It's the fastest way to spot a mistake.

After every 5 or 10 entries, pause and count your actual money or check your bank balance online. Does it match the cash book balance? If yes, you're on track. If no, there's an error in that block of entries.

If the actual balance is lower than your cash book says, you've either miscalculated or missed a transaction. Go back through those 5 to 10 entries and add them up by hand. Do the money-in figures add up to what you think? Do the money-out figures? Add money in, subtract money out, and see what you get. Compare it to the last balance you verified.

If the actual balance is higher than your cash book, you've missed a money-in entry. Check bank statements, PayPal, invoice records, and any other source of incoming cash. Fill in any gaps.

Do this check at least once a week, more often if you have many transactions. It takes 5 minutes and saves hours of detective work later.

Keep a separate "Discrepancies" note. Write down anything that doesn't add up. Over time, you'll see patterns (maybe you always forget to record card payments, or you miscount change). Fix the pattern, not just the entry.

A Simple Worked Example Over One Month

Let's walk through October for a freelancer.

October 1, opening balance: 800

Oct 3: Invoice 201 paid (3,000 in). Running balance: 3,800.

Oct 5: Pay website hosting (25 out). Balance: 3,775.

Oct 7: Cash workshop fee (500 in). Balance: 4,275.

Oct 10: Supplies (60 out). Balance: 4,215.

Oct 12: Invoice 202 paid (2,000 in). Balance: 6,215.

Oct 15: Pay software subscription (30 out). Balance: 6,185.

Oct 18: Pay myself (2,000 out). Balance: 4,185.

Oct 22: Invoice 203 payment received (1,500 in). Balance: 5,685.

Oct 25: Equipment purchase (200 out). Balance: 5,485.

Oct 29: Invoice 204 paid (2,500 in). Balance: 7,985.

Oct 31, closing balance: 7,985.

Total money in for the month: 3,000 + 500 + 2,000 + 1,500 + 2,500 = 9,500.
Total money out: 25 + 60 + 30 + 2,000 + 200 = 2,315.
Net change: 9,500 minus 2,315 = 7,185.
Opening balance (800) plus net change (7,185) = 7,985.
Closing balance matches.

This match tells you the cash book is correct. If your actual bank account also shows 7,985, you're done. If it doesn't, something outside the cash book happened (a fee, an uncredited deposit, or you haven't recorded something).

When a Hand-Written Cash Book Stops Working

A paper or spreadsheet cash book works fine until it doesn't. Common breaking points:

You have more than one income stream or business and mixing them up costs you money.

You share finances with one or two team members, and they need to see the same balance in real time.

You spend 30 minutes every evening writing up transactions.

You need to know how much you spent on each category of expense (rent, supplies, marketing), not just total spend.

You want to export a summary for your accountant or to review trends.

You receive receipts as photos and can't easily link them to entries.

When two or three of these apply, a digital cash book makes sense. Sign up free and you get one business, unlimited entries, and no credit card required. You can record transactions just as quickly as on paper, the balance updates instantly, and you can attach receipts. If you need team members, export options, or spending reports, Pro is 5 dollars a month.

The goal is the same as a hand-written book: know your balance at any moment and never lose track of where your money went. A digital tool just makes that faster and less error-prone as you grow.