Home 3-way Reconciliation

3-way Reconciliation

Match Side B reports against Side A and Side B records to identify discrepancies, verify transactions, and ensure accurate three-way reconciliation.
By Vishwesh Sarkar
• 30 articles

How do I create a new 3-way reconciliation?

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.

Last updated on Aug 31, 2026

How do I add a report to Side A, Side B, or Side C?

Short Answer: On the Copy reconciliation page click '+ Add report' under the side you want, open the 'Configure file' modal to map required fields, then click 'Save configuration'. PreRequisites 1. Be signed in 2. Open the Copy reconciliation page 3. Have the report file ready to upload Steps 1. Open the Copy reconciliation page. You see columns for 'Side A - Your Records', 'Side B - External records', and 'Side C - Settlement records'. 2. Under the side where you want the report, click '+ Add report'. An empty report tile appears document icon or the upload/configure flow opens. 3. If the 'Configure file' modal opens, map your file fields Header row, Date (optional), Amount, Reference / Identifier. Data preview 20 rows shows sample rows and dropdowns let you pick columns. 4. When mapping is complete, close the modal and click 'Save configuration' on the main page. 'Save configuration' completes and the report tile shows sample rows e.g., '20 sample rows'. Troubleshooting 1. + Add report button not visible. LikelyCause: You're not on the reconciliation edit page or you lack permissions. Action: Open the correct 'Copy reconciliation' page and sign in with an account that can edit the reconciliation. 2. Report appears to upload but no sample rows show. LikelyCause: Upload failed or file format wasn't detected correctly. Action: Remove and re-add the report, or re-export the file ensuring a standard CSV/Excel format before uploading. 3. 'Configure file' modal doesn't open after adding a report. LikelyCause: Browser popup/UI error. Action: Refresh the page and try again; if persistent, try a different browser. Note: Uploaded report tiles show '20 sample rows' in the screenshots. Map required fields before running reconciliation.

Last updated on Aug 31, 2026

How do I add a validation check between two reports?

Short Answer: Click '+ Add validation check', enter a 'Check name', choose Report 1 + Column and Report 2 + Column, then click 'Save check'. PreRequisites 1. At least two reports added to the reconciliation 2. Be on the Copy reconciliation page Steps 1. On the Copy reconciliation page click '+ Add validation check' near the side where you want to add the check. The 'Add validation check' modal opens. 2. In the modal type a descriptive name into 'Check name' placeholder shows examples. A Check name is entered. 3. Under 'Report 1' select the first report from 'Select report' and choose its 'Column'. Report 1 and Column are selected. 4. Under 'Report 2' select the second report from 'Select report' and choose its 'Column'. Report 2 and Column are selected. 5. Click 'Save check' to save the validation. Validation check is saved and appears on the main page example: 'T1' tag near a side. Troubleshooting 1. 'Save check' does nothing or appears disabled. LikelyCause: Required fields Check name, Report or Column are empty. Action: Enter a Check name and select both Report + Column pairs, then click 'Save check'. 2. Desired report not listed in 'Select report'. LikelyCause: That report hasn't been added to the reconciliation. Action: Add the report to the appropriate side first, then re-open the 'Add validation check' modal. Note: The 'Add validation check' modal shows a 'matches with' divider between the two report blocks. Saved checks appear on the main page near sides.

Last updated on Aug 31, 2026

How do I map Header row, Date, Amount, and Reference / Identifier for an uploaded report?

Short Answer: Open the 'Configure file' modal for the report, set 'Header row', choose 'Date (optional)' and 'Amount', then select one or more 'Reference / Identifier' columns. PreRequisites 1. Report uploaded to a side 2. Have access to edit the report pencil icon Steps 1. Open the report's Configure file modal by clicking the pencil icon on the report tile. Modal titled 'Configure file - 1' or 'Configure file - 2' opens and shows 'Data preview (20 rows)'. 2. In 'Required fields', set 'Header row' to the row number where column headers appear. Column headers in the Data preview update to the chosen header row example shows '4'. 3. If your file has a date column, set 'Date (optional)' to the column name that contains dates. Date column is selected and visible in the Data preview. 4. Set 'Amount' to the column that contains transaction amounts. The selected Amount column displays numeric values in the preview. 5. Under 'Reference / Identifier' select one or more columns to use as matching keys tokens like 'Identifier' and 'TestCaseID' appear. Selected identifiers appear as tokens in the field. 6. If applicable, choose whether this file should 'Match with Side A' or 'Match with Side C'. The chosen 'Match with' option is highlighted. 7. Close the modal and click 'Save configuration' on the main page to persist your mappings. Field mappings are saved for the report. Troubleshooting 1. Columns look wrong or blank after mapping. LikelyCause: Header row value is incorrect. Action: Change 'Header row' up or down until the correct header names appear in 'Data preview (20 rows)'. 2. 'Amount' is not available or shows non-numeric values. LikelyCause: Header detection failed or amount values include text/formatting. Action: Ensure the correct header row is selected; if needed, fix the source file to have a clean numeric Amount column. 3. Reference / Identifier options don't include the column I expect. LikelyCause: Wrong header row or headers contain unexpected characters. Action: Set 'Header row' to the correct row and re-open the dropdown to select the identifier column. Note: Date is optional; you can select multiple Reference / Identifier columns. Use 'Data preview (20 rows)' to verify mappings.

