Import Transactions into QuickBooks

You can import transactions into QuickBooks from various file types including Excel, CSV and IIF. Further, you can import bank transactions with QBO files or by connecting your bank account to QuickBooks desktop or online. Since you’ve several options, I’ll be going through each of them. Depending upon your current scenario, you can choose the solution that fits your needs and proceed to import transactions to your version of QuickBooks. Before you begin, make sure that you choose the correct platform and version of the program for the right steps. After importing transactions, you can take a few other steps to ensure integrity of your financial information, but more on this later. Let’s get started.

In this post, you’ll learn how to import transactions into QuickBooks.

Import Transactions into Quickbooks Desktop from Excel

When you record an invoice or journal entry in QuickBooks Desktop, the data is stored as a transaction. If you have the transaction details stored in an excel file, then you can change the file type after you’ve formatted the data according to the structure required by QuickBooks Desktop. You can then import the transaction data into QuickBooks Desktop.

As no direct way to import transactions from Excel exist in QuickBooks Desktop, you’ve to rely on this clever workaround that’s surely going to obviate the need to import a lot of transactions into QuickBooks Desktop:

• Phase 1: export an Excel file containing transaction data from QuickBooks desktop.
• Phase 2: use the format of the exported file to format the file that you want to import, and then begin the import process.

1. Steps to export transactions from QuickBooks Desktop:

1. Launch QuickBooks Desktop and use an admin account to log into your company file.
2. From the Customers menu, go to the Customer Center, then the Transactions tab.
3. Choose Invoices, then Apply Filters.
4. Click on Run Reports.
5. Choose to Create a New Worksheet when the export window appears.
6. Click on Ok, then Export.
7. Use Excel to view the format in which QuickBooks Desktop stores transactions, and use this same format for your transactions.

2. Steps to import transactions into QuickBooks Desktop:

1. After you’re done formatting the transaction data in Excel, you can Choose File menu in Microsoft Excel.
2. Then Choose Save As.
3. Remove the extension from the end of the file name, and don’t choose a file type.
4. Click on Save.
5. Right click on the excel file, and add the extension IIF at the end of the file name.
6. Choose Yes to confirm the change of file type.
7. Back in QuickBooks Desktop, click on the File option from the main menu.
8. From the Import option, Choose IIF File.
9. Choose Browse and select the file containing your transaction data.
10. Choose Open. When you’re ready to import the data, click on Ok.

Caution

Creating a backup file is highly recommended before you import transactions in QuickBooks Desktop because reversing the procedure manually can take a long time. And interruption to the process can cause further problems in your company file. To prevent any mishap, follow these steps to back up your company file:

1. Switch to Single-user mode from the File menu.
2. Click on File, then Choose Back Up Company.
3. Choose Create Local Backup, then Local Backup in the window that appears.
4. Click on Next.
5. Choose Browse and select the directory where you want to save the backup file.
6. Click on Save it Now, then Next.
7. Choose Finish.

Import Transactions into Quickbooks Accountants or Enterprise

Only QuickBooks Desktop and Enterprise have the batch import transactions option. This feature lets the user quickly import upto 1,000 transactions at once. You can use a CSV or an Excel file to import your data. But you should note that this feature isn’t available in Pro and Premier versions of QuickBooks.

Steps to batch enter transactions from Excel into QuickBooks Desktop Enterprise or Accountant:

1. Follow one of the two options:
   1. In QuickBooks Accountant, choose the Accountant menu.
   2. In QuickBooks Desktop, choose the Customers menu.
2. From the available options, Choose Batch Enter Transactions.
3. Select one of the transaction types:
   1. Checks
   2. Deposits
   3. Credit Card Charges & Credits
   4. Bills & Bill Credits
   5. Invoices & Credit Memos
4. You can change the account to which these transactions are recorded by selecting the A/R account option.
5. Before you paste data, you can choose to Customize Columns to alter the fields – you can both add or remove fields and even rearrange them to match the format to that of the transaction data saved in your company file.
6. Launch the excel file containing the transaction data.
7. Copy all of the data from the Excel file and Paste it into the Import Transactions window.
8. Wait for QuickBooks to Validate the data. Add details for all the data points marked red.
9. Click on Save Transactions to complete the import process.

Batch enter transactions utility is quite helpful and obviates the need to rely on an add-on. But it can only import 1,000 transactions at once, so you will have to repeat the steps if you want to import more transactions than the limit.

Import Transactions into Quickbooks Mac

QuickBooks Mac, with its entirely different user interface, has a completely different set of steps for importing transactions. But in some ways, the process to import transactions from excel into QuickBooks Mac is easier. You can use the same steps to import transactions into QuickBooks Mac Plus.

Steps to import transactions into QuickBooks Mac:

