Overflow in QuickBooks Desktop – How to Fix this Error

Basic Steps to Fix Overflow in QuickBooks Desktop 

QuickBooks is an accounting tool that is instrumental in helping entrepreneurs, accountants and tax experts in gathering their business objectives. This is a high level software. Yet, similar to some other program, QB also gets a few errors and glitches that may propel experts to delay their work. 

This article is made to talk about Overflow in QuickBooks Desktop. Further, in this post, you will be educated regarding probably the most widely recognized explanations behind the event of this error and some valuable tips to fix it. 


Comprehend Overflow  in QuickBooks Desktop 

  • This is a data error of a particular kind. At the point when this error happens, all the estimation units converge with each other to exceed the greatest limit of a specific field. A portion of the overall instances of Overflow Error in QuickBooks Desktop are as per the following: 
  • When endeavoring to access or open any data, report or file and one or various fields of a segment feature this error message. 
  • Flood Error in QuickBooks Desktop may likewise appear at the hour of running the Verify Data utility. The error text may peruse “Issue: A flood error has happened, one of your accounts has crossed the maximum limit permitted.” 
  • This error has greater likelihood of occurring with “the diagram of accounts.” If this is the situation, the flood will appear on at least one monetary record rather than a sum. 

“Problem: An overflow error has occurred. One of your accounts has exceeded the maximum value allowed.”


What causes Overflow in QuickBooks Desktop? 

  • There may be at least one of the accompanying explanations for the event of this error: 
  • The account equilibrium of your company or different fields is more than $9,999,999,999,999.99. 
  • A harmed or debased transaction data in your company data. 
  • In the event that you convert an enormous sum on a gathering thing to an alternate huge sum, this error may show up by the part thing of the gathering. 
  • In the event that the inventory has a worth bigger than the things number. 
  • In the event that the arrangement crisscrosses with the organization acknowledged by the QuickBooks Accounting Software. 


How to Fix Overflow in QuickBooks Desktop? 

Significant Note: Before playing out any of the arrangements, it is prescribed to check that your PC meets the QuickBooks Desktop Editions (2018, 2017, 2016, 2015) system necessities. Things to check specifically are Regional Settings, Disk Space and accessible RAM. 


Issue 1: How to reconstruct your data files? 


  • File Menu > Utility > Rebuild Data. 
  • Click Ok if a message box asks you to backup your company file to make sure about your data. 
  • Click Ok after Rebuild is finished. 


Issue 2: on the off chance that arrangement jumble issue 

On the off chance that you send out your files in Microsoft Excel to discover flood, follow the beneath given strides if there should be an occurrence of confuse issue: 


  • In the event that the flood error is set off by design confusion, flood columns may not show up on the error report. Make the segments to appear by year and months. 
  • Fare your bookkeeping page to your desktop. 
  • Now, limit QuickBooks and right-click the fare file. 
  • Select Open With and afterward go to Microsoft Excel. 
  • Press Ctrl+F keys to open the inquiry box. 
  • Type Overflow and tap on Find Next. 
  • Return to QuickBooks and correct the data in Account, Name and thing fields. 
  • Open Microsoft Excel and continue following the process until there are no outcomes left. 


Issue 3: Overflowing Issue with a gathering thing 


  • Here is the manner by which to fix the flood error set off by this reason: 
  • You need to set the Group Item Quantity to nothing. 
  • Close the field. 
  • Again put the specific Group Item Quantity. 


Issue 4: If Only 1 Item Is flooding 


  • On the off chance that while chipping away at QB you get an admonition that one thing is flooding, it very well might be the one, much of the time, that has been added as of late. Despite the fact that there may be a few exemptions, wherein a generally existing thing may likewise be the reason for the error. 

Case 1: if the error brought about by the recently added thing, you can eliminate that from the rundown and reproduce that. 

Case 2: If it’s an old thing – 

  • Check the thing and fix the transaction causing a flood. 
  • Type in Adjust Quantity/Value on Hand file to change or amend the normal expense in the event that you locate the current transaction causing the error. In the in the interim, on the off chance that you need special help you can contact the QuickBooks Error Support group. 


Issue 5: on the off chance that the account balance or different fields are excessively huge 


It might happen that the account balance field or different fields are surpassing their maximum limits because of some unidentified reasons. The greatest limit in QuickBooks is $9,999,999,999,999.99. On the off chance that any account balance crosses the maximum limit, the field will itself show the flooding error. 

Here is the thing that you can do for this situation: 

  • Perform investigating needed for fundamental data harm. 
  • Make a compact QB company file. 
  • Reestablish the file to another working file. 
  • Confirm your graphs of accounts. 
  • Go to the List menu and tap on the Chart of Accounts. 
  • Recognize the account having balance equivalent to or more than 10,000,000,000,000. 
  • Limit the equilibrium of the account. 
  • Follow the beneath steps if the issue actually exists. 
  • Flood on remembered reports 
  • For this situation, go to the Reports menu to run the report. 
  • On the off chance that you don’t see flood in the new report, erase it and reproduce the retained report. 
  • Move to the accompanying advances in the event that you see flood. 
  • Search all fields in all rundowns that have a sum or aggregate. You may need to add the latent things while experiencing your rundowns. 
  • Go to the Lists and select Add/Edit Multiple List entries. 
  • Click Customize Columns and pick any field that has a sum, for instance, Cost, Price, and so forth Discover Overflow and the right, change or eliminate the sum. 
  • Check all rundowns accessible. 
  • On the off chance that you are utilizing an updated version of QuickBooks, go to Edit, discover flood, look for list components and afterward transactions.
  • Edit the sums and continue checking them the error message quits showing up. 


Issue 6: If there is a defiled transaction 


On the off chance that the error is set off by a ruined transaction, follow the give steps: 

  • Run Financial Statements, sales by customer, sales by thing, custom transaction subtleties, and different reports until you discover flood. 
  • Continue performing Quick-zoom to discover the transaction level. 
  • Right the transaction. 



We trust that this article will help you in fixing the Overflow Error in QuickBooks Desktop.

Also Read:


Leave a Comment

Your email address will not be published. Required fields are marked *

Check Out Checkins