Banking | Manual import - Option to reverse Credits and Debits columns
A common problem importing bank files is the reversal of Debits and Credits. This is especially common with Credit Cards.
The "fix" that Xero recommend is to modify the file with a spreadsheet editor. This is only possible with CSV files and is error prone.
A setting to reverse credits and debits when importing bank files would be immensely useful when your credit card provider statement has it's debits and credits reversed.
Or maybe allow a bank to be treated as a Liability?
Robert Taylor
shared this idea
-
DIANA MADERO
commented
Some statements import them wrongfully and there's no way to adjust it other than to delete and enter them manually. This takes longer when it could be easy to just add the option to select deposit/withdrawal option on the transaction. Even if it gets imported wrongfully, we'll be able to adjust it with this option much faster and easier.
-
Doug Talbott
commented
This is exactly what I have been asking for. It should be a simple fix. Please implement ASAP.
-
Benedict Addis
commented
When Importing a bank statement in CSV format, it would be helpful to be able to flip the sign of the transactions so that credit card statements (like Amex) could also be imported. This would be a simple tick box!