Orders vs Bank Statement Template
Free template to match order exports against bank statement deposits line by line.
Try with sample files | View sample report
Download the working files
Problem statement
Order exports and bank deposits often use different dates, descriptions, and reference formats. A safe template must keep weak matches and unresolved rows visible instead of forcing every order into a bank row.
Numeric example
| Line item | Amount |
|---|
| Order ORD-1041 | $125.00 |
| Bank deposit with exact reference | $125.00 |
| Order ORD-1042 | $240.00 |
| Amount-only bank candidate | $240.00 needs review |
Why the numbers do not match
- Payment processor timing can move the bank date away from the order date.
- One payout or bank deposit can represent several source orders.
- Bank descriptions may omit the order number or contain only a processor reference.
- Refunds, partial payments, and amount differences may affect another review period.
What files to export
- Order export with order number, date, total, customer reference, and payment status.
- Bank statement CSV/XLSX with deposit date, signed amount, and bank description.
- Optional payout export when one bank movement may represent several orders.
Manual workflow
- Export orders.
- Export the bank statement.
- Normalize dates and amounts.
- Match strong references first.
- Review weak candidates.
- Keep unresolved rows visible.
- Export the final report.
Common mistakes
- Treating equal amount and nearby date as enough evidence for a final match.
- Ignoring possible grouped payments when one deposit covers several orders.
- Removing unpaid orders or unknown deposits from the final review package.
- Calling every amount difference a fee without supporting evidence.
How Reconcile Locally helps
- Keeps orders and bank rows in one local review workflow.
- Separates matched rows, review candidates, unpaid orders, and unknown bank payments.
- Preserves amount differences and possible grouped payments in the final report.
What still needs manual review
- Repeated amounts and weak bank references can require another source export.
- Grouped deposits should stay in review until all supporting rows are visible together.
Content review and sources
Written and reviewed by the Reconcile Locally product team. Last reviewed June 7, 2026.
Guidance is checked against current product behavior and first-party documentation where available. Reconciliation results still require human review.
Frequently asked questions
Can I match an order by amount and date only?
Amount and date can identify a candidate, but keep it in review when another row could plausibly explain the same bank movement.
What if one bank deposit covers several orders?
Treat it as a possible grouped payment until the supporting orders and payout detail explain the full deposit.