How To Import Transactions Into Quickbooks From Excel

Importing bank transaction or statement data is simple when you save direct access to the bank account of the client. However, you need to import old transactions from a few years ago or you might only have PDF or scanned copies of statements.

I recommend you check through them all before you decide which one you’d like to use. The most difficult one would be the amount column. If you have debit and credit, in IIF it must be just the amount. How do you get those minuses and plusses in right place? You would create the amount column in your template and then would enter the formula, as simple as this — which is debit minus credit.

Donor Statements – QB Desktop

The reason why the only account showing on the drop-down menu is the account is due to the system being unable to recognize the Web Connect file you’re trying to import. So it’s providing you a credit card account that isn’t linked to online services yet.

Quickbooks Point of Sale is an accounting program that tracks your small business’ inventory and sales. Unlike Microsoft Excel, which enables you to create any financial tracking system from scratch, Intuit Quickbooks is dedicated software that aims to replace the cash register. If you have recorded inventory or customer information previously using Excel, Quickbooks can import this data into its own files.

Importing Bank Transactions from Excel / CSV to QuickBooks Desktop Accountant or Enterprise

Click the »Convert» button to create a QBO or IIF file. The converter using your CSV/Excel filename and its location as the base name for the new file. You may adjust the filename and its location before converting. The first line in the CSV file should be the header with column names like date, amount, payee, memo, check number. Each transaction should take one line in the CSV/Excel file. Enhance your productivity with automated imports and exports of Invoices, Bills, Journal Entries, Payrolls and other entities from your Excel file into QuickBooks and vice versa.

How To Import Transactions Into Quickbooks From Excel

You can export your transactions from QuickBooks as Excel files with .xlsx or .xls extension, CSV format files. Though Excel is the often imported spreadsheet format, you are not damned to import only Excel files.

QuickBooks: How to Change Inventory to Non-Inventory

SaasAnt Transactions supports excel and text file formats with .xls, .csv and .txt extensions. It lets you review your imports and exports before it does the action. You can preview the transaction, recheck and change your preferences before you import or export. The following are the file formats supported for QuickBooks import. Here is a great way to eliminate manual labour, errors and stress in data entry.

  • Hi Jo Ellen, You could use an data import utility like Zed Axis that can assign Expense Accounts and a whole range of other fields like Class, Billable and Customer.
  • The allowed fields are a reference guide that explains the available fields for CSV and Excel import.
  • Moreover, the same can be exported, like the available journal entries, customer and vendor lists, etc.
  • Create donor thank-you statements ready to print and mail without any additional data entry.
  • Going to the excel check that the configuration of the columns as the spreadsheet should match with the QuickBooks.
  • Allowed fields – a reference guide explain what fields are available for the excel and CSV import.

However, this does not influence our evaluations. Here is a list of our partners and here’s how we make money. Say you need to import a spreadsheet into QuickBooks Online. You might use Microsoft Excel to track critical metrics but use QuickBooks to keep your financial records in order.

We have seen everything that you needed to know about importing and exporting transactions to and from QuickBooks. If you have not tried our application yet, please visit our product page to know more. Or feel free to drop us a line at We will get to you and help you with a demo to get started.

Confirm That QuickBooks Will Import Transactions

Take care here; incorrect mapping will import your transactions incorrectly. Rarely, you might have to disconnect the account from Banking altogether and then reconnect it. Before you proceed with the next step, match or accept any transactions currently waiting for you in the bank feed. Otherwise, How To Import Transactions Into Quickbooks From Excel they will be deleted when you disconnect the account. Sometimes, the bank feed will need to be reconnected. This typically happens when you change your login information with your financial institution. If this happens, click the pencil icon next to the account you need to reconnect.

How do you transfer data from Excel to QuickBooks?

  1. Go to the File menu, select Utilities then Import and then Excel Files.
  2. If you get the Add/Edit Multiple List Entries window, click No.
  3. Follow the wizard in importing files. Select the type of data. QuickBooks opens a formatted excel spreadsheet.

This will usually be the case but double-check your CSV to make sure there isn’t data that needs to be imported in Row 1. You will also need to indicate whether your credits and debits are in one column or two columns . If your debits and credits are in separate columns, you will need to map those columns separately . The Banking feature provides a way to reconcile your business’s bookkeeping to your bank’s records, almost in real-time. There is often a 24-hour lag in updates, depending on how your bank communicates with QuickBooks Online. Transaction Pro offers data mobility tools and services for small businesses and accounting professionals.

