cancel
Showing results for 
Search instead for 
Did you mean: 
cdill1
Level 1

Workflow statements sending monthly...how do I change it so it only sends statements for clients with a balance? I want to eliminate clients with credits or zero balances

 
6 Comments 6
DebSheenD
QuickBooks Team

Workflow statements sending monthly...how do I change it so it only sends statements for clients with a balance? I want to eliminate clients with credits or zero balances

Hello, cdill1.

 

We want to help you with your concern about editing transactions. However, changing the customer statement template isn't an option in QuickBooks Online (QBO). 

For now, you can choose to list each transaction as a single line, including all details, and show the aging table at the bottom of the form. To do this, you'll have to visit the Sales menu on the Account and Settings page. For the detailed steps, here's how:
 

  1. Go to the Gear icon.
  2. Choose Account and settings.
  3. Go to the Sales menu.
  4. Hit anywhere in the Statements section to open its contents.
  5. Tap the option you want (List each transaction as a single line, List each transaction including all detail lines, or Show aging table at bottom of statement).
  6. Tick Save.

 

Additionally, you're able to customize your sales forms like invoices, quotes, and sales receipts. This is to add information that matters most to your business. For the step-by-step guide, you can refer to this article: Customise invoices, quotes, and sales receipts in QuickBooks Online. It also includes details about editing custom templates.

 

Let us know if there's anything that you need about sending the client's statement QBO. I'm always here to help. Have a wonderful day!

cdill1
Level 1

Workflow statements sending monthly...how do I change it so it only sends statements for clients with a balance? I want to eliminate clients with credits or zero balances

I don't need to change the template, I only want clients with a balance to receive a statement.  Why does QB send zero balance and credit balance statements to the clients?  There should be an option to select >$0 only.

CharleneMaeF
QuickBooks Team

Workflow statements sending monthly...how do I change it so it only sends statements for clients with a balance? I want to eliminate clients with credits or zero balances

Thanks for getting back on this thread, cdill1. I know how important it is to send the correct statements to your customer. I'm here to help you with that.

 

Let's set the customer statement to open balances in QuickBooks Online. This helps us filter the unpaid transactions. He's how:

 

  1. Go to the Get Paid & Pay menu and then select Customers.
  2. Choose the customers with open balances.
  3. Click the Batch actions and then select Create statements.
  4. On the Statement Type, choose Open Item.
  5. Select the correct date.
    sil.PNG
  6. Review the transactions, then click Save and send.

 

For more details about the process, please see this article: Create and Send Customer Statements.

 

Additionally, I've included an article that'll help you personalize your sales forms in QuickBooks Online. This way, you can add the info that matters most to your business: Customize Invoices, Estimates, and Sales Receipts.

 

Please let me know if you need assistance in managing your sales transactions, cdill1. I’ll be more than happy to work with you again. Keep safe always!

cdill1
Level 1

Workflow statements sending monthly...how do I change it so it only sends statements for clients with a balance? I want to eliminate clients with credits or zero balances

Ok. then the workflow automated option will have to be turned off?  I will have to do this manually each month?

cdill1
Level 1

Workflow statements sending monthly...how do I change it so it only sends statements for clients with a balance? I want to eliminate clients with credits or zero balances

I have clients that have invoices older than 365 days.  Why wouldn't QB include ALL invoices?  I like this option but need it to include ALL invoices.

LieraMarie_A
QuickBooks Team

Workflow statements sending monthly...how do I change it so it only sends statements for clients with a balance? I want to eliminate clients with credits or zero balances

Hi there, @cdill1.


Yes, you can disable the workflow automated option and create statements manually each month. Though, it would be helpful to have more conditions, such as the inequalities symbols and date range filter. These options would help you decide to whom only you're sending the statements and invoices. I'll relay this message to our team in concern here on my end and add your vote for this one. 

 

Here's how to disable a workflow template:

  1. Go to the Workflows menu and select My Workflows.
  2. Find your template.
  3. Click the drop-down arrow under the Action column and select Disable.
  4. Choose Disable to confirm.

 

You can also share your thoughts and ideas through your account. Our product development team reviews all the feedback we receive to ensure we’re meeting the needs of our customers. 

 

Here's how:

  1. Select the Gear icon at the top, then Feedback.
    Capture.JPG
  2. Enter your comments or product suggestions then select Next.
  3. You'll be provided a list of suggested Help articles related to your comment. You can read through them or select Skip and send message.
  4. From the drop-down, choose the appropriate category, then select Send message.

 

For your reference, check out this link: How to Submit Feedback. Furthermore, you can also create workflows for your team. Check out this article for more info: Use workflows in QuickBooks Online Advanced.

 

Let me know if you need more help with sending reminders to customer. I'll be happy to help. Thanks again for reaching us and have a great day, @cdill1.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us