Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I am treasurer for my HOA with 36 units. I have a memorized transaction that creates invoices monthly for all the units in QB Desktop Pro.
I use my bank's ACH collection feature to collect dues from all the owners. The ACH collection appears on my statement and also downloads from the bank as one total amount for all 36 "customers".
Is there a way to create a batch or memorized transaction that will recognize or receive all 36 payments in QB Desktop and apply them to each of the 36 customer invoices?
I'd be happy to share with you what does the batch action in QuickBooks is all about, @JimJayhawk.
Creating a batch transaction for receive payments is unavailable. You can individually apply the payments to an invoice manually.
Batch action allows you to print, email, and enter transactions in bulk.
To learn more about how to perform the action, please check out this article: Enter transactions by batch in QuickBooks Desktop.
Please know that the Community is just around the corner if there's anything else you need.
Good Evening,
Could someone explain the statement below in more detail, does this mean I would ignore the bank fed, ACH batch transaction and manually mark the invoices as paid?
Thank you
wambat71
You can individually apply the payments to an invoice manually.
Good Evening,
Could someone explain the statement below in more detail, does this mean I would ignore the ACH batch transaction and manually mark the invoices as paid? QuickBooks will not allow you to mark more than one invoice as associated with a bank feed transaction. I can create a unique Vendor and list the individual vendors that were paid with the ACH transaction, but then the 1099 Summary does not list the transaction that was part of the ACH batch.
Might be a change that Intuit can look to add in the future.
Thank you
wambat53
You can individually apply the payments to an invoice manually.
Hello there, wambat53.
I see how convenient it is for you to ACH batch transaction in QuickBooks Desktop. However, QuickBooks will not allow you to match one bank transaction to multiple existing entries on your bank feeds.
To mark your invoices as paid, you can ignore the ACH batch transaction and manually apply individual payments for your invoices.
If you're using QuickBooks Payments (Merchant services), you don't need to do anything because the payments will sync with your transactions. Here's an article for more information: Automatically record QuickBooks Payments bank deposits in QuickBooks Desktop.
Please get back to me if you still have other questions about banking. I'll be here to help. Have a nice day!
Thank you for the response. Seems like I simple improvement since the functionality is very similar to the receipt functionality in Receive Payments.
Good morning, @wambat53.
Thanks for reaching back out.
We appreciate your feedback. I'll send it in to our Product Developers so they can consider this as an improvement to the system.
You can always check out our Blog site to keep up with what's new in the product.
Feel free to ask any other questions that you may have here in the Community. We're always here to have your back. Bye for now!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here