Home Vendor Reconciliation How do I add Books and Vendor statement files and run the reconciliation?

How do I add Books and Vendor statement files and run the reconciliation?

Last updated on Sep 08, 2026

Short Answer: Open 'Add files to reconciliation', upload your Books and Vendor statement files CSV, XLS, XLSX in each panel, then click 'Run reconciliation'.

PreRequisites

  1. Be signed in and have access to the reconciliation report

  2. Have your Books and Vendor statement files ready CSV, XLS or XLSX

  3. Know which period/report to update

Steps

  1. Open the Vendor Reconciliation report and click 'Add files & update report'.
    You land on the 'Add files to reconciliation' page.

  2. On 'Add files to reconciliation' confirm 'Reconciliation name' and 'Period'.
    The page shows two panels: 'Books / ledger' and 'Vendor statement'.

  3. In the 'Books / ledger' panel click the 'Upload files' area and select your Books file(s) CSV, XLS, XLSX.
    Files upload starts; you can select multiple files.

  4. In the 'Vendor statement' panel click the 'Upload files' area and select your statement file(s).
    Vendor statement files are uploaded to the right panel.

  5. Optional: Click 'View format' under either upload panel to check expected columns and mappings.
    An 'Expected data format' modal opens showing sample rows and mapping controls.

  6. Click 'Run reconciliation'.
    The reconciliation runs and the report updates with new totals and matching results.

  7. Review the updated Vendor Reconciliation report cards and tables.
    Cards Total / Fully matched / Partially matched / Unmatched and transaction lists reflect the new run.

Troubleshooting

  1. The 'Run reconciliation' button does nothing or is disabled.
    LikelyCause: No files uploaded into one or both panels.
    Action: Upload files in both the 'Books' and 'Vendor statement' upload areas, then try 'Run reconciliation' again.

  2. File upload fails or shows an error.
    LikelyCause: Unsupported file type or corrupted file.
    Action: Save the source as CSV, XLS or XLSX and retry. If the file is large, try a smaller sample file first.

  3. Totals or matches don't change after running reconciliation.
    LikelyCause: Columns in your files are not mapped correctly dates, amounts or identifiers.
    Action: Click 'View format' to confirm and adjust the Date, Amount and Reference/Identifier mappings, then re-run.

  4. Large unmatched difference after run.
    LikelyCause: Missing or incorrect reference columns, duplicates, or files not uploaded.
    Action: Open the 'Unmatched' tab, inspect problematic rows, verify source files and 'Reference / Identifier' mappings, then re-run.

Note: Supported upload types shown: 'CSV, XLS, XLSX — select multiple files'. Use 'View format' to preview expected columns and 'Download format' for a template.