Importing bank statements that are in CSV format into Quickbooks Pro 2020

Good day, Matt.

I know you wanted to import historical bank statement into your Chase bank account. I'll provide some tips on how to import them successfully.

The supported file when importing bank transactions is .QBO file in QuickBooks Desktop. You can sign in to your bank and download the transaction as .QBO file since the CSV file isn't an option.

Here's how:

1. In the File menu, choose Utilities, then Import.
2. Click Web Connect Files.
3. Locate the .QBO file you saved, then Open.
4. When prompted to Select Bank Account,
5. Click Continue, then OK.
6. Then, go to the Bank Feeds Center.

Alternatively, you can utilize a third-party application to import your bank statement or convert the CSV file into an IIF file. You can find one using this link: QuickBooks Apps.

For more insight, check out the following resources below:

• Import and export data in QuickBooks Desktop
• Get started with Bank Feeds for QuickBooks Desktop
• Import/export CSV files

Additionally, I've got you this article that can help you accurately reconcile your accounts: Reconcile an account in QuickBooks Desktop.

If you have further questions about bank feeds, let me know. I'm always here to help you.

@Matt_Moore 

You need to use a converter tool. i.e csv2qbo

https://www.moneythumb.com/?ref=110

or use an importer tool

https://get.transactionpro.com/qbd

Thank you but I am not quite there yet.

I have purchased a subscription to Moneythumb and have converted my Bank Statements in .pdf format to Excel  and then save that .xls file to a .csv file using Excel. That file "Test Conversion with minus sign.csv" looks like this except with 87 rows including Date, Payee and Amount as the column headers.

Date,Payee,Amount
9/16/2015,Boles Feed Nacogdoches Nacogdoches TX Card 3523,-66.51
9/21/2015,Boles Feed Nacogdoches Nacogdoches TX Card 3523,-21.90
9/22/2015,Deep East Texas Elec. Bill PPD ID: 1750229997,-135.50

I then used MoneyThumb to convert this .csv file to a .qbo file.

When try to import the .qbo file created above in to Quickbooks using the following steps

Banking>Bank Feeds>Import Web Connect Files (choose the file Test Conversion with minus sign.qbo) I get a dialog box to choose a file which I do.

(Capture one.JPG attached)

I think this is because I previously imported this file (Test Conversion with minus sign.qbo). I then click OK and it takes me to the "Bank Feeds" dialog box which looks like this:

It is at this point I am confused.  What I want to get to is the screen where you actually import the downloaded (my terminology my be wrong) in the the Bank Register and where I can create Import Rules.

(capture two.JPG attached)

Can you help me with this process?  When I go to your website and watch a video I see this screen

(Capture 3.JPG attached)

I do not understand how to get to this stage.

Thanks,

Matt

We appreciate you for being detailed about your concern, Matt_Moore. This information will direct us to the steps required to resolve the error.

Let's double-check the dates for your entries and then switch to Register Mode before uploading your bank data. Before we begin, allow me to share some information about why no transactions are imported:

• The Web Connect file you are trying to import has no new transactions.
• The transactions have been imported already. That is the dates collide leading to error.
• The QuickBooks company file might have been damaged.
• You imported a Statement with a longer date range, then attempted to re-import a statement for dates within that range.

It is possible that the date ranges of the transactions to be imported overlap, which leads to a web connect import error. If you are downloading and importing previously imported transactions, make sure you are not doing so. Then, switch to the Register Mode.

Here's how:

1. In your company file, head to the Edit menu at the top and choose Preferences.
2. Go to the Checking menu on the left panel and choose the Company Preferences tab.
3. Click on Classic Mode (Register Mode) from the Bank Feeds section.
4. Press the OK button.

Next, download the transactions directly from your Financial Institution's (FI) website and then import them. Here's how:

1. Log in to your bank’s website.
2. Download and save the.QBO file to your desktop.
3. In your QuickBooks, head to the File menu to select Utilities and choose Import.
4. Move to Webconnect files.
5. Go through the File location and choose file and then Open.
6. With the instructions from the Import Wizard, complete the import process. 

Once you've collected all of your company's data, categorize it to keep your records organized and easy to reconcile. For additional resources, you can go over the troubleshooting steps on how to resolve the following: Fix Web Connect import errors.

We want to make sure you have access to the information and tools you need to complete your accounting chores quickly. You can access them by going to the Community page.

Fill me in if you have other banking-related concerns or questions. I'd be delighted to answer them for you. Have a good one.