Home Vendor Reconciliation How do I select Reference / Identifier columns so transactions can be matched?

How do I select Reference / Identifier columns so transactions can be matched?

Last updated on Sep 08, 2026

Short Answer: Open 'Expected data format' and use the 'Reference / Identifier' area to select one or more identifier columns e.g., 'Invoice No.', 'PO No', 'Doc No', 'Vendor Invoice Ref'.

PreRequisites

  1. Open the 'Add files to reconciliation' page and click 'View format'

  2. Know which columns in your files contain order ID or transaction ID values

Steps

  1. Click 'View format' under the appropriate upload panel to open the 'Expected data format' modal.
    The modal opens showing sample columns and a 'Reference / Identifier' area on the right.

  2. In 'Reference / Identifier' click one or more chips representing sample columns e.g., 'Invoice No.', 'PO No', 'Doc No', 'Vendor Invoice Ref'.
    Selected identifiers appear as chips to indicate they will be used for matching.

  3. Close the modal and re-run reconciliation.
    The engine will use the selected reference columns when matching transactions.

Troubleshooting

  1. Transactions that should match remain unmatched.
    LikelyCause: Identifier columns contain mismatched values formatting, extra spaces or the wrong identifier columns were selected.
    Action: Open the source files and ensure identifier values match exactly by removing leading/trailing spaces and using consistent formatting, or choose different reference columns in 'View format'.