Related Articles
- Quickbooks Online Download Bank Transactions
- Quickbooks Not Downloading Bank Transactions
- Quickbooks Download Bank Transactions
- Quickbooks Automatic Download Bank Transactions Free
- 1 Import Banking to QuickBooks
- 2 Put a PayPal Account in Quickbooks
- 3 Import American Express OFX to QuickBooks
- 4 Convert an XLS File to an OFX File
If you cannot locate your bank on QuickBooks Online or if you need to download more than 90 days of banking transactions, then you’ll need to import your banking transactions using an Excel. Downloading Bank Transactions into QuickBooks How to Download Bank Transactions into QuickBooks Online. Downloading bank transactions in QuickBooks Online is pretty simple after you have set up your account for online banking. Follow the steps below to download your bank transactions: Step 1.
If you use QuickBooks to track financial transactions for your business, you can set up your company bank accounts for automatic downloads. This will allow you to reconcile your credits and debits. If you’d like to learn more about managing income, expenses and reporting in QuickBooks download our free 39 course QuickBooks tutorial here. Download Our Free Quickbooks Course. Why Is It Important to Manage Downloaded Banking Transactions (Bank Feeds) in QuickBooks Online? When you import the transactions into QuickBooks, they are un-posted. You can also create a direct connection to Chase from within QuickBooks and receive transactions automatically for a monthly fee. Once the transactions are.
For Chase banking customers, QuickBooks offers a number of powerful tools for managing a business. One of these tools is the software's ability to track income and expenditures and keep accounts in sync by integrating with the bank's software systems over an Internet connection. As a customer of Chase, you download account transactions to an external file and import them into QuickBooks with no fee. You can also create a direct connection to Chase from within QuickBooks and receive transactions automatically for a monthly fee. Once the transactions are available, you can use the information to reconcile accounts and simplify your financial bookkeeping.
Using Web Connect
1.
Log on to the Chase Online Banking page (see Resources). If you do not use Chase Online to manage your accounts, click on the 'Enroll Now' button to register for an online user account.
2.
Click on the 'Customer Center' tab once you have logged onto Chase Online. Scroll down to 'Reference Center' and click on the link 'Activate Money, Quicken, etc...'
3.
Click on 'Download Now (no charge)' to create a QuickBooks OFX-formatted file on your desktop and then click 'Continue.'
4.
Select the account from which to download transactions and then choose a date range of transactions.
5.
Click on the 'QuickBooks' radio button and select the version of QuickBooks you are using from the drop-down list. Click the 'Export' button.
6.
Click the 'Save' button if prompted and choose a destination folder to save the file. Intuit recommends saving the file to the desktop.
7.
Go to the destination folder that contains the OFX-formatted file. Right-click on the file and rename it to 'Filename.qbo' (include the quotation marks), where filename is the name of your downloaded file. This step is necessary because the QuickBooks Web Connect recognizes only QBO-formatted files.
8.
Open QuickBooks on your computer. Go to the 'File' menu and access 'Utilities,' 'Import' and 'Web Connect Files...' Navigate to the desktop and locate the OFX-formatted file you downloaded from Chase Online. Click 'Open' to continue.
9.
Select 'Use an existing QuickBooks account' when prompted in the 'Select Bank Account' dialog and choose your account from the drop-down list. If your account is not listed, select 'Create a new QuickBooks account' and type in a name. Click 'Continue.'
10.
Go to 'Online Banking' under 'My Shortcuts' to review and match the transactions you downloaded for this account.
Using QuickBooks' Direct Connect
1.
Log on to the Chase Online Web page (see Resources).
2.
Click the 'Customer Center' tab and scroll down to the 'Reference Center.' Click on the link for 'Activate Money, Quicken, etc...'
3.
Quickbooks Online Download Bank Transactions
Select 'Activate Direct Access through the PFM service ($9.95/month)' and click 'Continue.' Follow the onscreen instructions to complete the setup for direct access.
4.
Open QuickBooks on your computer. Go to the 'Banking' menu. Choose 'Online Banking' and then 'Set Up Account from Online Services.'
5.
Select the company account from the drop-down list or enter the name of a new account. Click 'Next' to continue.
6.
Scroll down and locate 'Chase' from the Financial Institutions drop-down list or type 'Chase' in the box. Click 'Next' to continue the account setup.
7.
Choose 'Direct Connect' and click 'Next.' Check the box next to 'Yes, my account has been activated for QuickBooks Online Services.' Click 'Next' to continue setup.
8.
Enter your Chase Online username and password when prompted. Select the online account to access and download.
9.
Choose 'Download Online Accounts' and 'Receive Transactions.' Click 'Finish' to complete the linking process.
Quickbooks Not Downloading Bank Transactions
Things Needed
- Chase Online account username and password
Tip
- Online account balances and transactions are usually current up to the prior business day.
Quickbooks Download Bank Transactions
References (6)
About the Author
Kammy Pow studied biological sciences at the University of California Irvine. She spent 13 years as a programmer for the financial, medical research, and healthcare sectors. She has been freelancing since 2005 and currently writes health-care related material and pens the occasional review for Southern California altweeklies.
Cite this Article