Level 7

Question

How to import bank transactions using excel.

Forum|Forum|7 years ago
December 11, 2018
12 replies
15 views

I am trying to import bank transactions from a bank that does not support Web Connect.

- My bank only allows downloads for Excel, Comma Separated Values, Micrsoft Money, and Quicken. My quickbooks only allows import for IIF File, Quicken, and Web Connect, none of which I have.

I don't not have Quicken or IIF. I only have Excel and Numbers(almost identical program).

Is there any way to download or convert the Excel file so I can import in quickbooks.

I have been at this for MONTHS!! HELP!!!!!!!!!!!

Many thanks,
Shelby

QuickBooks Desktop

L

lindak1119Author

Level 7

Hi Shelby,
Did you ever get this problem solved? I am having the same issue. The account I need to import has over a thousand transactions. Any insight would be greatly appreciated.

Thanks!
Heather

L

lindak1119Author

Level 7

Generally one does not import excel files into quickbooks.

the reason being an excel file needs to be converted into a file Quickbooks
and read..   And in my opinion is not worth the effort, to set up the file the way
QB can import the file.   Of course this applies to accountant, someone who is
IT trained, i am sure it fairly simple.

Therefore if the volume of transactions is large.   You may need help from an IT person to show you how to import an excel file.

L

lindak1119Author

Level 7

Ok, thanks!

My file is not very large. I don't understand why I am having this issue. I have downloaded IIF trial and that thing is a joke. I only need to import this list of transactions once, so I do not want to spend $100 on a program. Where are all my hackers at? Haha

I have tried to save the file in every way possible. I get the error message below when trying to import:

"QuickBooks was not able to complete your request.
Please contact your financial institution.
(OL-222)"

J

justin6

You're with US Bank, huh? I hate them.

There is a way to import large amount of data, once you get used to it, its quick too.

http://support.quickbooks.intuit.com/support/pages/inproducthelp/core/qb2k12/contentpackage/thirdparty/excel/data_in_use_templates.html?family=pro

S

shortib

Yes. Client has US bank and I need to get 1099s out, so I don't have time to hand enter a years worth of data.

ANy bright ideas?

The link you posted doesn't load.

K

KimberlyS

Moderator

I purchased moneythumb onetime purchase. It’s easy to use and set up however I am about to lose my mind because when I go to import it says

"QuickBooks is unable to verify the Financial Institution information for this download."

If I could just figure out how to resolve this issue I would 100% recommend moneythumb. I can not tell you how many hours of my life I have spent trying to resolve this. I use qbdt 2024 enterprises for contractors and I am trying to import a years worth of credit card transactions one month at a time using the web connect so that I can assign the correct accounts to each transaction and set up rules for future imports. Fifth Third corporate credit card with multiple sub accounts but only interested in uploading everything under one credit card account since moneythumb allows me to select the card user and add there name too the end of the memo line. If anyone knows how to resolve this error I continue to receive, I would be so appreciative of your help. Fingers crossed.

We appreciate you providing detailed information regarding your concern, Leslie_P. The error indicates an issue with Web Connect caused by incomplete bank files or incompatible formats. Let's dive into the troubleshooting together so you can bring your transactions to QuickBooks Desktop.

Please know that Web Connect can only read .qbo files. Any changes with your data or from your bank can cause issues when attempting to import them into QuickBooks.

To get this resolved, you'll want to ensure you download a .qbo file from your bank and not within QuickBooks. After that, switch your bank feeds mode before starting the importing process. Here's how:

In the Banking menu, choose Bank Feeds.
Select Change Bank Feeds Mode, then Classic mode (Register mode)
Hit OK so you can begin importing your .qbo file.

If the same behavior persists, proceed to Step 4 in this article to determine if the issue was in your company file for additional troubleshooting: Fix Web Connect import errors.

Moreover, we can't guarantee that you'll not encounter any compatibility issues with the tool you're using to convert your bank data. Thus, you'll want to look for another converter tool compatible with the program or manually enter each of your financial dealings.

Once your transactions are uploaded, post them to appropriate accounts for tracking. You can also create rules to streamline the categorization process. After that, consider reconciling your accounts regularly to keep them balanced for accurate reporting and tax calculation.

If you have other questions when importing credit card transactions, post your queries in this forum again or use the Reply button below. We're here to ensure all your queries are addressed by providing appropriate and timely responses.

AlcaeusF

Level 14

Hello there, kane_2.

I appreciate you for reaching out to the Community. I'm here to provide additional clarification with using QuickBooks Desktop.

The import and export process for QuickBooks Desktop for Windows and Mac is different. For users using the Windows version, they can only import list in the CSV format.

For additional insights, I'm adding this article: Import/export CSV files.

If you're now having issues with the import function in the Mac version, I recommend you give us a call. One of our Phone Support Specialists will need to check your program settings and set up to ensure it'll work at its best.

You can reach them through these steps:

Go to: https://help.quickbooks.intuit.com/en_US/contact#
Select QuickBooks Mac Desktop.
Select a topic.
Scroll down and click Get Phone Number.

Please be sure to let me know if there's anything else I can do to help you succeed.

A

Artslover

You attached an article how to import/export csv file but that article only lets you download an exe file which is a Windows file, but you replied to person who was using a Mac. Please update the article.

M

mox

I'm going to give this a try. I'll let you know

https://quickbooks.intuit.com/community/Banking-and-bank-feeds/How-to-import-bank-transactions-using-Excel-CSV-files/m-p/185578

A

Anton Bondar

Hello boltonalloys ! Business Importer Desktop app is made to import Excel and CSV files into QuickBooks Desktop. It has 14-days free trial, hope it will help you save your time!

BigRedConsulting

Level 15

RE: Is there any way to download or convert the Excel file so I can import in quickbooks. I have been at this for MONTHS!! HELP!!!!!!!!!!!

Yes, there are a couple of ways you can do this by converting the Excel or CSV file (opened in Excel) to another file format.

To convert it to an .OFX/.QBO file for import using bank feeds, use our BRC Excel to OFX/QFX/QBO Converter

To convert it to an IIF file to import directly into your bank (or credit card) registers, use our BRC IIF Transaction Creator

N

neilw60

I use a third party program to convert the file ...

Very easy ... using a program to convert the Quicken file to a QBO file (type of OFX cleaner).

I am not sure if I am allowed to disclose the name of the program ...

I believe it is worth the extra cost.

Thanks ...

A

AccountingAtEvergreen

I don't know why this works BUT...for Quicken .qfx files, simply download the .qfx file...open with Notepad...scroll down to where you see "<INTU.BID>4411" (the number 4411 may be different depending on the bank), change the 4 digit number to 3000. Now save the document and change the extension to .qbo and voila! It uploads as a QBO file!

A

AccountingAtEvergreen

I don't know why this works BUT...for Quicken .qfx files, simply download the .qfx file...open with Notepad...scroll down to where you see "<INTU.BID>4411" (the number 4411 may be different depending on the bank), change the 4 digit number to 3000. Now save the document and change the extension to .qbo and voila! It uploads as a QBO file!

N

numbers123

This discussion is talking about QUICKBOOKS DESKTOP not Quicken

After all these months no answer on this except to buy a 3rd party converter. It would be good to have some guidance from intuit.

Show more replies

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded