How to Import Transactions from Excel into QuickBooks?

June 8, 2023

How to Import Transactions from Excel into QuickBooks Online

If you are using the QuickBooks application, sometimes you are required to add data from some external sources. QuickBooks allows you to add the data from Excel. Adding data from QuickBooks is not at all difficult. This article explains how to Import Transactions into QuickBooks Desktop from Excel and Import transactions into QuickBooks Online from Excel.

Save Time, Reduce Errors, and Improve Accuracy

Dancing Numbers helps small businesses, entrepreneurs, and CPAs to do smart transferring of data to and from QuickBooks Desktop. Utilize import, export, and delete services of Dancing Numbers software.

*No credit card required

What All Transactions Can You Import on QuickBooks?

Importing transactions in QuickBooks helps you to save time as you are not required to start from scratch. You can import many things as listed below.

  • Bank Transactions
  • Accountants Changes
  • Items
  • To do
  • Notes
  • Classes
  • Vendor Types
  • Sales Types
  • Budgets
  • Payments Terms etc.

There are many transactions that you can import such as:

  • Account Beginning Balances
  • Checks
  • Cash Sales
  • Invoices
  • Deposits
  • Vendor Bills
  • Estimates
  • Payments from customers
  • Vendor bill refunds
  • Purchase order etc.

Points to Remember Before Your Import Transactions into QuickBooks from Excel

You need to keep the following points in mind while you Import Transactions into QuickBooks from Excel:

  • Back up the QuickBooks company file without overwriting any prior backups before importing any data.
  • You must disable Multiple Inventory Sites before importing item quantities or values if you have Advanced Inventory and Multiple Inventory Sites enabled.
  • You may create a Quantity On Hand (QOH) and a Value on Hand (VOH) for new inventory items, as well as an average cost.
  • Adjust Quantity/Value on Hand is entered in QuickBooks, debiting the item’s asset account and crediting Opening Balance Equity.
  • Subtotal, Payment, and Sales tax items cannot be imported using the Advanced Import feature, however, they may be imported using an IIF File.

Import Transactions into QuickBooks Online Using Dancing Numbers Online

You can import, export, and delete your transactions from XLS/XLSX/CSV files into your QuickBooks Online account using Dancing Numbers Online. Also, you can use our Dancing Numbers (Online) Application to monitor the import’s progress and fully control it thanks to a variety of features.

Steps for Importing Transactions into QuickBooks Online

To upload your files you have to follow the below steps.

  • You have to login into Dancing Numbers Online using a QuickBooks Online username and password or you can use Dancing Numbers username and password.
  • On the left side menu, you have to select the Upload link.
  • By dropping the file into Drop Zone you can upload a Text File or Excel File. Here multiple files can also be uploaded.
  • Select the sheet name, in case the file contains multiple sheets.
  • Now you have to select the QuickBooks Online Entity for the selected sheet.
  • When you upload a file using one of our suggested template files (such as the Sample template for Imports), QuickBooks Online fields will automatically be mapped. If you chose any other formats then you have to map the fields.
  • You can review your field mappings on the next page. By clicking on each cell you can edit the cell values.
  • By clicking the SETTINGS button you can change the import settings.
  • To continue you have to click the Upload button.
  • You may learn more about the QuickBooks import procedure from the progress bar. Visit the Progress Bar area at any moment to see the status of the uploaded files.
  • The Results Page allows you to check the status of each imported transaction.

Supported File Formats for QuickBooks Import

Supported File Formats for QuickBooks Import

The following file types are supported.

  • Text File (.txt or .csv) (Only Comma Separated delimiter supported)
  • Excel Workbook (.xlsx)
  • Spreadsheet (.xls)

Excel Versions supported by Dancing Numbers

The following Excel Versions are supported:

Excel 2003Excel 2007Excel 2013Excel 2016

Alternate Ways to Import Transactions into QuickBooks?

If you have files in different formats, you have to change them into Excel and then import it into your QuickBooks account. Here are the different ways in which you can Import your Transactions into QuickBooks:

How to Import Transactions into QuickBooks Desktop from Excel

