Home Credit Card Reconciliation How do I upload Books and Credit card statement files and run a credit card reconciliation?

How do I upload Books and Credit card statement files and run a credit card reconciliation?

Last updated on Sep 08, 2026

Short Answer: Upload your Books and Credit card statement files to the respective panels, enter the Credit card account name and Period, then click 'Run reconciliation'.

PreRequisites

  1. Be signed in to Cointab.

  2. Have Books (.xlsx) and Credit card statement (.xlsx) files ready examples shown: QuickBooks_Credit_Card_Books (1).xlsx, Amex_Credit CardStatement_.xlsx.

  3. Know the Credit card account name and Period month/year to reconcile.

Steps

  1. Open the Credit card reconciliation page.
    You see the Books / ledger and Credit card statement panels and the 'Run reconciliation' button.

  2. In the Books / ledger panel click '+ Add more files to Books' and upload your Books file.
    The Books file appears as a file card inside the Books panel.

  3. In the Credit card statement panel click '+ Add more files to Credit card statement' and upload the statement file.
    The Credit card statement file appears as a file card in that panel.

  4. Enter the 'Credit card account name' and select the 'Period' Select month/year at the top.
    Both fields are filled and ready for the run.

  5. Click 'Run reconciliation' top-right.
    The reconciliation runs and you are taken to the results summary with cards such as 'Fully matched' and 'Unmatched'.

Troubleshooting

  1. The 'Run reconciliation' button is disabled or nothing happens when I click it.
    LikelyCause: Required inputs e.g., 'Credit card account name' or 'Period' are not filled or there is a temporary UI issue.
    Action: Fill 'Credit card account name' and 'Period', then try again. If it still doesn't respond, refresh the page and retry.

  2. File upload fails or file is not accepted.
    LikelyCause: File is corrupt or not in the format shown. Screenshots show .xlsx files.
    Action: Re-export the file as .xlsx and re-upload. If problems continue, try a different browser or check file size and content.

  3. I uploaded files but the summary did not update.
    LikelyCause: You updated files on an existing report without using the update flow.
    Action: From the summary page click 'Add files & update report' to return to the upload/configure screen, then re-run reconciliation.

Note: Example file names visible in the UI are .xlsx; the UI shows separate panels for Books and Credit card statement.