Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
B
BethFL
September 6, 2023
Question

I have set up a Workflow for recurring monthly statements in QBO. How can I set up the Workflow to only send statements to customers with an open balance?

  • September 6, 2023
  • 1 reply
  • 12 views
My zero balance customers are complaining that they are receiving the statements even when they have made their payment. They do not look at the detail portion of the statement to see the zero balance. They just react as if we are asking them to pay their bill again.

    1 reply

    C
    ChristieAnn 11
    Level 9
    September 6, 2023

    Welcome back to the QuickBooks Community, BethFL. I'll be sharing further details on how Workflows works in QuickBooks Online. Let me also ensure you can achieve your goal by performing the alternative steps below.

     

    Utilizing workflows in QBO helps you automate common tasks in QuickBooks like sending payment reminders to customers. Also, the details below are some common uses for workflows for customers:

     

    • Automatically send unsent invoices: Send your customers invoices that haven't been sent yet.
    • Payment received: Automatically email customers to let them know you received their payment.
    • Payment due reminder: Automatically email customers to let them know their invoice payment is due soon.
    • Overdue invoice memo: Automatically update an invoice message with an overdue or customized stamp.

     

    With the information mentioned above, setting up the Workflow to only send statements to customers with an open balance is currently unavailable.

     

    However, you can create and send customer statements manually in QuickBooks. This shows the outstanding balances or invoices that will soon be overdue.

     

    Here's how:

     

    1. Go to the Customers and leads menu on the left panel.
    2. Choose Customers.
    3. Select the customer you want to make statements for. 
    4. Choose the New Transaction dropdown and select Statement.
    5. Review the customer’s email address, then click Save and close.

     

    Then, you can open this article if you need steps on how to make multiple statements for your customers: Create and send customer statements in QuickBooks Online.

     

    Lastly, refer to this article on how to view the status of all sales transactions such as open and paid invoices in QBO: View sales transactions in QuickBooks Online.

     

    Please comment down below if you have further concerns about sending customer statements in QuickBooks Online. We're available 24/7. Stay safe, BethFL.

    B
    BethFLAuthor
    September 7, 2023

    I know haw to send statements to my customers in QBO. I have been doing the manual method for two years. Once again Quickbooks has provided an ?improvement that should have made my work easier that does not fulfill the promises. The automation aspect was the one I hoped would take this item of of my monthly to do list.

    Do not understand why when you send statements manually and choose balance forward you have the option to only include customers with an open balance but with Workflow you can choose balance forward but are not given the option to choose only customers with an open balance. I will now go back to the way I have been sending statements before. What a fail of a promising improvement.

      F
      FateCandylaneTQuickBooks Team
      QuickBooks Team
      September 7, 2023

      We recognize the relevance and convenience when managing Workflows to complete QuickBooks tasks, BethFL.

       

      Currently, the ability to only send statements to customers with open balances is unavailable when setting up Workflows in QuickBooks Online. We can consider taking into account the information shared by my colleague, ChristieAnn, above to manually send customer statements.

       

      Thus, we recommend sending this relevant feature request to our product engineers. They're always open to suggestions to help improve customer experience and may consider having this option in future product enhancements.

       

      Here's how to submit feedback:

       

      1. Go to the Gear icon and select Feedback.
      2. Enter your product suggestions or feedback.
      3. Then, click Next to submit feedback.

       

      Furthermore, I've included this reference to help you review and manage your business finances: Run reports in QuickBooks Online.

       

      We appreciate your understanding as we work towards improving our products, BethFL. We'll keep this thread available if you have additional queries about managing workflow. Feel free to leave them in the comments below. Keep safe!

      Need QuickBooks guidance?
      Log in to access expert advice and community support instantly.
      Terms & ConditionsAccessibility statement