Automated matching is usually sold as a module, but the licence is the smallest part of the cost. The real work is teaching the system how your customers pay: which references they use, which fees are deducted, how partial payments are allocated, how one transfer settles several invoices and what happens when a bank file arrives late. A cost model that ignores this work produces a budget that survives the demo and fails in the first month.
This guide is for a finance or operations lead in Bangladesh who needs to size the project before requesting quotes. It explains the work, the drivers, a formula you can apply to your own numbers and a worksheet that makes proposals comparable.
What the project actually includes
Discovery maps the current process, the payment sources and the exception owners. Integration connects the bank, mobile financial service or gateway to the accounting system. Matching rules decide how references, amounts, dates and fees are compared. An exception queue holds what cannot be matched automatically. Reporting produces the audit trail and the open-item list that finance reviews each month. Include the month-end close calendar, because the matching run has to finish before reporting starts.
Testing deserves its own line. Historical statements contain the partial payments, duplicate credits and missing references that a clean sandbox never shows. Training and support determine whether the finance team trusts the result or keeps a parallel spreadsheet.
Cost drivers to quantify
- Payment sources: each bank, mobile financial service and gateway adds a connector and a settlement format.
- Volume: payment lines and invoices per month affect batch design, storage and peak handling.
- Reference quality: free-text narrations and reused references require fuzzy matching and manual review.
- Payment patterns: partial, consolidated, split and advance payments each need a rule.
- Entities and branches: multi-company or multi-branch reconciliation adds dimensions and permissions.
- Accounting system: a documented API is a different job from a file import or screen automation.
- Audit requirements: evidence export, retention and segregation of duties shape the design.
A scope-based formula
Use a formula rather than a per-invoice guess:
effort = discovery + (payment sources x connector effort) + (rule sets x rule effort) + exception queue + reporting + testing + training + contingency
Estimate each term in person-days with the vendor, then multiply by a blended rate you have agreed. The formula is deliberately transparent. If a proposal cannot show which terms it included, it is not comparable with the others. Ask for the assumption behind each term, especially the connector effort and the number of rule sets.
Calculator logic for your own numbers
Inputs: payment sources, monthly payment lines, monthly invoices, the share of payments with a usable reference, the share that are partial or consolidated, the number of entities, the accounting system and the audit evidence required. Outputs: one-off implementation effort, recurring support effort and the manual hours the system should remove.
Do not accept a single "automation score". Test the assumptions against last month's actual files. If the vendor cannot ingest a sample bank statement and a sample invoice ledger during the first workshop, the estimate is theoretical. Add a contingency for the exceptions found in that sample. Review the assumptions with the person who clears exceptions today, because they know which cases the process hides.
A percentage model for the budget envelope
After the bottom-up estimate, use a percentage split to check it: discovery and design, integration, matching logic, exception handling, testing and change management, and contingency. The percentages are a budgeting convention, not a market price. If one line is far out of proportion to the work described, ask why. The purpose is to expose omissions, especially testing and exception handling, which are routinely understated.
Business case without invented savings
Measure the current process: hours per week spent matching, open items at month-end, the age of the oldest unresolved item, duplicate payments and the hours spent retrieving evidence for auditors. Multiply only the hours you can observe by a loaded cost. Treat error reduction as a range and state the assumption. A business case can be strong without a payback period you cannot defend.
Budget worksheet
| Line | Basis | One-off | Recurring |
|---|---|---|---|
| Discovery and process mapping | Days | Yes | No |
| Payment source connectors | Sources | Yes | Support |
| Matching rules and tolerances | Rule sets | Yes | Review |
| Exception queue and workflow | Queues | Yes | Yes |
| Reconciliation reporting | Reports | Yes | Maintenance |
| Audit trail and permissions | Controls | Yes | Review |
| Testing and training | Days | Yes | Refresher |
| Contingency | Percentage | Yes | No |
Leave the rate column blank until vendors quote against the same basis. That is what makes the worksheet useful.
Vendor questions
- Which payment sources have a documented API, and which rely on file import?
- How are fees, partial payments and consolidated transfers handled?
- What happens when a reference is missing or reused?
- Who owns the exception queue after go-live?
- Can we export every match, every exception and the supporting evidence?
- What is the exit plan if we change accounting systems?
90-day plan
Weeks one and two establish the baseline. Weeks three and four run vendor demonstrations using your own statements. Weeks five to eight pilot one entity and one payment source. Weeks nine to twelve review the evidence, compare the manual hours removed and decide on rollout. Acceptance criteria should be written before the pilot: all sample statements ingested, exceptions visible, audit export complete and finance sign-off recorded.
We build reconciliation and payment workflows under Commerce Systems. The pricing page explains how discovery, integration and support are separated. For the failure modes that drive much of this cost, read automated invoice and payment matching problems and fixes.
Sources
- ISO 20022, Universal financial industry message scheme, accessed 17 November 2026.
- Bangladesh Bank, Payment systems overview, accessed 17 November 2026.
- COSO, Internal Control — Integrated Framework, accessed 17 November 2026.
- Xero Central, Reconcile bank transactions, accessed 17 November 2026.
Responses (0)
No comments yet. Add the first one below.
Leave a response
Your email address will not be published. Required fields are marked *.