Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have my historic bank statements in Excel and would like to import them into my Chase Bank account. That option is not available under the Banking menu item. It ask me to set up my bank for downloading.
I know this is probably a very simple thing to do but I cannot seem to figure it out. Can someone please help.
Thanks,
Matt
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:
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:
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.
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:
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:
Next, download the transactions directly from your Financial Institution's (FI) website and then import them. Here's how:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here