cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

Unable to import bank statement correctly

Hello, I'm trying to import bank statement as a CSV file. The file contains two tricky columns (the rest of columns are fine): they show type of operation (credit/debit) and amount respectively. How can I import that file correctly? I do see an option with "one column" (expecting negative numbers possible) and "two columns" (expecting two columns with credit numbers and debit numbers).. neither option works for me. In my case I need to decide whether amount is credit or debit based on value of another column. Is it ever possible with intuit? The same works for me in Zoho Books.

Thanks,
Alexey.

Solved
Best answer 10-16-2018

Accepted Solutions
QuickBooks Team

Re: Unable to import bank statement correctly

Good day, azotsit.

 

Thanks for posting in the Community. I want to make sure you're able to import your bank transactions as a CSV file in QuickBooks Online.

 

When importing bank transactions using a CSV file(comma-separated values), take note of the accepted CSV file template format. It should contain the following information: Date, Description and Amount.

 

To successfully import the transactions, edit your CSV file using Microsoft Excel and follow either of the format showing in this article: https://community.intuit.com/articles/1458636.

 

Once the format is followed correctly, you’ll be able to import your bank transactions via CSV file without any issue.

 

Feel free to reach out to me if there’s anything else you need. I’ll be here to help. Enjoy your day!

View solution in original post

7 Comments
QuickBooks Team

Re: Unable to import bank statement correctly

Good day, azotsit.

 

Thanks for posting in the Community. I want to make sure you're able to import your bank transactions as a CSV file in QuickBooks Online.

 

When importing bank transactions using a CSV file(comma-separated values), take note of the accepted CSV file template format. It should contain the following information: Date, Description and Amount.

 

To successfully import the transactions, edit your CSV file using Microsoft Excel and follow either of the format showing in this article: https://community.intuit.com/articles/1458636.

 

Once the format is followed correctly, you’ll be able to import your bank transactions via CSV file without any issue.

 

Feel free to reach out to me if there’s anything else you need. I’ll be here to help. Enjoy your day!

View solution in original post

Level 1

Re: Unable to import bank statement correctly

Hello!

 

Everything I'm seeing offers resolution to importing for QuickBooks ONLINE. I have the QuickBooks desktop version and I'm having troubles uploading even with the proper formatting as described. The bank feed DOES work, however, it only provides me with the last 90 days of bank transactions, so I'm attempting to upload the remaining transactions manually but have had no luck. 

 

Please help!

QuickBooks Team

Re: Unable to import bank statement correctly

I'm glad you joined the thread, DZDInc.

 

Luck is on your side today! Manually importing bank transactions in QuickBooks is my specialty, so I'd be delighted to lend you a hand in uploading your transactions.

 

The feature that will allow us to download more than 90 days worth of data is called WebConnect, and there are two ways to use it. We can either do it from outside or inside QuickBooks.

 

The following steps will guide you on how to do it outside the program:

  1. Open a web browser and access your bank's website.
  2. Log into your bank account using your User ID and PIN or password.
  3. Download your transactions via QuickBooks Web Connect (.QBO) file.
  4. Import the file to QuickBooks.

Here's how you can do it inside:

  1. Open QuickBooks.
  2. Access your bank's website within the program.
  3. From the Banking menu, select Bank Feeds then Bank Feeds Center.
  4. Choose the appropriate bank.
  5. Click Download Transactions.
  6. A browser window will open and will display your bank's website. Enter your User ID and PIN or password.

I'm including a great article with more in-depth information about this: Download Bank Feed transactions

 

That should do it! Of course, I want to ensure that this is taken care of for you, so please let me know how it goes by posting a reply. Wishing you all the best.

Level 1

Re: Unable to import bank statement correctly

Hello, 

 

Thank you for your assistance, however, this is not particularly helpful. My bank does not offer a QBO download option. I am offered only PDF, Excel and CSV. I downloaded the transactions in a CSV file, formatted based on the article provided (Three columns; Date, Description, Amount), changed the file extension to QBO to allow QB Desktop to find it and still no luck. It goes through the motions as if it was successful but the transactions are not in the system. What am I missing? Is there a character limitation on the "Description" column? Even then, wouldn't it upload the transactions that meet the parameters and leave the others? Or at least give me an error?

Anonymous
Not applicable

Re: Unable to import bank statement correctly

Hello again, @DZDInc.

 

Thank you for providing information about importing bank statements. I can help route you to the right direction in importing these transactions in QB Desktop.

 

You can use the Intuit Interchange Format (.IIF) file when importing transactions to and from different platforms. Using this format, you can import lists such as chart of accounts, item, payment method, budgets, and others. For transactions, you can import checks, deposits, credit card transactions and so on.

 

Here's a helpful article for the steps you'll need to follow when importing IIF files in QuickBooks: https://community.intuit.com/articles/1762781-export-or-import-iif-files.

 

As always, you can contact our Desktop Care Support if you need assistance with the steps. They'll be able to pull up your account in a secure environment and help you navigate using one of their tools.

 

Here's how to get their contact information: 

  1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose your QuickBooks Product.
  3. Select your QuickBooks Version.
  4. On the Contact Us page, click a topic.
  5. Click on the Get Phone Number button to see the support number.

That should do it. I'll be here to help if you have other questions about importing transactions in QB Desktop. Feel free to visit us us if you need anything else.

Level 1

Re: Unable to import bank statement correctly

My CSV file comes four columns - with amount, the dr/cr in column four.  I am struggling and getting a duplicate record error.

QuickBooks Team

Re: Unable to import bank statement correctly

Hi eemersonbioM,

 

When you map your CSV file, you'll want to select the 2 Column option for the amount. Then, specify which column is for Money Spent and for Money Received. Please do not select a column name twice to avoid an error about duplicate mappings. The column name will show in the fields indicated. Please check the detailed steps in this article: How to import bank transactions using Excel CSV files.

 

 

You can always get in touch with us if you have other questions.

Need to get in touch?

Contact us