Could you please help to fix it? Thanks.
Normally the bank will provide the CSV file with a single column for the amount, where it indicates the ‘Money Out’ transactions as negative balance (by inserting the ‘Minus’ symbol in front) and ‘Money In’ transactions will show as positive amount, (with no ‘Plus’ symbol in front).
When you upload the CSV file you will need to map this amount column to the ‘Amount’ header. Therefore, when you import it further, Reckon One will automatically, import them correctly and allocate it as payment or receipt, accordingly.
i.e All the negative amount will import as ‘Money out’ transactions and you will be able to allocate it as allocate payment transactions
All the positive amount will import as ‘Money in’ transactions, therefore allowing you to record it as ‘Allocate receipt’.
Further, as you wish to delete the incorrect import, could you please follow through this instruction on how to delete all the incorrect upload transactions in bulk, and try uploading it again with the correct mapping as explained above.
Hope this helps.
Please let me know how it goes.
Just out of curiosity, you mentioned that in your CSV file, you have Dr and Cr amount, was it from Paypal feed by any chance? Cause, I know that PayPal exports have that such fields on their export.
On my test, for ANZ bank, they had a single column for the amount with positive and negative amounts in it, and Reckon One will automatically recognise -ve amount as Money Out type of transactions.