Quickbooks 2013 Condense Data Upgrade To Enterprise

Your database has become corrupted and you cant seem to be able to fix it.

How can you tell when large is too large and what can you do about it The definition of too large in QuickBooks is fuzzy.

You can hit a ceiling based on the sheer size of the file (defined in megabytes, or MB) or by whats in the file itself (e.g.

You may have a small file in term of the amount of space it takes on your hard drive and still reach a limit based on how you use QuickBooks.

The key limitations are the following: File size Theoretically, there is no limit to the size of your file, but in practicality, assume that you are stretching QuickBooks Pro and Premier when you get to around 150MB.

Above these limits, QuickBooks becomes painfully slow and the database tends to get corrupted easily.

Number of items There is a limit to the number of list items (classes, customers, jobs, classes, etc.) that you can have in your file.

This limit is different for each type of item and for each version of QuickBooks and it changes year to year, so its a hard target to keep track of.

Heres a good rule of thumb to use: if your total number of items is below 10,000 overall, youre safe with QuickBooks Pro and Premier.

Above these limits, you need to get more granular and look at your individual items types.

Hit F2 when you are in QuickBooks and it will give you a count of all your items.

For more details on the limits per item type, refer to this table: Shrinking the size of your QuickBooks file Lets assume that you reached the conclusion that your file is too big.

Quickbooks 2013 Condense Data Upgrade To Enterprise

What can you do First and foremost, you need to decide if you maxed out QuickBooks Pro and Premier and you need to upgrade to Enterprise.

If you have reached the limit on number of items, you can try to cleanup the items that you dont use anymore (see more on this below), but if it doesnt have a sufficient impact, Enterprise might be your best option.

I recommend that you first try a cleanup, because Enterprise represents a significant jump in price from Pro or Premier.

Getting a second opinion from an expert is not a bad idea at that stage, just because of the cost involved.

Dont bother asking Intuit because they have an incentive to get you upgraded to Enterprise.

If you decided to try to decrease the size of your file, you have 3 options: Use QuickBooks Clean Up Company Data feature to condense the past years.

This feature replaces most of the transactions from the previous years by much smaller monthly journal entries.

The details on your previous years are gone, but the PL and balance sheet should remain intact.

Use QuickBooks Clean Up Company Data feature to remove ALL transactions.

The same Clean Up feature mentioned above also allows you to create a new company file without any transactions left, but with all your lists of items intact (customers, vendors, etc.).

In this scenario, you need to manually recreate the opening balances for all your accounts, starting from a certain date, including open invoices, open bills, inventory, bank accounts, etc.

Its as if you started with a brand new company file, exept that you dont have to recreate your item lists.

Start a brand new company file This is the brute force approach.

Here are some examples: Your current item list is unnecessarily bloated.

Starting afresh is sometimes faster than deleting old items, which in some cases is not possible anyway.

Quickbooks For Mac 2013 Condense Data