Showing results for 
Search instead for 
Did you mean: 

Import and export data in QuickBooks Desktop

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 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 an accountant if you need one.
  • Check out the Intuit Marketplace to see apps that help you import data.

Was this helpful?

You must sign in to vote, reply, or post
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us