Use the CS QuickBooks Data Utility
You can use the data utility when Quickbooks can't open your client data during the import process (such as when your Quickbooks is installed in a different location).
Complete the following steps to:
- Install the CS QuickBooks Data Utility v.15.0 or later for use with the QuickBooks Pro, Premier, or Enterprise editions currently supported by Intuit.
- Create an export file containing your company’s QuickBooks data for the date range to give or transmit to your accountant.
- Import adjustment data from your accountant’sAccounting CSapplication into QuickBooks, if requested to do so by your accountant.
Install the CS QuickBooks Data Utility
note
For Virtual Office CS, go to the My Product Downloads page of our website and download the CS QuickBooks Data Utility.
Complete the following steps to install the CS QuickBooks Data Utility on the same network drive or workstation where your QuickBooks application is installed.
- Save theqbdatautilityfile to your Windows desktop.
- To begin the installation, double select theqbdatautilityfile on your desktop.noteIf a previous version of the utility is already installed on your machine, theApplication Maintenancewindow will briefly show and automatically uninstall the old version before installing the new one. No confirmation window will show upon completion.
- To create a desktop shortcut, go to the following path:C:\Program Files (x86)\Creative Solutions\QB Data Utility
- After the utility has been successfully installed, you can delete theqbdatautilityfile from your Windows desktop.
Create an export file from QuickBooks
- Open QuickBooks, but not your QBW company file.
- Double select theCS QuickBooks Data Utilityicon on your desktop. This opens theCS QuickBooks Data Utilitywindow.
- SelectExport data to Accountant.
- Specify the date range to include in the export file by doing either of the following, as directed by your accountant.
- Select 1 of the following from theDatesdropdown:
- This Month
- This Calendar Quarter
- This Calendar Year
- Last Month
- Last Calendar Quarter
- Last Calendar Year
- SelectCustomfrom theDatesdropdown and specify theFrom / Todates using the MMDDYY format.
- In the 1st file location field, enter or go to the file location for your QuickBooks company data file (QBW).
- In the 2nd file location field, enter or go to the location where you want to save the export file.
- Open your QBW company file in QuickBooks.
- SelectExportin the CS QuickBooks Data Utility.
- TheQuickBooks - Application Certificatewindow opens automatically in QuickBooks.
- SelectYes, always; allow access even if QuickBooks is not running.
- Mark theAllow this application to access personal data such as Social Security Numbers and customer credit card informationcheckbox. (This is to make sure that any payroll data present in the QuickBooks company data will be included in the export file.)
- SelectContinue.
- At the confirmation window, selectDoneto complete the creation of the export file.
note
The name of the export file created by the utility includes the date range specified by the user plus the QuickBooks company name (for example, CSExport from 01-01-YY to 12-31-YY Company Name.QBW.qbexportdata).
Send the export file to your accountant
You can transmit a copy of the export file to your accountant in whatever manner you and your accountant have agreed upon. For example, you can copy the export file to removable media to give or send to your accountant, or you can attach it to an email message to your accountant.
Import data from your accountant into QuickBooks
Your accountant may occasionally need to send you a file with transaction adjustments for you to import into QuickBooks.
note
If the file is in IIF format, you should be able to import that file directly into QuickBooks. However, if the file from your accountant is called
QBgenxfer<clientID><date><time>.xml
, you'll need to use the following steps to import the file from your accountant.- Open QuickBooks, but not your QBW company file.
- Double select theCS QuickBooks Data Utilityicon on your desktop.
- In the CS QuickBooks Data Utility, selectRetrieve data from Accountant.
- Enter or go to the folder location for your QuickBooks company data file (QBW).
- Enter or go to the folder location for the file to be retrieved.
- SelectRetrieve.
- Open your QBW company file in QuickBooks.
- TheQuickBooks – Application Certificatewindow opens automatically in QuickBooks.
- SelectYes, always; allow access even if QuickBooks is not running.
- Mark theAllow this application to access personal data such as Social Security Numbers and customer credit card informationcheckbox.
- SelectContinue.
- At the confirmation prompt, selectDoneto complete the retrieval process.