QuickBooks HelpQuickBooksHelpIntuit

Import and export data in QuickBooks Desktop

by Intuit1 Updated 3 months ago

Learn how to import or export info with QuickBooks Desktop.

Instead of starting from scratch, you can transfer info to and from QuickBooks. This makes it easy if you need to convert, upgrade, or create a new company file.

Import and export overview

You can import things like your bank transactions, accountant’s changes, general journal entries, and batch transactions. You can also import your customers and vendors.

You can export reports, general journal entries, and customer and vendor lists.

Here are some lists and transaction types you can import into QuickBooks.

  • Chart of Accounts
  • Employees
  • Vendor types
  • Items
  • Shipping methods
  • To dos
  • Notes
  • Sales tax codes
  • Customers and customer:jobs
  • Other names
  • Classes
  • Payment terms
  • Customer messages
  • Sales reps
  • Vendors
  • Customer and job types
  • Payment methods
  • Budgets
  • Price levels
  • Account beginning balances
  • Cash sales to customers
  • Checks
  • Deposits
  • Invoices
  • Account transfers of funds
  • Vendor bills
  • Cash refunds to customers
  • Credit card transactions
  • Estimates
  • Payments from customers
  • Vendor bill refunds
  • Credit card refunds to customers
  • Credit memos to customers
  • General journal entries
  • Purchase orders

Ways to import and export info in QuickBooks

With MS Excel

Using CSV files

Import and export invoice and other form templates

Import and export IIFs

Import bank transactions with Web Connect files

Send journal entries back and forth with your accountant

Export your file for your accountant and import accountant changes

Import batch transactions from your accountant

Things to keep in mind when you import and export data

  • Since you can't undo the info you import, you should make a backup just in case.
  • We provide support for basic import and export questions. Consider talking to your accountant before you import data. Or, we can help you find a ProAdvisor if you need one.
  • Check out the Intuit Marketplace to see apps that help you import data.

Error: "To download and import transactions, sign in with your Intuit account"

If you use Advanced Mode in bank feeds, you may need to sign in to your Intuit Account or switch modes

Import of web connect files (.qbo) requires you to sign in to your Intuit Account within QuickBooks Desktop.

QuickBooks Desktop AccountantQuickBooks Desktop Accountant PlusQuickBooks Enterprise QuickBooks Enterprise AccountantQuickBooks Enterprise DiamondQuickBooks Enterprise GoldQuickBooks Enterprise Platinum

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this