Finance
Bank Reconciliation
Match bank transactions with your business records.
Bank Reconciliation compares your bank transaction data with invoices and other business records. It matches what can be matched by clear rules and gives you a focused list of everything that needs a decision, with every step recorded.
What it does
The product takes in bank transaction data, for example from bank statement and transaction files, together with your invoice or business records. It matches transactions using transparent rules based on amounts, references, dates and counterparties.
Where one payment covers several invoices, or an invoice is paid in parts, the amounts can be allocated accordingly. Unmatched and ambiguous items go to a review list. A person reviews them and approves the results, and every match, allocation and decision is kept in an audit trail.
Typical input
- Bank statement and transaction files
- Invoice records
- Other business or financial records to match against
What you receive
- Matched transactions and allocations
- A list of unmatched and ambiguous items
- Reviewed and approved reconciliation results
- An audit trail of every match and decision
Works on its own
Bank Reconciliation is sold and installed on its own. It works with invoice and business records from your existing systems and does not require any other product.
The problem it solves
Reconciling bank transactions by hand means going through statements and searching for the matching record, again and again. It becomes harder when payment references are unclear.
- Payment references that are missing, shortened or incorrect
- One payment covering several invoices, or several payments for one invoice
- Time-consuming reconciliation at the end of each period
- Little record of why a transaction was matched the way it was
How it works
- 1
Import data
Bank transaction data and your business or invoice records are imported.
- 2
Match
Rules match transactions by amount, reference, date and counterparty.
- 3
Allocate
Payments are allocated across one or more records where needed.
- 4
Identify exceptions
Unmatched and ambiguous items are collected in a review list.
- 5
Review and approve
A person resolves exceptions and approves the results.
- 6
Keep the audit trail
Every match, allocation and decision is recorded, and results can be exported.
Example workflow
A business reconciles its bank account against open customer invoices at the end of each week.
- 01The latest bank transaction file and the list of open invoices are imported
- 02Transactions with a clear reference and matching amount are matched
- 03One payment is allocated across two invoices from the same customer
- 04A transaction without a usable reference is listed for review, with possible matching invoices
- 05The reviewer selects the correct invoice and approves the results, and the decision is recorded
Key capabilities
Transaction import
Takes in bank statement and transaction files in agreed formats.
Rule-based matching
Predictable matching by amount, reference, date and counterparty.
Transaction allocation
Split one payment across several records, or combine partial payments.
Exception handling
Unmatched and ambiguous items are collected for review.
Review and approval
A clear process for people to resolve exceptions and approve results.
Audit trail
A record of every match, allocation and decision.
Optional AI assistance
Help interpreting unclear payment descriptions, where useful.
Structured results
Reconciliation results in Excel or a database.
Expected business impact
- Reduce repetitive manual matching of transactions
- Make unmatched items easier to identify
- Create a clearer, consistent review process
- Maintain traceability for every reconciliation decision
Before
- Go through statements line by line
- Search for the matching record manually
- Keep track of decisions in notes, or not at all
After
- Clear matches are made by rule
- Only exceptions need review
- Every decision is recorded
The actual effect depends on your volumes and current process. We discuss realistic expectations during the requirements phase.
Customization
Core automation, adapted to your workflow.
Reconciliation depends on your bank data, your records and how you work, so the product is set up around them.
- Bank transaction file formats
- Source and structure of invoices and business records
- Matching rules and tolerances
- Review and approval rules
- Whether AI assistance is used for unclear items
- Export format and connection to accounting software, where technically possible and agreed in the scope
Ownership & deployment
This product is installed into infrastructure that your organization owns and pays for. After delivery, you remove our access and keep full control.
- Your repository, database and deployment
- Your data, API accounts and external service accounts
- Developer access only during the project, removed by you after delivery
- Keeps running without our accounts or servers
| GitHub | Private repository with the system's code |
|---|---|
| Supabase | Database for transactions, matches and audit trail |
| Vercel | Hosting for the review interface |
| Anthropic API (optional) | Only if AI assistance for unclear items is included |
Bank transaction data is imported from statement or transaction files. A direct bank connection is only included if agreed for your bank in the scope.
How ownership and handover workPricing
Project price
€4,000 – €6,000
Final price depends on reconciliation rules, transaction sources and integrations.
A one-time project price for customization, installation, testing and delivery. The final price is agreed in writing after the requirements discussion.
Founding Client PricingIntroductory pricing for our first 3 client projects.
Prices exclude VAT where applicable.
After successful delivery, we may ask for permission to use anonymized results or a case study. This is always your choice.
Included in the project
- Setup of data imports and matching rules
- Installation in your infrastructure
- Testing with your own transactions and records
- Handover and documentation
What affects the final price
- Number of bank accounts and file formats
- Complexity of matching and allocation rules
- Whether AI assistance is included
- Required integrations
Running costs of services in your own accounts (hosting, database, AI API usage) are billed to you directly by those providers.
How to order
Every product is ordered the same way:
- 1Contact
- 2Requirements
- 3Scope & quote
- 4Customization
- 5Implementation
- 6Testing
- 7Delivery
Talk to us about Bank Reconciliation
Send a short description of your current workflow. We will reply with questions for scoping and the next steps.