cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
Yousaf
Level 1

How to mark payment of multiple invoices in single payment? Is there any way to import multiple invoices detail from excel sheet to QB to mark multiple invoices?

How to mark payment of multiple invoices in single payment? Is there any way to import multiple invoices detail from excel sheet to QB so that the multiple invoices can be marked at once? It is a hassle to manually mark hundereds of invoices by ticking every invoice individually.
3 Comments 3
Rose-A
Moderator

How to mark payment of multiple invoices in single payment? Is there any way to import multiple invoices detail from excel sheet to QB to mark multiple invoices?

I can help you import and pay multiple invoices in QuickBooks Online, Yousaf.

 

You can use the Import data feature to bring in multiple invoice details into QuickBooks Online and mark them as paid.

c.PNGv.PNG
Before importing, it is important to turn on the custom transaction numbers option, otherwise, your transaction numbers will be replaced by standard QuickBooks invoice numbers.

 

Here's how:

  1. Click the Gear icon ⚙ at the upper right corner and choose Account and Settings.
  2. Go to the Sales and select Sales form content section.
  3. Enable Custom transaction numbers.
  4. Select Save and hit Done.

Once turned on, you can start importing your invoice details by following the outlined steps in this article: Import multiple invoices at once. This will provide you the step-by-step process in importing your transactions into QuickBooks. After that, you can visit this article: Record invoice payments in QuickBooks Online. It contains information on how to pay your invoices.

 

You can always get back to me if you have any other invoice concerns. I'll be more than willing to lend you a hand. Have a good one.

Yousaf
Level 1

How to mark payment of multiple invoices in single payment? Is there any way to import multiple invoices detail from excel sheet to QB to mark multiple invoices?

Hello Rose,
Thanks for the reply, but this procedure does not work as it shows the payment of every invoice individually in the QB bank statement. I want to mark payment of multiple invoices in a single payment, like the payment of 100 invoices worth $1000/- in total and $10/- each, in a single payment entry from the 'Receive Payment' section. If I follow the procedure that you have provided there would be 100 individual entries showing up in the bank statement because of which I would not be able to reconcile the bank statement. 
Picture 1 shows what is needed.
Picture 2 shows what is happening by following your provided procedure.

Catherine_B
QuickBooks Team

How to mark payment of multiple invoices in single payment? Is there any way to import multiple invoices detail from excel sheet to QB to mark multiple invoices?

Hi Yousaf, 

 

Have you imported your invoices already? If so, you can use the Receive Payment option to make a lump sum payment for each customer. Let me show you how: 

 

  1. Go to the +New button and click Receive Payment
  2. Select the first customer and enter the payment details.
  3. Under the Deposit to field, select the bank to where you'll want to post the funds.
  4. Select all customer invoices included in the payment.
  5. Click Save and close.

However, if you want to deposit all payments at once from different customers, you'll want to do the steps above on how to receive the payment. Instead of the bank account, make sure that the Undeposited Funds account is selected under the Deposit to. Then, create a Bank deposit. For more details, feel free to check this article: Record and make bank deposits in QuickBooks Online.

 

You'll want to run reports that will give you an overview of the payments you created:

 

Keep me posted if there's anything else that you need help with. The Community Team is always available.