1. Launch QuickBooks for Mac and log into the company file as an admin.
2. Choose the File option from the main menu.
3. Click on the Import option, then Transactions.
4. Choose the Type of Transactions that you’ll import.
5. Go to the Gear Icon, then choose Export Table Template.
   Note: this template will help you format your excel sheet that contains the transactions data.
6. Save the sample file and launch it using a spreadsheet program.
7. Format your transactions data in the same format as in the sample file.
8. In QuickBooks for Mac, click again on File, then Import, then Transactions.
9. Choose type of transactions.
10. Then copy all the transactions from the spreadsheet file.
11. Paste the transaction data into the import window in QuickBooks Mac.
12. Once you’ve verified your data, click on Import.

You can later use reports to verify that you’ve imported the correct file.

Import Transactions into Quickbooks Online

You can use Excel or CSV files to transfer your transaction data into QuickBooks online. You can also map these transactions to the appropriate bank account. And if the bank account is already connected to QuickBooks online, then you can even enable the sync feature so that all the transactions are automatically recorded in your accounting software.

1. Steps to import transactions from Excel or CSV file into QuickBooks online:

1. Ensure that your transactions are formatted properly.
2. Sign into QuickBooks online using an admin account.
3. From the Dashboard on the main screen, choose Banking.
4. Click on Select Files, then browse and select the Excel or CSV File containing the transactions data.
5. Hit the dropdown menu titled QuickBooks account, then choose an account to link the transactions to. Click on Continue to move on to the next step.
6. Go through the on-screen instructions and follow accordingly to map the transaction details to correct fields in QuickBooks. Choose continue.
7. Mark all the transactions that you want to import in QuickBooks online, then choose Continue.
8. Click on Yes, then Done.

2. Import Transactions into Quickbooks Desktop from CSV File

CSV files are simple text files that contain data separated by comma. These files can be accessed using a spreadsheet program. If you’ve your transaction data stored in a CSV file, you can use the QuickBooks Import Excel and CSV toolkit, provided by Intuit, to import this data into QuickBooks Desktop.

Steps to import transactions from CSV file into QuickBooks Desktop using the toolkit:

1. After downloading the QuickBooks Import Excel and CSV toolkit setup, double click on it to launch it.
2. In the installation window, choose Browse and select a location for extracting the toolkit files. Choose Ok.
3. Click on Unzip. The files for the toolkit will be extracted to the selected location on your system.
4. Click on Close, then open the folder containing the extracted files for the toolkit.
5. Open the Sample Files folder and use the provided template to format your transactions data.
6. Launch the tool, then click on Browse and select the CSV File with the transaction data.
7. Click on Import.
8. Use reports in QuickBooks Desktop to ensure that the data was successfully imported.

You can also convert your CSV files to Excel format using a spreadsheet program. This doesn’t actually give you any advantage, but it is still an option.

3. Import Transactions into Quickbooks from One Company File to Another

If you want to transfer transactions from one QuickBooks company file to the other, then instead of Excel files, you should rely on IIF files. Importing transactions from Excel can be a difficult task, and importing an IIF file is a lot easier than importing an excel file.

Steps to export transactions from a company file in QuickBooks Desktop:

1. Launch QuickBooks Desktop and log into the company file as an admin.
2. From the File menu, click on Utilities, then Export.
3. Choose Transactions to IIF Files.
4. Choose the transactions to include in the exported file, then click on Ok.
5. Choose the Save In drop-down option and select the directory for storing the exported file.
6. Click on Save after entering a name for the file.

Steps to import an IIF file into QuickBooks Desktop:

1. From the File menu, click on Utilities, then Import.
2. Choose Import IIF.
3. Browse and select the IIF file with the transaction data.
4. Click on Open, then Ok to begin the import process.

Import Type of Transactions into QuickBooks

1. Import Bank Transactions Into Quickbooks Desktop

Instead of Excel, you should use the QBO file format to import bank transactions into QuickBooks Desktop. Both CSV files and Excel files aren’t a good fit for these transaction types. Further, QuickBooks Desktop has an inbuilt feature to import bank transactions when they’re in QBO format.

Steps to import bank transactions into QuickBooks Desktop:

1. From the File menu, click on Utilities, then Import.
2. Choose Web Connect Files.
3. Choose the QBO File that contains the bank transactions.
4. Click on Open, then Ok.
5. Choose the Bank Account associated with the transactions, then click on Continue.
6. Click on Ok when the success message appears.

You can further simplify the process to import transactions by connecting your bank account with QuickBooks Desktop. Then, you’ll have the option to sync the data directly from your bank account so that you don’t have to manually download bank transactions and then import them into QuickBooks Desktop.

2. Import Credit Card Transactions Into QuickBooks

