Articles | Updated 22 October 2026
Daily sales in Excel and the cash drawer does not match: how to fix it
A drawer that does not match the sales total in Excel usually does not mean money was stolen. It comes from payment channels not being kept apart, such as transfers mixed with cash, forgetting to subtract the opening float, or taking cash out for supplies without noting it. The fix is to close every day with the same steps, separate cash from transfers, record every cash movement in and out of the drawer, and log any difference with a reason
Common causes
Transfers mixed with cash
What you see: The drawer is short by exactly the transferred amount
How to prevent it: Record the payment method on every bill and total cash and transfers separately
Opening float not subtracted
What you see: The drawer is over by the morning float
How to prevent it: Note the float each morning and subtract it before comparing
Cash taken for supplies not noted
What you see: Unexplained shortage
How to prevent it: Keep receipts in the drawer and note cash out immediately
Wrong change
What you see: Small shortfalls or overages over several days
How to prevent it: Count change in front of the customer every time
Sales missed or entered twice
What you see: The Excel total differs from the bills issued
How to prevent it: Record from bills issued, not from memory in the evening
Voids or discounts without a record
What you see: File sales exceed money received
How to prevent it: Decide who may void or discount and record each one
| Reason | What you see | How to prevent it |
|---|---|---|
| Transfers mixed with cash | The drawer is short by exactly the transferred amount | Record the payment method on every bill and total cash and transfers separately |
| Opening float not subtracted | The drawer is over by the morning float | Note the float each morning and subtract it before comparing |
| Cash taken for supplies not noted | Unexplained shortage | Keep receipts in the drawer and note cash out immediately |
| Wrong change | Small shortfalls or overages over several days | Count change in front of the customer every time |
| Sales missed or entered twice | The Excel total differs from the bills issued | Record from bills issued, not from memory in the evening |
| Voids or discounts without a record | File sales exceed money received | Decide who may void or discount and record each one |
Closing the day step by step
- Get the day sales split by cash, transfer and card
- Count the cash in the drawer and subtract the opening float
- Add back cash taken out during the day, with receipts
- Compare with cash sales, and recount before concluding
- Check transfers against that day bank statement
- Record any difference with a reason and the closer name, every day
Why Excel makes tracing hard
Excel figures can be changed later without any trace of who changed them or when. When shortages repeat, you cannot find where things first went wrong, and anyone who can open the file can edit it. Good closing needs records that cannot be overwritten; at minimum save each day closing sheet as a PDF or photo
How to do it in the app
In GORINY staff open and close shifts with a cash count, and the system compares sales with the counted cash to show any difference at once. Cash, transfer and card are taken separately, so each channel is totalled for you. Cash in and out of the drawer and closing differences are posted to the books. The owner decides who may void bills or give discounts, and every action records who did it and when
Frequently asked questions
- Small shortages every day: what to do?
- Record each day difference with the closer name, then see which shift or channel it follows. A pattern usually shows within two weeks
- Should transfers be recorded separately?
- Yes. Mixed with cash, the drawer will be short by the transfers every time, and you cannot check against the bank
- How often should cash be counted?
- At least at each change of cashier and at closing. Shops with several shifts should count at every shift change
Related features
Get new articles and ask about store tax on LINE
Add GORINY's LINE OA as a friend. We only send things your store can actually use.
Try it with your own store's data
Sign up yourself right away for a free 14-day trial, no card needed. Or try the sample shop first.