Walkthrough to Use the QuickBooks Condense Data Tool

1
(No Transcript)
2
Walkthrough to Use the QuickBooks Condense Data
Tool

• The Condense Data feature is a recent addition to
  QuickBooks Desktop. This tool helps in the
  reduction of the file size. Notably, helps
  preserve transactions and the company file data
  remains unaltered. The current discussion shall
  explain all about the QuickBooks condense data
  tool and the different including its advantages
  and the process to use it. So, keep reading.

3
Advantages of QuickBooks Condense Data Utility

• The major advantages of this tool are
• The audit trails can be deleted easily using this
  tool.
• The Company files can be retrieved pretty easily.
• Removes redundant transactions while preserving
  essential ones.
• Provides a detailed summary of complex
  transactions.

4

• Procedure for using the QuickBooks Condense
  Repair Tool

• This tool can be used by the performing the
  following steps

5
Step 1 Identify Non-Condensable Transactions

• Identification of non-condensable transactions is
  the first step. The walkthrough below should help
  you
• Click on Run Any Report option to locate
  non-condensable files.
• Place checkmarks beside transactions not to be
  condensed.

6
Step 2 Condense QB File to Run the Report

• Now, go for the condensation of the QuickBooks
  file. The steps are
• Go to File in QuickBooks and from there, click on
  Utilities.
• Now, tap on the option to Condense Data.
• After that, use the Wizard tool and click on
  Transaction before specific date.
• Click on the option to Summarize Inventory
  Transactions and specify condensing preferences.
• Choose transactions to delete and proceed with
  condensing.

7
Step 3 Prepare the Company File

• The next step is the Company file preparation.
  This can be done as follows
• Go to the Accounting tab. There, click on Company
  Preference and set the closing date.
• Erase 'Data' from the 'closing data' box. Then
  click on Ok.
• View profit and loss or balance sheet.
• Use 'Run rebuild and verify the data utility' to
  make sure that data integrity issues are not
  existing.

8
Step 4 Track the Comparison Report

• Create PDF copies of essential reports Cash Flow
  Statement, Balance Sheet, Profit Loss, Accounts
  Payable Receivable.

9
Step 5 Condensing procedure for the Company File

• Perform the following steps to condense the
  Company file
• Run the Condense Data Utility.
• Go to the File menu.
• Head for Utilities.
• Go to the Condense Data option.
• Abide by the preferences and then start
  condensing.
• Review the Pre and Post Condensed files for
  comparison.

10
Steps for Quality Check after Condensing

• The quality check for condensed data should be
  performed. The steps for this are
• Click on re-run for printing the reports.
• Examine the Profit and Loss to ensure a balanced
  sheet.
• Address any differences, reviewing alleged
  transactions.
• Click on Repair damaged transactions and re-run
  compress data to restore backup.

11
Winding up!

• This article subsumes all the information related
  to QuickBooks Condense data tool and the process
  to use it. If you find any technical issue while
  performing the steps discussed in this blog, then
  feel free to call us at the helpline
  1-800-7614-1787.

12
Source https//qbsservices.ucoz.net/blog/walk
through_to_use_the_quickbooks_condense_data_tool/2
023-12-19-18