Skip to main content
B
Bernt
March 18, 2021
Question

Worldpay batch reconciling

  • March 18, 2021
  • 2 replies
  • 0 views

We receive lots of orders and payment is arranged by Worldpay.

On our bank statement worldpay list a batch of payments made on that day. To reconcile these with quickbooks we have to print out the worldpay statement and find each payment in Quickbooks, is there a faster way, plugins etc?

2 replies

E
EmmaM
March 18, 2021

Hello Bernt, you may be able to link a third party app to pull through the sales  here is a link to the  page you can search for a category of app or a specific one. We welcome other  Community users who have used an app they can recommend for that to comment on this thread.

R
regor99
August 1, 2021

Hi I have the same problem 
We took the WP statement and using the invoice date and the amount made a unique excel concatenated reference. 
We did the same with our orders and used this to Vlookup the our invoice so we now had an exact match between our invoices and the worldpay statement on a spreadsheet. 
With the bank statement we now still have to match the daily WP payments but it’s very quick. 
Then using Saasant transactions an app for QBO, we then upload all the matched payments in one go. The app receives as well as matches. 

if that sounds too much
You could make a bank feed from the WP statement, import into QBO and allow it to help you match your orders within QBO. 


Hope either suggestion helps

 

Terms & ConditionsAccessibility statement