Condensing data in quickbooks desktop. QuickBooks Condense Data Utility to Condense QuickBooks Data

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

It contains all the relevant data of your organization and helps running mostly all of the QuickBooks operations. However, company files those are 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. Are you facing issues in your QuickBooks Company File that are interrupting your daily work schedule?

Call us on 1. 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. Here is a list of other reasons as well. There are certain elements that you must explore before compressing a Company File in QuickBooks. Check out these points:. 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.

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:. Note : Try to fixing every transaction by bringing it to the screen and selecting Apply Credits to link it with existing credits. 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. 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. In order to compress a large QB file in QuickBooks for Mac, close all the QuickBooks windows and go through the following instructions:.

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.

However, if you feel the need for external support of an expert to help you, dial Support Number 1. Client portal:. How to use the client portal. 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. Remove the transaction groups as you wish and click Next. Click on Begin Condense. It will not start condensing as of now but will only run the report. Now, prepare your company file for condensing through the following steps: Remove the closing date of your data file by the following steps: Open QuickBooks and select the Edit menu.

Hit OK. 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.

Under Chart of Accounts , re-sort the lists. Make sure of zero data damage by running the Rebuild and Verify Data Utility.

Make a back up of your company file and copy it to a secure location. Accrual-based Profit and Loss for all the dates. Accrual-based Balance Sheet for all the dates.

Cash Flow statements. Reports recommended by your accountant or adviser otherwise. At last, run the utility to condense data by following these steps: Open QuickBooks and select the File tab. Go to Utilities and choose the Condense Data option. Going through the wizard, you will be asked to condense from the following transactions and list entries.

Choose Help if you face any difficulty. Click on the Begin Condense. Select Utilities and choose the option of Condense Data. Permit to create a backup file and select OK. Access the tool by following the given steps: Open QuickBooks and select the File tab. Click on Utilities and then select Condense Data. 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. Click Next. 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. 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.

 
 

QuickBooks Condense Repair Utility: Fix, Repair QuickBooks Data Error.

 

We have found that most people run into bigger problems by doing this, like not reducing any data, causing some vital data to be compromised or even data being removed without knowing. Is your QuickBooks file slow to open or run? Some common reasons for a slow or clunky QuickBooks experience are:. This sometimes results from an incorrect initial build, but can also happen when you update without checking the file, or when you add plugins and custom programming.

Our team can easily diagnose the problems in your file, open even a badly damaged file, repair the problem, and deliver a clean file back to you. QuickBooks is meant to make running your business easier. These problems can cause irreparable damage to your company file and result in incorrectly reported earnings. Read Case Study. Having performed thousands of QuickBooks implementations and engagements in all fifty states, our team of certified QuickBooks ProAdvisors has knowledge and experience you can rely on in a business partner.

Get help with implementing and optimizing the right QuickBooks solution for your business. Even though QuickBooks is designed to be a general business product, over one million businesses across all kinds of industries in the U.

Alisha Raesz of Fourlane has been a tremendous asset to our company. She has completely overhauled our accounting system and guided us to increased profits by setting up new cost coding and job tracking reports. Her knowledge of QuickBooks and professionalism have helped us rise to the next level. We started with Fourlane specifically for Quickbooks point of sale help. Fourlane was awesome.

They have incredible knowledge of Quickbooks. This year we added another layer of Fourlane help. We hired Fourlane for bookkeeping. We are thrilled that we did. LaTiffany is our day to day contact. She is incredible. Neither the invoice or payment exist any longer in QuickBooks, so the program doesn’t know that an invoice for March 1 was paid on April 1.

A side effect of this impacts Sales Tax reportability. While the condense journal entries created via the Condense Utility credits income for invoices condensed, the details do not exist to determine which portions of that income are taxable and which were non-taxable.

Since the Invoices no longer exist, the details related to sales tax no longer exist including the amount collected for the invoice. Accordingly, sales tax reports will be inaccurate in terms of taxable sales and tax liability. One additional side effect impacts “customer-based” accounts receivable.

A similar situation occurs in terms of Accounts Payable, bills and bill payment checks no longer exist and the expenses are no longer linked to cash payments, so QuickBooks cannot know when to report cash basis related expenses.

Since all detail level reports within QuickBooks draw their data from items within the transactions. They will be in error after a condense since there are no more invoices and bills as well as related transactions , and accordingly, no more transaction item details upon which to build the detail reports. As such, the reports turn out blank. If you use Class tracking, you might as well forget about having comparative financials tied to class. Do you have concerns about the performance of your file due to its size?

It also minimizes the risk of data damage. The updated Condense feature provides an option to remove the audit trail which reduces your file size but leaves all the detailed transactions, unlike the traditional File Condense feature which removes transaction detail and creates a consolidated journal entry for data prior to the selected date. This is also a much faster method that the standard File Condense.

The traditional Condense feature is still available if you prefer to use it. Before Condensing, make sure it’s the best option for your company. Condensing cannot be undone at a later point, so we recommend Condensing after trying all other solutions. Here are some valid reasons to Condense:. If your company file is damaged, try resolving data damage on your company file.

If you use Condense to repair the damage but is unsuccessful, you only have two options:. Your cash basis reports for the Condense period will be inaccurate. Example: If you entered an invoice on February 1 and payment on March 1, the histories will show they are linked.

QuickBooks includes the invoice in cash basis income for March 1. After running Condense Data, the income is Condensed into the February 1 journal entry and the cash is Condensed into the March 1 journal entry.

The invoice and payment no longer exist. QuickBooks does not know that an invoice for February 1 was paid on March 1 or that the invoice and payment ever existed. Any transactions summarized by the utility will not have classes assigned.

Running a Profit and Loss by Class report will show all amounts in the unclassified column. Sales Tax Liability Report Invoices with sales tax no longer exist. A Condensed journal entry has an amount credited to income accounts, but QuickBooks has no way of knowing what part of the income is taxable and which part is non-taxable.

Also, the Tax Collected comes from the invoices, which no longer exist, so it will show zero. These reports draw their data from items on invoices and bills. Since there are no more invoices and bills, there will be no more items and the reports will be blank. The total is zero because all of the invoices in this trivial file are paid. Since Condense removes transactions from your company file, the transactions will also be removed from the Audit Trail report.

Remember that your original reports are preserved in the backup and archive copy, and in any other backups that you create. Before running the Condense, reconcile all accounts, print all reconciliation and discrepancy reports, or save these reports in PDF format, and backup your Company file.

Your current company file does not have the detail and your archive copy does not have the detail. To see how your company is doing this year compared to last year:. QuickBooks will display Archive Copy [date the archive was created] of [company file name] in the title bar while the file is open.

This feature allows you to share bills, payments, information, and much more. QuickBooks allows you to access almost all types of accounts, including but not limited to savings account, checking account, credit card accounts, and money market accounts. We value your privacy and are strongly against any kind of phishing, spam, and malware.

We collect your information for our legitimate business purpose only. This information is safe with our in-built security. Search for:. Schedule a call with us. Schedule Call Here. Get a 7 day free trial now!! Table of Contents. Technical Details Easy Process.

Error Free. On-time Support. Buy Now. Sign Up. It was tedious to enter donations […] Read more The Challenge We are Plano-based IT Company and have more than different classes that we deliver in-person or online […] Read more To track hours and make them more complete was a great challenge […] Read more Frequently Asked Questions.

Get Support Call Now. Chat Now. Close X. If they are not properly linked to one another.

 

Use the Condense Data Utility and Repair QuickBooks Files – QuickBooks 2019 New Option

 
Select Remove all transactions keep lists and preferences.