cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
Ade23
Level 1

Multiple payments for one invoice

When I process wages (50 employees) I process one invoice for the total amount, but have 50 payments to reconcile to the one invoice. How to a select and merge multiple payments to pay off this one invoice 

Solved
Best answer June 06, 2019

Accepted Solutions
JamesC
QuickBooks Team

Multiple payments for one invoice

Hey Ade23,

 

You can bulk-tick and select the transactions, and then "Exclude Selected" - As you're matching too them, rather than adding them outright; they are already recorded in your books on the invoice..

You can exclude what's in the banking section and rely wholly on QB.

 

Personally, i'd create 50 different receive payments against your one invoice, and then match to each of the individual receive payments, but this is not time-effective,

 

Eexcluding them won't prevent you from reconciling, you just won't automatically tick them on your reconcile, you'll need to tick the single payment against the invoice - as long as the payment against the invoice totals the same as the 50 payments.

 

Does that help at all?

View solution in original post

6 REPLIES 6
TaliaI
QuickBooks Team

Multiple payments for one invoice


Hello Ade23,

 

Do you have your bank connected?

 

Thanks,

 

Talia

Ade23
Level 1

Multiple payments for one invoice

yes, so i can see i long list of payments waiting to be matched, but i have to go into each payment at present and match against the one invoice (30 times) 

TaliaI
QuickBooks Team

Multiple payments for one invoice

Were these payments all made on the same day, or different days?

 

Thanks,

 

Talia

Ade23
Level 1

Multiple payments for one invoice

all on the same day

Ade23
Level 1

Multiple payments for one invoice

Yes

JamesC
QuickBooks Team

Multiple payments for one invoice

Hey Ade23,

 

You can bulk-tick and select the transactions, and then "Exclude Selected" - As you're matching too them, rather than adding them outright; they are already recorded in your books on the invoice..

You can exclude what's in the banking section and rely wholly on QB.

 

Personally, i'd create 50 different receive payments against your one invoice, and then match to each of the individual receive payments, but this is not time-effective,

 

Eexcluding them won't prevent you from reconciling, you just won't automatically tick them on your reconcile, you'll need to tick the single payment against the invoice - as long as the payment against the invoice totals the same as the 50 payments.

 

Does that help at all?

Need to get in touch?

Contact us