What Is the Company File Diagnostic Tool and How Do I Use It?

Intuit’s QuickBooks Company File Diagostic Tool is designed to diagnose and repair problems that prevent a company file from opening. The tool is a program that you can download from Intuit, install on the same computer where the company file is located, and run. The program only works on company files (.qbw) from QuickBooks 2006 [...]

What Is the Connection Diagnostic Tool and How Do I Use It?

The QuickBooks Connection Diagnostic Tool is a program to troubleshoot errors you might receive when opening a QuickBooks company file (.qbw) in a multi-user environment. It only works with QuickBooks 2008 or newer and Enterprise Solutions 8.0 or newer. It’s designed to troubleshoot error codes H202, H505, and 6000 series errors, such as error code [...]

Does Intuit Offer Support For IIF Files?

Unfortunately, no. Intuit’s policy is stated in this Intuit knowledgebase article. Intuit Interchange Files are delimited text files that can be used to import and export data when working with a QuickBooks company file (.qbw). While the ability to use IIF files is still included in QuickBooks, most newer programs have adopted techniques that make [...]

What Are the Capabilities of IIF Files?

Intuit Interchange Format (IIF) files are delimited text files used for import and export operations with Intuit data files, such as a QuickBooks company file (.qbw). In QuickBooks, IIF files have some important limitations, which are discussed in this Intuit knowledgebase article. These files: can’t be used to import linked transactions, such as a link [...]

Can I Import Data to QuickBooks From Microsoft Excel?

Yes, subject to certain limitations. You can only import list data into 1 of 4 lists: Customers Vendors Items Accounts You can import either in Microsoft’s supported workbook format (.xls or .xlsx, depending on your version of Excel) or CSV format. Intuit offers a free Import Excel and CSV Toolkit, which includes a PDF manual, [...]

How Do I Determine My QuickBooks Version and Release?

To determine the version and release of QuickBooks, press F2 (or alternately, Ctrl + 1) while QuickBooks is running to display the Product Information window. The Product field shows the version and release at the top left of the window. In the example below, Enterprise Solutions: Accountant 10.0 is the version and R6P is the [...]

What Does the Clean Up Company Data Utility Do?

The Clean Up Company Data… utility performs 2 functions: selectively summarizes closed transactions by creating new general journal entries by month and deletes the summarized transactions selectively removes unused list items, including accounts, items, customers, vendors, other names, and To Do notes The Clean Up utility can accomplish several important goals: improve performance by reducing [...]

What Are the Effects of Running the Clean Up Utility?

When the Clean Up utility is run, the effects on a company file (.qbw) can be significant. The goals of the Clean Up utility are to shrink the company file size and to make using that file more efficient. These gains come with some trade-offs. Important considerations when using the Clean Up utility are: Transaction [...]