What is the easiest way to deal with invoices paid via credit card via Worldpay in UK? I have the WP deposits in my Banking but each covers several client invoices.

Hi baron2,

Thanks for joining us here on the Community 👋

The simplest solution for this would be to select 'find match' on the deposit in the bank for-review screen and select the multiple invoices which apply to this on the following screen. 

As the banking feature searches for dates and amounts, it may be unable to find all of the invoices which relate to this. 

In this instance, you can either exclude the payment in the bank and then record the payments individually on each invoice, or, you can follow the steps below which will allow you to match all invoices to the one deposit. To do this:

1) Open up one of the client invoices and select 'Recieve payment'

2) On the following screen, select the 'Deposit to' account as the 'Undeposited funds' account (this is a default account in QuickBooks used for holding funds)

3) Ensure the invoice is ticked under 'Outstanding transactions' then save & close

4) Once you have repeated this for each invoice, create a bank deposit by going t, + New > Bank deposit

5) On the bank deposit, select the bank account and date that this was received, and select all of the payments which apply showing under 'Select the payments included in this deposit'

6) Save & match to the transaction in the bank feed

Get back to us below if you have any Q's!

Nope. Struggling with this. Anything but 'Quick', though appreciate trying to swap over 18 months worth of sales and payments to QB hardly helps! Maybe a precis of where I am starting from will help.

• All my sales invoices are raised via a CMS system called Lightblue. I have no desire to change this as I can quickly see where I am in terms of sales relative to targets and previous years. I can export these for QB and have done so for the first 6 months to give me something to work with.
• Purchase cannot be pulled out of LB and imported. I have been trying to clear down the worst using bank reconciliation but while this can be tied to a supplier it is not linked to any invoices. Tomorrows problem though
• Clients pay mostly by card via Worldpay card machine. Some pay by Cash. Some a mix of cash and card!
• Payment by card come into bank that is linked to QB. These payments into bank may cover several client invoices

I have tried your initial suggestion of linking via bank statement. First one went fine but very next one The related invoices did not match the card payments because one client had paid part in cash! something I can only confirm by checking back to the original invoice in LightBlue.

Bearing in mind I am not desperately worried about reconciling the bank statement. At least not for last year can I not simply accept payment straight to my bank rather than undeposited fund?. If I do this should I exclude all the Worldpay payments to my bank or is the bank effectively separate so does not effect the main accounts?

Also what do I do with the cash payments?  While booked in on the invoices of course they rarely make it to the physical bank. Either used for cash purchases or effectively my drawings as self employed. 

If I do try to do things by the book as item 5 of your list am I able to not select the cash part. Also how does all this get reconciled on the bank tab?

Good Morning, @baron2. 

Thanks for reaching back out to the Community and clarifying. Since you've tried the steps that my colleague provided and they didn't work, then I recommend contacting our Customer Support Team. They'll be able see the information by doing a screen share and walking you through a few instructions on how to resolve this issue. Here's how: 

1. Go to the Help icon. 
2. Select the Contact Us button. 
3. Give a brief description of the problem and press Let's Talk. 
4. Scroll down and choose to Get a Call. 

It's that easy. 

If you run into any trouble, just let me know. I want to make sure you're able to get back to running your business as soon as possible. Take care!