Hi Carlo,

The messages ‘Net Amount: invalid data for transaction Net Amount field’ and ‘Tax amount: invalid data for Transaction tax amount field’ appear when the information in the specified field is not correct. For example, if a letter appears in a numeric field.

It can also appear if a line break has been entered in Excel.

To resolve this edit the import file to correct the specified field.

For information about how to replace any hidden line breaks, please refer to the section ‘Hidden line breaks’ in Ask Sage article 16869.

This error commonly occurs when 0 is entered in the exchange rate field. For base currency transactions, you must enter 1 for the exchange rate.

The message ‘Tax Code: Illegal tax code’ occurs when the tax code hasn’t been entered in the correct format, or the tax code you have entered doesn’t already exist in your Sage Accounts data. A tax code should be entered with a T prefix, e.g. T0, T1, T2, etc.

You can check which tax codes already exist in your data in Settings > Configuration > Tax Codes.

Full info on how to import data in Sage Accounts here.