Mapping a recurring aggregate ACH deposit to multiple clients recurring invoices

frustrated_FF · ‎April 25, 2024

I have several clients that are setup on a recurring invoice each month in QBO. These clients all pay using an ACH deposit, setup through my financial institution to occur on the same date. It is an aggregate deposit of several clients, (e.g. 10 clients, Invoiced for $25.00, total Deposit $250.00).

Under Recurring Transactions there is an option to create recurring invoices and recurring deposits (etc.), however there doesn't appear to be a way to integrate these two recurring items together. I understand if under the bank transactions I select the ACH deposit, then select Match, I can then scroll through the entire list of outstanding invoices to match them manually. This process is tedious and time consuming. I am looking to streamline the process and reduce the time required to reconcile each aggregate deposit against the multiple invoices.

Does QBO have the capability of having a recurring monthly deposit automatically credit recurring monthly invoices for multiple clients?

If not does anyone know of a third party APP that does this type of function. I have looked through the QBO APP store and cannot locate one that may have this capability buried in with the myriad of other import export report functions that seem to be popular.

Looking for some answers.

Thank you kindly community.

MarkAngeloG

Hi there.

I know how crucial it is to integrate two recurring items. However, this option is currently unavailable in QuickBooks Online. In the meantime, you can still manually match those invoices.

While we can't guarantee that a third-party app exists in the QBO App Store, you can still search for it online to streamline the reconciliation process.

I understand that matching them manually is very time-consuming so I recommend sending feedback directly to our product engineers so they can take note of your request. Rest assured, our product engineers are doing their best to improve our services and your experience in QuickBooks Online.

Here's how to send a feedback:

Select the Gear icon and choose Feedback.
Fill in your suggestions in the Feedback field.
Select Next to send it.

After successfully mapping the recurring items, you can consider categorizing them and reconciling them to match with your QBO records.

I'm always here to assist you if you have additional concerns besides integrating two recurring items in QuickBooks Online. Please feel free to reply below.

beancounter1234

You can use Fazeshift (https://www.fazeshift.com/) to get the functionality you're looking for. It automatically matches ACH deposits from your financial institution to recurring invoices in QBO and credits the invoices for each client.

Hopefully QBO adds this functionality at some point, but doubtful since every financial institution's payments are quite different. Good luck!

Topics

Training

Community

Resources

Mapping a recurring aggregate ACH deposit to multiple clients recurring invoices

Mapping a recurring aggregate ACH deposit to multiple clients recurring invoices

Mapping a recurring aggregate ACH deposit to multiple clients recurring invoices

Need to get in touch?