Home 3-way Reconciliation How do I create a new 3-way reconciliation?

How do I create a new 3-way reconciliation?

Last updated on Aug 31, 2026

Short Answer: Enter a Reconciliation name and Period, upload files for Side A, Side B and Side C CSV, XLS, XLSX, optionally add supporting data or reports, then click "Run reconciliation".

PreRequisites

  1. Be signed in to Cointab

  2. Open the New reconciliation page

  3. Have CSV, XLS, or XLSX files ready for each side you want to reconcile

Steps

  1. Enter a name in the "Reconciliation name" field placeholder: "e.g. Orders vs PSP".
    The Reconciliation name field is filled with your label.

  2. Select a period using the "Period" field placeholder: "Select month/year".
    A month/year is selected and shown in the Period field.

  3. Under "Side A - Your Records", click the "Upload file" area and choose a CSV, XLS, or XLSX file.
    Your Side A file is uploaded and listed in Side A.

  4. Under "Side B - External records", click the "Upload file" area and choose a CSV, XLS, or XLSX file.
    Your Side B file is uploaded and listed in Side B.

  5. Under "Side C - Settlement records", click the "Upload file" area and choose a CSV, XLS, or XLSX file if you have settlement/bank data.
    Your Side C file is uploaded and listed in Side C.

  6. Optionally click "+ Add supporting data" under any side to attach extra files.
    Supporting data files are attached to that side.

  7. Optionally click "+ Add report" at the bottom of a side column to attach a report.
    The report is attached to the reconciliation.

  8. Click the "Run reconciliation" button at the top-right of the page to start the reconciliation.
    The reconciliation job begins processing status or results screen appears after processing.

Troubleshooting

  1. "Run reconciliation" does nothing or stays disabled.
    LikelyCause: Required fields Reconciliation name or Period are empty or required files are not uploaded.
    Action: Fill the "Reconciliation name" field, select a "Period", upload the needed side files, then try "Run reconciliation" again.

  2. File upload fails or shows an error.
    LikelyCause: File is not CSV/XLS/XLSX or network issue during upload.
    Action: Confirm the file is CSV, XLS, or XLSX. If it is, retry the upload and check your network connection.

  3. Unable to attach supporting data or report.
    LikelyCause: Browser blocked file dialogs or you lack permission to modify reconciliation.
    Action: Allow file dialogs in your browser, try a different browser, or check with your administrator for permissions.