Home Customer Reconciliation How do I configure the Customer statement file columns for reconciliation?

How do I configure the Customer statement file columns for reconciliation?

Last updated on Sep 08, 2026

Short Answer: Open 'Configure file - Customer statement', set the header row, choose 'Value Date' as Date, select 'Separate credit and debit columns', map 'Credit amount' and 'Debit amount', and add 'Invoice No.' and 'PO No' as Reference / Identifier.

PreRequisites

  1. Customer statement file is uploaded and visible in the Customer statement card.

  2. You know which columns in your file are Date, Credit, Debit and identifiers Invoice No., PO No.

Steps

  1. On the 'Customer reconciliation' page click the pencil icon on the Customer statement card to open 'Configure file - Customer statement'.
    'Configure file - Customer statement' modal opens.

  2. Set 'Select the row number where the column headers are present' to the row that contains your headers example shows '4'.
    Data preview shows the selected header row.

  3. Under 'Date (optional)' choose 'Value Date'.
    'Value Date' is selected as the Date column.

  4. Under 'Amount' select 'Separate credit and debit columns' and note the guidance 'Net amount = Credit - Debit'.
    Separate credit/debit option selected and guidance visible.

  5. Set 'Credit amount' to 'Credit (USD)' and 'Debit amount' to 'Debit (USD)'.
    Credit and Debit dropdowns show the correct column choices.

  6. In 'Reference / Identifier' select 'Invoice No.' and 'PO No' add more if applicable.
    'Invoice No.' and 'PO No' appear as selected identifiers.

  7. Close the modal by clicking 'X' and verify the mapping is saved in the card.
    Customer statement mapping is applied and will be used when you run reconciliation.

Troubleshooting

  1. Preview shows wrong column names or data under header row.
    LikelyCause: Incorrect header row number selected.
    Action: Change 'Select the row number where the column headers are present' to the correct row until column headers align with preview.

  2. Amounts sign or totals are inverted after reconciliation.
    LikelyCause: Wrong amount orientation selected. Net amount interpretation differs.
    Action: Re-open 'Configure file - Customer statement' and confirm 'Separate credit and debit columns' is selected and that 'Credit amount' and 'Debit amount' dropdowns are assigned correctly. See the 'Net amount = Credit - Debit' note.

  3. Identifiers like Invoice No. aren't available to select.
    LikelyCause: Header row incorrect or column not present in file preview.
    Action: Adjust header row or use 'Add column' in the modal to expose/match that column, then select it under 'Reference / Identifier'.

Note: Customer statement modal shows the help note 'Net amount = Credit - Debit' — use this to confirm correct credit/debit mapping.