QuickBooks Error: Overflow in QuickBooks Desktop
- QuickBooks POS Support
- Dec 11, 2017
- 3 min read
Here are some of the instances where you may get overflows in QuickBooks.
When you run the Verify Data utility, you see the error: "Problem: An overflow error has occurred. One of your accounts has exceeded the maximum value allowed"
When you open your Chart of Accounts, one or more of your balance sheet accounts show *overflow* instead of an amount.
When you run a report, one or more of the amount columns show *overflow* instead of an amount.
There are several possible causes:
An account balance or other field in your company file has an amount greater than $9,999,999,999,999.99.
Damaged transactions in your company data file.
When a large quantity on a Group Item is changed to another large quantity, Overflow can appear next to the Group's component items.
An Inventory item with a value that is too large for the number of items. e.g., a quantity of 1 and a value of $18,000,000.
The format you are copying from an Excel spreadsheet does not match a format that is accepted by QuickBooks.
Intuit suggests more than one answer for this issue. For best outcomes, play out the arrangements in the request appeared.
Essential: Before playing out any of the arrangements, it is best to confirm that your PC meets the QuickBooks Desktop 2018, 2017, 2016, 2015 framework prerequisites. Things to check specifically are Regional Settings, Disk Space and accessible RAM.
Rebuild your data file
From the File menu, click Utilities > Rebuild Data.
Click OK if you receive a warning message to backup your company file Your computer may display the message QuickBooks is not responding. However, as long as you can move your mouse cursor, wait for it to complete.
Click Ok when you get the message Rebuild is complet
Export your file to Microsoft Excel to find the overflow
Overflow rows may not display on the report. Display the columns by year or month.
Export your lists to your desktop.
Minimize QuickBooks.
Right-click the export file and choose Open With > Microsoft Excel.
Press Ctrl + F.
Enter *overflow* and click Find Next.
Switch back to QuickBooks and correct the data for the field in the Account, Name or Item that contains it.
Switch back to Excel and continue this process until there are no more results.
A Group Item is overflowing
Set the Group Item Quantity to zero.
Tab out of the field.
Reenter the correct Group Item quantity.
Just one item is overflowing
If it is a new item, delete it from the Item list and recreate it.
If it is not a new item:
Audit the item and correct the transaction that is causing a overflow. For example, a Bill with an amount of $1,000,000 and an amount of 1 instead of 1,000,000, will change the average cost from $1.00 to $1,000,000.
If you cannot find such a transaction, enter an Adjust Quantity/Value on Hand document to adjust the average cost.
The balance or other field of an account is too large
Perform basic data damage troubleshooting
Create a portable company file and restore it to a new working file.
Check your Chart of Accounts
From the Lists menu, click Chart of Accounts.
Find the account with a balance of 10,000,000,000,000 or more.
Reduce the balance of that account so that it never reaches 10,000,000,000,000.
If the issue persists, continue to the next step.
Memorized Reports
If the overflow appears on a memorized report, run the report from the Reports Menu.
If the new report does not show overflow, delete and recreate the Memorized Report.
If the new report includes overflow, proceed to the next steps.
Search all lists for all fields that hold an amount or total. You may need to include the inactive items as you go through your lists.
Under the Lists > Add/Edit multiple List Entries.
Click Customize Columns and choose any field that holds an amount (such as Credit Limit, Cost and Price). Look for Overflow then edit, change, or delete that amount.
Check all lists.
In newer versions of QuickBooks under Edit > Search look for *overflow*, search for list elements first, then search for transactions.
Continue running verifies after editing the amounts in the company file until the message no longer appears.
Damaged Transactions
If damaged transactions are the root cause of your issue, they should be easy to find.
Run various reports (Financial Statements, Custom Transaction Detail, Sales by Customer, Sales by Item, etc.) until you see overflow.
QuickZoom on overflow until you get to the transaction level.
Then fix the transactions.
Get QuickBooks Error Support
QuickBooks Error support number connects users with in-house intuit certified QuickBooks ProAdvisors. By providing support for all versions of QB accounting software, we ensure a smooth experience for QB users.
Comments