Steven_ZA
Level 3

How to recon bank statement amount with payment when it includes a refund

We get deposits from our payment processor which sometimes includes refunds and so is less than the full payment amount.

 

ie. there was a payment of R200 but also a refund of R50 on the same day. We then only get a deposit of R150.

 

The R200 is created as a payment and linked to an invoice. The R50 refund is created as an expense (because there is no invoice or goods attached, and so can't be a refund receipt).

 

The problem: how do I link the bank statement line of R150 with the payment (R200) and expense (-R50)? Note: it's important that the expense can be created outside of the bank recon as a separate action (since it will be automated via the API), and so we don't want to use the "Resolve" option on the bank recon to create the expense there - we need a way of linking already created documents.

 

I appreciate any help. Thanks.