Last updated on Aug 31, 2026

How do I open the 'Matched transaction details' for a matched pair?

Short Answer: Click the matched row in the list Fully/Partially/Unmatched to open the 'Matched transaction details' modal showing both sides and the match basis. PreRequisites 1. You are signed in and can open the report. 2. Open the 3 way + validation report title: '3 way + validation'. 3. The match list Fully/Partially/Unmatched is visible. Steps 1. Open the '3 way + validation' report page. You see the summary cards Total, Fully matched, Partially matched, Unmatched and the transaction list area. 2. Select the comparison tab you need for example 'Side A - Your Records vs Side B - External records'. The transactions for that comparison are shown in the list area. 3. Locate and click the matched row you want to inspect for example the row showing Reference/Identifier 'TC1' and Amount '100.00'. The 'Matched transaction details' modal opens. 4. Review the modal content: 'Match basis', 'Side A - Your Records transactions', 'Side B - External records transactions' and the totals/difference. You can see Date, Amount, Identifier, TestCaseID, Amount 2, Scenario and Notes for each side. Troubleshooting 1. Clicking a row does not open 'Matched transaction details'. LikelyCause: You may be on a different comparison tab, or an overlay/loader is blocking interaction. Action: Make sure 'Side A - Your Records vs Side B - External records' or the correct comparison is selected. Close any overlays, refresh the page and try again. 2. Modal opens but columns are truncated or not visible. LikelyCause: Window size or scroll position hides columns. Action: Resize or scroll the modal to reveal columns, or maximize your browser window. Note: Rows that represent matched pairs appear in the transaction list area; click any such row to view details.

Last updated on Aug 31, 2026

How do I unmatch a matched transaction pair?

Short Answer: Open the 'Matched transaction details' modal for the pair and click the red 'Unmatch' button in the 'Match basis' box. PreRequisites 1. You can open the specific matched pair in 'Matched transaction details'. 2. You are signed in and have permission to modify matches if applicable. Steps 1. Open the matched pair in 'Matched transaction details' see how in the open details steps. The modal is visible showing both sides of the match. 2. In the modal locate the 'Match basis' box and click the red 'Unmatch' button. The platform removes the current match for that pair and the UI updates to reflect the change. 3. Verify totals and the match lists Fully/Partially/Unmatched to confirm the change. The transaction should move out of the matched group and totals update accordingly. Troubleshooting 1. 'Unmatch' button is not visible or not clickable. LikelyCause: You opened a summary view not the details modal or your account lacks edit permissions. Action: Open the full 'Matched transaction details' modal and try again; if still not clickable, check your account permissions or contact your admin. 2. You clicked 'Unmatch' but totals did not change. LikelyCause: UI did not refresh or server-side update failed. Action: Refresh the report page and re-open the match details; if the problem persists, retry later or contact support. Note: The 'Unmatch' action is available inside the 'Matched transaction details' modal in the 'Match basis' area.

Last updated on Aug 31, 2026

Why do amounts differ between Side A and Side B for a matched pair?

Short Answer: Open 'Matched transaction details' and compare the 'Amount' and 'Amount 2' fields — the report's 'Match basis' uses 'Amount' not necessarily 'Amount 2'. PreRequisites 1. Open the matched pair in 'Matched transaction details'. Steps 1. Open the matched pair's 'Matched transaction details' modal. You see side-by-side rows for Side A and Side B. 2. Check the 'Match basis' box which shows 'Reference ID + Amount' and the text 'Transactions matched using Identifier and Amount.' You confirm the report used the 'Amount' column for matching. 3. Compare the 'Amount' fields on both sides; then compare 'Amount 2' if present. If the 'Amount' values differ, that explains the difference; if 'Amount' matches but 'Amount 2' differs, 'Amount 2' is a secondary field and does not affect the match. 4. If source data is incorrect, correct the source and use 'Add files & update report' to refresh the report. Updated data will reflect in totals after the report is updated. Troubleshooting 1. Totals show 0.00 difference but 'Amount 2' values differ for example 300 vs 320. LikelyCause: The report used the 'Amount' column for matching/totals and the 'Amount' values match, while 'Amount 2' is an additional field only for reference. Action: Confirm 'Match basis' and rely on the matched 'Amount' for totals; if you need to match using 'Amount 2', standardize data and re-run the report or unmatch and reprocess with the desired fields. 2. Amounts differ and you cannot find which transactions cause the delta. LikelyCause: Some transactions contributing to totals may be in other match categories Partially matched or Unmatched. Action: Switch between 'Fully matched', 'Partially matched' and 'Unmatched' tabs and open suspicious matches to locate discrepancies. Note: The screenshots show 'Reference ID + Amount' as the match basis; rely on those fields when investigating amount differences.

Last updated on Aug 31, 2026