F&B & Multi-Outlet Retail

Kwetiau 28 Aho Auto-Reconcile Sales Dashboard

A 100% automated engine matching point-of-sale transactions to multi-bank settlements, every day.

Client context

Where things stood.

Kwetiau 28 Aho, a popular multi-outlet dining establishment.

Kwetiau 28 Aho faced operational friction reconciling daily point-of-sale transactions against multiple bank mutations and payment channel settlement reports (QRIS, Debit, Credit Cards). Ascendiz built an automated sales reconciliation platform that links sales terminals directly with bank settlement mutations, displaying instant match rates and fee breakdowns.

Solution

System capabilities.

Automated transaction matching engine

Automatically correlates individual POS sales transactions with incoming bank mutations from BCA QRIS, BCA Debit, Mandiri Debit, and BRI QRIS, reaching a 100% automated match rate for settled transactions and flagging discrepancies in real time.

MDR & net settlement calculation

Automatically calculates Merchant Discount Rates (MDR) for each payment channel, reconciling gross sales figures against net bank receipts and eliminating mystery bank fee deductions.

Multi-store dashboard

A unified view showing total transaction volume, gross revenue, matched totals, and unmatched items per store location, with direct export for accounting and tax reporting.

Architecture

How it fits together.

CHANNELSBCA QRISMandiri DebitBRI QRISINGESTBank mutation feedPOS transaction logPayment gateway logsMATCHAuto-match engineMDR calculatorDiscrepancy flaggingDASHBOARDMulti-store viewMatch rate trackingExport to accounting
POS transactions across every payment channel are automatically matched to bank settlements and rolled up per store.

Business impact

100%
Automated match rate between sales and bank settlements
Minutes
Daily cash-close time, down from hours
Multi-outlet
Complete visibility over liquidity and channel performance
Tech stack

What it runs on.

Backend
GoPostgreSQL
Frontend
ReactTypeScript
Cloud
AWSECS

Facing something
similar?

Talk to an engineer