Intercompany Reconciliation

Cointab automates intercompany reconciliation by matching Entity A vs B transactions to detect missing entries, mismatches, and timing differences—replacing manual Excel processes.

By Vishwesh Sarkar

• 10 articles

Dates in the data preview show timestamps e.g., 2025-01-05T00:00:00. How do I fix header/column alignment so dates display correctly?

Dates in the data preview show timestamps e.g., 2025-01-05T00:00:00. How do I fix header/column alignment so dates display correctly? Category: Troubleshooting Short Answer: Open 'Configure file', set the correct 'Header row', and select the correct 'Date' column for example 'Document Date' so preview columns align and dates display properly. Answer PreRequisites 1. File uploaded 2. 'Configure file' modal open Steps 1. Click the pencil icon on the uploaded file to open 'Configure file'. Data preview and mapping fields are visible. 2. Set 'Header row' to the row number where headers are located example: change to '5'. Preview's header row aligns with column names. 3. Under 'Date (optional)' select the column that holds dates e.g., 'Document Date'. Date column is associated correctly and preview shows dates. 4. If timestamps still appear, format the date in the source file to a standard date format and re-upload. Preview displays clean date values. Troubleshooting 1. Dates remain in ISO timestamp format after changing header row. LikelyCause: Source file uses non-standard or text-formatted dates. Action: In the source spreadsheet, re-format the column as a date and save, then re-upload and re-check 'Date' mapping.

Last updated on Sep 08, 2026

How do I add supporting data or add another report to the reconciliation?

How do I add supporting data or add another report to the reconciliation? Category: File management Short Answer: Click '+ Add supporting data' inside a statement card to attach supplementary files, or click '+ Add report' at the bottom to add another report area. Answer PreRequisites 1. Reconciliation setup screen open 2. Supporting file(s) ready Steps 1. On the Intercompany reconciliation setup page, locate the '+ Add supporting data' link inside the Entity A or Entity B statement card. Link '+ Add supporting data' is visible inside the statement card. 2. Click '+ Add supporting data' and select the supporting file to upload. Supporting file is attached to that statement. 3. To add another report area, scroll to the bottom and click '+ Add report'. A new report upload area is created. 4. Upload files to the new report area and configure them as needed. Additional report is included in reconciliation inputs. Troubleshooting 1. '+ Add supporting data' is not visible. LikelyCause: You might be on a different reconciliation type or the card is collapsed. Action: Make sure you are on the Intercompany reconciliation page and expand the statement card; try resizing your window if necessary.

Last updated on Sep 08, 2026

How do I configure a file's Sheet, Header row, Date, Amount and Reference/Identifier columns?

Short Answer: Open the uploaded file's 'Configure file' modal, choose the Sheet and Header row, select the Date column, pick the amount representation, and add Reference/Identifier columns. PreRequisites 1. File already uploaded 2. Know which row contains column headers 3. Know the column names for date, amount and identifiers Steps 1. Click the pencil edit icon on the uploaded file to open 'Configure file - Entity A statement' or 'Configure file - Entity B statement'. 'Configure file' modal appears with a data preview. 2. In the right panel use the 'Sheet' dropdown to select the worksheet containing transactions e.g., 'Branch Ledger' or 'Head Office Ledger'. Correct sheet selected and preview shows rows from that sheet. 3. Set 'Header row' to the row number where the column headers are present example shows '5'. Preview column headers align with the data. 4. Under 'Date (optional)' select the column that contains the transaction date e.g., 'Document Date'. Dates are associated with the selected column. 5. In 'Amount' choose how amounts are represented: 'Single signed amount column' or 'Separate credit and debit columns' and then pick the appropriate column e.g., 'Net Movement (USD)'. Amount mapping is set and preview shows amount values. 6. Under 'Reference / Identifier' add one or more columns used to match transactions chips like 'Reference No', 'PO / Agreement Ref', 'Narration / Memo', 'Doc No'. Identifier chips appear showing selected columns. 7. Use 'Add column' in the data preview if you need to create or combine columns optional. New column is added to preview if needed. 8. Close the modal X to save and return to the reconciliation setup. File mapping is applied and used for reconciliation. Troubleshooting 1. Dates show as '2025-01-05T00:00:00' in the data preview. LikelyCause: 'Header row' is set incorrectly or the Date column is not selected. Action: Set 'Header row' to the row that contains your headers e.g., 5 and select the correct 'Document Date' under Date. 2. Totals or signs are incorrect after reconciliation. LikelyCause: Amount column not mapped correctly or file uses separate credit/debit columns. Action: In 'Amount' choose 'Single signed amount column' and select 'Net Movement (USD)', or choose 'Separate credit and debit columns' and map each column accordingly. 3. Transactions that should match are not matching. LikelyCause: Required identifier columns were not added as Reference / Identifier. Action: Add identifiers such as 'Reference No', 'Doc No', 'PO / Agreement Ref' or 'Narration / Memo' in the 'Reference / Identifier' section and re-run reconciliation. Note: Selected Identifier columns show as chips; you can include multiple identifier columns to improve matching.

