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

Can statements be create for each separate client contact that does not include all the other owed amounts for other contacts for the same client?

I need to be able to create an account statement just for John Doe at ABC Inc. that doesn't also show all the other amounts owed by other contacts ABC Inc. I have not been able to figure out how to do that. This is something that I can do in QB Desktop.
6 Comments 6
Rasa-LilaM
QuickBooks Team

Can statements be create for each separate client contact that does not include all the other owed amounts for other contacts for the same client?

It’s nice to see you in the Community, Bea5.


Let me help and provide some information on how to create statements for your customer.


The parent customer’s name will show up beside the sub-customer in the To section of the transaction. Since the entry is per client, the data that will show up is only for the one you’re working on.cx statement.png


When you email the statement, make sure to enter the correct email address. This is to ensure the right client will receive it.


Here’s how to create a statement:

 

  1. Tap the Sales menu on the left panel and choose the Customers menu.
  2. This action will take you to the Sales page.
  3. From there, look for the sub-customer and click the drop-down under the Action column to select Create statement.
  4. In the Create Statements screen, click the Statement type drop-down and pick the correct transaction type.
  5. Key in the appropriate date in the Statement Date.
  6. Type your client’s email in the Email Address field.
  7. Tap the Print or Preview menu to view the entry.
  8. Click Save and send or Save and close.

 

For more insights into this feature, check the following article: Create and send customer statements in QuickBooks Online. It outlines the complete steps on how to customize the transaction and view one.

 

Additionally, the links below contain topics about organizing invoices, payments, income, and other customer-related activities.

 


Drop a comment below if you have other statements questions or other customer-related concerns. I’m more than happy to answer them for you. Wishing your business continued success.

Bea5
Level 1

Can statements be create for each separate client contact that does not include all the other owed amounts for other contacts for the same client?

Doesn't seem to work for me. I followed all those steps (which I had done before) for a client that had an outstanding balance showing on the list. I chose Open Item as the kind of statement (though I tried others too) and got a balance of $0.00 at the top right corner and a message that said:

 

 

Can't create all statements

1 of1 customers have no statements for this date. Adjust this date or click Save to create statements for the other 0. To see customers for whom statements are not generated, update the filter above the grid.

A sub-customer is being billed with its parent customer. You need to create a statement for the parent customer.

 

<end of QBO message>

And therein is the rub. Because what I NEED to do is to create separate statements for each sub-customer, not a statement for the parent customer. It looks to me like it's not possible with the message above, though the steps taken look like this should produce the desired outcome. Again - the outcome I need (and this works fine in QB Desktop) is one statement per sub-customer. We work with companies that have many contacts (i.e. sub-customers) and it's not appropriate or desirable to send one to the parent customer (i.e. client company). In fact, we don't even necessarily have a central point of contact to whom to send such a statement.

 

Bea5
Level 1

Can statements be create for each separate client contact that does not include all the other owed amounts for other contacts for the same client?

Just replied, but here's the picture:

Capture.PNG

RenjolynC
QuickBooks Team

Can statements be create for each separate client contact that does not include all the other owed amounts for other contacts for the same client?

Thanks for your prompt reply, Bea5.

 

I'd like to share a way on how you can print the statement for a specific customer.

 

I agree that creating a statement for a sub-customer is unavailable when it is set to Bill by parent. However, you have the option to change it by following these steps:


  1. Go to Sales > Customers.
  2. Select the sub-customer's name and click the Edit button. 
  3. Click the second drop-down next to the Is sub-customer menu, and choose Bill this customer
  4. Hit Save.

Once done, you can create the statement.

 

Here's how:

 

  1. In the Transaction List tab, put a check mark on the transaction you want to include in the statement. 
  2. Click the drop-down arrow next to New transaction and select Statement
  3. Go to the Statement available tab and you will see the statement for John Doe. 
  4. Click Print, Save, or Save and send

Here's also a screenshot to see what the statement would look like:

 

 

After printing or saving the statement for John Doe, you can change it back to Bill with parent by following the steps above. 

 

The articles shared by my colleague also includes more info about creating statements in QuickBooks Online.

 

In case you need help with other task in QuickBooks Online, you can visit our general help topics page. This will route you to the related help articles, Community discussions, video tutorials and more.

 

Please feel free to leave a reply below if there's anything else you need. We're always available to help you out. Have a good day ahead. 

Bea5
Level 1

Can statements be create for each separate client contact that does not include all the other owed amounts for other contacts for the same client?

Thanks for the info. I was hopeful, but after the steps 1 and 2, I got this message:

 

Capture.PNG

 

I cannot do what the system is asking me to do. We're talking about hundreds, probably thousands of transactions.

 

It looks like I'm out of luck.

Pam ANS
Level 1

Can statements be create for each separate client contact that does not include all the other owed amounts for other contacts for the same client?

We do the same thing and just found that the when we put a comma between the parent customer and the sub-customer it will not allow us to bill the sub-customer but once comma was removed it billed just the sub-customer.  I hope that works for you!  

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

Need to get in touch?

Contact us