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

    I'm answering my own enquiry here! Here's what I did:

    1. Using Auto Entry I had already uploaded all the Worldpay invoices for the fees being debited. I hadn't used the 'mark as paid' function against Worldpay within Auto Entry at this point.

    2. Using the Worldpay Dashboard I was able to view the invoices and so I then made manual 'supplier payments' against each Worldpay invoice - this brought them through into the Bank Feeds Sage Transaction window.

    3. I then allocated both the customer payments and worldpay invoices to the corresponding bank credit and all reconciled perfectly.

    This was however very time consuming and our transaction volumes are tiny.

    I have since turned on the 'mark as paid' function against Worldpay within Auto Entry - I think this will bring through the Worldpay Invoices into the Bank Feeds Sage Transaction window automatically and so this should make slightly quicker.

    Ultimately the answer is to switch the merchant service away from Worldpay and use 'Wonderful Payments' instead - much quicker, easier and cheaper going forward!

    Thanks to all for your replies.

Reply
  • 0

    I'm answering my own enquiry here! Here's what I did:

    1. Using Auto Entry I had already uploaded all the Worldpay invoices for the fees being debited. I hadn't used the 'mark as paid' function against Worldpay within Auto Entry at this point.

    2. Using the Worldpay Dashboard I was able to view the invoices and so I then made manual 'supplier payments' against each Worldpay invoice - this brought them through into the Bank Feeds Sage Transaction window.

    3. I then allocated both the customer payments and worldpay invoices to the corresponding bank credit and all reconciled perfectly.

    This was however very time consuming and our transaction volumes are tiny.

    I have since turned on the 'mark as paid' function against Worldpay within Auto Entry - I think this will bring through the Worldpay Invoices into the Bank Feeds Sage Transaction window automatically and so this should make slightly quicker.

    Ultimately the answer is to switch the merchant service away from Worldpay and use 'Wonderful Payments' instead - much quicker, easier and cheaper going forward!

    Thanks to all for your replies.

Children
No Data