Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi everyone,
I have a company where we have roughly 250 monthly payments from recurring invoices sent to them via QB, the issue we're having is that the rules are not working the way we would like them to, when the rule is applied the transaction is categorised and not matched, this then shows that the client's balance as 0.00 but they are still overdue, does anyone know if there is a way that QB can automatically match the payment to the client's account against the last invoice? On the screenshot, the red is what the rule does and the blue is when it's done manually.
Any help would be greatly appreciated!
Have an awesome day.
Yes, there's a way to automatically apply payments to an invoice in QuickBooks Online (QBO), iamgavinjones.
Thank you for the screenshot. You don't need to create a rule for the deposit to automatically apply to the invoice.
QBO has an automation feature where you can automatically apply payments to an open invoice. This option can be turned on in the Account and Settings section.
Here's how:
If these payments are creating an overpayment, I recommend the following article which contains steps for what to do: Apply A Credit From An Overpayment.
QuickBooks estimates and invoices are improving. Check out this link to learn about the latest update: See what’s new with estimates and invoices in QuickBooks Online. The workflow for these forms will look different depending on whether you have the old or the new version of estimates and invoices.
Let me know if you have other concerns aside from applying payments to invoices. I'll be right here to help you.
Hello, Gavin Jones.
Thanks for your reply, and I appreciate the screenshot for clearer picture on what's going on. I'll give some details about the Automatically apply credits option, and how you can take care of those deposits and invoices.
Just to clarify what the Automatically apply credits option will do, it only works on future invoices. For example, if the deposit was automatically categorised before the invoice was created, then the option will take effect (right after the invoice was created).
The option won't work for existing invoices, so we're unable to automatically apply those deposits. Though, you'll want to continue manually linking and recording those payments.
To make it easier, I'd recommend using the Receive payments option (go to the + New button, then select Receive payments). Just select your customer, then check the invoices and the deposits to link them together.
Regarding the missing option, I double-checked the setting on my sample company, and it is still there. It looks like something is preventing it from appearing on your end.
If you want to use the option for future transactions, I'd recommend contacting our support. They can check on your account and investigate what's preventing the system from showing the option.
Here's how to reach them:
If you need help with your bank account reconciliation in the future, feel free to use this article: Reconcile an account in QuickBooks Online.
I still encourage you to reply here if you have any other concerns with your customer transactions (or any other processes in QuickBooks). I'm always here to help.
Hi. So I have "Automatically apply credits" selected, but it doesn't seem to be working. My invoices and payments are coming in automatically through an interface from the program Teachworks, if that matters. Please advise. That's not a setting that only works in a higher version of QB, is it?
Hi there, meldeiry.
Thanks for joining this thread. I want to make sure you're able to use the automatic apply credit feature in your QuickBooks Online account.
You mentioned this feature has been selected in your settings but not working properly. To rule out any browser related issues, I recommend first clearing the cache. The cache is used to collect frequently used data to make loading web pages quicker and easier. If the cache becomes too full it can cause viewing and performance errors within the system. Clearing it will remove anything preventing the system from operating properly. Here's how to get this done in Chrome for example:
1. Click the three vertical dots in the top right corner.
2. Select More Tools, then Clear Browsing Data.
3. Change the time range to All Time.
4. Only check Cached images and files.
5. Click Clear data.
The following article provides similar steps for other browsers: Clear cache and cookies to fix issues when using QuickBooks Online
Give this a try and the credit function should start working. Please don't hesitate to reach back out if you have any other questions.
Hi Morgan,
I tried this and unfortunately, it doesn't seem to have worked. What else can I try? Or can someone look at my account? Thanks.
Hello, meldeiry.
Thanks for getting back to us. Allow me to jump in and help ensure this is taken care of for you.
Since the issue persists after following the steps shared by my colleague above, I highly suggest contacting our Support team. They have tools such as screen-sharing (remote access) that can pull up your account in a secure environment and check the cause of this odd behavior. They can also perform other troubleshooting steps if necessary.
Here's how to reach them:
For more tips and other resources, I recommend visiting our website for future reference: Self-help articles.
Please post again in the Community or leave a comment in this thread if you have additional questions about this or anything else QuickBooks. I'm more than willing to answer them. Stay safe.
I have seen this answer for auto payments a number of times and I think it is false. The automatic credits is for credit memos, which are refunds. It does not work for payments.
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