Short Answer: Open the "Configure books data" modal, map the books file columns to reconciliation fields using the right-hand controls, apply any filters if needed, then click the yellow button at the bottom-right to save and proceed.
PreRequisites
-
A Books / Books of accounts file has been uploaded to the corresponding card.
-
Statement review and party mapping (if applicable) are completed.
Steps
-
In the reconciliation flow, open the "Configure books data" modal.
The left panel shows sample rows from the uploaded books file, while the right panel displays the mapping controls. -
Use the right-side dropdowns to map your books file columns to reconciliation fields such as:
-
Ledger
-
Amount
-
Date
-
Party
Each required reconciliation field is assigned to a source column from your file.
-
-
Configure any filters or date ranges available in the right panel (if present).
Filters or ranges appear applied within the modal interface. -
Click the yellow button in the bottom-right corner to save the configuration and continue.
The configuration is saved and the system proceeds to run reconciliation or move to the results screen.
Troubleshooting
-
Mapping dropdowns do not show expected column names.
Likely Cause: The books file does not contain a header row or the headers are not in the first row.
Action:
Add a clear header row, ensure it is on the first row of the first sheet, then re-upload the file. -
Amounts do not match expected totals after mapping.
Likely Cause: The wrong column was selected for the amount field, or values are formatted as text.
Action:
Reopen "Configure books data", select the correct amount column, and ensure the column is formatted as numeric in the source file.
Note: Pay special attention to Amount and Party/Ledger mappings—incorrect mapping can lead to mismatches during reconciliation.