Export Accounting
The following accounting reports will need to be exported out of QuickBooks for import into CDM+.
Transaction Detail Report
Chart of Accounts Report
Vendor Contact List Report
Employee Contact List Report
The Following Balance Sheets:
Balance Sheet as of the ending date of the year prior to the earliest year of data transferring
Balance Sheet as of the beginning date of your current fiscal year
Balance Sheet as of the ending date of your transactions
Transaction Detail Report
Go to Reports
Within Quickbooks navigate to the “Reports” menu. This can usually be found at the top of the Quickbooks window
Choose Transaction Detail Report
In the Reports menu, locate and select the “Transaction Detail” report
3. Set Report Dates
Once you've selected the Transaction Detail report, you'll be prompted to set the report dates. Choose the date range for which you want to view transactions
4. Customize Report
Please customize the report to include the following columns:
Trans #
Type
Entered/Last Modified
Date
Num
Name
Memo
Account
Class
Clr
Split
Debit
Credit
Amount
Check #
5. Run Report
Once your report is customized to contain the aforementioned data points, click on the “Run Report” button to generate the Transaction Detail Report
6. Save Report
Click the “Export” button, select “Excel” as the export format
Chart of Accounts Report
1. Navigate to Reports
Within Quickbooks navigate to the “Reports” menu. This can usually be found at the top of the Quickbooks window
2. Choose Chart of Accounts Report
In the Reports menu, locate and select the “Chart of Accounts” report
3. Customize Report
Please customize the report to include the following columns:
Account
Type
Balance Total
Description
Acct. #
Tax Line
4. Run Report
Once your report is customized to contain the aforementioned data points, click on the “Run Report” button to generate the Chart of Accounts Report
5. Save Report
Click the “Export” button, select “Excel” as the export format
Vendor Contact List Report
1. Navigate to Reports
Within Quickbooks navigate to the “Reports” menu. This can usually be found at the top of the Quickbooks window
2. Choose Vendor Contact List Report
In the Reports menu, locate and select the “Vendor Contact List” report
3. Customize Report
Please customize the report to include the following columns:
Vendor Code
Vendor Name
Vendor Bill from Address1
Vendor Bill from Address2
Vendor Bill from City
Vendor Bill from State
Vendor Bill from Zip
Vendor Phone
4. Run Report
Once your report is customized to contain the aforementioned data points, click on the “Run Report” button to generate the Vendor Listing Report
5. Save Report
Click the “Export” button, select “Excel” as the export format
Employee Contact List Report
1. Navigate to Reports
Within Quickbooks navigate to the “Reports” menu. This can usually be found at the top of the Quickbooks window
2. Choose Employee Contact List Report
In the Reports menu, locate and select the “Employee Contact List” report
3. Customize Report
Please customize the report to include the following columns:
Employee ID (optional)
Employee First Name
Employee Middle Name
Employee Last Name
Employee Birthdate
Employee SSN#
Employee Address1
Employee Address2
Employee City
Employee State
Employee Zip
Employee Email
Employee Phone
4. Run Report
Once your report is customized to contain the aforementioned data points, click on the “Run Report” button to generate the Employee Listing Report
5. Save Report
Click the “Export” button, select “Excel” as the export format
Balance Sheets
1. Navigate to Reports
Within Quickbooks navigate to the “Reports” menu. This can usually be found at the top of the Quickbooks window
2. Choose Balance Sheet Report
In the Reports menu, locate and select the “Balance Sheet” report
3. Set the Report Date
In order to capture all of the necessary data please generate a balance sheet as of:
The ending date of the year prior to the earliest year of data being transferred (i.e. if you are transferring data beginning on 1/1/2018, this report would be from 12/31/2017)
The beginning date of your current fiscal year
The ending date of your transactions
4. Run Report
Once your report is customized to contain the aforementioned data points, click on the “Run Report” button to generate the Balance Sheet Report. Please do this for each of the above mentioned balance sheets
Save Report
Click the “Export” button, select “Excel” as the export format