Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI'm looking for a way that I can automate notifications if a specific account reaches a $ amount threshold. I doubt basic QB online is flexible enough to do this, but I'm open to cracking open the developer tools and coding it myself.
Basically, I want to build a rule where a notification email is sent to either myself or others if the account balance of an expense account reaches a certain $ amount. I don't want to be constantly flipping between screens to review the account as I confirm transactions and constantly monitoring it, then to export reports and send to my employees. How would I go about setting this up?
Never thought about it but this is definitely a value-added feature.
You have couple of options here, both outside QBO.
1) Use Zapier + Google Sheets to keep track of running balance for an account and trigger email.
2) Use google apps script to pull account balance and trigger email. (more complex)
Thank you for dropping by the Community, KK2023-1. I appreciate you bringing this concern and I'd be glad to help.
QuickBooks Online doesn't offer a built-in feature specifically designed for setting threshold alerts or custom rules for account balances. However, we can send direct feedback to our product engineers to consider this in the future:
However, this functionality is not available in QBO, I recommend submitting direct feedback to our product engineers:
Your feedback on this is greatly appreciated, and it helps QuickBooks consider such scenarios for potential updates in their features. If you'd like to track the status of your feedback, please visit our QuickBooks Customer Feedback page.
While waiting for potential product enhancements, consider looking for a third-party app that offers the capabilities of your needs for automating notifications based on account balances:
1. Go to Apps.
2. Then, Find apps.
3. Search for an application that fits your business needs.
On the other hand, you have the capability to create custom reports that showcase your account balances with QBO Advanced. You can also set these custom reports to be automatically sent to your employees, thereby eliminating the need for manual exporting and distribution.
Here's how:
Im actually working on an app for this called Lunova. We're currently in the middle of the QB App Store approval
process.
I was thinking about adding an integration for balance. I'd love to connect and work on that feature with you.
[email address removed]
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