QuickBooks Condense Data Utility
QuickBooks is an amazing software that helps users to manage their business and their accounts without any hassle. Though it is worthwhile, you may experience some issues and errors, such as performance errors in QuickBooks. This error slows down the entire performance of your system. QuickBooks Condense data utility is the last method that you can try to troubleshoot this issue.
What is QuickBooks Condense Data Utility?
With the minimal risk of data damage, this process allows you to reduce the size of files without removing any details or damage. In short, it removes all the audit trails from your files, so the overall size gets reduced.
Why use QuickBooks Condense Data Utility feature?
The most beneficial part of the QuickBooks Condense data utility feature is that It removes the size of your files without deleting anything from them and frees up storage. By doing that, it improves the overall performance of your system. It is a way faster method than the traditional file condense feature.
Uses of QuickBooks Condense Data Utility Tool
One can still use the traditional ones, but while using that, you should keep in mind that it would remove all of your transaction details. With condensed data utility, you’ll not have to face that issue as all of your transactions would be there. By removing the audit trail info, it removes the file size up to 40%. You can use it in different scenarios, such as
- You can use this in different situations, such as
- When you have a really big file
- When you’re about to touch the list limit
- When you’ve just upgraded your hardware
- You’ve tried all other options and nothing worked.
How to use QuickBooks condense data utility feature?
This process can be accessed just like the traditional one.
If you are confused about how you can use the condense data utility feature, follow the steps mentioned below.
- Open your QuickBooks
- First, you have to go to the File menu.
- From there, select “Utilities.”
- A window will now open where you can find the option of Condense Data, select that.
- Now, you have to select the first option. The system will show you the approximate reduction of your file.
- Now, you have to select the option Next.
- You’ll now be able to see a notice on your system screen stating, “working on your file now.” It means that the process has been started.
- After it completes, a window will open on your system that will show you the total reduction of your file size. It will also tell you where the backup is located before the file is optimized.
Things to consider before condensing files in QuickBooks
Though it is an amazing feature from QuickBooks, you have to keep in mind or know a few things before using this feature. Let’s talk about these in brief.
You can’t undo it
It is the main reason why it is always advised not to use this method if you have other options left, as once it is done, you can’t change or undo it. Try all the probable solutions before applying this one.
When it comes to the company file, it may or may not work
In most cases, it reduces the size of the company file, but when you use inventory items, it means your lists are not removed and the size of the file is not reduced. Sometimes, it can condense some of the transactions but doesn’t affect the size much. On the other hand, open transactions are not condensed and it doesn’t change the size of the file. So, undoubtedly, it is the best way to reduce the size of your file, but in certain circumstances, it may not work.
Don’t expect that it would fix the File damage
If you’re expecting that this method will fix your damaged company file, you may not be right. This method usually doesn’t fix the file damage; rather, you have to apply other troubleshooting methods to fix the data damage. If you try using condense data utility for this cause, there is a high chance of not being successful. In those cases, you can either restore a backup company file or recreate a new company file.
It does not remove some transactions in certain situations
- Payroll transaction
It can happen when the condensate date is before 12/31, or you’ve not reviewed an employee’s W2.
- Invoices, payments, credit memos, and refund cheques
When they aren’t linked with each other
- Payments recorded to Undeposited Funds
When they are not deposited into the bank account
- Estimates linked to invoices
These non-posting entries cannot be removed.
- Sales tax if it is not paid in Pay Sales Tax
Taxes paid by cheques are not condensable.
- Some transactions
When they are linked to a non-Condensable transaction
It affects several reports
It has an effect on several reports and many things within those reports can be changed for condensing.
- Account-based items and item-based reports
All the item data such as Sales and Purchase reports, Job Costing reports, and A/R and A/P Aging reports will be gone.
- All cash basis report
All reports of the condensed period will be incorrect.
- Reports filtered by Class
When you summarize any transaction by the utility, it will not have classes assigned.
Besides these, it will also affect on Sales tax liability report (the invoices will be gone), The sales and purchase detail report (these will be blank), the AR collection reports (it will show that the condensed journal entries are under No name) and The Audit trail report (The transactions will be gone from here too).
That’s why it is very important to save and preserve all your data accurately in a backup. You should always have a backup. You can also save these reports separately in a PDF format as well.
Contact QuickBooks Condense Data Support
Condensing your file can be beneficial and risky at the same time. You have to be sure that you have no other option left except it. Hope this article was helpful to you. Please call our QuickBooks desktop support experts at +1888-727-4587 for more information if you have any additional questions.