Short Answer: Use the 'Bank statement' panel to drag & drop the file or click 'Upload file' (Supported formats: CSV, XLS, XLSX; Maximum file size: 10 MB), then configure mappings in 'Configure bank statement'.
PreRequisites
-
Bank statement file in CSV, XLS, or XLSX format.
-
File size ≤ 10 MB.
-
Relevant data on the first sheet.
Steps
-
Open the New reconciliation page and locate the 'Bank statement' panel.
The Bank statement panel is visible and ready for file upload. -
Drag & drop your file onto 'Drag & drop your file here' or click 'Upload file' and select the file.
The file begins uploading, and the supported formats (CSV, XLS, XLSX) and maximum file size (10 MB) hint are visible. -
Wait for the upload to complete. The Bank statement card should display the file name and an Edit icon.
The uploaded file appears on the Bank statement card. -
Click the Edit icon on the Bank statement card to open 'Configure bank statement'.
The Configure bank statement modal opens showing 'Data preview (first 20 rows)'. -
Map the required fields such as Transaction date, Date format, Description / Narration, and Amount column.
-
Click 'Save & apply' to confirm the mappings.
The bank statement file is now ready for reconciliation.
Troubleshooting
-
Upload fails or the file is not accepted.
Likely Cause:
• The file exceeds 'Maximum file size: 10 MB'.
• The file is not in CSV/XLS/XLSX format.Action:
• Reduce the file size or split the file if necessary.
• Export the file to CSV, XLS, or XLSX, then try 'Upload file' again. -
Data preview shows missing or incorrect columns.
Likely Cause:
• The reconciled data is not on the first sheet.
• The file contains extra header rows.Action:
• Move the data to the first sheet.
• Remove any extra header rows.
• Save the file and upload it again.
Note: Supported formats and file size limits are shown under the upload box in the Bank statement panel.