duplicate items in register and reconciliation
- August 30, 2021
- 1 reply
- 0 views
I am trying to do my first bank reconciliation for this specific account. As I've been entering transactions (expenses, bill payments, credit card payments, etc.) I've been trying to match them to downloaded transactions (I say trying because often, there appear to be duplicated transactions. I'll match to one of the two that appear, and usually the second will disappear after matching with the other but not always).
When I go to reconcile the account though, some of those transactions still appear twice. I'd love to link the transactions I know are duplicates, but there doesn't seem to be a way to do that, and I can't usually tell which of the two to delete or which to initially exclude from the banking screen.
I determined that some of the problems were rules that automatically "added" items that were also being manually added as expenses and then couldn't be matched, but that doesn't explain the rest. I'd almost guess that if I match to the wrong one of the two transactions, the duplication in the reconciliation screen occurs. Attached is a screen shot of the banking screen. There are 3 items there duplicated (the amex payment, and two different payments to AIC Longwood). I am also including a reconciliation screenshot that shows a duplication after matching on the banking screen.