Learn how to import or export your data files with QuickBooks desktop:

If you are in search of a process to import and export data in QuickBooks desktop, then you have landed on the right place. In order to access information, the user might think the only option being starting from scratch, but the fun fact is that the user can also transfer information to and from QuickBooks. This process not only makes it simpler for the user to convert, upgrade, or create new company file, but also saves a lot of time that the user can invest in more important tasks. The process to import and export data in QuickBooks involves a few basic steps, which we will be discussing later on in this post. So, make sure that you stay connected to the article till the end, and do not miss out any of the steps.

Moreover, the user can also get in touch with our QuickBooks support team for any further assistance. You can ring up at our toll-free number i.e. 1-800-761-1787, and ask our experts and certified accounting professionals for importing and exporting data in QuickBooks desktop. Our team can aid in your endeavor and resolve all your accounting related issues.

You may also see: How to Register or Activate QuickBooks Desktop?

Brief into Import and export data

Talking about the importing data, the user can easily import things like the bank transactions, accountant’s changes, general journal entries, and batch transactions. The user can also import the customers and vendors. Moreover, the same can be exported, like the general journal entries, customer and vendor lists, etc. We will be having a look at some lists and transactions types that the user can import into QuickBooks.

Lists the user can import

The list of information the user can import is huge. Let us have a look at the elements that the user can import without any issue.

  • Charts of accounts
  • Vendor types
  • Employees
  • Items
  • Shipping methods
  • To dos
  • Notes
  • Sales tax codes
  • Customers and customer: jobs
  • Other names
  • Classes
  • Payment terms
  • Customer messages
  • Sales reports
  • Vendors
  • Budgets
  • Payment methods
  • Customer and job types
  • Price levels

Transactions that can be imported

Now talking about the transactions that can be imported, we have listed them below, have a look:

  • Account beginning balances
  • Cash sales to customers
  • Checks
  • Deposits
  • Invoices
  • Account transfers of funds
  • Vendor bills
  • Estimates
  • Payments from customers
  • Vendor bills refunds
  • Purchase orders
  • General journal entries
  • Credit memos to customers
  • Credit card refunds to customers

Points to remember

There are certain points that the user should remember, at the time of exporting and importing data in QuickBooks. Let us check out some of the most important ones:

  • As the user is not allowed to undo info imported, they should make a backup of your data files for safety purposes
  • Also, the user should also speak to the accountant before importing the data
  • Another important thing is to check out the Intuit marketplace to look for the apps that can assist you in importing the dat.

You may also see: How to Use QuickBooks Conversion Tool?

Process to import and Export Info in QuickBooks desktop

The process might differ for the item to import and export, so we will be exploring the steps for different items one by one:

MS EXCEL

The standard import process for MS excel involves a few basic steps. QuickBooks opens up a formatted excel spreadsheet, where the user can enter the information. At the time when the users save and close the file, they can review results and view data in QuickBooks. To import customers, vendors, and products, the steps below can be incorporated:

  • The very first step is to visit the file menu, and then select the utilities option and then hit import
  • Also, click the Excel files
Import Excel Files in QuickBooks desktop - Screenshot Image
  • And then, if the user gets Add or edit multiple list entries window, then he/she is supposed to click no
  • And then follow the wizard in importing files
    • For this choose the type of data
    • QuickBooks opens a formatted excel spreadsheet. After you have entered the information, saved the file and closed it, the user will be given the option to Add My Data Now.
    • And then, review results and view data in QuickBooks
    • End it by selecting the close option when done

The point to be noted here is that if you need to import additional customer, vendor or item data from excel using this option, getting back to this window option is always available.

Using CSV files

In order to import a list in the CSV format, the user needs to install the QuickBooks import excel and CSV toolkit. The tool kit will have the following components:

  • Import from Excel and CSV Manual- A pdf document with instructions, best practices and notes
  • XLS example folder- A sample excel file containing 4 worksheets, one for each type of list
  • Allowed fields- a reference guide explain what fields are available for the excel and CSV import
  • CSV examples folder- sample CSV files, one for each type of list

