Premium Bordereaux Reconciliation demo
The premium bordereau, the cash received and the statement of account matched line by line; every difference gets a cause. 1:15
What the demo shows
A reconciliation solution that matches premium bordereaux, cash and statements line by line.
Six agents read each delegate's premium bordereau, the wires and remittance advices, and the broker's statement of account, then join them line by line in three columns: one-to-one, or many part-payments to one line, with the exchange rate shown on every join. What does not join drops into tolerance buckets, each with its cause and a suggested pairing. The premium accountant accepts; the head of DA finance approves the settlement.
Transcript
- Premium Bordereaux's reconciliation matches Bordereaux's cash and broker statements, line by line.
- They rarely agree, so month-end close waits on a spreadsheet hunt.
- Northbeam's September Bordereaux, 418 lines in Canadian dollars, settled in U.S.
- dollars. The agents join every line across all three columns.
- Kettle Valley Timber Frame paid in four parts, at four exchange rates.
- For payments, join one line.
- The join shows the rate and a $53 difference.
- 21 lines land in buckets, each with a cause and a suggested pairing.
- Renata applies an unidentified receipt to a missing August endorsement.
- NorthBeam owes $40,224, Imogen approves.
- Built on Botminds: agents, data, screens, and governance on one platform.
Transcribed from the film’s narration. Captions are on the player.