Analysis / Revenue reconciliation
Reconcile customer invoices with bank receipts
Use Proforma to reconcile customer invoices with bank receipts. Get invoice-to-receipt match table from your business data with this copyable prompt.
Finance lead · Revenue operations manager
Bring this question into Chat
Your starting prompt.
Reconcile our invoices against bank receipts for [period]. Match exact invoice references first, then suggest customer, amount and date matches within [tolerance]. Separate partial payments, overpayments and unmatched items. Produce a reconciliation table and totals by currency, with the matching reason on every row. Keep suggested matches distinct from confirmed matches and show the original record IDs.
Copy this starting point, then replace the placeholders with your own inputs.
Method and review
Keep the assumptions visible.
Agree on identifiers, currency, periods and account mappings before comparing totals. Keep unmatched records and timing differences visible instead of forcing a match.
For this task, check
Review suggested matches when several invoices share the same customer and amount.
Before you begin
- Uploaded exports or permitted Data covering the listed inputs
Work with permitted files or queryable data. Verify the result against the original records.
Synthetic illustrative example
See the method in practice.
Synthetic input. Illustrative output checked locally; this is not a live Proforma run or customer result. Five invoice and receipt records, all USD; no date or amount tolerance is assumed.
These invented records explain the method. They are not a recorded Proforma run.
| Record | Invoice reference | Customer | USD |
|---|---|---|---|
| I-101 | I-101 | Birch | 1000 |
| I-102 | I-102 | Acme | 800 |
| I-103 | I-103 | Acme | 800 |
| R-11 | I-101 | Birch | 600 |
| R-12 | None | Acme | 800 |
| Invoice | Exact paid | Outstanding | Review |
|---|---|---|---|
| I-101 | $600 | $400 | Partial payment |
| I-102 | $0 | $800 | Candidate; review required: R-12 |
| I-103 | $0 | $800 | Candidate; review required: R-12 |
Method
Match invoice reference, customer and currency before summing receipts. Outstanding = invoice amount − exact matched receipts. R-12 fits two invoices and stays unallocated; it is not counted twice or treated as confirmed payment.
What the result tells you
I-101 has $400 outstanding after a partial payment. Both Acme invoices require review of R-12. The $2,000 outstanding invoice total includes unresolved allocation; one unallocated $800 receipt remains outside it.
Take the next step
Make it your investigation.
Copy the prompt above, create or open your Workspace, and paste it into Chat. Add the inputs you have permission to use and adapt the assumptions with your agent.
Start exploringYour prompt is carried by copy and paste. Signing up does not submit it or start this work automatically.
Or start with your own agent
The setup prompt includes this public task. Your agent will help you connect when needed and use the access you approve.