For exporting the CSV files, if the user is not having MS excel installed on the system or if MS excel is not installed on the system or if the user wishes to view and edit the data using a different format.

Customer and vendors

  • The very first step is to open the customer/vendor centre
  • And then select the excel drop down, then select:
    • Export customer/vendor list: if the user wishes to export the customer data such as name, balance, or the contact information
    • And Export transactions: If the user wishes to export transactions
  • Now, in the export window, the user needs to select the create a comma separated values file
  • And then click on export option
Create a comma separated values file - Screenshot Image
  • And also, assign a file name, and then select the location where you wish to save the file
  • Also, locate, open and edit the file if needed

Reports

  • For this, the user needs to open the report option
  • And then go for the excel drop down at the top of the report
  • The next step is to choose the create new worksheet
Create new worksheet - Screenshot Image
  • Also, opt for create a comma separated values file on the send report to excel window
Create a comma separated values file - Screenshot Image
  • The next step is to select export
  • And then assign the file name, also select the location to save the file
  • And also, locate, open, edit the file as per the requirements

Read Also: How to Crack QuickBooks Admin Password?

Import and export IIFs

The steps to export IIFs are as follows:

  • The very first step is to sign in the company file as an admin
  • And then visit the file menu and also opt for switch to single user mode option
  • The next step is to visit the file menu and then choose the utilities tab and then hit export option. Also, select the export IIF files
Export iif files in QuickBooks desktop - Screenshot Image
  • Moving ahead, the user needs to opt for the location to save the IIF from the save in drop down.
  • After that, the user needs to enter a name in the file menu and also select save
  • The last step is to select OK button.

The steps to import IIFs

  • The initial step is to sign in the company file as an admin
  • And then move to file and opt for the switch to single user mode
  • The next step is to make a backup of the company file. The user can restore it if the data doesn’t import the way it was expected to
  • After that, the user needs to move to file menu and opt for the utilities and import option. Also, select the import IIF files
Exporting the file to excel - Screenshot
  • And browse to the IIF file. Also, select it and open
  • The last step is to select Ok to confirm the data imported

Importing batch transactions from the accountant

QuickBooks batch enter transactions - Screenshot Image

The process to import batch transactions from the accountant involves the following steps:

  • The very first step is to select the batch enter transactions from the accountant menu
  • And then, from the transaction type drop down, the users need to select the transactions, they need to enter. The user will have the option to enter multiple checks, deposits, credit card charges or credits, invoices, credit memos, bills and bill credits, but only in the supported versions of QuickBooks
  • The next step is to opt for the appropriate bank / credit card or AR/AP account from the down arrow. The user can also select the Add new to set up the account.
  • Moving ahead, the user needs to open the spreadsheet containing the transactions to paste it to QuickBooks
  • And then, the user needs to arrange the columns in the spreadsheet to match the column order in the QuickBooks batch enter transactions screen
  • The next step is to highlight the transactional information, and then right click it and also select the copy option
  • Followed by right clicking the first date field in the list and select paste in the batch enter transactions screen
  • Now, the information from the spreadsheet will display the batch enter transactions screen
  • And then continue with the steps to add all transactions
  • The next step is to select save transactions option and also hit yes to save
  • To end the process, the user needs to select OK to finish the import

It should be noted that the batch transactions cannot be exported, but the user can copy multiple transactions from the company file to another in a form that can be imported using the enter batch transactions feature.

See Also: How to Access QuickBooks Desktop Remotely?

Conclusion!

The list of steps for importing and exporting different data in QuickBooks desktop doesn’t end over here. You can give us a call at our toll-free number i.e. 1-800-761-1787, if any of your query remained unanswered.

You can also contact us, if you want our experts and certified accounting professionals to carry out the export and import process in QuickBooks desktop on your behalf. Our 24/7 QuickBooks enterprise support team will be happy to help you.

 

More Resources

How to Fix QuickBooks Balance Sheet Out of Balance Error?

How to Troubleshoot QuickBooks Unrecoverable Error?