In order to import your data from Quickbooks Online please export the following 5 reports.
NOTE: Quickbooks Online Essentials plan is required to run Transaction List by Customer and Transaction Detail By Account reports.
TABLE OF CONTENTS
- Customer Contact List
- Customers Balance Summary
- Transaction List by Customer
- Transaction Detail By Account
- Product/Service List
Customer Contact List
- Click on “Business Overview” on sidebar
- Click on “Reports”
- Click on “Customer Contact List” report
- Click on “Customize”
- Under “Rows/Columns” select "None" from "Group by"
- Under “Rows/Columns” click on “Change columns”
- Under “Select and reorder columns” select the following:
- Customer
- Phone Numbers
- Full Name
- Phone
- Company Name
- Note
- Billing Street
- Billing City
- Billing State
- Billing ZIP
- Billing Country
- Shipping Street
- Shipping City
- Shipping State
- Shipping ZIP
- Shipping Country
- Last Name
- First Name
- Click “Run report”
- Click export icon and click “Export to Excel” (you may need to scroll the report to the right)
Customers Balance Summary
- Click on “Business Overview” on sidebar
- Click on “Reports”
- Click on “Customer Balance Summary” report
- Click on “Customize”
- Under “Report period” select “All Dates”
- Uncheck “Except zero amount”
- Click “Run report”
- Click export icon and click “Export to Excel” (you may need to scroll the report to the right)
Transaction List by Customer
- Click on “Business Overview” on sidebar
- Click on “Reports”
- Click on report “Transaction List by Customer”
- Click on “Customize”
- Under “Report period” select “All Dates”
- Under “Rows/Columns”
- Select “None” for “Group by”
- Click on “Change columns”
- Under “Select and reorder columns” select the following:
- Date
- Transaction Type
- Num
- Posting
- Memo/Description
- Account
- Amount
- Customer
- Ref #
- Open Balance
- A/R Paid
- Invoice Date
- Customer/Vendor Message
- Due Date
- Create Date
- Last Modified
- Payment Method
- Click on “Run report”
- Click export icon and click “Export to Excel” (you may need to scroll the report to the right)
Transaction Detail By Account
- Click on “Business Overview” on sidebar
- Click on “Reports”
- Click on “Transaction Detail by Account” report
- Click on “Customize”
- Under “Accounting method” click on “Accrual”
- Under "Rows/Columns" select "None" from "Group by"
- Click on “Change columns”
- Under “Select and reorder columns” select the following:
- Date
- Transaction Type
- Num
- Name
- Memo/Description
- Amount
- Balance
- Create Date
- Last Modified
- Customer
- Qty
- Rate
- Account
- Payment Method
- A/R Paid
- Due Date
- Open Balance
- Debit
- Credit
- Product/Service
- Under “Report period” select "Custom"
- Enter a start and end date for the whole first year you used Quickbooks
- Click on “Run report”
- Ensure report does not say "This report is too large to export completely. Please use Customize to filter."
- Click export icon and click “Export to Excel” (you may need to scroll the report to the right)
- Click on "Customize"
- Under "Report period" enter date range for the following year
- Run and export the Report ensuring report does not say "This report is too large to export completely. Please use Customize to filter."
- Repeat steps 14-16 until date range includes current date
Product/Service List
- Click on “Business Overview” on sidebar
- Click on “Reports”
- Click on “Product/Service List” report
- Click on “Customize”
- Under "Rows/Columns" click on “Change columns”
- Under “Select and reorder columns” select the following:
- Product/Service
- Type
- Description
- Price
- Cost
- Create Date
- Last Modified
- Click on “Run report”
- Click export icon and click “Export to Excel” (you may need to scroll the report to the right)