Hi Mazzii1,
Thank you so much for your post and welcome to the Community Forum! I am sorry to hear that you were having problems in importing your sales. I really appreciate your patience and understanding about this issue and thanks for the information. When importing into AccountRight Live, a Tab Delimited or Comma Separated CSV file, that has been saved from Microsoft Excel, can cause the import to skip the records, with the message: Error -25: Invalid amount.
To fix this, The quotation marks need to be removed before importing again. There are multiple ways to achieve this, ideally just change the column format in Microsoft Excel, and save the file and import again. Identify the column causing the issue, then in Excel select the entire column, then right click the column header, and select Format Cells.
You can also visit this post for more information: Importing sales error -25.
Please do let me know how you go on this.
Regards
Earl
Hi Earl_HD ,
Thank you and I have read through your previous suggestions and tried to apply your solution, even though I cannot see any quotation marks on the text file or the text file logs. But it still hasn't helped.
I'm exporting time billing sales, reconfiguring the csv to look like an Item Bill, saving as a text file and importing from there. I had one successful file but coulnd't do it again after that. I'm not sure why and I'm not understanding the issue from the import error log.
Thank you again.
Regards,
Mazzii
