Short Answer: Upload both Entity A and Entity B statement files, confirm column mappings if needed, select the Entity pair and Period, then click 'Run reconciliation'.
PreRequisites
-
Be signed in
-
Have Entity A and Entity B statement files ready CSV, XLS, or XLSX
-
Know the month/year Period to reconcile
Steps
-
Open the Intercompany reconciliation page and enter or select the 'Entity pair name' and 'Period'.
'Entity pair name' and 'Period' fields are visible. -
Upload the Entity A file by clicking the 'Upload file' area inside the 'Entity A statement' box and select your CSV/XLS/XLSX file.
Entity A file appears inside the statement card filename shown. -
Upload the Entity B file the same way in the 'Entity B statement' box.
Entity B file is attached to its card. -
Optional: Click the pencil edit icon on each uploaded file to open 'Configure file' and verify Sheet, Header row, Date, Amount and Reference mapping.
'Configure file' modal opens for the selected file. -
When files are uploaded and mappings confirmed, click 'Run reconciliation' green button top-right.
Reconciliation runs and the results page e.g., 'X Company recon' opens.
Troubleshooting
-
Clicking 'Run reconciliation' does nothing.
LikelyCause: One or both statement files are not uploaded or 'Period' is not selected.
Action: Upload both Entity A and Entity B files and select a 'Period', then try 'Run reconciliation' again. -
File upload fails.
LikelyCause: File is not in an accepted format or is corrupted.
Action: Save the file as CSV, XLS or XLSX and re-upload.
Note: Use '+ Add supporting data' to attach supplementary files and '+ Add report' to include additional reports.