Bookkeeping 101

End-of-Day Cash Reconciliation: 7 Steps

Spot errors and theft early. Learn a simple 7-step end of day cash reconciliation routine that takes 10 minutes and keeps your books accurate.

· · 6 min read
A small business owner seated at a desk, counting cash notes and coins next to a notebook and calculator, during end-of-

End of day cash reconciliation is the practice of comparing the cash you physically have with what your records say you should have. If they match, your books are clean. If they don't, something is missing or was entered wrong. Most small business owners and freelancers skip it, then spend weeks hunting for a lost 500 or a duplicate entry.

Doing it daily takes 10 minutes. Doing it weekly takes an hour. Letting it slide for a month can mean a full day of detective work. The routine below is designed to fit into your closing routine, whether you run a market stall, a service business or a freelance operation.

Step 1: Count your physical cash

Before you do anything else, count every note and coin in your till, your wallet or your safe. Count it twice. Write the total down or take a photo of the till before you leave.

Do this in a quiet moment when you're not distracted. Cash counting errors are the most common reason reconciliation fails. If you have staff, ask someone else to count and verify. If you use a card reader, ensure it's off and that no payments are still processing.

If your business is mostly card payments, this step is quick. If you take mostly cash, set aside 5 minutes. The time you spend here saves you 30 minutes of confusion later.

Step 2: Record any cash received that day

Open your cash book or app and add any cash transactions you haven't recorded yet. Include:

  • Sales or fees you received
  • Loans or personal money you put in
  • Refunds or cash returns from customers
  • Any other money that came in

If you use a cash book app like TheCashFox, add these as "Cash In" entries with the date and amount. Include a description ("Sale to XYZ Ltd", "Deposit from personal account"). If you're nervous about accuracy, use your phone camera to photograph each receipt as you go through the day, then record them in batches at the end.

Many freelancers and small shop owners lose track here because cash feels informal. But cash in is cash in, and it must be recorded the same day it arrives.

Step 3: Record any cash paid out that day

Now add every cash payment you made. This includes:

  • Supplies or stock you bought
  • Bills or rent paid in cash
  • Wages or freelancer payments
  • Travel, fuel or other expenses
  • Refunds to customers

If you kept receipts, now is the time to use them. A photo of a receipt stamped with today's date is legal proof of the expense. If your app supports attachments, upload them to each entry. If you spent cash without a receipt (tips, small items), estimate as best you can and note it in the description so you remember later.

The goal is to capture what left your pocket.

Step 4: Calculate your expected cash balance

Add up everything in step 2 (cash in). Subtract everything in step 3 (cash out). Add your opening balance (what you started the day with). The result is what you should have right now.

Here's a worked example:

  • Opening balance: 2,000
  • Cash in (sales): 1,500
  • Cash out (supplies): 300
  • Cash out (petrol): 100
  • Expected balance: 2,000 + 1,500 - 300 - 100 = 3,100

Write this number down. If you use a cash book app, the running balance updates automatically as you add entries, so you can see this figure without doing math.

Step 5: Compare expected balance to actual cash

Now compare the total you're holding (from step 1) with the expected balance (from step 4).

If they match, reconciliation is complete. Mark the date in your book or app and move on.

If they don't match:

  • Check for typos. A 50 entered as 500 is easy to miss.
  • Did you record every transaction? Look at your receipts again.
  • Did you count correctly? Count the cash one more time.
  • Is there a transaction from yesterday that should have cleared today? Dates matter.
  • Did you forget to record a personal withdrawal or a petty cash float?

Small gaps (under 1-2% of your balance) can sometimes be rounding errors, but they should still be investigated.

Step 6: Investigate discrepancies

If you're short cash or over by more than a small amount, you have a problem to solve. Here's how to narrow it down.

First, check whether the error is in today's transactions or an older mistake. Add up only today's cash in and cash out, then reconcile. If that balances, the error is in a previous day.

Next, review your last few days of entries. Look for:

  • A transaction entered twice
  • A transaction entered on the wrong date
  • An amount typed incorrectly (50 vs 500, 30 vs 300)
  • A transaction that should be cash out but was entered as cash in, or vice versa
  • A payment to you that you recorded but didn't actually receive

If you keep receipts or photos, compare them to your entries one by one. This is tedious but it works. If you're missing a receipt, ask yourself: did I really make that purchase, or did I record someone else's?

For a small business with many transactions, reconciling one week at a time is often easier than one day. The error is usually in the most recent 5-10 entries.

Step 7: Lock the books and plan to do it tomorrow

Once you've reconciled, record the date and the final balance somewhere you'll see it. If you use an app, many of them timestamp entries automatically. If you use a notebook, write the date and balance at the bottom of the day's entries.

If you found a discrepancy and fixed it, jot down what it was so you remember next time. ("Entered 500 as 50 on 17 October" or "Forgot to record freelancer payment.")

Then tomorrow, repeat. Consistency is what keeps errors small and fixes them fast.

Making end of day cash reconciliation part of your routine means you'll never waste a whole day hunting for a missing transaction. It also means you'll spot theft or payment processing errors within 24 hours, when you can still contact your customer or your payment processor.

Tools that make reconciliation easier

A plain notebook works, but it requires you to do all the math and remember every entry. A spreadsheet is better, but you still have to type everything in manually. A cash book app removes the math, timestamps every entry, stores receipts, and shows you the running balance without thinking.

If you sign up free at TheCashFox, you can record cash in and out, attach receipt photos to each entry, and see your updated balance instantly. The running balance updates as you add entries, so by the time you finish recording your day, you already know your expected cash total. On the Pro plan, you also get a weekly or monthly email summary of your cash flow, so you can spot trends (like spending creeping up in a certain category) without opening the app every day.

Many small business owners who get serious about reconciliation find they also get serious about categories and descriptions. Instead of "misc" or "other", you learn to tag each expense as "supplies", "travel" or "rent", which means you can answer questions like "How much did I spend on supplies this month?" without digging through a year's worth of entries.

Whether you use an app or a notebook, the routine is the same: count, record in, record out, compare, investigate, lock, repeat. Do it daily for a week and it becomes automatic. Do it daily for a month and you'll wonder why you ever skipped it.

More in Bookkeeping 101

Ready to track your numbers?

Setup takes 2 minutes. Free forever, no credit card required.

Create free account →