Close

QuickBooks Condense Data Utility to Condense QuickBooks Data

QuickBooks Company File is probably the most essential part of the QB applications in your system. It contains all the relevant data of your organization and helps running mostly all of the QuickBooks operations. However, company files those are 5-10 years older or more face issues owing to their enormous size. To counter this problem, users can use the QuickBooks Condense Data Utility to shrink it and restore the efficiency of the company file. Let’s discuss this tool in detail and find out the process involved condensing the company file in QuickBooks.

Are you facing issues in your QuickBooks Company File that are interrupting your daily work schedule? Call us on 1.800.579.0391 and get immediate assistance for your problem from our expert support staff

What is this utility and why should I condense data in QuickBooks?

As we have mentioned earlier, the utility to condense data in QuickBooks is a tool to shrink or compress the size of a bloated company file that causes the overall inefficiency in running the QuickBooks. It saves an archival copy of your data file and removes and summarizes the old closed transactions. However, that’s not the only reason why you need the utility. Here is a list of other reasons as well.

  • If you want to import the Company File from QB Desktop to QB Online.
  • If you are closing to an inventory list limit.
  • In case you have upgraded all the hardware of your system.
  • If your accountant or adviser has discussed various other alternatives and has accepted to condense.

What to acknowledge before you compress a Company File in QuickBooks?

There are certain elements that you must explore before compressing a Company File in QuickBooks. Check out these points:

  1. Non-Reversible Action– The decision to condense your company file shall not be taken hastily as you cannot reverse the action. So, only condense the company file in QuickBooks if you need it utmost.
  2. May or may not be Effective on Company File Size– There is a high chance that it may not reduce the size of your Company File as the open transactions and some of the inventory items may not be condensed, thus not affecting the overall size of the company file.
  3. Definitely not to Repair File Damage– Most users try to condense the company file in order to fix file damage. It does work sometimes however, you can repair the damage by restoring the backup of the company file or just create a new one.

As we mentioned that it doesn’t remove some transactions in the second point, here is a list of them with reasons:

  1. Payroll Transactions (If the data is before the last day of the year or unreviewed W2 of an employee).
  2. Invoices, payments, credit memos, and refund checks (If not linked to each other).
  3. Undeposited Funds’ payments (If not deposited to a bank account).
  4. Bills, bill payment checks, and bill credits (If not linked to each other).
  5. Estimates of invoices (Non-posting entries can’t be condensed into posting transactions).
  6. Unpaid Sales Tax in Pay Sales Tax column (They are open transactions).
  7. Transactions linked to a non-condensable transaction.

It also affects certain reports for the condense period only. Take a look:

  • Reports based on Accounts and Items
  • Reports based on Cash in to Income or Cash out to Expenses
  • Class-filtered reports
  • Reports on sales and purchases in detail
  • Reports on Sales Tax liability
  • A/R collections report
  • Audit trail report
  • Reconciliations

Note: You can preserve your reports by making a backup of the Company File before the condensation. If you ever need to view the data from both the post-condensed company file and archival backup file, just merge their data in another program.

How to use the QuickBooks File Condense Utility? (For QB Desktop 2018 and earlier)

Before you head on to start condensing the company file, make sure to follow the steps listed below in order to back up the transactions that will not be covered in condensation of the file. Store them or print them out through the link that will be given in the report. To run the report go through the following steps:

  1. Open QuickBooks and select File tab.
  2. Go to Utilities and select Condense Data option.
  3. Choose the Transactions before a specific date option and enter the appropriate date.
  4. Check-mark the optional box and select Next.
  5. Click on Summarize inventory transactions (recommended) and select how your inventory will be condensed, later click Next.
  6. Remove the transaction groups as you wish and click Next.
  7. Click on Begin Condense. It will not start condensing as of now but will only run the report.

Note: Try to fixing every transaction by bringing it to the screen and selecting Apply Credits to link it with existing credits.

