This file cannot be imported until the account numbers are corrected" Sage 50 message
The import stopped because one or more account numbers in the file are invalid, duplicated, or in the wrong format.
The message “This file cannot be imported until the account numbers are corrected” means the import process checked your chart of accounts and found a problem it will not work around. It is not a crash and not data loss. The software is refusing to continue until every account number in the incoming file is one it can accept.
What the message actually means
An import does not just move data; it validates it first. Before a single transaction is brought in, the software walks the account list in the file and checks each number against its own rules. If any number fails, the whole import halts. The message names account numbers because that is the first thing the check caught, not necessarily the only issue.
Why the numbers get rejected
The usual causes are straightforward. A number may be duplicated, so two accounts claim the same identifier. A number may be blank on an account that requires one. A number may contain characters the destination does not allow, or it may be longer than the destination’s limit. It can also happen when the source file uses a different account-numbering scheme than the company receiving the data expects, which is common when moving between accounting systems or editions.
Check the account list yourself first
Open the file in its source program and review the chart of accounts. Look for duplicates, blanks, and any account number with unusual characters. Fixing those and re-exporting the file resolves this message in many cases. If the file came from another system entirely, the numbering scheme may simply be incompatible, and no amount of small edits will make the import accept it as-is.
When the file itself is the problem
Sometimes the account numbers look fine on screen but the import still fails. That points to damage or inconsistency inside the data rather than in what you can see. In that situation, editing the visible list will not help, and repeated import attempts will not either. The file needs to be examined and repaired at the data level before anything can be imported from it.
If the goal is a conversion
This message often appears when someone is moving Sage 50 data into QuickBooks. The account-numbering rules differ between the two products, and a direct import frequently trips on exactly this kind of mismatch. A structured conversion handles the renumbering and mapping for you. See our Sage 50 to QuickBooks conversion service if that is your situation, or our Sage 50 Canada conversion service for Simply Accounting files.
What to do next
Start by ruling out the simple causes: duplicates, blanks, and stray characters in the account numbers. If the list is clean and the message persists, the file likely needs professional attention. We can examine it and tell you what is wrong before you commit to anything: send it to us for a free evaluation and quote.