Skip to main content
November 21, 2024
Question

Customer Statements (4500 Customer Limit) Workaround

  • November 21, 2024
  • 3 replies
  • 0 views

Hi All,

 

When I go to create customer statements for 90 days past due customers (should only be around 50 customers) I run into the limit of 4500 customers. This was added to QB Enterprise 2024 but wasn't a problem in any previous versions.

I'm wondering if anyone has a solution to this as it has been a barrier for us to notify and collect past due customers. 

 

3 replies

November 21, 2024

Your efforts in attaching a screenshot is appreciated, bena. Issues with creating customer statements can be challenging, especially when timely communication is vital for cash flow and your business's financial health. Together, let's explore an alternative so you can create customer statements effectively. 

 

Since you're only creating statements for approximately 50 customers but encountered this alert message, I'd recommend choosing the Multiple Customers selection instead of the All Customers option. This approach lets you select specific customers, potentially avoiding data issues affecting this process.



However, if you continue to receive the same alert message, I'd suggest performing some diagnostic procedures to resolve this unexpected behavior. These steps can help us identify the root cause of the issue and implement an effective solution. 

 

Here's how:  

 

  1. Click the Window tab, then select Close All.
  2. Go to the File menu, and then hit Utilities.
  3. Choose Verify Data. If you see: 
    • QuickBooks detected no problems with your data: The data is clean. An error message: We can search for it on our QuickBooks Desktop support site on how to fix it. 
    • Your data has lost integrity: Data dais detected. Rebuild your data to fix it.  

 

Then, we can Rebuild your company file data to ensure we can completely remove any problems. If the issue persists, we can use the QuickBooks Desktop Tool Hub to fix common QuickBooks Desktop issues.  

Additionally, you have the option to create statements for each customer individually for now. This approach tailors information for each customer's needs, ensuring they receive accurate and relevant transaction details. 


I’ll
provide several resources to help you learn more about adding line items directly to a customer’s account register and creating automated payment reminders for invoices and statements:

 

 

I want you to know that I’m here to provide any additional assistance you may need as you work on generating customer transaction summaries. Should you have any questions or encounter any challenges along the way, drop a comment below.

benaacoAuthor
November 21, 2024

I knew you were going to suggest that but it doesn't work, it doesn't show what customers have an open balance or are past due. 

This is not a solution or a workaround.

January 15, 2025

Same issue! Have been a customer for over 25 years. Had to upgrade due to some things not working. Now they are telling me have to go through 4500 customers and manually select who I want to do a statement for. That is not even possible!!

May 29, 2025

We upgraded to Enterprise 2024 recently.  I am trying to print customer statements for about 120 and the error message tells me I have too many (4500)  My filters don't seem to be working.  Is there a solution?

benaacoAuthor
May 29, 2025

Hey mgzsmith, there is not a solution. They'll say that you can individually select the customers but that is the only solution they are currently offering.

The only "workaround" I've found is to select "Customers of Type" and I can get some of the statements out but other than that you'll have to go through and make a list of the statements you want to send and then manually go through and select those customers using the "Multiple Customers" option.