Last updated on Sep 08, 2026

How do I download, share, copy, or delete a reconciliation report?

Short Answer: Use the top-right buttons: click 'Download report' to download; open the three-dot menu to 'Share', 'Copy reconciliation', 'Delete records', or 'Delete report'. PreRequisites 1. Reconciliation report page open 2. Appropriate permissions to perform report actions Steps 1. Open the reconciliation report e.g., 'X Company recon'. Report header and action buttons are visible. 2. To download the report, click 'Download report' green button, top-right. Report is downloaded to your device. 3. To access other actions, click the three-dot menu to reveal 'Share', 'Copy reconciliation', 'Delete records', 'Delete report'. Dropdown menu with these options appears. 4. Select the desired action from the menu 'Share', 'Copy reconciliation', 'Delete records', 'Delete report'. Selected action executes subject to permissions. Troubleshooting 1. An action download/share/delete is not available or fails. LikelyCause: Insufficient permissions or the report is locked. Action: Confirm your permissions and try again or contact your admin to perform the action. Note: The screens do not show subsequent confirmation dialogs for delete/share; follow on-screen prompts if they appear.

Last updated on Sep 08, 2026

How do I run an intercompany reconciliation after uploading files?

Short Answer: Upload both Entity A and Entity B statement files, confirm column mappings if needed, select the Entity pair and Period, then click 'Run reconciliation'. PreRequisites 1. Be signed in 2. Have Entity A and Entity B statement files ready CSV, XLS, or XLSX 3. Know the month/year Period to reconcile Steps 1. Open the Intercompany reconciliation page and enter or select the 'Entity pair name' and 'Period'. 'Entity pair name' and 'Period' fields are visible. 2. Upload the Entity A file by clicking the 'Upload file' area inside the 'Entity A statement' box and select your CSV/XLS/XLSX file. Entity A file appears inside the statement card filename shown. 3. Upload the Entity B file the same way in the 'Entity B statement' box. Entity B file is attached to its card. 4. Optional: Click the pencil edit icon on each uploaded file to open 'Configure file' and verify Sheet, Header row, Date, Amount and Reference mapping. 'Configure file' modal opens for the selected file. 5. When files are uploaded and mappings confirmed, click 'Run reconciliation' green button top-right. Reconciliation runs and the results page e.g., 'X Company recon' opens. Troubleshooting 1. Clicking 'Run reconciliation' does nothing. LikelyCause: One or both statement files are not uploaded or 'Period' is not selected. Action: Upload both Entity A and Entity B files and select a 'Period', then try 'Run reconciliation' again. 2. File upload fails. LikelyCause: File is not in an accepted format or is corrupted. Action: Save the file as CSV, XLS or XLSX and re-upload. Note: Use '+ Add supporting data' to attach supplementary files and '+ Add report' to include additional reports.

Last updated on Sep 08, 2026

How do I unmatch a partially matched group?

Short Answer: Open the group's 'Partially matched transaction details' modal and click the 'Unmatch' button in the modal header to separate the matched transactions. PreRequisites 1. Reconciliation results open 2. You have permission to edit/unmatch records Steps 1. Open the reconciliation report and go to 'Partially matched' card or tab. Partially matched list is visible. 2. Click the partially matched group to open 'Partially matched transaction details'. Modal with group rows and match basis opens. 3. In the modal header where 'Match basis' is shown, click the 'Unmatch' button red bordered. Transactions in the group are separated back to unmatched and report counts update. Troubleshooting 1. 'Unmatch' button is not visible or is disabled. LikelyCause: You lack required permission or the group is already unmatched. Action: Confirm your user permissions or contact an admin; ensure the group is currently matched before attempting to unmatch. Note: The modal shows the applied 'Match basis' so you can confirm why the group was created before unmatching.

