Bank Reconciliation: Automatically recognise and remove duplicate statement lines
Imported bank statements - propose for Xero to spot "duplicate" transactions as to remedy this situation I had to process a large number of lines one by one across a number of different accounts
-
Nickalaus Goodman commented
So your system is not smart enough to tell Lowes # 00495 $21.35 07/10/2023 is a duplicate of Lowes # 00495 Sale $21.35 07/10/2023 ? That seems very odd, as most computers software an see the same date, same amount and the Transactions have similar enough names to identify it as a duplicate. Intuit does a great job at this, so does EXCEL. It would see that Sale is in every row and exclude it form the Match Criteria. If your software is this poor then I would tell people up front to not import known duplicates. That would be same as it not recognizing the duplicate if it had an extra space at the end of the text. You should add a more defining text around how the system identifies duplicates because it really does not identify duplicates. It locates EXACT matches which is different
-
Svitlana Blyzniuk commented
Purpose:
Remove duplicated transactions fetched from my bank and a paid invoice or Link my books.Problem:
For expenses: every time I receive and invoice in Xero and pay it with my bank card, that is integrated to Xero account, I get transaction duplicated. For income: the same happens if Amazon pays to my bank card and Link My Books sends detailed brake down of this transaction to Xero.
Then while reconciling such transactions the amount is duplicated, if I match the records and I should create Reconciliation adjustment, which if quite annoying.Solution:
If it's possible, please add the ability to match transactions fetched from bank and Link my books or transaction fetched from bank and invoice paid in the system into one record.