A cash drawer can look balanced at a glance and still conceal a mistake: a missed sale, an incorrect change amount, a duplicate entry, or a bill placed in the wrong compartment. A cash drawer reconciliation sheet gives staff a consistent way to compare the money on hand with what the register or point-of-sale system says should be there.
Used regularly, the sheet can make end-of-shift closeouts clearer, help businesses investigate discrepancies, and create a useful record for bookkeeping. This guide explains what a reconciliation sheet should include, how to use one, and how to make the process more reliable.
What Is a Cash Drawer Reconciliation Sheet?
A cash drawer reconciliation sheet is a form used to record and compare:
- The cash a drawer should contain, based on recorded transactions and starting funds
- The cash actually counted at the end of a shift or business day
- Any difference between those figures
- Relevant details, such as the employee, register, date, and explanation for a discrepancy
The sheet may be a printed form, spreadsheet, or feature within a point-of-sale (POS) system. Whatever the format, its purpose is the same: to document how the drawer was counted and whether the actual balance agrees with the expected balance.
Why Reconcile a Cash Drawer?
Spot mistakes promptly
A timely count can help uncover incorrect change, a transaction entered under the wrong tender type, a missed refund, or a cash drop that was not recorded properly. The sooner a discrepancy is noticed, the easier it may be to investigate.
Create a clear record
A completed sheet provides a record of who counted the drawer, when the count took place, and what was found. That documentation can support internal reviews and help a bookkeeper understand how cash was handled.
Improve accountability
A consistent process clarifies expectations for employees and managers. It also helps separate routine counting from the review or approval of results.
Support stronger cash controls
Reconciliation is one part of a wider system of internal controls. The U.S. Small Business Administration recommends keeping business finances organized and maintaining sound financial records; the details of cash handling should fit the size and needs of the business. [1]
What to Include on the Sheet
A useful cash drawer reconciliation sheet should be easy to complete and review. Consider including the following fields:
| Field | What it records |
|---|---|
| Business location | Store, branch, or department |
| Date and shift | The period being reconciled |
| Register or drawer ID | Which drawer was counted |
| Employee or cashier | Person responsible for the drawer |
| Starting cash or float | Cash placed in the drawer at the start |
| POS expected cash | Expected amount according to the register report |
| Denomination count | Number of bills and coins by denomination |
| Actual cash total | Total counted in the drawer |
| Cash drops or payouts | Cash removed or paid out, if applicable |
| Over/short amount | Difference between actual and expected cash |
| Explanation | Notes about a discrepancy or unusual transaction |
| Prepared and reviewed by | Sign-off by the counter and, where appropriate, a reviewer |
The sheet should match the business’s actual workflow. For example, a shop that removes cash during a shift should record each cash drop rather than relying on memory at closing.
How to Reconcile a Cash Drawer: Step by Step
1. Gather the necessary records
Before counting, collect the relevant POS or register report, the drawer’s opening-float record, and documentation for cash drops, payouts, refunds, or other adjustments. Use the same time period for the physical count and the system report.
2. Secure and identify the drawer
Follow the business’s cash-handling procedure. Confirm the register or drawer ID, date, and shift, and limit access while counting. If the business assigns drawers to individual employees, record that assignment.
3. Count the cash by denomination
Separate bills and coins, then count each denomination. Record the number of each and calculate its value. For example:
| Denomination | Quantity | Amount |
|---|---|---|
| $20 bills | 8 | $160.00 |
| $10 bills | 5 | $50.00 |
| $5 bills | 6 | $30.00 |
| $1 bills | 14 | $14.00 |
| Coins | — | $6.35 |
| Total counted | $260.35 |
Counting by denomination makes the total easier to verify and can help reveal a simple counting error.
4. Determine the expected cash balance
Use the POS report and the business’s established procedure to calculate how much cash should be present. A common basic formula is:
Expected cash = opening float + cash received − cash removed
“Cash received” and “cash removed” should reflect the business’s reporting conventions. For example, recorded cash drops, paid-outs, or change replenishments may affect the expected amount. Follow the POS system’s definitions rather than applying the formula mechanically.
5. Compare expected cash with actual cash
Calculate the difference:
Over/short = actual cash − expected cash
- A positive result means there is more cash than expected.
- A negative result means there is less cash than expected.
- Zero means the drawer balances.
For example, if expected cash is $260.35 and the count is $258.35, the drawer is $2.00 short.
6. Review discrepancies
If the drawer does not balance, recount it first. Then review the register report, transaction history, cash drops, refunds, voids, and other relevant records. Record what was checked and any explanation supported by the evidence. Avoid changing the figures simply to make the drawer appear balanced.
7. Sign, review, and file the sheet
The employee who performed the count should sign or otherwise identify themselves. Depending on the business’s controls, a manager or another authorized person may review the count and sign off. Store the sheet with the corresponding register report and supporting records according to the company’s recordkeeping policy.
A Simple Cash Drawer Reconciliation Example
Suppose a drawer starts with a $150.00 float. During the shift, the POS records $620.00 in cash sales, and staff make a documented $400.00 cash drop.
Using the basic formula:
Expected cash = $150.00 + $620.00 − $400.00 = $370.00
If the physical count is $368.00, then:
Over/short = $368.00 − $370.00 = −$2.00
The drawer is short by $2.00. The employee should record the amount, recount the cash, and follow the business’s discrepancy-review procedure.
This example is intentionally simple. Taxes, tips, refunds, paid-outs, cash back, and other transaction types may affect the calculation. The POS report and the business’s written procedures should determine which amounts belong in the reconciliation.
Common Reconciliation Mistakes to Avoid
Mixing the float with sales cash
The opening float is not sales revenue. Record it separately so that staff do not mistake the starting cash for money collected during the shift.
Forgetting cash drops or payouts
A drawer may appear short if money was removed but the cash drop was not recorded. Likewise, a payout or change replenishment can affect the count if it is not documented.
Counting before transactions are complete
An open sale, pending refund, or unclosed register report can make the expected balance unreliable. Follow the POS closeout steps before beginning the comparison.
Recording only a total
A single total is harder to verify than a denomination breakdown. Recording bills and coins separately helps another person check the arithmetic.
Treating every difference as misconduct
A discrepancy is a signal to review the process, not proof of wrongdoing. Counting errors, transaction mistakes, and missed documentation can all create differences. Investigate consistently and use factual notes.
Changing records without an audit trail
Corrections should be traceable. If a figure needs to be changed, follow the business’s correction procedure rather than overwriting information without explanation.
Best Practices for a More Reliable Process
- Use a standard form. Keep the same fields and calculation rules across shifts and locations.
- Count in a consistent setting. Use a secure, well-lit area with minimal interruptions.
- Separate duties when practical. Where staffing allows, have one person count and another review the result. This is a common internal-control practice, but small businesses may need an approach suited to their staffing.
- Keep supporting records together. Attach or link the POS closeout report and documentation for cash movements.
- Set a discrepancy policy. Define who reviews differences, what information must be recorded, and when a matter should be escalated.
- Review patterns, not just individual incidents. Repeated differences tied to a particular shift, register, or procedure may point to a process issue that needs attention.
- Protect sensitive records. Restrict access to cash records and retain them according to the organization’s recordkeeping rules.
Internal controls should be appropriate to the business’s size and operations. The Association of Certified Fraud Examiners describes internal controls as measures designed to help safeguard assets and support reliable records; a reconciliation sheet can contribute to those aims, but it does not replace broader controls. [2]
Paper Sheet, Spreadsheet, or POS Tool?
Each option has trade-offs:
- Paper forms are simple and work without specialized software, but they can be misplaced or difficult to analyze over time.
- Spreadsheets can calculate totals automatically and make trends easier to review, but they require careful access controls and version management.
- POS reconciliation tools may reduce duplicate data entry and connect counts to transaction reports, though setup and reporting capabilities vary.
Whichever format you choose, make sure the process is understandable, the calculations can be checked, and records can be retrieved when needed. A complicated template is not necessarily a better one.
Conclusion
A cash drawer reconciliation sheet turns a routine cash count into a consistent, reviewable process. By recording the opening float, expected cash, denomination count, actual total, and any difference, a business can close each shift with a clearer picture of what happened.
The most effective sheet is one that fits the business’s POS system and cash-handling procedures—and is completed carefully every time. Pair it with clear responsibilities, documented cash movements, and a fair discrepancy-review process to make daily closeouts more accurate and useful.
Sources
- U.S. Small Business Administration, “Manage your finances.” https://www.sba.gov/business-guide/manage-your-business/manage-your-finances
- Association of Certified Fraud Examiners, Occupational Fraud 2024: A Report to the Nations, discussion of internal controls and fraud prevention. https://www.acfe.com/fraud-resources/report-to-the-nations
- Internal Revenue Service, “Recordkeeping.” https://www.irs.gov/businesses/small-businesses-self-employed/recordkeeping