I am unable to reconcile any transactions where I receive money (from this instance from Worldpay but it could be any merchant service/payment gateway type provider - Shopify, AMEX etc.).
The problem I'm having is that if there's an amount hitting my bank which is made up of 3 payments it's fine. If it's a negative amount and contains refunds then that's usually fine. But when there's money coming into my bank account, but the total contains a refund there's no way of matching. The example below showing the transactions that make up a £715.45 payment into my account:
416.50 GBP
161.50 GBP
-102.00 GBP
128.95 GBP
110.50 GBP
Total: £715.45
The positive value transactions are all there, but the £102 refund is nowhere to be seen.
Things I've tried:
- Refund Receipt (this is what you should be able to do as that's what you're doing, refunding a sales receipt).
- I've tried rather than refund receipt creating a credit note. Then add an expense against the customer as a debtor. After doing this the expense appears on the Match Transactions list. However if you check the box it adds as if it is taking a payment, not refunding. So in my instance, it's a refund for £102 that makes up part of a payment from Worldpay. When I add in the £102 expense in the match list, rather than reducing the difference from £102 to £0, it becomes £204.
- If I then create a payment received the way you'd normally do when clearing a refund the transaction then disappears from the match list and back to square one.
There's got to be a solution to this. It's impossible to reconcile without. This is not an uncommon thing.
