Hi I have been tasked with fixing mistakes made on Sage 50.  1 of the tasks is correcting the tax code on a number of transactions (1250 approx transactions) The person inputting wages payments had been inputting the BP's using the T0 tax code, i need to change them all to T9 so that we have the correct figures for RTD.  I tried exporting the audit trail report, the normal report shows the transactions fine but when i run the report in excel in order to change the tax code and import back into sage the net amounts are showing negative amounts which cannot be imported.  Is there any way around this as to change each transaction manually is going to take an age.

Any advice would be welcome