Match each tender separately
Compare PayNow sales with PayNow settlement records and card sales with the card processor’s settlement records. Matching by tender avoids treating different payment flows as one combined deposit.
Singapore restaurant finance guide
Reconcile PayNow and card settlements by matching POS sales to payment-provider settlement records and bank deposits, while checking split tenders, outlet IDs, processor fees and timing differences. Start by separating each shift’s gross sales by payment method, then trace each settlement to the bank and record documented fees separately. This guide uses a fictional S$1,000 restaurant shift to show how the numbers tie out, and gives restaurant owners and finance teams a practical process for investigating differences. The key takeaway: compare gross sales with the settlement records before treating a net bank payout as the sales figure.
Head of AI Finance Operations team from ccMonet
Experienced leader in AI-powered accounting services with 5+ years experience and AI-powered accounting services enthusiast. My background is in AI-powered accounting services, with more than five years of experience in the field.
PayNow and card settlement reconciliation is the process of checking that a restaurant’s POS sales for each tender agree with payment-provider settlement records and the money deposited into its bank account. It helps explain differences caused by processor fees, settlement timing, split tenders or outlet mix-ups. Restaurant operators and finance teams use it to confirm that sales are accounted for and that unmatched items are investigated.
The same shift can produce separate records across a POS, payment provider and bank statement. Keep the following checks distinct so a real exception does not get mistaken for an ordinary fee or timing difference.
Compare PayNow sales with PayNow settlement records and card sales with the card processor’s settlement records. Matching by tender avoids treating different payment flows as one combined deposit.
Include the outlet ID and shift or settlement reference in your working records. That context helps prevent a payout from being matched against another location’s sales.
A card payout can be lower than gross card sales when the processor has deducted a documented fee. Use the processor record to identify the fee, then reconcile the gross sale to the payout plus that fee.
The POS records S$1,000 in dine-in collections: S$700 by card and S$300 by PayNow. The bank shows a S$300 PayNow deposit and a later S$686 card payout. The processor records a S$14 fee, so the card amount reconciles: S$686 + S$14 = S$700.
| Date / shift | Outlet ID | Tender | POS amount | Bank payout | Recorded fee | Difference / status |
|---|---|---|---|---|---|---|
| Shift 1 | [Outlet ID] | PayNow | S$300 | S$300 | S$0 | S$0 — Matched |
| Shift 1 | [Outlet ID] | Card | S$700 | S$686 | S$14 | S$0 after fee — Matched |
| Total | — | — | S$1,000 | S$986 | S$14 | S$0 after fee |
What to do: Export the POS sales or shift report, PayNow transaction or settlement report, card processor settlement report, and bank statement entries for the period. Keep the original exports available while you compare totals.
Success looks like: You have the source records needed to trace each sales amount from the POS through settlement to the bank.
Common mistake to avoid: Do not rely on the bank deposit alone to identify the gross sales behind it.
What to do: Separate each shift’s PayNow and card totals, and retain the outlet ID with each amount. Keep split-tender bills divided into their recorded payment portions.
Success looks like: You can identify the gross POS amount for each payment method and outlet without combining unrelated totals.
Common mistake to avoid: Do not match a combined POS total to a single tender’s settlement.
What to do: Compare PayNow totals with PayNow settlement records and card totals with card processor records. Check amounts and available transaction, batch, shift and outlet references.
Success looks like: Each settlement record is associated with the appropriate tender and POS sales for the relevant outlet or shift.
Common mistake to avoid: Do not assume that a similar amount alone proves a match if the outlet or batch reference conflicts.
What to do: Compare settlement amounts and references with bank statement entries. Check subsequent bank entries when the deposit date differs from the POS shift date.
Success looks like: A bank deposit is matched to its relevant settlement record, or its absence remains recorded as an item to investigate.
Common mistake to avoid: Do not label a payout missing solely because it did not arrive on the POS sale date.
What to do: Use the processor settlement record to identify fees, then compare gross card sales with the payout plus the recorded fee. In the fictional example, S$686 + S$14 reconciles to S$700 in card sales.
Success looks like: The gross card sales, net payout and recorded fee agree, or the remaining difference is clearly identified.
Common mistake to avoid: Do not treat the net card payout as the gross POS sales amount.
What to do: Note unresolved items with their amount, date, outlet, tender and available references. Investigate missing or duplicate deposits, unexplained differences and any fee that may have been recorded more than once.
Success looks like: Every item is either matched or clearly listed for follow-up and review.
Common mistake to avoid: Do not silently write off a difference that has not been explained by the source records.
| Problem | Cause to check | Practical fix |
|---|---|---|
| Card payout is below card sales | A processor fee may have been deducted, or the difference may be unexplained. | Check the processor settlement record and reconcile the documented fee separately from gross sales. |
| Deposit does not appear on the POS date | The settlement may reach the bank later than the sale. | Check subsequent bank statement entries and compare them with the settlement record before treating it as missing. |
| A settlement amount appears unmatched | It may relate to a different outlet, batch or tender. | Compare outlet IDs, references and payment methods across the POS, settlement report and bank entry. |
| POS and settlement tender totals differ | A split tender may be recorded under the wrong payment method or portion. | Review the POS bill and match each recorded portion to its corresponding tender record. |
| The same fee or adjustment seems duplicated | A fee or adjustment may have been entered or deducted more than once. | Compare each fee with the processor record and check that it is recorded only once in the reconciliation. |
For the wider POS-to-bank process, use a consistent POS-to-bank reconciliation workflow. If your restaurant has several locations, keep the outlet-level records distinct as part of multi-outlet bookkeeping.
ccMonet describes its reconciliation workflow as using AI to propose transaction matches and flag exceptions for review. Connectivity and professional review depend on setup and scope, so confirm that the workflow fits the records and process you use.
Learn about ccMonet’s AI bank reconciliation workflow.
When to use it: consider it if you want help proposing matches and surfacing exceptions; when not to: do not rely on a tool to replace checking source records or reviewing unresolved differences.
It means comparing a restaurant’s POS sales by tender with the relevant PayNow or card settlement records and bank deposits. The comparison accounts for documented processor fees and differences in settlement timing. It also helps identify records that are missing, duplicated or associated with another outlet.
Check the card processor’s settlement record for a documented fee. Compare gross POS card sales with the bank payout plus that recorded fee. In the fictional example in this guide, S$686 in payout plus a S$14 fee equals S$700 in card sales.
Keep the tenders separate when matching POS sales to settlement records because they may have different records and payout flows. A combined total can hide which payment method has an unexplained difference. You can still check the combined total after each tender has been reconciled.
Compare the settlement report with subsequent bank entries before deciding that the payout is missing. Use available settlement references, dates and amounts to trace the deposit. Keep it open for investigation if you cannot match it to a bank entry.
Keep each split-tender portion assigned to the payment method shown in the POS records. Include the outlet ID when matching the sale, settlement and bank entries. If the references do not agree, record the item as an exception and investigate rather than forcing a match.
A reliable reconciliation connects each POS tender total to its settlement record and then to the bank, while keeping outlet IDs, split tenders, documented fees and timing differences visible. In the fictional S$1,000 example, the S$300 PayNow deposit matches directly, and the S$686 card payout reconciles to S$700 after the S$14 processor fee is included. Start with your source exports, follow the checklist, and review any difference that the records do not explain.
Keep a restaurant bookkeeping workflow that preserves the connection between POS sales and settlement records. For the underlying source documents, retain PayNow settlement records and the card processor settlement report. Record documented processor fees separately, preserve source-to-ledger traceability, and keep bank reconciliation exceptions visible until reviewed. A workflow that proposes matches and flags AI bank reconciliation items can support review, subject to setup and scope.