Quickbooks desktop condense data

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Companies generally use it when their data file is very large, the list limit is about to be exhausted, or you are changing your system hardware.

Generally, the reason for using QuickBooks desktop condense data utility is to reduce the company file size. However, in certain situations, the file size can remain unchanged. The utility generally removes transaction details and lists entries in order to reduce the size. There will be no major impact if your data is full of inventory items or open transactions. Many users have been using this utility to repair damage affecting your company file.

There is no sure assured guarantee that the damage will be fixed using Quickbooks Condense Data Utility. In case it does not work, try restoring the backup company file or creating a new one. If you are still confused about which transactions will be affected and which ones will be not, here is a complete list of all the things that remain unaffected by Quickbooks Condense Data Utility Backing up your company file is important before you use QuickBooks condense data utility. Your application will ask you to do it before you actually use it.

Follow these steps to use the utility In case you want to find out when your company file was condensed, you just need to go through these simple steps So now we hope that you know all the required things about Quickbooks condense data utility. We discussed why companies are using it, What to do if QuickBooks condense data tool not working, and all the important things one should know before using it.

In case you are facing any difficulty following the given instructions to truncate the transaction log greyed out. As per the norm, when the company file size reaches about 1GB or more, it is the correct time to condense data. QuickBooks Desktop Enterprise and older , targets. QuickBooks Desktop for Mac , targets. QuickBooks Desktop Pro and Premier and older , targets. When you condense a file: QuickBooks The overall file size is reduced and you get to keep all your data and details.

QuickBooks and earlier: Some transactions are archived and turned into Journal Entries. Journal Entries generate targets as well. Reports may not match after condensing a file. Make sure to store either file in a safe place. See Use the Condense Data utility for more information. Mac: Press CMD? Check the Total Targets number. Select Yes to the message Budget data may be moved during cleanup. Do you want to continue anyway? In the Condense Data window, select Transactions before a specific date.

Use the Date field to select a date. QuickBooks will remove closed transactions on or before the date you choose. That way, your average cost for items will remain correct. Select Next. Select a method to summarize the transactions you’re removing then Next. If you’re not sure, select Help me choose. Optional Select any of the check boxes for the dialog boxes that follow then select Next.

Select Begin Condense. Select Yes below the message ” Budget data may be moved during cleanup. Select Begin Cleanup. Select OK below the message about making a backup before cleaning up the data file. Select File then Utilities and then Condense Data. Select OK. A message appears telling you that QuickBooks will make a backup file before it condenses the transactions. Select OK to create the backup file. The backup file ensures that you will still have a record of the details of any transactions that QuickBooks removes from your company file.

Resolve possible issues after importing the condensed file Creating a portable company file Select the File menu then choose Create Copy. Select Portable Company File then choose Next. Save the portable company file to your desktop or create a new folder on your computer. The portable company file is saved with a.

 
 

 

Condense your QuickBooks Desktop file for import to QuickBooks Online.

 
Select File then Utilities and then Condense Data. Select OK once the backup is complete. In the long run, you may find the few extra dollars you spend bring with them fewer difficulties and headaches than condensing does. Do any of the following: Repair the damaged transactions and rerun Condense Data; Use the restored company file without rerunning Condense Data; or Create a new company file. QuickBooks converts the portable file to a regular company file with a.

 
 

– Quickbooks desktop condense data

 
 

Not Effective in all company file size If you are using inventory items, then your list will not be reduced. Not to Repair the File Damage Sometimes users try to condense the file size to fix the file damage. Transactions which are not removed by using QB Condense Data Utility Tool As mentioned in the second point that there are some transactions which are not removed.

Payroll Transactions: Transactions is not removed if the data is before the last day of the year or unreviewed W2 of an employee. Invoices, payments, credit memos, and refund checks are not removed if they are not linked.

Bills, bill payment checks, and bill credits are not removed if not linked to each other. Transactions linked to a non-condensable transaction. Certain Reports are also affected for the condense period only. Now go to Utilities and select Condense Data option. Choose the Transactions before a specific date option. Enter the appropriate date. You must mark the optional box and select Next. Make sure to click on Summarize inventory transactions recommended. After that, select how your inventory will be condensed, click Next.

Remove the transaction groups and click Next. Further, click on Begin Condense. It will not start condensing now but will only run the report. Step 2- Prepare your Company File Now, you must prepare your company file for condensing: Remove the closing date of your data file by the following steps: Launch QuickBooks and go to the Edit menu.

Click on Preferences, and then select the Company Preferences. Finally, click, OK. Step 3- Edit the transactions You must edit the transactions that are entered before your company starting date.

To find them, run the Profit and Loss and Balance Sheet utilities. Now, under Chart of Accounts, re-sort the lists. Run the Rebuild and Verify Data Utility to ensure zero data damage.

Step 4- Create backup of your company file Create a backup of your company file and copy it to a secure location. Accrual-based Profit and Loss for all the dates. Need to make changes or updates to your accounts or subscriptions?

Visit the Account Management Page. QuickBooksHelp Intuit. Targets do. To convert your Desktop data to QuickBooks Online, the Desktop file must be less than the following limits: QuickBooks Desktop Enterprise with latest releases and newer , targets.

QuickBooks Desktop Pro and Premier with latest releases and newer , targets. QuickBooks Desktop Enterprise and older , targets. QuickBooks Desktop for Mac , targets. QuickBooks Desktop Pro and Premier and older , targets. When you condense a file: QuickBooks The overall file size is reduced and you get to keep all your data and details. QuickBooks and earlier: Some transactions are archived and turned into Journal Entries.

Journal Entries generate targets as well. Reports may not match after condensing a file. Make sure to store either file in a safe place. See Use the Condense Data utility for more information. Mac: Press CMD? Check the Total Targets number. Select Yes to the message Budget data may be moved during cleanup.

Do you want to continue anyway? In the Condense Data window, select Transactions before a specific date. Use the Date field to select a date.

QuickBooks will remove closed transactions on or before the date you choose. 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. In QB Desktop , 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:. Important Note : To check for discrepancies, use the comparison reports that you printed and if you find any, then:.

We hope that the content will be relevant to your queries and helps you to perform the mentioned actions and processes successfully. Your email address will not be published. Save my name, email, and website in this browser for the next time I comment. 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? Check out these points: 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. 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. 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. Invoices, payments, credit memos , and refund checks If not linked to each other. Bills, bill payment checks, and bill credits If not linked to each other. Transactions linked to a non-condensable transaction.

It also affects certain reports for the condense period only. For QB Desktop 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. To run the report go through the following steps: Open QuickBooks and select File tab.

Go to Utilities and select Condense Data option. Choose the Transactions before a specific date option and enter the appropriate date. Check-mark the optional box and select Next. Click on Summarize inventory transactions recommended and select how your inventory will be condensed, later click Next.