Intelligent Bank Reconciliation
Upload your sales invoices and bank statement to begin the automated reconciliation process. Our AI will match transactions and identify discrepancies.
Upload your sales ledger or invoice export
Click to upload or drag and drop
CSV, Excel files supported
sales_invoices_march.csv
24 invoices • £45,200.00 total
Expected Columns:
Upload your bank statement export
Click to upload or drag and drop
CSV, OFX, QBO, Excel files
barclays_statement_march.csv
156 transactions • £52,340.00 total
Expected Columns:
Populate with sample transactions for demonstration
Intelligent Bank Reconciliation
24
Sales Invoices
156
Bank Transactions
18
Auto-Matched
6
Needs Review
Review AI-suggested matches before proceeding to exceptions
Select an invoice or bank transaction to view match details
Exception Handling
Review unmatched items and discrepancies. Take action to resolve each exception.
These sales invoices have no corresponding bank transaction. The payment may be pending, made by different method, or the invoice may be unpaid.
GL Coding & Classification
Review and confirm GL codes for all transactions. AI has suggested codes based on your rules.
24
Total Transactions
18
Auto-Coded
6
Needs Review
£45,200
Total Value
| Date | Description | Reference | Amount | AI Suggested GL | Final GL Code | Status |
|---|
Final Confirmation
Reconciliation Complete
All transactions have been matched, coded, and are ready for posting.
Review the summary below and confirm to post all transactions to your general ledger. This action cannot be undone.
24
Matched Transactions
100%
Coded to GL
£45,200
Total Value
12m
Time Saved
| Account | Description | Debit | Credit |
|---|---|---|---|
| 1200 - Bank Account | Barclays Business Current | £45,200.00 | - |
| 2200 - Accounts Receivable | Trade Debtors | - | £42,940.00 |
| 4000 - Sales Revenue | Sales - Services | - | £2,260.00 |
| Total | £45,200.00 | £45,200.00 | |