Singapore restaurant finance guide

How to Reconcile PayNow and Card Settlements for a Singapore Restaurant (Step-by-Step)

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.

What Is PayNow and Card Settlement Reconciliation? (Quick Definition)

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.

What Can Affect PayNow and Card Settlement Reconciliation?

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.

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.

Keep outlet and shift details visible

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.

Distinguish gross sales from net payouts

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.

Worked example: one fictional shift

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.

Fictional example of reconciling restaurant PayNow and card settlements
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
Worked example is fictional.

Quick Answer (Do This First)

  • Export the POS shift or sales report, PayNow transaction or settlement report, card processor settlement report and relevant bank entries.
  • Separate the POS totals by tender, date or shift, and outlet ID.
  • Check that any split-tender bill is divided between the correct payment methods in the source records.
  • Match each settlement to bank entries using the amount, date, batch or transaction reference, and outlet ID.
  • Check later bank entries before classifying a settlement as missing; payout timing can differ from the POS sale date.
  • For card transactions, compare the gross POS card total with the bank payout plus fees documented by the processor.
  • Keep any unexplained difference visible until it has been investigated and reviewed.

Prerequisites (What You Need)

  • POS sales or shift reports that show payment methods and outlet IDs.
  • PayNow transaction or settlement records for the period being reconciled.
  • Card processor settlement records, including any recorded fees.
  • Bank statement entries covering the relevant sales and settlement dates.
  • Available batch, transaction, shift or outlet references to compare across records.
  • A worksheet or accounting workflow for recording matches and unresolved differences.

Step-by-Step: Reconcile PayNow and Card Settlements

Step 1: Gather the source records

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.

Step 2: Break down POS sales by tender and outlet

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.

Step 3: Match PayNow and card settlements to the POS

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.

Step 4: Trace settlement records to bank deposits

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.

Step 5: Account for documented card fees

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.

Step 6: Record and review exceptions

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.

Validation Checklist (Make Sure It Worked)

  • ☐ POS sales are separated by PayNow and card tender.
  • ☐ Outlet IDs and shift or settlement references remain visible in the working records.
  • ☐ Split-tender bills are represented under the appropriate payment methods.
  • ☐ PayNow settlement amounts have been compared with the relevant POS totals.
  • ☐ Card settlement records have been compared with gross card sales.
  • ☐ Bank entries have been checked against settlement amounts and references.
  • ☐ Documented processor fees explain any corresponding reduction from gross card sales to payout.
  • ☐ Later bank entries have been checked where settlement timing differs from the POS date.
  • ☐ Unmatched, duplicated or otherwise unexplained items remain visible for review.

Common Issues & Fixes

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.

Best Practices (Do It Right Long-Term)

  • Reconcile by tender rather than relying only on a combined daily total — separate flows make mismatches easier to locate.
  • Keep outlet IDs and shift or batch references with each line — this reduces the risk of matching across locations.
  • Compare POS sales, settlement reports and bank entries as separate record types — each confirms a different stage of the payment flow.
  • Keep processor fees distinct from gross sales — this makes the net payout understandable without understating sales.
  • Check later bank entries before raising a missing-deposit exception — settlement timing may differ from the sales date.
  • Make unresolved items easy to see and review — visible exceptions are less likely to be mistaken for completed matches.
  • Retain the source references used for each match — they help someone retrace the reconciliation later.

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.

Recommended Tool (Optional): ccMonet

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.

  • Transaction matching can help surface records that may correspond across payment and accounting workflows.
  • Exceptions can be flagged for review rather than treated as resolved automatically.
  • Reconciliation sits alongside ccMonet’s bookkeeping and expense workflows in its AI-first finance platform.
  • Source-to-ledger links are a stated platform strength for tracing entries back to source records.

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.

FAQs

What does it mean to reconcile PayNow and card settlements?

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.

How do I reconcile a card payout that is less than card sales?

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.

Should PayNow and card sales be reconciled together?

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.

What if the bank deposit arrives after the POS shift date?

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.

How should a restaurant handle split-tender bills and multiple outlets?

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.

Related reconciliation guides