Home Intercompany Reconciliation How do I configure entity A statement to map my file columns for reconciliation?

How do I configure entity A statement to map my file columns for reconciliation?

Last updated on Apr 24, 2026

Short Answer: Open the Configure entity A statement dialog, review 'Data preview (20 rows)', set '1. Select sheet', '2. Header row', '3. Transaction date', '4. Date format', '5. Reference / Description' and '6. Amount representation', then click 'Save & apply'.

PreRequisites

  1. Open the Configure entity A statement dialog with your file loaded (you should see 'Data preview (20 rows)')

Steps

  1. Confirm you are in the 'Configure entity A statement' dialog and that 'Data preview (20 rows)' shows sample rows and columns (for example: 'Entry No', 'Posting Date', 'Document Date', 'Doc Type', 'Doc No').
    Dialog title and sample data preview are visible.

  2. Under '1. Select sheet' choose the sheet that contains your data (example shown: 'Branch Ledger').
    '1. Select sheet' shows the chosen sheet name.

  3. Set '2. Header row' to the row number that contains your column headers (example shown: '5').
    Column labels are read from the selected header row.

  4. In '3. Transaction date' select the column that holds transaction dates (example: 'Posting Date').
    The chosen column is marked as the transaction date source.

  5. Under '4. Date format' set 'First value', 'Second value', 'Third value' to match the order of day, month, and year in your file (example: Day | Month | Year).
    Date parsing is set to the correct D/M/Y or M/D/Y order.

  6. Confirm the fields listed in '5. Reference / Description' (chips shown: 'Entry No', 'Doc Type', 'Doc No', 'Reference No', 'P O / Agreement Ref', 'Terms', 'Narration / Memo', 'Currency', 'Status'). Remove any unwanted chips by clicking '×'.
    Reference/description fields are composed of the selected chips.

  7. Choose the appropriate option under '6. Amount representation' — either 'Single signed amount column' or 'Separate debit and credit columns'.
    Amount representation setting matches how amounts appear in your file.

  8. Click 'Save & apply' to save your settings, or click 'Cancel' (or the 'x' at top-right) to close without saving.
    Mappings are saved and the dialog closes, or changes are discarded if you cancelled.

Troubleshooting

  1. Dates appear invalid or are not parsed.
    LikelyCause: '3. Transaction date' points to the wrong column or '4. Date format' does not match the date order in your file.
    Action: Under '3. Transaction date' select the correct date column, then set 'First value', 'Second value', 'Third value' in '4. Date format' to match your file (e.g., Day / Month / Year).

  2. Reference / Description is empty or shows wrong values.
    LikelyCause: '2. Header row' is not set to the row with column headers, so the expected column names are unavailable for mapping.
    Action: Set '2. Header row' to the row that contains your headers (example: 5). Confirm the desired columns appear as chips in '5. Reference / Description'.

  3. Amounts total incorrectly after mapping.
    LikelyCause: Incorrect selection in '6. Amount representation' (signed amounts vs separate debit/credit).
    Action: Switch between 'Single signed amount column' and 'Separate debit and credit columns' to match the file format and reapply.

  4. 'Save & apply' is disabled or does not save.
    LikelyCause: One or more required fields under 'Required fields' (items 1–6) are not set.
    Action: Complete each item under 'Required fields' (Select sheet, Header row, Transaction date, Date format, Reference / Description, Amount representation) then click 'Save & apply'.