Now, prepare your company file for condensing through the following steps:

  1. Remove the closing date of your data file by the following steps:
  • Open QuickBooks and select the Edit menu.
  • Click on Preferences, and then go to the Company Preferences
  • Click on the Set/Date Password option and delete the date given in the box.
  • Hit OK.
  1. Edit the transactions that are entered before your company starting date as you cannot fix them afterward. To find them, run the Profit and Loss and Balance Sheet utilities.
  2. Under Chart of Accounts, re-sort the lists.
  3. Make sure of zero data damage by running the Rebuild and Verify Data Utility.
  4. Make a back up of your company file and copy it to a secure location.

At last, you would need to print or save the following data as PDF’s to compare them with the condensed data and check if all the information is still intact.

  1. Accrual-based Profit and Loss for all the dates.
  2. Accrual-based Balance Sheet for all the dates.
  3. Cash Flow statements.
  4. A/R and A/P Aging Detail for all the dates.
  5. Reports recommended by your accountant or adviser otherwise.

Now, you are all set to use the QuickBooks File Condense utility. However, be patient as the condensing may take some time depending on your file size and the performance of your system. For faster completion, do not run other applications in the background and ignore any message that Windows shows regarding QuickBooks. Also, if you use QuickBooks in multi-user mode, run the condense tool only on the computer that you use to manage all the workstations in the network.

Important Note: You would need to restore the backup you made before condensing, in case if the file condense process fails or you cancel in-between.

At last, run the utility to condense data by following these steps:

  1. Open QuickBooks and select the File tab.
  2. Go to Utilities and choose the Condense Data option.
  3. Going through the wizard, you will be asked to condense from the following transactions and list entries. Choose Help if you face any difficulty.
TRANSACTIONS LIST ENTRIES
Not cleared or unreconciled bank and credit card Accounts
To be printed Customers and Jobs
“To be sent” Invoices and Estimates Vendors
All of the Estimates, Sales Orders, Purchase Order, and Invoices that are pending Other Names
All of the Time and Mileage activities “Done” to-do notes
Unbilled expenses and items Classes
Items

4. Click on the Begin Condense.

For the users of Premier Accountant and QB Enterprise, you may need to look for the Period Copy. It is a condensed version of your QuickBooks Company file that contains data for a specific period. Follow our article on Period Copy of the Company File for more info.

How can I Compress a Large QuickBooks File in QB for Mac?

In order to compress a large QB file in QuickBooks for Mac, close all the QuickBooks windows and go through the following instructions:

  1. Open QB Desktop for Mac and go to the File tab.
  2. Select Utilities and choose the option of Condense Data.
  3. Permit to create a backup file and select OK.

Important Note: It is advisable to select the last day of the month if you track inventory. In that way, the average cost for items will not be affected.

How to Condense QuickBooks Desktop File in QB Desktop 2019?

In QB Desktop 2019, the process to condense QuickBooks Desktop file is streamlined and has been made to complete the means much faster than the traditional one. Additionally, it provides an option to remove the audit trail without deleting the detailed transactions by making a combined journal entry for data to the selected date. Access the tool by following the given steps:

  1. Open QuickBooks and select the File tab.
  2. Click on Utilities and then select Condense Data.
  3. Just as in the given image, if you choose the new option, it will show the approximate reduction that will be done to your Company File. However, you can choose the traditional option as well.
  4. Click Next.
  5. When the process completes, a window will pop-up informing you about the total reduction and the location of the backup will also be mentioned there.

Important Note: To check for discrepancies, use the comparison reports that you printed and if you find any, then:

  • Restore your backup file.
  • Note the damaged transactions and re-run Condense Data after repairing them.
  • Create a new Company file.

At this point, we are concluding our blog on the QuickBooks Condense Data Utility tool. We hope that the content will be relevant to your queries and helps you to perform the mentioned actions and processes successfully. However, if you feel the need for external support of an expert to help you, dial Support Number 1.800.579.0391 and get immediate assistance anytime.

QuickBooks Condense Data Utility to Condense QuickBooks Data
Article Name
QuickBooks Condense Data Utility to Condense QuickBooks Data
Description
QuickBooks Condense Data Utility is a tool used to shrink or compress the size of a bloated company file that causes the overall inefficiency in running the QuickBooks. It saves an archival copy of your data file and removes and summarizes the old closed transactions. Let’s discuss this tool in detail and find out the process involved condensing the company file in QuickBooks.
Accounting
Publisher Name
Accounting Helpline
Publisher Logo