How Thai Sellers Should Reconcile PromptPay, Card, and Shopee Payouts in 2026

A Thai online seller can have a clean checkout and still lose hours every week matching bank deposits to orders. PromptPay transfers land in the bank statement one by one with no order reference, card settlements arrive in batches with fees already deducted, and Shopee, Lazada, and TikTok Shop each pay out on their own cycle with their own deduction logic. The accountant still needs books that make sense in FlowAccount, PEAK, or a spreadsheet — with a tax invoice trail the Revenue Department will accept.

The core matching order is the same one that works everywhere in the region: reconcile by order ID first, settlement batch second, and payment method third. Do not start from the bank statement alone. Keep one daily export per channel and match each order to a settlement line before you look at the bank balance.

What to prepare first

• One order export that covers every channel: your own website checkout, Shopee, Lazada, TikTok Shop, and LINE chat orders. If orders live in five back offices, reconciliation fails before it starts — Thai sellers running marketplaces alongside LINE typically centralize this in an order management system like Zort, which syncs Shopee, Lazada, TikTok Shop, and offline POS into one dashboard from ฿600/month.
• A separate settlement export per payment rail: PromptPay credits from your bank, card settlement reports from your gateway, and the payout/income statement from each marketplace seller centre.
• A fee map per rail. PromptPay QR is free or near-free — Beam, for example, accepts PromptPay QR with no merchant fee while cards start at a 1.8% merchant discount rate. Cards and marketplace commissions are where gross and net diverge.
• A cut-off convention. Marketplace payouts lag orders by days; decide whether you book revenue at order confirmation or at payout, and keep it consistent — Thai VAT filing (PP.30) punishes mixed conventions.

Daily workflow

1. Export yesterday's orders from every channel into one sheet keyed by order ID.
2. Pull the PromptPay credit list from your bank and the card settlement report from your gateway.
3. Match order IDs to settlement lines. Only then compare the matched total against the actual bank deposit.
4. Park every unmatched line in an exceptions list with a reason code — do not let them roll forward silently.

Fifteen minutes daily beats four hours at month-end, because yesterday's mismatch is still explainable: the customer who paid twice, the QR that expired, the test order that shipped.

PromptPay reconciliation

PromptPay is instant but anonymous: a bank statement line says who paid and when, not which order it was for. Three ways Thai sellers close that gap:

• Dynamic QR per order. A QR generated per checkout carries the amount, so an exact-amount match against an open order is usually safe. Identical amounts on the same day are the classic false match — flag them instead of auto-matching.
• Gateway-issued PromptPay. When PromptPay runs through a payment gateway rather than a bare bank QR, every credit arrives tagged with an order reference. A platform like HitPay does this out of the box — its PromptPay and PayNow acceptance feeds automated bookkeeping and payout reconciliation, so the settlement export already lists order IDs, and its free tier means a small shop pays per transaction rather than a monthly fee.
• Slip verification. Chat-commerce orders paid by bank transfer still arrive as a slip image in LINE. Verify the slip against the statement the same day; a slip that never landed in the bank is the single most common Thai chat-commerce loss.

Card and e-wallet reconciliation

Cards settle in batches, net of fees. Reconcile the batch, not the transaction: the gateway's settlement report lists which orders a deposit covers and the fee taken per order. Book the fee as an expense line — netting it silently into revenue understates both revenue and cost, and breaks the VAT base. E-wallets (TrueMoney, ShopeePay, LINE Pay) behave like cards: batch payouts, per-transaction fees, own report.

Marketplace payout reconciliation

Shopee, Lazada, and TikTok Shop are their own economy: commission, transaction fee, campaign co-funding, shipping subsidies, and returns all net out inside the payout. Match in two steps — first the seller centre's income statement against your order list (per order), then the payout total against the bank deposit (per cycle). The number that matters is the effective take rate per marketplace per month; when it drifts, a fee changed or a campaign setting is eating margin. Sellers syncing orders through Zort get the order side of this match from one export instead of three seller centres.

Accounting handoff

Thai books need a Thai trail: tax invoices (ใบกำกับภาษี), PP.30 VAT reports, and withholding certificates. FlowAccount (from ฿165/month) and PEAK (from ฿208/month, with native e-Tax Invoice and PP.30 automation and bank reconciliation against Thai banks) both accept the daily matched export. Hand the accountant matched data, not raw statements — the reconciliation is the seller's context, and it does not survive the handoff otherwise.

Month-end close checklist

• Exceptions list at zero, or every surviving line has an owner and a reason.
• Effective take rate per marketplace computed and compared to last month.
• Card and e-wallet fees booked as expenses, not netted.
• PP.30 revenue total ties to the matched order export, not to bank deposits.
• Payouts in transit (ordered this month, paid next) listed explicitly.

Common mismatch cases

• Same-amount PromptPay collisions — two ฿590 orders, one credit. Resolve by timestamp and customer name, never by assumption.
• Marketplace return after payout — the clawback lands in a later cycle; match it to the original order, not to the cycle it appears in.
• Expired QR, paid anyway — the customer scanned a stale QR; money arrived with no open order. The exceptions list catches it.
• COD remittance shortfalls — courier COD arrives as a lump sum days later; treat it as its own rail with its own export.

Build the close before volume arrives

Reconciliation is boring exactly until a campaign doubles order volume and the books stop tying. The sellers who survive audits and cash-flow crunches are the ones whose daily fifteen-minute match was already running when volume arrived. Set the exports up once, hold the matching order — order ID, then batch, then method — and month-end becomes a checklist instead of an archaeology project.