Afaik, it has nothing to do with file sharing with software licenses or copyrights. If you are not familiar with IIF, utilize one of these importer tools to import it as Journal Entry. Just hit the Reply button if you have other concerns with importing or with QuickBooks. Firstly, choose Export to Excel from the Drop-Down menu. Firstly, choose the Settings menu and click Import Data. Enter the email address of your PayPal account and then click Next.


Reconcile all the transactions in a single go within QuickBooks. No need for manual reconciliation because you have pushed 100% of the bank data into QuickBooks. Now you are sure that all the back information is in QuickBooks. Now click on customize column button to choose the column you wish to see in Add/edit multiple list entries window. Or you can also select the default button to go back to the Pre-set columns. We have come up with a spectacular application that connects Excel with QuickBooks.

  • Then select “File Upload” from the drop-down menu.
  • Now, you will see the QuickBooks attributes for invoices in default on the left of your screen.
  • You can connect your bank to QuickBooks Desktop by setting up a feed.
  • Although Direct Connect is simpler to implement and use, some users prefer not to link their bank account with QuickBooks Desktop.
  • Transactions are pulled directly from QuickBooks and made ready to import into another company file.
  • Our certified experts made sure to encapsulate in this article all the necessary and relevant data pertaining to importing and exporting different data in QuickBooks desktop.

After you have entered the information, saved the file and closed it, you will be given the option to Add My Data Now. Moreover, you can also get in touch with our QuickBooks support team for any further assistance.

Unlimited Imports

The order shown from top to bottom within the “Chosen Columns” list is the order they will appear from left to right in the window after you click the “OK” button. To reorganize their display, select the name of a column in the “Chosen Columns” list. You can enter details such as the vendor or payee name, a category to file the transaction under and a memo for future reference. If you already have automatic transactions enabled but need to add more dates. When you’re ready, click the “Connect” button to sync your transactions. Correct any transactions that display a number in the Description column. Now that you know what a QuickBooks Import Excel and CSV toolkit is, here are the steps involved in how to import CSV into QuickBooks.

How To Import Transactions Into Quickbooks From Excel

It is SaasAnt Transactions and the role is to import your transaction data from excel files into QuickBooks. Not just importing, SaasAnt Transactions has a great tool for QuickBooks export to Excel as well. Yes, once your account is connected for an online banking connection, the system automatically downloads the recent transaction available from your bank. For 90 days old and older transactions, you need to prepare an Excel .QBO file for them as suggested above, then manually import the file to QuickBooks.

Update to New Built-in Browser for Quickbooks Desktop

You can edit multiple vendors and customers using the specific tool to add or edit the Multiple List Entries tool. Select and sort by the amount, which will give you the amount all in order. Copy all the transactions of debit, then cut and paste in a new sheet sorting with date wise. The dollar sign before the amounts needs to be removed as QuickBooks does not accept the dollar signs. You have an option to indicate that the first row in the CSV file is a header row .

CSV files are known as “comma separated values” format, that’s a simple text file that Excel uses to display a spreadsheet that is not in the Microsoft Excel format. QuickBooks allows you to import CSV files and Excel files into the program. There’s a plugin you must download and install to help you. If you have a lot of data to import into Intuit QuickBooks, there’s no need to waste time entering everything manually. Not only will this take way more time than you have, but it increases the chance for error, which could easily throw off your entire dataset. Check that the column configuration matches excel.

or our TransImporterQO© for QuickBooks Online.

By default, QuickBooks will match the details you enter with other entries from the same vendor. If you don’t want this, you can edit your settings to disable the feature.

Our team can aid in your endeavor and help you in importing and exporting data in QuickBooks desktop. The accounting and bookkeeping process frequently involves data from other systems.

Copy and Paste List Data from Excel into QuickBooks Pro- Instructions

Finally click on Save Transactions, and all the Invoices will be created automatically. Is for names or items not in the QuickBooks Database. To extract the contents, select Unzip, and then Close to close the WinZip Self-Extractor window. Select the QBO file downloaded from the Bank’s website and click on Open. You should always delete any previously added/matched transaction. Direct Connect is an effective method and one on which you can always rely.