Resolving reconciliation source file linking and unlinking issues

Last updated: May 7, 2026

When working with reconciliation source files, you may encounter various errors during the linking or unlinking process. This article covers the most common issues and their solutions.

Error: "No matching account codes were found in this sheet"

This error typically occurs due to formatting issues in your spreadsheet.

Resolution Steps:

  1. Remove the first two columns from your spreadsheet (you can keep them for reference, but removal may be required for successful linking)

  2. Ensure your date format is exactly MM/DD/YYYY - other formats like DD/MM/YYYY are not supported

  3. You can include additional reference columns (such as account names or descriptions) alongside the required Account and Date columns

  4. For multi-entity reconciliation: Ensure your Entity column contains the numeric entity ID (external ID from your ERP system), not the entity name. You can find entity IDs in the Entities tab on the GL Settings page and export that table to Excel. You may keep a separate column with entity names for reference, but the Entity column used for reconciliation must contain the numeric ID.

  5. If the system continues to show “Multiple entities” even after selecting a specific entity in the upload interface, remove the Entity column entirely from your spreadsheet for single‑entity reconciliations.

  6. Verify your account codes are formatted correctly:

    • Account codes must exactly match your GL account numbers character-for-character

    • Avoid decimal formatting: 1505 ≠ 1505.00

    • Remove any spaces before or after account codes

    • Remove any text prefixes added to account codes

Tab name mismatch errors

When you rename sheet tabs after initially linking a Google Sheet, the system continues looking for the original tab name, causing linking errors.

Resolution Steps:

  1. Navigate to Reconcile tab > Manage Sources (the folder icon in the top right corner)

  2. Locate the linked spreadsheet in the sources list

  3. Select the spreadsheet and click Remove/Unlink

  4. Relink the file and carefully select the current correct tab name during the linking process

Important: Simply updating the tab name in your spreadsheet will not resolve the error. You must complete the full remove and relink process.

Duplicate account mapping errors

This error occurs when the same account code appears in multiple linked source files for the same period (not from duplicates within a single sheet). The system cannot determine which source file to use for that account.

Resolution Steps:

  1. Navigate to Managed Sources (folder icon in top right corner) to identify where duplicate mappings are occurring

  2. Review all linked workbooks to locate accounts that appear in multiple sources for the same period

  3. Remove or consolidate duplicate account mappings to ensure each account has only one source

Chart of Accounts (COA) update edge case

In some cases, duplicate account errors can occur after a recent COA update in your ERP system. This happens when the system picks up multiple external IDs for the same GL account codes, creating ambiguous mappings that cannot be resolved by removing duplicate sources.

Resolution: Contact support for assistance, as this requires system-level intervention to resolve the conflicting external IDs.

Source linking limitations

One-to-one constraint

Each unique source file can only be linked once per period. Attempting to link the same file to multiple reconciliations will result in errors.

Resolution options:

  • Consolidate approach: Combine multiple reconciliation tabs into one summary tab within the same source file

  • Separate files approach: Create individual files for different account reconciliations and upload them separately

Roll-forward option limitation

Roll-forward settings cannot be modified after initial linking. Files linked as single-period sources cannot be converted to roll-forward sources.

Resolution options:

  • Disconnect and re-link: Completely disconnect the original source, then re-link the same file with roll-forward enabled

  • Create a copy: Make a copy of the file with a different name and link the new file with the 'Roll Forward' option checked

Best Practice: Always consider whether you need the roll-forward option enabled before initially linking reconciliation files, as this decision cannot be reversed without disconnecting the source or creating a new file.

Key limitations to remember

  • Only MM/DD/YYYY date format is supported

  • Each source file can only be linked once per period

  • Roll-forward settings are permanent after initial linking

  • The system stores references to original tab names and doesn't detect renaming