How to Resolve Overflow Error in QuickBooks Desktop?

Published by John Smith at April 16, 2019

When does overflow error appear in QuickBooks Desktop?

A QuickBooks user can get QuickBooks overflow error under these situations –

When a QuickBooks user runs the QuickBooks Verify Data utility, he or she can get this error message displayed on the computer’s screen – A QuickBooks overflow error has taken place. This means that one of your accounts has gone beyond the allowed maximum value.
When a QuickBooks user open his or her Chart of Accounts, instead of an amount, overflow is shown in one or more of the balance sheet accounts.
When a report is run by a QB user, instead of an amount, overflow is shown in one or more of the amount columns.

Why does QuickBooks Desktop overflow error occur?

Many reasons can lead to QuickBooks overflow error –

An amount greater than $9,999,999,999,999.99 is present in a QuickBooks company file account balance or other fields.
The format that a QuickBooks user is copying from a Microsoft Excel spreadsheet is not getting matched with a QB accepted format.
QuickBooks Desktop overflow error can appear on the QB screen near the Group’s component items if in case, a large quantity present on a Group item is altered to some other large quantity.
A value associated with an inventory item is extraordinarily large for the number of items. To cite an example, you can consider a value of $18,000,000 for the quantity of 1.
QB company data file has damaged transactions.

How to fix QuickBooks Desktop overflow error?

More than one solution is available for fixing this error. If you want the best results, you are required to perform the following solutions in the order given below.

But, before applying any of the solutions mentioned below, make sure that your PC satisfies the system requirements of QB Desktop 2018, QB Desktop 2017 and QB Desktop 2016. You have to particularly check the following – what are your computer’s regional settings, how much disk space your PC has and how much RAM is available.

Also Read: How to Access QuickBooks Desktop Remotely?

Solution 1 - This solution involves rebuilding your data file. Follow these steps –

Navigate to File in QB’s menu.
Choose Utilities.
Then, select Rebuild data.
If in case, a warning message flashes on the screen and asks to back up a company file, click the OK button. QuickBooks not responding message may get displayed, but if you are able to move the cursor, ignore this message and wait for the process to get completed.
When Rebuild is complete message appears, click the OK button.

Solution 2 - This solution involves finding the overflow by exporting the file to Excel. Follow these steps –

You have to export lists to desktop.
After that minimize your QB.
Now, you have to perform a right-click on the export file.
Now, from the list that appears, select Open with Excel.
Look for transactions having overflow value.
Press the following two keys simultaneously on your keyboard - Ctrl, and F.
Type the word overflow.
Click on Find Next.
Maximize your QB again
Rectify the field data in Account, Name or Item that consists of overflow.

Now, check for overflow error in QuickBooks Desktop.

Solution 3 - Follow these steps if in case a group item is overflowing –

First of all, you have to set the number of group items to zero.
After that, you have to tab out of the field.
Now, again enter the correct quantity of the group item.

Solution 4 - Follow these steps if in case just one item is overflowing –

Delete the item from the Item list if it is a new item, and then you have to recreate it.
You have to audit the item if it is not a new item and then correct the overflow causing transaction.

Now, check whether QuickBooks overflow error is appearing or not.

Solution 5 - If in case the balance or another field of an account is too large, follow these steps –

First of all, you have to perform basic data damage troubleshooting.
Then, you have to create a portable company file and after that, you have to restore the created file to a new working file.
After the above step is done, you have to check your Chart of Accounts.
After the Chart of Accounts, Memorized Reports are to be checked.
Now, you have to look for all fields that hold an amount or total in all the lists. Inactive items may have to be included as you look through your lists.

Solution 6 - If in case, the damaged transactions are leading to QuickBooks Desktop overflow error, you can find them easily –

Firstly, you have to run various reports until overflow is seen.
Go to the transaction level, by doing a Quick-zoom on overflow.
Now finally, fix the transactions.

The solutions given above should fix the QuickBooks Desktop overflow error. But, if you face a problem in applying any of these solutions, or if the error does not get fixed, you can call us at QuickBooks 24/7 Support Phone Number our 1-855-365-6O12 to get expert technical assistance.