Home Vendor Reconciliation How do I configure a vendor / supplier statement for reconciliation?

How do I configure a vendor / supplier statement for reconciliation?

Last updated on Apr 28, 2026

Short Answer: Use the right-hand 'Required fields' panel to map columns (sheet, header row, transaction date, date format, reference fields, amount representation), preview data, then click "Save & apply".

PreRequisites

  1. A vendor/supplier file is loaded and visible in Data preview (20 rows)

  2. You can identify the header row and the columns for dates and amounts

Steps

  1. Open the dialog titled "Configure vendor / supplier statement" and confirm data appears under "Data preview (20 rows)".
    You see a preview table with columns like "Line No", "Value Date", "Document Date", "Doc Type", "Invoice No.", "P O No".

  2. Under "1. Select sheet" choose the sheet that contains your statement (e.g., "Vendor Statement").
    The correct sheet is selected.

  3. Set "2. Header row" to the row number that contains the column names (e.g., "5").
    Column headings align correctly in the preview.

  4. Choose the transaction date column under "3. Transaction date" (e.g., "Value Date").
    The selected column is used for transaction dates.

  5. Set the date order under "4. Date format" using First value / Second value / Third value (e.g., Month / Day / Year).
    Date format matches your file.

  6. Map descriptive fields under "5. Reference / Description" by selecting columns (e.g., "Doc Type", "Invoice No.", "P O No", "Description", "Currency", "Remarks").
    Selected fields appear as tags.

  7. Choose the correct option under "6. Amount representation":
    Single signed amount column OR Separate debit and credit columns.
    Selection matches your file format.

  8. Verify everything in "Data preview (20 rows)", then click "Save & apply" (or "Cancel" to discard).
    Mappings are saved and applied.

Troubleshooting

  1. Dates look incorrect after applying mappings.
    LikelyCause: Wrong transaction date or incorrect date format order.
    Action: Re-check "3. Transaction date" and adjust "4. Date format".

  2. Reference / Description is missing expected fields.
    LikelyCause: Incorrect header row.
    Action: Fix "2. Header row" so column names appear correctly.

  3. Amounts are incorrect or signs are wrong.
    LikelyCause: Wrong amount representation.
    Action: Switch between signed and separate debit/credit options.

  4. Cannot click "Save & apply".
    LikelyCause: Required fields are incomplete.
    Action: Ensure sheet, header row, and transaction date are properly set.

Note: Always use the Data preview to validate mappings before saving. Use Cancel or the X to exit without applying changes.