cancel
Showing results for 
Search instead for 
Did you mean: 

Reply to message

View discussion in a popup

Replying to:
QuickBooks Team

Reply to message

Welcome and thank you for joining the thread, @Snderitu.

 

Allow me to share some information about importing bank feeds transactions in QuickBooks Desktop (QBDT).

 

Instead of starting from scratch, QBDT allows us to import/export data. You can transfer information to and from QuickBooks in case you need to convert, upgrade or create a new company file. Before importing, make sure to identify the transaction type and file format to ensure that QuickBooks will be able to handle them. QuickBooks allows us to import/export list to and from MS Excel. 

 

Importing of bank feeds transaction in QBDT uses the web connect (.QBO) files and not .IIF, you can only import transactions like invoices, bills, checks, and others using the .IIF files. Web connect (.QBO) files are online banking transactions from your bank's website, this can be downloaded and saved on your computer. Afterwards, you can import the transactions so they become available in your bank feeds. The multi-currency feature should be turned on in QBDT so you can import foreign currency bank transactions. I recommend backing up your company file before proceeding with the steps below.

 

To turn on Multi-currency:

 

  1. Click Edit at the top menu bar.
  2. Select Preferences.
  3. On the left-pane, select Multiple Currencies.
  4. Go to the Company Preferences tab.
  5. Select Yes, I use more than one currency.
  6. From the drop-down, select your home currency.
  7. Click OK to save the changes.

To import web connect (.qbo) files:

 

  1. Go to the File menu.
  2. Select Utilities.
  3. Click Import.
  4. Select Web Connect Files.
  5. Select the QBO file you saved, then select Open.
  6. When prompted to select bank account, select Use an existing QuickBooks account if the account you are importing the transactions into is already set up in QuickBooks and select Create a new QuickBooks account if the account you are importing the transactions into is not yet in QuickBooks.
  7. Select Continue. You should see a dialogue box telling you that the data has been successfully read into QuickBooks.
  8. Select OK.
  9. Go to the Bank Feeds Center to review your transactions.

You can check these articles for additional reference:

 

 

That would allow you to import bank feeds transactions. Please feel free to add a comment below if you have additional questions about importing transactions. Have a wonderful day!

Need to get in touch?

Contact us