RECONCILIATION WORKFLOW

Receipts matched.Next steps made clear.

Connect bank receipts to invoice records, approved system updates and a clear report for follow-up.

BEFORE THE CONNECTION

One task.
Several manual handoffs.

  • Download the bank transactions.
  • Compare receipts with the invoice list.
  • Identify shortfalls and outstanding invoices.
  • Re-enter allocations and prepare a follow-up list.

WITH THE AGREED WORKFLOW

Connect. Match. Review. Update.

  • Retrieve authorised transactions and invoice records.
  • Match using Particulars, Code or Reference, or a linked payer account number available in the bank data. Apply the agreed amount and allocation rules.
  • Keep unclear receipts in an exception list.
  • Send approved updates and produce the agreed report.

PAYMENT-STATUS REPORT FORMAT

Clear records. Actionable follow-up.

Report format · NZD · Payment status and unmatched receipts are shown separately.
Customer / invoiceExpectedMatched receiptsRemainingResult / action
Customer 001 / INV-1041$620.00$620.00$0.00Approved allocation to finance records.
Customer 002 / INV-1042$320.00$200.00$120.00Part paidReceived amount recorded; shortfall for follow-up.
Customer 003 / INV-1043$180.00$0.00$180.00UnpaidNo matched receipt at the cutoff.
Total expected balances$1,120.00$820.00$300.00Plus one unallocated receipt below.
Review

$95.00 received · reference “Payment”

Without a usable reference or a linked payer account, this receipt remains unallocated. It is excluded from the matched totals above until reviewed.

Finance records

Approved allocations can be written back through a supported connection or prepared for an agreed import.

Follow-up report

Outstanding and partly paid balances provide the context your team needs for the next action.

Exception list

Unallocated receipts and failed deliveries remain visible to the person responsible for review.

Your records. Your rules. Your outputs.

Actual matching criteria, refresh timing, report format and update behaviour depend on the source data and supported systems. We confirm these details before quoting the implementation.

START WITH YOUR REQUIREMENTS

Less admin starts
with one email.

Tell us what needs to connect. We clarify the requirements, provide a quote including GST, and start after you sign the contract. Full payment follows delivery.

Email Your Requirements