NewAR Executive · Waterfall reconciliation

From every sale to banked cash, accounted for.

One view that follows each day's sales from the POS, to the delivery platform, to the bank — and names every gap along the way.

POS salesS$100k
Platform salesS$98.6k
−S$1.4k · Platform vs POS — orders that differ
Net payoutS$74.9k
−S$23.7k · Grab deductions — commission, marketing, other adjustments
Bank cash receivedS$73.7k
−S$1.2k · Bank vs platform — a break to chase

Explained by VALException to chaseIllustrative month, one outlet group. Figures are an example, not a client's.

The problem

Money goes missing between the till and the bank.

A sale rings up at the POS. Days later the delivery platform pays out — less commission, less fees, less refunds, sometimes bundled with other days. Then it lands in the bank as one lump sum.

Each system is right on its own. Nobody joins them up, so when the bank is short, nobody can say whether it's a fee, a timing difference or money that's simply gone.

Deductions in one lump

Commission, marketing and adjustments arrive netted off, so the payout never equals the sales.

Payouts that don't match a day

What the platform pays and what the bank receives rarely line up day by day.

Gaps found at month-end

By the time the variance shows up, the orders behind it are weeks old.

How it works

Three hand-offs, each matched automatically.

01
Sales → platform
Each day's POS sales are matched to the platform's own sales. Any difference is shown, not buried.
02
Platform → payout
Every deduction is laid out line by line — commission, marketing and other adjustments, GST included — down to the net payout.
03
Payout → bank
Each net payout is matched to the cash the bank actually received. The lines must add up to the bank, to the cent.

Matched

Ties out, nothing to do.

Explained

A gap with a named cause.

Data gap

A statement is missing — we say which.

Break

Real money to chase, for a person to review.

Every gap ends in one of four places. Your team works only the breaks and the data gaps.

See it in VAL

What your team sees each month.

From the waterfall to one day's orders, in VAL with demo data (about 60 seconds, no sound).

VAL's AR Waterfall canvas: POS sales to bank cash received, with sales and bank reconciliation beside it — 01
The waterfall
POS sales down to bank cash received, with every deduction on its own line. The check at the bottom must read zero.

Outlet breakdown with each gap sorted into its reason, beside a day-by-day trace marked matched, explained, data gap or not explained — 02
Explained by VAL
Pick an outlet and VAL has already sorted the gaps into their reasons — customer compensated, Grab compensated us, refund reversed, discounts, keyed wrongly. What your staff explained is kept apart, and anything still unexplained is shown as Remaining to explain.

One day opened in a side panel: how the day was checked, what explains the break, and the orders behind it — 03
Drill down to the order
Click a day to see how it was checked, what explains the break, and the orders behind it.

Accounting tab with balanced sales entry and bank receipt journal lines per entity — 04
Ready to post
The same figures turned into balanced journal lines — receivables, commission, GST and bank receipts.

Screens from VAL with demo data — the outlets and figures are made up. Click a screen to enlarge it.

What we reconcile

Every way your customers pay, down to the bank.

Payment methods, platforms, vouchers and banks we reconcile for F&B groups today — each one built and kept up to date by us when a provider changes its file.