ReconcileIQ - Bank Reconciliation Tool

Files must be in CSV format or Excel format (.csv, .xls, .xlsx)
Required columns (supports various header names):
- Date (e.g., "Date", "Transaction Date", "Posted", "Value Date", "Processed")
- Amount (can be single column or split):
  - Single column (e.g., "Amount", "Value", "Total", "Sum")
  - OR split columns (e.g., "Money In"/"Money Out", "Credit"/"Debit", "Deposits"/"Withdrawals")
- Description (e.g., "Description", "Narrative", "Details", "Reference", "Memo")
Dates accepted in common formats (DD/MM/YYYY, YYYY-MM-DD, DD-MMM-YYYY, etc.)
Amounts can include currency symbols (£, $, €), commas, parentheses for negatives

Example rows:


        Date,Amount,Description

        01/03/2024,-224.78,"Payment reference here"


        Posted,Money In,Money Out,Narrative

        01/03/2024,,224.78,"Payment reference here"

📄 Bank Statement (CSV or Excel) Choose File No file chosen

📄 Bookkeeping Software (CSV or Excel) Choose File No file chosen

Select Bank and Software

The software is designed to intelligently map most statement structures appropriately
Both CSV and Excel files (.csv, .xls, .xlsx) are supported
But if the mapping fails or if your statements are complex, check out the general guide below or use the dropdowns for tailored instructions

View General Guide - click here for generalised instructions or use dropdowns below for tailored instructions

Files can be either CSV format or Excel format (.csv, .xls, .xlsx)
Required columns (supports various header names):
- Date: e.g., "Date", "Transaction Date", "Posted", "Value Date", "Processed"
- Amount: Can be a single column (e.g., "Amount", "Value", "Total", "Sum")
  or split into multiple columns (e.g., "Money In"/"Money Out", "Credit"/"Debit", "Deposits"/"Withdrawals")
- Description: e.g., "Description", "Narrative", "Details", "Reference", "Memo"
- Fee columns: e.g., "Fee", "Charge", "Commission" – these are recognized and handled separately
Dates are accepted in all common formats:
- DD/MM/YYYY, MM/DD/YYYY, YYYY-MM-DD
- DD-MMM-YYYY (e.g., 01-Jan-2024)
- DD MMM YYYY (e.g., 01 January 2024)
Amounts can include:
- Currency symbols (£, $, €)
- Thousands separators (commas)
- Negative formats: -100.00 or (100.00)
- Optional decimal places

Example rows:

Date	Amount	Description
01/03/2024	-224.78	Payment reference here

Posted	Money In	Money Out	Narrative
01/03/2024		224.78	Payment reference here

OR other variations according to the rules stated above

Excel files will be automatically converted to the appropriate format

For specific instructions tailored to your setup, please use the dropdowns below and click "Show Instructions"

Currency of Files:

You can drag the blue boxes (even from above the header) to adjust the mapping.