End-of-day reconciliation is a critical control for organisations that process payments through POS terminals. It confirms that recorded sales, collected cash, card transactions, and settlement reports agree before the business closes its financial records.
A structured process helps identify discrepancies such as missing transactions, duplicate entries, cash shortages, and delayed card settlements. By reviewing and documenting these differences promptly, banking and finance teams can strengthen transaction accuracy, accountability, and operational control.
Establishing an Accurate End-of-Day Reconciliation Process
An accurate end-of-day reconciliation begins with a documented procedure covering transaction cut-off times, staff responsibilities, required reports, and approval steps. The process should remain consistent across business days so that POS activity can be compared reliably with banking records.
Before reconciliation starts, staff should secure the relevant POS terminals and obtain complete records for the operating period. These may include transaction totals, refunds, voids, gratuities, cash movements, and card settlement information. System timestamps should be checked where business hours cross midnight.
Access to reconciliation records should be limited according to established banking controls. Each employee should use an individual login, and manual adjustments should require a reason and supporting evidence. Separating preparation from review can reduce undetected errors.
The process should also define how differences are recorded and escalated. No amount should be altered merely to force agreement between records; unexplained variances should remain visible for investigation during the subsequent end-of-day reconciliation steps.
POS Transaction Data to Review at Day-End
Review the POS terminal’s end-of-day transaction report for total sales, refunds, voids, discounts, taxes, tips, and transaction counts. These figures establish the expected activity before payment settlements and cash holdings are compared.
Separate transactions by payment method, including cash, debit cards, credit cards, mobile wallets, and other accepted options. Verify that each category reflects authorized, completed, and reversed transactions recorded during the business day.
Check transaction timestamps, terminal identifiers, batch numbers, and operator records, particularly when multiple terminals or shifts are involved. Out-of-sequence entries, offline transactions, and manually entered payments may require separate examination under the institution’s procedures.
Accurate data collection supports end-of-day reconciliation by providing a complete record for comparison with settlement reports, cash counts, and ledger entries. Retain system-generated reports securely according to applicable banking controls and record-retention requirements.
Matching POS Records With Settlement Reports
Compare the POS terminal’s end-of-day transaction totals with the processor or bank settlement report for the same business date. Review gross sales, refunds, voids, discounts, tips, taxes, fees, and the net amount expected for deposit.
Use transaction IDs, batch numbers, terminal identifiers, and settlement dates to align both records. A settlement may occur on a different calendar day, particularly for late-night transactions, weekends, or holidays, so the applicable processing cut-off should be verified.
Record each matched amount and identify differences by transaction type. A variance may result from delayed processing, an authorized refund, an offline transaction, processing fees, or a batch that was closed after the reporting period. Do not treat timing differences as losses without confirming the settlement cycle.
During end-of-day reconciliation, retain the POS report and corresponding settlement report together. Document the variance, supporting evidence, and any corrective action required under the institution’s banking control procedures.
Reconciling Cash Collected Through POS Terminals
Reconcile cash collected through POS terminals by comparing the system’s expected cash total with the physical amount counted in each drawer. Use the terminal’s end-of-day report, sales records, refunds, voids, and approved cash transactions to establish the expected figure.
The counted cash should be verified by an authorized employee and recorded according to established banking controls. Separate tills or cashier drawers should be reconciled individually before combining totals, reducing the risk of concealing errors between locations or operators.
Record every overage or shortage with the date, terminal or drawer identifier, employee responsible, amount, and supporting explanation. Repeated differences may indicate counting errors, incorrect change, unrecorded transactions, or unauthorized activity and should receive appropriate review.
Cash drops and drawer movements must also be checked against signed logs and POS records. Each transfer should show the amount, time, originating drawer, receiving location, and authorizing personnel, creating an auditable trail for the end-of-day reconciliation.
Comparing the expected and counted cash
At day-end, determine the expected cash balance from POS records, beginning drawer funds, cash sales, refunds, payouts, and documented cash drops. Use the terminal’s transaction totals and approved adjustment records rather than estimates or informal notes.
Count the physical cash in the drawer or designated storage area separately from the person responsible for the transactions, where controls permit. Sort denominations, record the count on a reconciliation sheet, and exclude non-cash payments such as card or mobile-wallet transactions.
Compare the counted amount with the expected balance and calculate the variance. A surplus indicates more cash was present than recorded, while a shortage indicates less. Check that the opening float, cash drops, and authorized drawer movements were entered correctly before treating the difference as an error.
During the End-of-day reconciliation, retain the expected total, counted amount, variance, date, terminal identifier, and staff sign-off. These records provide an auditable basis for investigating differences and supporting banking controls.
Documenting cash overages and shortages
Record every cash overage or shortage on the daily reconciliation form, including the terminal or drawer identifier, business date, expected cash amount, counted amount, and exact variance. The record should also include the employee responsible for the count and the time it was completed.
A clear explanation should accompany each variance when the cause is known. Supporting evidence may include cash-count sheets, approved cash drops, refund records, voided transactions, or documented drawer transfers. Avoid altering the original POS record; corrections should follow the organization’s approved adjustment procedure.
Supervisors should review and authorize material or recurring differences according to established banking controls. Unresolved variances should remain visible in the reconciliation record, with the investigation status, assigned reviewer, and any follow-up action documented.
Consistent records create an audit trail for the End-of-day reconciliation process and help identify patterns such as counting errors, unrecorded cash movements, or transaction classification problems. Access to these records should be restricted and retained according to applicable policy.
Reviewing cash drops and drawer movements
Review each cash drop against the POS terminal’s recorded cash activity, including the amount, time, employee responsible, and deposit or bag reference. The drop should be supported by a receipt, log entry, or system record that creates a clear audit trail.
Drawer movements must also be traced throughout the shift. Review transfers between tills, opening and closing floats, paid-outs, refunds, and cash removed for security or banking. Each movement should have proper authorization and documentation.
Compare the recorded movements with physical cash, deposit records, and employee declarations. Unexplained transfers or missing documentation can cause the expected balance to differ from the counted amount during end-of-day reconciliation.
Record any variance with its amount, transaction reference, and preliminary explanation. Where the business uses dual control, confirm that both employees’ approvals are documented before the reconciliation is finalized.
Investigating End-of-Day Reconciliation Differences
Compare the POS terminal’s transaction log, cash count, batch totals, and settlement report to identify the exact point of difference. Review transaction timestamps, reference numbers, payment methods, and operator records before making any adjustment.
Common causes include declined transactions recorded as completed, offline payments awaiting approval, duplicate entries, timing differences between authorization and settlement, incorrect tender classification, and manual input errors. Confirm whether missing entries were reversed, voided, refunded, or posted to another business date.
Investigate duplicate, missing, or misclassified records against receipts and processor documentation. Preserve an audit trail showing the original amount, correction, supporting evidence, and employee responsible. Do not alter records without authorization or adequate documentation.
If the difference remains unresolved, escalate it according to the institution’s control procedures. Supervisors, payment processors, or banking operations teams may need to review logs and settlement files. The end-of-day reconciliation should remain open until the variance is explained, approved, or formally recorded as an exception.
Common causes of transaction discrepancies
Transaction discrepancies often arise from timing differences between a POS terminal and the acquiring bank. A payment may be authorised at day-end but settled later, causing temporary differences between terminal totals, processor reports, and bank credits.
Manual errors are another common source. Staff may enter incorrect amounts, select the wrong payment method, issue an unrecorded refund, or leave a transaction incomplete. Cash sales can also differ when change is calculated incorrectly or receipts are not issued.
Technical problems may create duplicate, missing, or reversed entries. Network interruptions, terminal reboots, delayed responses, and offline transactions can prevent a completed payment from appearing consistently across systems. A declined transaction may also be recorded locally before its status is updated.
During end-of-day reconciliation, staff should compare timestamps, transaction references, approval codes, refunds, voids, and settlement batches. Clear documentation helps distinguish temporary processing delays from genuine recording or cash-handling errors.
Reviewing duplicate, missing, or misclassified entries
Review each POS transaction against the terminal log, register journal, and payment processor report to identify duplicate entries. Duplicates may result from repeated uploads, reprocessed batches, or manual recording of a transaction already captured electronically.
Missing entries require tracing the transaction from the customer receipt through the POS system and settlement file. Check declined, voided, refunded, and offline transactions carefully, because they may appear in one record but not another.
Misclassified entries occur when a payment is assigned to the wrong tender type, account, location, tax category, or business date. Compare transaction details, authorization codes, timestamps, and batch numbers before correcting the classification.
During end-of-day reconciliation, document every adjustment with its reason, supporting evidence, and authorisation. Corrections should preserve the original entry where possible, creating a clear audit trail rather than deleting or overwriting transaction data.
Escalating unresolved differences
When a discrepancy remains after reviewing POS records, cash counts, settlement reports, and supporting documents, the matter should be escalated through the organization’s defined control process. The original difference must remain unchanged for auditability.
Provide the responsible supervisor or reconciliation team with:
- Transaction date, terminal ID, and affected payment method
- Amount expected, amount recorded, and variance
- Investigation steps already completed
- Receipts, settlement reports, and system references
- Any suspected processing or recording error
The supervisor should assess whether the issue requires correction, a merchant or bank inquiry, or a formal incident report. Access to transaction data should be limited to authorized personnel, consistent with banking controls and privacy requirements.
Unresolved items should be assigned an owner and target resolution date. Until resolved, they should remain documented as outstanding in the end-of-day reconciliation record, with all follow-up actions and management decisions recorded.
Handling Card Payment and Settlement Exceptions
Card payment exceptions should be reviewed by comparing POS terminal records with processor or acquirer settlement reports. Investigate declined, reversed, voided, refunded, and partially approved transactions, confirming that each entry has the correct status and amount.
Use documented procedures to classify differences before adjusting accounting records:
- Check settlement dates, batch numbers, and transaction references.
- Confirm whether fees, chargebacks, or timing differences explain the variance.
- Verify that refunds and reversals were authorized and recorded once.
- Separate unsettled transactions from confirmed processing errors.
When a payment appears in the POS system but not in the settlement report, review its authorization response and batch status with the payment provider. If a settlement amount differs, retain supporting reports and record the variance for follow-up rather than forcing the figures to agree.
Include unresolved exceptions in the end-of-day reconciliation log, identifying the responsible party, required evidence, and review deadline. Corrections should be approved, traceable, and reflected in the appropriate banking or accounting records.
Recording Reconciliation Results for Banking Controls
Document the completed end-of-day reconciliation in the approved banking or accounting system immediately after review. The record should identify the business date, POS terminal or location, employee responsible, transaction totals, settlement amounts, and any cash variance.
Retain supporting evidence with the reconciliation record, such as POS reports, processor settlement statements, cash-count sheets, deposit slips, and adjustment approvals. A clear audit trail enables authorized reviewers to trace figures from the terminal through settlement and deposit.
Record exceptions separately and describe the investigation performed. Include:
- Duplicate, missing, or misclassified transactions
- Cash overages or shortages
- Card settlement delays or rejected payments
- Corrective actions and approval references
Access controls should restrict editing and preserve timestamps or version history where the system supports them. Supervisors should review and approve material differences according to documented thresholds and internal policies. Consistent records make the end-of-day reconciliation process auditable and support financial reporting, fraud monitoring, and regulatory controls.
Improving the Accuracy and Efficiency of Daily Reconciliation
Use standardized reconciliation checklists that define each review step, required report, and approval point. Consistent procedures reduce omitted checks and help staff identify unusual POS activity before records are finalized.
Automated exports from POS terminals can limit manual entry and support faster comparisons with processor settlement reports. Access should be controlled, while system timestamps, batch numbers, and transaction identifiers should remain available for audit review.
Separate duties where practical by assigning transaction review, cash counting, and final approval to different individuals. Supervisors should examine adjustments, voids, refunds, and unresolved variances rather than approving reconciliations without supporting evidence.
Track recurring differences by location, terminal, shift, or transaction type. Document corrective actions and update procedures when a pattern results from training gaps, configuration errors, or delayed settlement data. This approach makes end-of-day reconciliation more accurate and efficient without weakening banking controls.
Closing the Day With a Verified POS Reconciliation
Before closing the business day, confirm that POS totals, counted cash, card settlements, refunds, voids, and recorded adjustments agree with the relevant source documents. Any difference should be investigated or formally documented according to the institution’s reconciliation procedures.
An authorized employee should review the completed end-of-day reconciliation and verify that supporting reports are complete, dated, and securely retained. The review should identify who prepared the reconciliation, who approved it, and when each action occurred.
Once verified, finalize the POS batch or settlement process in accordance with the acquirer’s requirements. Secure cash and transaction records, restrict further changes to the closed period, and communicate unresolved exceptions to the designated supervisor or banking control team.
The reconciliation record should provide a clear audit trail from individual POS activity to deposited funds and settlement entries. A verified close allows the next business day to begin with accurate opening balances and properly controlled transaction data.