POS Payment Reconciliation: How to Match Sales, Card Settlements and Bank Deposits
A POS sales report and a bank statement do not always show the same amount for the same business day. Card settlement delays, refunds, transaction fees, voided sales, and payment processing errors can all create differences.
POS payment reconciliation is the process of comparing sales records, payment-provider reports, and bank deposits to confirm that transactions have been recorded correctly. For retailers, restaurants, supermarkets, and other businesses, a consistent reconciliation process helps identify discrepancies before they become larger accounting problems.
This guide explains how POS payment reconciliation works, why differences occur, and how businesses can build a reliable daily process.
What Is POS Payment Reconciliation?
POS payment reconciliation involves checking whether transactions recorded by a point-of-sale system agree with the amounts reported by payment providers and received in the business bank account.
A typical reconciliation involves three records:
- POS sales records: Transactions recorded by the checkout system, including sales, refunds, and voids.
- Payment-provider records: Card transactions, settlement batches, processing fees, refunds, and adjustments reported by the payment provider.
- Bank statement: The actual deposits and withdrawals recorded by the bank.
These records serve different purposes. The POS shows business transactions, the payment provider reports payment processing activity, and the bank confirms the money that has arrived or left the account.
The goal is to explain differences between these records rather than assume that every amount should match on the same date.
Why POS Sales May Differ From Bank Deposits
Several common situations can create differences between POS sales and bank deposits.
1. Card Settlement Delays
A card transaction may be recorded in the POS today but settled by the payment provider on the next business day or according to a different settlement schedule.
For example, a restaurant may record card sales on Friday evening, while the corresponding funds appear in its bank account on Monday.
The timing difference does not automatically indicate a missing payment. Finance teams should compare transaction dates, settlement dates, and bank posting dates.
2. Payment Processing Fees
Some payment providers deduct processing fees before transferring the settlement amount.
Suppose a business processes card payments worth 10,000 monetary units and the provider deducts a fee of 200 units. If no other adjustments apply, the expected net deposit is 9,800 units.
The POS may show the full sales amount, while the bank statement shows the net settlement. Recording the fee separately helps explain the difference.
Actual fees and settlement arrangements depend on the provider's agreement.
3. Refunds and Reversals
Refunds may be processed separately from the original transaction or appear in a different settlement period.
A business might record a sale on Monday and issue a refund on Wednesday. The refund should be linked to the original transaction where possible, and the payment-provider and accounting records should reflect the corresponding adjustment.
Voids, reversals, and completed refunds should not be treated as interchangeable. Their accounting and payment effects depend on their actual status.
4. Cash and Card Sales Mixed Together
A daily POS report may include cash, card, digital wallet, and other payment methods.
Comparing total sales directly with a card settlement deposit will produce an incorrect comparison if cash transactions are included in the sales total.
Separate the totals by payment method before beginning reconciliation.
5. Duplicate or Missing Transactions
Occasionally, a transaction may be duplicated in a report, recorded under an unexpected reference, or missing from a settlement batch.
These discrepancies require investigation using transaction references, timestamps, amounts, payment status, and provider records. A difference should not be classified as an error until the underlying transactions have been checked.
How to Reconcile POS Payments Step by Step
Step 1: Close the Business Day
Generate the POS closing report for the relevant business date.
Review gross sales, discounts, completed refunds, voids, and totals by payment method. Confirm that the closing period is correct, especially when a business operates late into the night.
Retain the report for reference and avoid changing finalized records without an appropriate audit trail.
Step 2: Separate Transactions by Payment Method
Divide transactions into categories such as cash, card, digital wallet, and other supported payment methods.
Cash should be reconciled against the cash drawer and cash deposits. Card payments should be checked against the payment provider's transaction and settlement reports.
This separation makes discrepancies easier to identify.
Step 3: Match POS Transactions With Provider Records
Compare individual transactions or settlement batches using available reference numbers, dates, amounts, and payment statuses.
Look for transactions that appear in one system but not the other. Check whether pending, failed, reversed, or refunded transactions have been included incorrectly.
For businesses with multiple payment terminals or providers, maintain a separate reconciliation view for each provider before combining the results.
Step 4: Calculate the Expected Settlement
Start with the transactions included in the relevant settlement batch.
Account for applicable refunds, reversals, processing fees, chargebacks, reserves, and other documented adjustments. The exact calculation depends on the payment provider and the settlement agreement.
Do not subtract a fee or adjustment simply because it would make the numbers match. Confirm it in the provider's report.
Step 5: Match the Settlement to the Bank Statement
Identify the bank deposit associated with the settlement batch.
Compare the expected net settlement with the actual bank deposit. If the deposit has not yet arrived, check the provider's settlement status and expected timing before marking it as missing.
Where several batches are combined into one deposit, reconcile the combined amount using the provider's settlement references.
Step 6: Investigate and Document Differences
Record each unresolved difference with its amount, transaction reference, likely cause, and next action.
For example, a difference may be caused by a settlement that is still pending, a refund processed in another period, or a fee that was not recorded in the accounting system.
Assign responsibility for investigating outstanding items and follow them until they are resolved or properly documented.
Step 7: Complete the Accounting Entries
Once transactions and settlement adjustments have been verified, record the applicable sales, payment clearing, bank receipts, processing fees, refunds, and other adjustments according to the business's accounting method.
Avoid recording the same sale twice simply because the POS report and bank deposit are separate records of the transaction lifecycle.
A Simple POS Reconciliation Example
Consider a retailer with the following card settlement activity:
| Item | Amount |
|---|---|
| Card transactions included in settlement | 10,000 |
| Refunds included in settlement | -300 |
| Payment processing fees | -200 |
| Expected net settlement | 9,500 |
| Actual bank deposit | 9,500 |
| Unexplained difference | 0 |
In this example, the settlement matches after accounting for refunds and fees.
If the bank deposit were 9,400 instead, the business would have an unexplained difference of 100 units. The finance team should check the provider's settlement statement and transaction references before determining the cause.
These figures are illustrative and do not represent actual WaslaSoft customer results or a specific payment-provider arrangement.
How Multi-Branch Businesses Can Improve Reconciliation
Businesses operating several branches face additional challenges. Each location may have different cashiers, payment terminals, settlement batches, and closing times.
A structured process should identify the branch, business date, payment method, payment provider, and settlement reference for each reconciliation record.
Managers should review unresolved discrepancies by branch rather than relying only on a consolidated company-wide total. This helps identify where an issue occurred and who needs to investigate it.
Clear closing procedures and consistent reporting are particularly useful when finance teams reconcile transactions from multiple locations.
Can POS and Accounting Software Make Reconciliation Easier?
Integrated business systems can reduce manual work when they provide the required transaction reports, payment references, accounting records, and settlement information.
Depending on the system and integration, useful capabilities may include:
- Transaction-level sales reports.
- Payment-method summaries.
- Refund and void records.
- Exportable reconciliation data.
- Accounting entries for verified sales and fees.
- Reporting across multiple branches.
However, a POS system does not automatically guarantee that every payment has settled correctly. The available integration, provider data, accounting configuration, and reconciliation controls all matter.
Before selecting a solution, businesses should confirm which payment providers and accounting workflows are supported, which steps remain manual, and how discrepancies can be traced.
A Daily Reconciliation Checklist
At the end of each business day, the responsible team should confirm that:
- POS closing reports have been generated and reviewed.
- Cash and card transactions have been separated.
- Refunds, reversals, and voids have been checked.
- Payment-provider settlement records have been reviewed.
- Bank deposits have been matched where available.
- Pending settlements have been documented.
- Unexplained differences have an assigned owner.
- Verified accounting entries have been recorded correctly.
Not every card transaction will settle on the same day. The important point is to distinguish a legitimate timing difference from a genuine discrepancy and maintain evidence for both.
Final Thoughts
POS payment reconciliation is more than comparing two totals. It is a controlled process that connects sales activity, payment processing, bank movements, and accounting records.
By separating payment methods, matching settlement batches, documenting adjustments, and investigating unexplained differences, businesses can improve the accuracy of their financial records and gain better visibility into daily operations.
WaslaSoft provides POS and business management solutions for businesses across the Gulf. Businesses evaluating a POS solution should ask how its reporting and available integrations support their own payment reconciliation process.
Explore WaslaSoft to learn more about its business software solutions.
