Skip to content
Counter Sales app iconCounter SalesStore operations

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

  1. At the end of the shift, the manager opens the reconciliation worksheet for the cash register.
  2. They count the drawer and enter the quantity of each denomination.
  3. Counter Sales compares the count with the cash expected from the day's sales.
  4. The manager sets the deposit amount and the closing amount left in the drawer.
  5. 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.

Counter Sales app icon

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.

Ask a product question

Product Questions