Short Answer: Open 'Configure file' for the uploaded file, choose 'Header row', set 'Account name' (and 'Account code' if available), pick closing balance handling (Single balance column or Separate debit and credit columns), then click 'Save & apply'.
PreRequisites
-
A trial balance file uploaded and visible in the Trial balance box
-
File contains header row and account names
Steps
- On the New account reconciliation page click 'Edit' next to the uploaded trial balance.
'Configure file - filename' modal opens.
- In the Configure file modal set the 'Header row' to the row containing your column headers.
Preview rows align with the header row you selected.
- Select the column for 'Account name' (and 'Account code' if you have one).
Account names map correctly in the preview.
- Under 'Closing balance' choose either 'Single balance column' or 'Separate debit and credit columns'. If you pick Separate, select the 'Debit' and 'Credit' columns.
Closing balances are configured and the preview updates.
- Click 'Save & apply' to save the mappings.
Mappings saved and the reconciliation preview uses the mapped columns.
Troubleshooting
- Preview cells show 'Click to generate' instead of values.
Likely Cause: The corresponding column has not been mapped.
Action: Choose the correct column for 'Account name' or add the missing column mapping in the modal.
- Balances look incorrect after mapping.
Likely Cause: Incorrect closing balance method chosen (Single vs Separate debit/credit).
Action: Reopen Configure file, choose the correct 'Closing balance' option and select proper Debit and Credit columns if using 'Separate debit and credit columns'.
Note: The Configure file modal shows the hint 'Closing balance = Debit - Credit' when you choose Separate debit and credit columns.