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

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 to get in touch?

Contact us