Import and export data in QuickBooks Desktop
by Intuit•1• 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 suppliers.
You can export reports, general journal entries, and customer and supplier lists.
Here are some lists and transaction types you can import into QuickBooks.
Ways to import and export info in QuickBooks
With MS Excel
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 an Accountant if you need one.
- Check out the Intuit Marketplace to see apps that help you import data.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Export data out of QuickBooks Onlineby QuickBooks•13•Updated January 29, 2024
- Export reports, lists, and other data from QuickBooks Onlineby QuickBooks•125•Updated 1 month ago
- Common questions about importing data to QuickBooks Onlineby QuickBooks•66•Updated May 30, 2024
- Import products and services into QuickBooks Onlineby QuickBooks•82•Updated 1 month ago
- Manually upload transactions into QuickBooksby QuickBooks•324•Updated 1 month ago