Cash Register Reconciliation for Microsoft Dynamics 365 Business Central
Counting the drawer on paper and keying the totals into the general ledger later leaves room for errors and makes variances hard to trace. Counter Sales reconciles each cash register by denomination in Business Central, then posts the reconciled cash and any variance to the general ledger.
The worksheet records starting, ending, deposit, and closing amounts for one cash register.
Counter Sales has two versions on Microsoft Marketplace: North America for customers in North America; Worldwide for customers outside North America.
How Cash register reconciliation works in Counter Sales
- At the end of the shift, the manager opens the reconciliation worksheet for the cash register.
- They count the drawer and enter the quantity of each denomination.
- Counter Sales compares the count with the cash expected from the day's sales.
- The manager sets the deposit amount and the closing amount left in the drawer.
- Counter Sales posts the reconciled cash and any variance to the general ledger.
Key capabilities
Count by denomination
Enter the count of each bill and coin, and Counter Sales totals the drawer. Nobody adds up a tally sheet by hand.
Per register
Each cash register is reconciled on its own worksheet, with starting, ending, deposit, and closing amounts.
Variance posting
When the count does not match expected cash, Counter Sales posts the variance to the general ledger along with the reconciled cash.
Separated from other tenders
Card, gift card, and other payments are recorded by payment type on each order, so the drawer count is compared with cash only. See Multiple Payment Types.
Reconciliation history
Counter Sales reconciliations are kept as records in Business Central, so a past count can be reviewed.
See Cash register reconciliation on screen
Real screens from Counter Sales, shown with demo data.
Details that matter on the floor
The count becomes the entry
The denomination count is the input to the general ledger posting, so the number in the ledger is the number in the drawer, with the variance shown separately.
Who uses Cash register reconciliation
Store managers
Count and reconcile each cash register at the end of the shift.
Accounting staff
Receive reconciled cash and variances in the general ledger without rekeying.
Owners
See over and short amounts by register.
Questions about Cash register reconciliation
Does Counter Sales post cash variances to the general ledger?
Yes. Reconciled cash and any variance are posted to the general ledger from the reconciliation.
Can we reconcile more than one register?
Yes. Each cash register is reconciled on its own worksheet.
How does this fit with the end of the day?
Reconcile the drawers, then run the Daily Close to post the day's counter documents and advance the posting date.
Related Counter Sales features
All Counter Sales features →Part of Counter Sales
Streamline retail operations with simplified order entry, advanced tools, and efficiency-boosting features.
Have a question about Cash register reconciliation?
Send us a note and the Counter Sales team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