Like bank transactions, credit card transactions should also be imported using the QBO file format. Most banks enable you to export the data in this format so that you can later import the transactions into your accounting software.

Steps to import credit card transactions into QuickBooks Desktop:

1. From the File menu, click on Utilities, then Import.
2. Choose Web Connect Files.
3. Choose the QBO File that contains the credit card transactions.
4. Click on Open, then Ok.
5. Choose the Bank Account associated with the credit card transactions, then click on Continue.
6. Click on Ok when the success message appears.

3. Import Stripe Transactions Into QuickBooks

To import stripe transactions into QuickBooks Desktop, you can use the stripe app from the Intuit Marketplace. Once you’ve added the app to QuickBooks Desktop, your transactions from strips will be automatically synced with QuickBooks Desktop.

Steps to integrate the Stripe app into QuickBooks Desktop:

1. Log into your QuickBooks Desktop company file as an admin.
2. From the Help menu, click on App Center:Find More Business Solutions.
3. Click on the Search field in the Apps for QuickBooks Desktop Marketplace window.
4. Input Stripe and hit enter.
5. Choose the Strip integration app and configure it to automatically sync data with QuickBooks Desktop.

Stripe also enables you to export the transaction details in IIF format, which as you know can be easily imported into QuickBooks Desktop. You can find the IIF export option in the Legacy exports settings. 

If you need to merge your bank account with the Stripe Checking account in QuickBooks Desktop, then follow these steps:

1. From the Lists menu, choose Chart of Accounts.
2. Make both the accounts on the same level.
3. Choose the Stripe Checking Account.
4. Choose Account, then click on Edit Account, in the Chart of Accounts window.
5. Input the name of your bank account.
6. Click on Save.
7. Choose Yes to merge the two accounts in QuickBooks Desktop.

All the transaction data from the Stripe Cheking account will be migrated to your actual bank account.

4. Import Paypal Transactions Into Quickbooks

You can export paypal account history in IIF file format. You can narrow down the search of transactions by entering a date range. When you export the account history, the transactions within the specified date range are exported to the selected file type – IIF file in this case. QuickBooks Desktop has an inbuilt utility to import IIF Files.

Steps to import PayPal transactions into QuickBooks Desktop:

1. Log into your Paypal account.
2. Choose History from the My Account menu.
3. Click on Download History.
4. Input Date Range for the transactions that you want to import into QuickBooks Desktop.
5. Click on File Types for Download.
6. Choose QuickBooks (.iif).
7. Click on the Download History button.
8. Choose a location to store the file and click on Save.
9. Log into your QuickBooks company file as an admin.
10. Go to the File menu, then click on Utilities.
11. Choose Import, then Import IIF.
12. Browse and select the IIF file that you downloaded from your Paypal account.
13. Click on Open.
14. Choose Ok when the confirmation message appears.

5. Import Bank of America Transactions Into Quickbooks

Bank of America, like many other banks, enables you to export your transactions in Web Connect format. Once you’ve exported your transactions data, you can import them into QuickBooks Desktop easily.

Steps to import bank of America bank transactions into QuickBooks Desktop:

1. Log into your Bank of America account.
2. Choose the Account whose data you want to import into QuickBooks Desktop.
3. Click on Download, then input the Transaction Period or enter a Custom Date Range.
4. In the File Type option, choose WEB Connect for Quicken 2017 and above.
5. Click on Download transactions.
6. Log into your QuickBooks Desktop company file as an admin.
7. From the File menu, click on Utilities, then Import.
8. Choose Web Connect Files.
9. Choose the QBO (web connect) File that you exported from your Bank of America account.
10. Click on Open, then Ok.
11. Choose the Bank Account associated with the transactions – in this case, the Bank of America account. Then click on Continue.
12. Click on Ok when the success message appears.

6. Import Square Transactions Into QuickBooks

Square doesn’t enable you to export your transactions data in IIF file format nor in QBO format. So you’ve to work with an Excel or CSV file in this case.

Steps to import square transactions into QuickBooks Desktop:

1. Sign into your Square account.
2. Choose Sales from the left menu bar.
3. Go to the Transactions tab and choose the transactions that you want to export.
4. Click on Export.
5. Choose Transactions CSV.
6. Log into your QuickBooks company file using an admin account.
7. From the File menu, click on Import, then Transactions.
8. Choose Sales Receipts.
9. Choose Import from the Square icon in the Sales Receipts window.
10. Choose the Bank Account that stores Square transactions in QuickBooks Desktop.
11. Input the tax rate for square transactions.
12. Click on Ok, then on Import.

If you face any difficulty while performing the operation or need some assistance with any QuickBooks related problem, we recommend you get to in touch with our AccountingErrors QuickBooks help-team on ✆.

FAQ