Below are the standard steps mentioned to Import the transactions from Excel:

  • First of all, select the account for which you need to upload the transactions.
  • Select the Next button to proceed further.
  • A bank account can be added if it is not available or does not exist.
  • A New Bank account can be added using Add new button which is available just above the drop-down list.
  • Perform the column mapping in the CSV File to QuickBooks.
  • Make sure to map the correct file, failing this can lead to importing the data incorrectly.
  • You can indicate the CSV file’s first row as a header row using a button available there.
  • Now choose that credits and debits are in one column or two-column.
  • If credits and debits are in a different column then you are required to map the column accordingly.
  • After completion of Mapping click Next to continue.
  • Now you will see a window that helps you to see a preview of transactions that are going to import.
  • Make sure that the data showing should be correct by data comparison in this window.
  • Now click Next.
  • You will see a message showing how many transactions will be imported.
  • If you are already ready to import the report then click the yes button to continue.
  • Click No if you are not ready to submit the transactions.
  • If you will click No then you have to follow the import process from start again.
  • Once the Import process is done you will ask to accept the transactions.
  • Now click Let’s Go.
  • Finally, you will be sent to the Bank screen to start matching the transactions.

How to Import CSV Files using QuickBooks Import Excel and CSV Toolkit

To import the list in CSV format install the QuickBooks Import Excel and CSV toolkit. This tool kit contains.

  • Allowed Fields: This is a reference field that contains fields for Excel and CSV Import.
  • XLS Example Folder: Contains Excel sample file having 4 worksheets each for every type of list.
  • CSV Example Folder: 4 sample file lists each for one.
  • Import from Excel and CSV Manual: Contains a PDF document with Practice, Notes, and instructions.

Steps to Install the QuickBooks Import Excel and CSV Toolkit

  • First, for the toolkit open the file download Windows and save it.
  • Now go to your Windows Desktop and save.
  • Once you save it, Locate QuickBooks_Import_Excel_and_CSV.exe on the Windows desktop after it opens the WinZip self-extractor window.
  • Click Browse and choose the folder in which you want to install the toolkit, then select OK.
  • To see and extract the contents choose to unzip and then close the WinZip self-extractor window open.
  • Finally, open the QuickBooks Import Excel and CSV folder which has been selected in the above steps.

How to Import Transactions into QuickBooks Online from Excel Through .QBO Format

Importing transactions into QuickBooks using .QBO format can be done by using the below steps.

  • First of all sign in to your bank account.
  • Download the transactions .QBO format.
  • Now, go to the File menu in QuickBooks Desktop.
  • Choose Utilities and go to Import.
  • Select Web Connect files.
  • Click on the .QBO file and then click the Open button.
  • Choose your bank account and continue.
  • You will see a message coming to your screen saying that data is successfully read into QuickBooks.
  • Finally, click ok and go to the Bank Feed center.

Importing transactions into QuickBooks is one of the best features. Using this feature you don’t require to start from scratch and anyone can easily import the transactions. This article helps you to understand how to import transactions into QuickBooks from Excel. Hopefully, the above-mentioned steps will help you to easily import your transactions in QuickBooks.

However, if you are still stuck or have any queries; you can get in touch with the QuickBooks customer helpdesk. All the professionals are highly educated, trained, and certified to provide the best solutions for QuickBooks.

Accounting Professionals, CPA, Enterprises, Owners
Accounting Professionals

Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.


Frequently Asked Questions (Faqs)

Before Importing Your Transactions into QuickBooks from Excel, it is Important to Create a Backup of Your Data?

Yes, It’s important to create a backup of your data before importing your Transactions into QuickBooks from Excel. To make a backup manually, follow these steps:

  • In your QuickBooks accounting software.
  • Navigate to the File menu.
  • If you are not in single-user mode, click Switch to Single-User Mode.
  • Click the File menu once more.
  • Now select the option to backup the company file now.
  • You must select the option, make a local backup
  • Then, Once the window appears on your screen, click the Next button on it.
  • Once done you must choose a location to save the backup.
  • Set the number of backups you wish to make as well.
  • When you have finished selecting your files, click the OK button.
  • Then go to the Save it Now option.
  • Now click the Next button.
  • Finally, You have completed your manual backup.

While You Import Transactions into QuickBooks from Excel, What All File Format Does QuickBooks Support?

QuickBooks can only read transactions from CSV, QFX, QBO, OFX, or TXT files, among other supported formats. These files are normally downloaded from your bank.

How to Perform the Column Mapping while you Import Transactions into QuickBooks from Excel?

When you map your accounts, QuickBooks understand how to import data from your Excel sheet. Since the column headers in QuickBooks and Excel may differ, you will need to match them.

  • Enter a name for the mapping.
  • Account should be selected as the Import type.
  • Match the column titles in your Excel document to the information in QuickBooks.
  • Select the Save option.

News about SaaS Industry

Cion Digital, a Blockchain SaaS Startup, Raises $12 Million from Green Visor

In a seed funding round, Cion Digital has closed $12 million. The US-based company is planning to open an R&D centre in Pune. The capital will be used for R&D and crypto expansion. The solutions we develop will help big retailers and other industries transform their businesses.

close btn

Get Your Case Study

Call Now +1-800-596-0806
Top