Short Answer: Select Bank reconciliation, upload the Bank statement and Books files, map the required fields in each Configure modal, then click Run reconciliation.
PreRequisites
-
Have Bank statement and Books files in CSV, XLS, or XLSX format.
-
Each file must be ≤ 10 MB (Maximum file size: 10 MB).
-
Keep the data to be reconciled in the first sheet of the file.
-
Have the bank account name or number (if required).
Steps
1. Select reconciliation type
Open New reconciliation, click Select reconciliation type, and choose Bank reconciliation.
The reconciliation type is set to Bank reconciliation.
2. Enter the bank account
Click the Bank account name field and type or select the bank account name or number.
The Bank account name field is populated.
3. Upload the Bank statement
In the Bank statement panel, click Upload file or drag & drop your file.
Supported formats: CSV, XLS, XLSX.
The Bank statement card shows the uploaded file and an Edit icon appears.
4. Upload the Books file
In Books / Books of accounts, click Upload file or drag & drop your file.
The Books card shows the uploaded file and an Edit icon appears.
5. Configure Bank statement mapping
Click Edit on the Bank statement card to open Configure bank statement.
Map the following fields:
-
Transaction date
-
Date format
-
Description / Narration
-
Amount representation
-
Amount column
Then click Save & apply.
The mapping is saved and the modal closes.
6. Configure Books mapping
Click Edit on the Books / Books of accounts card to open Configure books data.
Map the following fields:
-
Date
-
Date format
-
Description / Narration
-
Amount column
Then click Save & apply.
The Books mapping is saved and the modal closes.
7. Run reconciliation
Once both files are uploaded and mappings are saved, click Run reconciliation.
The reconciliation process begins.
Troubleshooting
1. Run reconciliation button is disabled
Likely Cause:
-
One or both files not uploaded
-
Required mappings not saved
-
Bank account name missing
Action:
Upload both files, open Edit for each file and click Save & apply, and enter the Bank account name if required.
2. File upload fails
Likely Cause:
-
File size exceeds 10 MB
-
File format not supported
Action:
Use CSV, XLS, or XLSX, ensure the file is ≤ 10 MB, then upload again.
3. Dates or amounts appear incorrect in preview
Likely Cause:
-
Incorrect Date format selected
-
Wrong Amount column selected
-
Numbers formatted in scientific notation
Action:
Open the Configure modal, select the correct Date format, confirm the Amount column, and re-upload if needed after correcting formatting.
Note: Keep the reconciliation data in the first sheet of your file and use the Data preview (first 20 rows) in the Configure modals to confirm your column mappings before running reconciliation.