This article provides troubleshooting help for potential error messages related to file upload or AI processing. Contact our support team for assistance if you receive an error not covered in this article. For instructions on using the Crunchafi Data Extraction enhanced file upload option, click here.
| Error Message | Notes & User Action |
| Unsupported file type | The COA or Trial Balance file does not have one of the following file extensions: .csv, .xls, or .xlsx. Upload a file with a supported file extension to continue. |
| File too large (max 10 MB) | The COA or Trial Balance file size exceeds the limit of 10MB. Upload a file that is 10M or smaller to continue. |
| Cannot upload N files. Maximum 60 files allowed, currently have X. | The selected Trial Balance files would exceed the 60-file maximum. Consolidate or remove one or more files to continue. NOTE: This only applies to Trial Balance files. |
| File is too small to be a valid document. | The COA or Trial Balance file is smaller than 4 bytes. Confirm you are uploading a valid document to continue. |
The error messages below are only triggered if the uploaded file does not match the format expected for the file extension.
| Error Message | Notes & User Action |
| File content does not match .xls format. |
The uploaded file has the .xls extension, but the contents do not match the Excel 97-2003 data structure. This could be a matter of an. xlxs or .csv file having been renamed or saved with the .xls extension. To re-upload the file, try re-exporting the file from your accounting system or open the file in Excel to see if it detects the format and save it with correct extension. |
| File content does not match. xlxs format. |
The uploaded file has the. xlxs extension, but the contents do not match the ZIP/Office Open XML archive data structure. This could be that the file is of a different type (e.g., .csv, .xls, or html) or was corrupted mid-export. To re-upload the file, try re-exporting the file from your accounting system or open the file in Excel to see if it detects the format and save it with the correct extension. |
| File content appears to be a binary document, not CSV. |
The uploaded file has the .csv extension, but the contents follow the data format of a standard Excel file (.xls). The file was most likely mislabeled. To re-upload the file, either rename it to .xls to keep it as an Excel file or open it in Excel and go to File > Save As > CSV if you prefer to upload a CSV file. |
When .xlsx files are uploaded, the system checks them for a safe subset of Excel formulas. Any formula outside of this subset triggers an error message. Check the table below for specific errors.
In most cases, files exported from accounting systems have cached values and are not impacted by these validations. These errors most commonly appear with files that were manually edited in Excel before upload in the Data Extraction portal.
Unless otherwise noted below, the error can be fixed by opening the Excel file, selecting and copying all impacted cells, pasting them as Values Only (i.e., remove formulas), saving the file, and re-uploading it.
| Error Message | Cause/Trigger |
| This file contains N formula(s) that cannot be evaluated. For example: {sample}. To fix this: open the file in your spreadsheet application, select all cells, copy, then paste as Values Only (removing formulas), save, and re-upload. | This error message is triggered when any unsupported formula is present with no cached values. |
| Cell {ref}: VLOOKUP (lookup formula) | Cell uses VLOOKUP, HLOOKUP, or XLOOKUP. |
| Cell {ref}: _XLL.GL (add-in formula) | Cell uses an Excel add-in function (e.g., Dynamics 365 GL functions). |
| Cell {ref}: EOMONTH (date formula) | Cell uses a date function such as EOMONTH, TODAY, NOW, or EDATE. |
| Cell {ref}: IF (conditional formula) | Cell uses IF, IFS, SWITCH, IFERROR, IFNA, SUMIFS, COUNTIFS, or AVERAGEIFS. |
| Cell {ref}: SUBTOTAL (subtotal formula) | Cell uses SUBTOTAL. |
| Cell {ref}: circular reference detected | Cell formula depends on its own value directly or indirectly. |
| Cell {ref}: whole-column range references (e.g., A:A) in SUM are not supported - save the file with values and re-upload. |
SUM formula contains a whole-column range reference. NOTE: This error can also be fixed by narrowing the range to only show the actual data if the formula needs to remain. |
These checks apply to COA uploads only and run after the file has been converted to CSV.
| Error Message | Notes & User Action |
| File is empty or could not be read. | File contains no content. Confirm the correct file was selected and try again. |
| Failed to parse file: {details} | CSV parsing threw an exception. Review the exception message for guidance. |
| File contains no data rows. | File parsed successfully but no data rows were found. Confirm the correct file was selected and try again. |
| File has only N data rows. A Chart of Accounts should have at least 5 accounts. | Fewer than 5 data rows were detected. Confirm the full file was exported from the accounting system and try again. |
| File has only N column(s). A Chart of Accounts needs at least 2 columns (account ID and name). | Fewer than 2 columns were detected. Confirm the full file was exported from the accounting system and try again. |
| Could not detect an account identifier column. Expected a column with account numbers or codes (e.g., '1000', 'A-100', '4.1.001'). | No column matching account number patters could be identified. Check the file for an account ID and try again. |
If you receive any of the following warning messages, you can still proceed with your upload (if applicable):
N of total rows (%) are empty. This may indicate a formatting issue.
This file may be a Trial Balance rather than a Chart of Accounts. Found columns that look like amounts {list}. If this is intentional, you can proceed.
NOTE: If you do not have access to a COA, review our guide, Using a Trial Balance Instead of a Chart of Accounts.
When users submit files for processing, the system can trigger three types of errors: 1) AI ran into data validation issues that can be recovered by the user, 2) AI ran into a backend workflow issue that is not recoverable by the user, or 3) the system ran into a data ingestion issue that requires the user to re-upload files.
If processing completes and AI detects validation issues, the user is shown expandable issue groups with details and options to download the full error report and re-upload files once fixed. See below for more context.
| Issue Category & Detail Message | User Action |
|
Balance {Month Year} monthly totals don’t balance to zero. Check for missing or incorrect entries in your source file. |
Correct the trial balance for the named month and re-upload. |
|
Missing Data {Month Year} is missing from the trial balance. Add the missing month(s) and re-upload. |
Add the missing period to the trial balance and re-upload. |
|
Duplicate Data (Message passed through from system) |
Review the downloadable error report for specifics. |
|
Other categories (Message passed through from system as-is) |
Review the downloadable error report for specifics. |
Receiving a Something Went Wrong error message with the details below means that the issue cannot be resolved by retrying the processing or re-uploading the file. Contact our support team for assistance. This may be the case, for example, if there has been no progress on processing for more than 1 hour.
We're sorry - the AI ran into a problem it couldn't recover from. Unfortunately, there is no workaround for this issue. Please contact Crunchafi Support and provide the reference number below.
Receiving a Processing Failed error message indicates that the files need to be re-uploaded. Clicking the Re-upload files button redirects you to the Chart of Accounts upload step. Below are the possible error codes and their descriptions.
| Error Code | Detail Message |
| TypeConversionFailure | Unable to parse data format in uploaded file. |
| ValidationFailure | Data validation failed. |
| MissingRequiredField | Required data is missing from uploaded file. |
| MappingColumnNameNotFoundInSourceFile | A required column was not found in the uploaded file. |
| (any other code) | Data processing error: {code} |
| (no error code present) | Data processing encountered an error. |
