Troubleshooting reconciliation source file linking and connection errors

Last updated: June 2, 2026

When linking or reconnecting reconciliation source files, you may encounter various errors or connection issues. This article covers common problems and their solutions to help you successfully set up and maintain your reconciliation sources.

Spreadsheet Structure Requirements

Before linking spreadsheet files as reconciliation sources, ensure your file meets these structural requirements:

Column Positioning

The Account column must be positioned in column A of your spreadsheet. Incorrect column positioning can result of 500 errors when attempting to connect the reconciliation source.

Account Code Matching

If you receive the error "No matching account codes were found in this sheet", you can use the account's external ID from your ERP system instead of the account code. Format the external ID in the account column as ext[xxxx] (lowercase 'ext' with brackets around the external ID number).

For example, if the external ID in your ERP system (e.g., NetSuite) is 1225, enter ext[1225] in the account column. This allows Numeric to map the reconciliation to the correct account.

Multi-Entity Setup

If you're using a multi-entity configuration, you must reference the Internal ID of the entity rather than the entity name. To find the Internal ID:

  1. Navigate to Settings > Integrations > General Ledger

  2. Go to the Entity tab

  3. Look for the ID field (typically single or double digit numbers)

Common symptom: If you're working with a single-entity reconciliation but have included an entity column in your source file, the connection may show as successful but fail to save or display properly. In this case, remove the entity column entirely from your spreadsheet since it's not needed for single-entity reconciliations.

Folder Sync Issues

Missing Numeric Lead Sheet

If your folder sync gets stuck for extended periods (45+ minutes), it may be due to files missing properly labeled Numeric tabs:

  • A single file without the correct Numeric lead sheet can prevent the entire folder from syncing

  • All files in a synced folder must have proper Numeric lead sheets for successful folder-level syncing

Resolution:

  • Ensure all files in the folder have appropriately labeled Numeric tabs

  • Remove any problematic files that don't meet this requirement

  • If the sync remains stuck, disconnect and reconnect the entire folder

Duplicate Account Handling

Account Code Duplication Rules

The system enforces specific rules for account code duplication depending on your reconciliation source type:

  • Single-entity leadsheets: Each account code can only appear once on a leadsheet linked to a specified entity

  • Multiple entry reconciliation sources: An account code can appear once per entity combination

If an account code appears more than once in violation of these rules, you will receive an error indicating the account code repeats.

Resolution:

  • Check for and remove duplicate reconciliation sources in the Manage Sources view before attempting to add or reconnect a source

  • Remove duplicate accounts from secondary workbooks

  • Remove unused workbooks that contain duplicate accounts

File Relinking Limitations

The system has specific limitations when reuploading previously uploaded spreadsheet source files:

  • Files can only be reuploaded if both the initial upload and re-upload occur within the same period

  • This particularly affects rollforward files that were previously disconnected and then attempted to be reuploaded in a different period

Workarounds for Relinking Issues

If you encounter issues relinking a spreadsheet source file that was previously disconnected in a prior period, try these solutions:

  1. Upload with a different name: Create a duplicate of your file and upload it with a different filename

  2. Contact support: Reach out to support to have engineering delete the previous file record from the backend, which will allow relinking of the original file

General Troubleshooting Tips

  • Verify that your spreadsheet file format is supported

  • Check that all required data fields are populated

  • Ensure file permissions allow the system to access the document

  • If connection appears successful but balance information doesn't display or save, check for: duplicate reconciliation sources in Manage Sources, incorrect Account column positioning, entity ID reference issues, or unnecessary entity columns in single-entity reconciliations

If you continue to experience issues after following these troubleshooting steps, contact support for additional assistance.