Merchant Services Invoices with fees 'netted' off

SOLVED

We use Worldpay for our online merchant services. They used to send us money from customer payments and then invoice for their fees separately which was easy. Now they 'net off' their fees from the payments.

So when using Bank Feeds I can match the incoming payments to customer invoices but how do I then match to the Worldpay invoices which are not pulling through in the Bank feeds screen?

Thanks

James

Parents
  • 0
    SUGGESTED

    Personally, I wouldn't want to raise a batch invoice in my customer account as it would cause confusion and query with the customer.

    We have a similar issue with Paypal.  When funds come in, we post the actual net amount as a bank transfer to the main bank account, then post a sales receipt for the full value that the customer paid, then a bank payment for the fees, all using the same "Ref" as the net £ amount received. These 3 transaction net to zero in the control account.

    In one client situation there are only a few transactions a month so it's not too onerous, but another client has multiple payments a day so we now download reports showing actual receipts, fees and transfers and import that into Sage through 3rd party add ons.

Reply
  • 0
    SUGGESTED

    Personally, I wouldn't want to raise a batch invoice in my customer account as it would cause confusion and query with the customer.

    We have a similar issue with Paypal.  When funds come in, we post the actual net amount as a bank transfer to the main bank account, then post a sales receipt for the full value that the customer paid, then a bank payment for the fees, all using the same "Ref" as the net £ amount received. These 3 transaction net to zero in the control account.

    In one client situation there are only a few transactions a month so it's not too onerous, but another client has multiple payments a day so we now download reports showing actual receipts, fees and transfers and import that into Sage through 3rd party add ons.

Children
No Data