Home Amazon Reconciliation How do I create and run a new reconciliation for Amazon MTR Report vs Disbursement?

How do I create and run a new reconciliation for Amazon MTR Report vs Disbursement?

Last updated on Sep 01, 2026

Short Answer: Open the New reconciliation page, choose or create a Reconciliation name, set Period, upload the Amazon MTR and Amazon Disbursement files, verify mappings with 'View format', then click 'Run reconciliation'.

PreRequisites

  1. Signed in to Cointab

  2. CSV, XLS or XLSX files for Amazon MTR Report and Amazon Disbursement ready

  3. Access to the reconciliation page

Steps

  1. Open the New reconciliation page for the Amazon MTR vs Disbursement flow.
    You see 'Reconciliation name', 'Period' and tiles for 'Amazon MTR Report' and 'Amazon Disbursement'.

  2. Select an existing Reconciliation name or click '+ New' to create one.
    The Reconciliation name field is populated.

  3. Click 'Select month/year' and pick the Period you want to reconcile.
    Period is selected and visible in the Period field.

  4. Under each tile for example 'Amazon MTR Report' and 'Amazon Disbursement' click 'Upload files' and add your CSV/XLS/XLSX files.
    Files appear attached in the respective tile.

  5. Click 'View format' for each dataset to confirm field mappings Date, Amount, Reference / Identifier and 'Records to include' rules.
    'Expected data format' modal opens allowing you to verify mappings and filters.

  6. Click 'Run reconciliation' top-right to run the matching process.
    Reconciliation runs and opens the results report page with summary cards.

  7. Review results on the report page and use 'Download report' or 'Add files & update report' if you need to export or update.
    Summary cards and the tabbed results list are visible.

Troubleshooting

  1. Upload fails or files do not appear in the tile.
    LikelyCause: Unsupported file type, corrupt file, or temporary network error.
    Action: Confirm files are CSV/XLS/XLSX, try re-saving the file or upload a smaller sample. Retry upload and check your network.

  2. Many records are missing from results or show as 'Skipped'.
    LikelyCause: 'Records to include' filters exclude those rows.
    Action: Open 'View format' for that dataset and either toggle on 'Include all records' or adjust the filter values to include your rows.

  3. Reconciliation totals look wrong after the run.
    LikelyCause: Fields Date/Amount/Reference are mis-mapped or the Header row is incorrect.
    Action: Open 'View format' and verify 'Header row', 'Date', 'Amount' and 'Reference / Identifier' mappings; correct and re-run.

Note: If you need to change files after a run, use 'Add files & update report' to attach new files and re-run.