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

  1. Click on “Business Overview” on sidebar
  2. Click on “Reports”
  3. Click on “Customer Contact List” report
  4. Click on “Customize”
  5. Under “Rows/Columns” select "None" from "Group by"
  6. Under “Rows/Columns” click on “Change columns”
  7. Under “Select and reorder columns” select the following:
    • Customer
    • Phone Numbers
    • Email
    • 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
  8. Click “Run report”
  9. Click export icon and click “Export to Excel” (you may need to scroll the report to the right)

Customers Balance Summary

  1. Click on “Business Overview” on sidebar
  2. Click on “Reports”
  3. Click on “Customer Balance Summary” report
  4. Click on “Customize”
  5. Under “Report period” select “All Dates”
  6. Uncheck “Except zero amount”
  7. Click “Run report”
  8. Click export icon and click “Export to Excel” (you may need to scroll the report to the right)

Transaction List by Customer

  1. Click on “Business Overview” on sidebar
  2. Click on “Reports”
  3. Click on report “Transaction List by Customer”
  4. Click on “Customize”
  5. Under “Report period” select “All Dates”
  6. Under “Rows/Columns”
  7. Select “None” for “Group by”
  8. Click on “Change columns”
  9. 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
  1. Click on “Run report”
  2. Click export icon and click “Export to Excel” (you may need to scroll the report to the right)

Transaction Detail By Account

  1. Click on “Business Overview” on sidebar
  2. Click on “Reports”
  3. Click on “Transaction Detail by Account” report
  4. Click on “Customize”
  5. Under “Accounting method” click on “Accrual”
  6. Under "Rows/Columns" select "None" from "Group by"
  7. Click on “Change columns”
  8. 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
  9. Under “Report period” select "Custom"
  10. Enter a start and end date for the whole first year you used Quickbooks
  11. Click on “Run report”
  12. Ensure report does not say "This report is too large to export completely.  Please use Customize to filter."
  13. Click export icon and click “Export to Excel” (you may need to scroll the report to the right)
  14. Click on "Customize"
  15. Under "Report period" enter date range for the following year
  16. Run and export the Report ensuring report does not say "This report is too large to export completely.  Please use Customize to filter."
  17. Repeat steps 14-16 until date range includes current date

Product/Service List

  1. Click on “Business Overview” on sidebar
  2. Click on “Reports”
  3. Click on “Product/Service List” report
  4. Click on “Customize”
  5. Under "Rows/Columns" click on “Change columns”
  6. Under “Select and reorder columns” select the following:
    • Product/Service
    • Type
    • Description
    • Price
    • Cost
    • Create Date
    • Last Modified
  7. Click on “Run report”
  8. Click export icon and click “Export to Excel” (you may need to scroll the report to the right)