Importing sales error -25
Hi Camelkathy
Thank you for providing the sample import file, it's very helpful.
I'm glad to see our very knowledgeable experts gavin12345 and Mike_James has offered to help, they've offered very valid points:
- v20xx use different import format compare to v19.x. An import file for v20xx should start with {} in the first line, which looks like this:
- The column with header 'Inc-Tax Amount' is expecting tax inclusive amount, not the tax codes. Tax codes should be entered in a different column.
- In the 'Amount' column the software is expect numeric value, please replace - with 0.00 instead.
The Invalid Amount error can also refer to the software is finding the numbers in the transaction doesn't add up, e.g. the Tax-exclusive amount + tax amount doesn't equal to the Inc-Tax amount. AccountRight v20xx does more checks during import than v19.x to prevent unbalanced transactions to be imported.
I'd suggest recording one of the transactions in AccountRight manually, then export it with all available fields ticked. Open the export file in Excel to view the format and how data are presented, then use it as a template. For more details please follow this Help page: Using an import template.