Last updated on Sep 08, 2026

How do I view details for partially matched transactions?

Short Answer: Open the reconciliation results, click 'Partially matched' card or tab, then open a group's details to see the 'Partially matched transaction details' modal with match basis and row-level data. PreRequisites 1. Reconciliation run has completed 2. You are viewing the reconciliation results page Steps 1. Open the reconciliation report for example 'X Company recon'. Results page with summary cards and tabs is visible. 2. Click the 'Partially matched' card or select the 'Partially matched' tab to show partially matched groups. List of partially matched groups is shown. 3. Click one of the partially matched groups or rows to open the 'Partially matched transaction details' modal. Modal displays Entity A and Entity B transactions that were grouped. 4. Review the 'Match basis' area to see which Identifier and Amount fields were used example shows 'Reference ID + Amount' and inspect row-level details. You can see Document Date, Net Movement (USD), Doc No, Reference No and PO / Agreement Ref in the modal table. Troubleshooting 1. A partially matched group contains unexpected transactions. LikelyCause: Identifier selection or amount mapping caused unrelated rows to be grouped e.g., identical Reference values. Action: Open each file's 'Configure file' and adjust Reference / Identifier selections or amount mapping; re-run reconciliation to refresh groups.

Last updated on Sep 08, 2026

What does 'Match basis' mean and where can I see which fields were used to match transactions?

Short Answer: 'Match basis' shows the Identifier and Amount columns used to create a match for example 'Reference ID + Amount' and is shown in the group details modal. PreRequisites 1. Reconciliation results are available Steps 1. Open the reconciliation results page e.g., 'X Company recon'. Summary cards and lists are visible. 2. Open the 'Partially matched' tab or click a partially matched group to open its details. 'Partially matched transaction details' modal opens. 3. Look at the 'Match basis' area near the top of the modal to see chips like 'Reference ID' and 'Amount' and the explanatory text. You can confirm which fields created the match. Troubleshooting 1. Match basis does not reflect the fields you expected. LikelyCause: File column mappings Reference / Identifier or Amount differ from what you intended. Action: Open 'Configure file' for both files, update Identifier and Amount mappings, and re-run reconciliation.

Last updated on Sep 08, 2026

Which file formats are accepted for statement uploads?

Short Answer: The uploader accepts CSV, XLS, and XLSX files for statement uploads. PreRequisites 1. Have the statement file saved as CSV, XLS or XLSX Steps 1. On the reconciliation setup page locate the 'Upload file' drop zone in the statement card. 'Upload file' area shows accepted formats CSV, XLS, XLSX. 2. Click the drop zone and select a CSV, XLS or XLSX file to upload. File uploads and appears in the statement card. Troubleshooting 1. Upload fails or file is rejected. LikelyCause: File is not in CSV/XLS/XLSX format or is corrupted. Action: Convert or re-save the file in CSV, XLS or XLSX format and try again.

Last updated on Sep 08, 2026

Why do I see differences between Entity A and Entity B totals?

Short Answer: 'Differences' come from unmatched or partially matched transactions — review the 'Fully matched', 'Partially matched', and 'Unmatched' cards to find where amounts or counts differ. PreRequisites 1. Reconciliation run completed 2. Results page open Steps 1. Open the reconciliation results page and look at the summary cards: 'Total', 'Fully matched', 'Partially matched', and 'Unmatched'. Cards show amounts and transaction counts per statement. 2. Click 'Partially matched' and 'Unmatched' cards or tabs to view the specific transactions causing the difference. Lists of transactions that are partial or unmatched appear. 3. Open individual groups using the 'Partially matched transaction details' modal to inspect matched rows and the 'Match basis'. You can identify which reference/amount combinations caused the grouping. 4. If needed, adjust file mappings Reference / Identifier or Amount and re-run the reconciliation to see if differences resolve. Adjusted mappings produce updated match results. Troubleshooting 1. Many transactions are partially matched or unmatched, causing a large difference. LikelyCause: Identifier columns missing/wrong or amount mapping not correct e.g., separate credit/debit not handled. Action: Open 'Configure file' for both files, ensure correct Reference / Identifier columns and Amount mapping, then re-run reconciliation. Note: The summary cards provide a quick way to locate where mismatches occur before drilling into row-level details.

Last updated on Sep 08, 2026