Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
islandferries
Level 2

monthly statements

Hi,

 

We are a long time user of QBO. Recently we changed office managers and I have lost track of how to print monthly statements only with non zero balances due.

 

I have about 650 customers. In any given month, most have zero balance forward and no activity (let's say 500). Some have no balance forward and some activity in the month just finished. Some have a balance forward and either some recent activity or no recent activity. We want to print and send (email or paper) statements only for those with some balance current or past owing. I used to know how t do this, but can't recall now how to do that. Can you help?

Solved
Best answer February 06, 2022

Best Answers
DivinaMercy_N
Moderator

monthly statements

Hi there, @islandferries. I'm here to ensure you'll be able to create statements for your customers with non zero balance dues.

 

In QuickBooks Online (QBO), you can specify the Customer Balance Status to Open so this will only send statements for customers with non zero balance. I'll show you how:

  1. In your QBO account, select the +New button.
  2. Next, choose Statements.
  3. From there, select Balance Forward under the Statement Type drop-down.
  4. Set the date range for the statement.
  5. Then, in the Customer Balance Status field, pick Open.
  6. To print the statements, simply select the Print and preview button. On the other hand, click Save and send to email it directly to your customers. 

 

For your reference in creating statements in QBO, please visit this article: Create and send customer statements in QuickBooks Online​​​​​​. It also includes steps on how you can customize the statement.

 

In case you want to see current statements made for a customer, you can simply go to the Sales menu. 

 

I'm just around the corner if you have any other concerns about creating statements in QBO. I'd be glad to assist you further. Have a great week ahead. 

View solution in original post

1 Comment 1
DivinaMercy_N
Moderator

monthly statements

Hi there, @islandferries. I'm here to ensure you'll be able to create statements for your customers with non zero balance dues.

 

In QuickBooks Online (QBO), you can specify the Customer Balance Status to Open so this will only send statements for customers with non zero balance. I'll show you how:

  1. In your QBO account, select the +New button.
  2. Next, choose Statements.
  3. From there, select Balance Forward under the Statement Type drop-down.
  4. Set the date range for the statement.
  5. Then, in the Customer Balance Status field, pick Open.
  6. To print the statements, simply select the Print and preview button. On the other hand, click Save and send to email it directly to your customers. 

 

For your reference in creating statements in QBO, please visit this article: Create and send customer statements in QuickBooks Online​​​​​​. It also includes steps on how you can customize the statement.

 

In case you want to see current statements made for a customer, you can simply go to the Sales menu. 

 

I'm just around the corner if you have any other concerns about creating statements in QBO. I'd be glad to assist you further. Have a great week ahead. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up