Daily cash reconciliation: records, calculations and checks

Sales tell you what was sold. Payment records tell you how money was received or is still due. Drawer records tell you what physically entered or left the till.

A transfer payment does not increase the cash drawer. Money taken from the drawer for a supplier reduces the drawer, but it does not undo a sale. A customer’s transfer screenshot is not the same as independently confirming the money reached your account.

At the sale, record the item, amount, time, person handling it and payment method. For split payments, record the separate amounts. Keep a payment reference that lets a reviewer find the matching bank or provider record without collecting unnecessary customer data.

For example, suppose your shop records the following drawer movements in NGN. The count is taken before any closing bank lodgement. There are no other drawer movements in this example.

If the physical count is ₦173,000, the drawer is ₦2,000 short against that expectation. Record the difference and investigate it. Do not create a fictional expense to force the figures to agree.

Check the opening count, change given, refunds, payouts and any transaction recorded with the wrong payment method. A later correction should preserve who changed what and why. The difference itself is not proof of misconduct.

If cash is removed for banking after this count, record that movement separately and retain its handover or deposit evidence. Do not subtract it from a calculation that already measured the drawer before removal.

Suppose a customer says they transferred ₦25,000 for an order. The sales record says “transfer,” but the receiving account doesn't yet show a matching credit. Keep the order reference, amount, time and confirmation status together. No part of that ₦25,000 belongs in the cash-drawer count.

If the credit later appears and matches, link it to the existing payment record. Don't record a second sale. If it remains unconfirmed, leave it open for the manager to investigate under the shop's payment policy. An alert or screenshot supplied by the customer doesn't settle the question.

Refunds need the same care. Link each one to the original sale and record how the money was actually returned. For cash paid to a supplier, retain the authorization and receipt beside the drawer movement.

These details are easier to capture during the event than reconstruct from a message thread hours later. Software helps only if the team knows where and when to record them.

End the day with a short open-items note:

• Item: what does not yet match?
• Evidence: which sale, payment, receipt or count supports it?
• Owner: who will investigate?
• Next action: what will they check, and by when?
• Status: unresolved, explained or corrected, with a reference to the correction.

For the shortfall above, you could write: “₦2,000 drawer difference. Manager to review refunds and recount by tomorrow morning.” Keep the item marked unresolved until the review is complete.

Record cash movements when they occur, retain supporting receipts and compare the expected balance with the physical count at close. Review transfers separately and assign unresolved items to a named person. This provides a consistent record for the next shift or the manager reviewing the day.