Limited time only. 50% off QuickBooks for 6 months.
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Annaja
Level 1

Batch Payments to Invoices in Quickbooks Desktop

I have 500 students payments to be applied to invoices in QuickBooks Desktop, does any knows how to batch payments to invoices.  

5 Comments 5
SheandL
QuickBooks Team

Batch Payments to Invoices in Quickbooks Desktop

Hello Anna, I'll outline two scenarios to help you apply or match your students' payments to their invoices.


If this is a lump sum payment and you want to apply it to multiple invoices, you'll first need to wait for it to appear in your bank feeds. 

 

Once it does, you can match it to the existing invoices in QuickBooks Desktop by following these steps:

 

  1. Navigate to the Banking menu and select Bank Feeds.
  2. From the Bank Feed Center, choose the bank account that received the payment.
  3. Click on the Transactions List and locate the lump sum payment you want to match.
  4. Next to the payment, click the Select dropdown and choose Match to existing transaction.
  5. A new screen will appear, allowing you to select multiple existing invoices that this payment covers.
  6. Once you've selected all applicable invoices, hit Confirm Match.

 

However, if you have multiple separate payments that need to be applied to multiple invoices, you'll have to match them manually. QuickBooks Desktop does not currently offer a feature to batch apply payments to invoices. 

 

If you have other concerns, let us know below. We're always here to help.

SIAB
Level 7

Batch Payments to Invoices in Quickbooks Desktop

@Annaja 

You can prepare your Receive Payments data with the following template

 

CustomerCheck NumberTransaction DatePayment MethodMemoApply to Invoice (blank auto-applies)AmountDeposit ToDiscount AmountDiscount AccountDiscount ClassAR AccountExchange Rate
Anne's Bakery12301/11/2020Check 10010000Checking     
John's Barber Shope99901/11/2020Check 101500Checking     

 

then use an importer tool to proceed. It's a $199 one time license.

https://get.transactionpro.com/qbd

 

If you have a US business credit card or ACH, you can get a free license from a partner. T&C apply.

Annaja
Level 1

Batch Payments to Invoices in Quickbooks Desktop

Thank you, very much, once I try this option.  I will provide an update 

Annaja
Level 1

Batch Payments to Invoices in Quickbooks Desktop

SheandL, thanks for  your response, I realize that the batch option is available in the US but not in Canada, but I am hoping to find a work around especially when dealing with such a large number of entries 

Annaja
Level 1

Batch Payments to Invoices in Quickbooks Desktop

SheandL, thanks for  your response, I realize that the batch option is available in Canada, but I am hoping to find a work around especially when dealing with such a large number of entries

Need to get in touch?

Contact us