quickBooks®
As your financial institution completes its system conversion, you will need to modify your QuickBooks Online settings to ensure that your data connectivity transfers smoothly to the new system. This document contains instructions for both connectivity types (Express Web Connect and Web Connect).
These instructions refer to two “Action Dates.” The 1st Action Date is September 14, 2022 and 2nd Action Date is September 21, 2022.
IMPORTANT: Express Web Connect will not be available until 5 business days after the 2nd Action Date, so please utilize another connectivity type if you need transaction updates during this downtime.
To navigate this document, just click the link below that matches your product connectivity
Quickbooks Desktop
Instructions for One-Step Update initiated from within QuickBooks
QuickBooks Windows Direct Connect
QuickBooks Mac Direct Connect
Instructions for Downloading a Web Connect file from your Online Banking Site
QuickBooks Windows Web Connect
QuickBooks Mac Web Connect
IMPORTANT: If you currently use Direct Connect in QuickBooks to initiate Bill Payments, please complete the additional tasks at the link below. If you do not use Direct Connect Bill Pay or you only initiate Bill Payments from within your online banking site, these additional tasks are not required.
Quickbooks Online
Instructions for One-Step Update initiated from within QuickBooks Online
QuickBooks Online Express Web Connect
Instructions for Downloading a Web Connect file from your Online Banking Site
QuickBooks Windows Direct Connect
Before the 1st Action Date - September 14, 2022:
- Backup QuickBooks Windows Data File &
- Choose File > Back Up Company > Create Local Backup.
- Download the latest QuickBooks Go to Help > Update QuickBooks Desktop.
- Complete a final transaction download and match downloaded
- Complete one last transaction update before the change to get all of your transaction history up to date.
- Accept all new transactions into the appropriate (required)
On or After the 2nd Action Date - September 21, 2022:
- Deactivate online banking connection for accounts connected to financial institution that is requesting this change.
- Choose Lists menu > Chart of Accounts.
- Right-click on the first account you would like to deactivate and choose Edit Account.
- Click the Bank Feeds Settings tab in the Edit Account window.
- Select Deactivate All Online Services and click Save & Close.
- Click OK for any alerts or messages that may appear with the deactivation.
- Repeat steps for any additional accounts that apply.
- Reconnect online banking connection for accounts that apply.
- Choose Lists menu > Chart of Accounts.
- Right-click on an account you would like to activate and choose Edit Account.
- Select Set Up Bank Feeds on the bottom of the popup screen and select Yes in the dialog box that will appear.
- Enter your institution's name in the search field and select Continue
- Enter your Direct Connect Direct Connect might require credentials that do not match your online banking credentials. Contact your financial institution if your login information does not work.
- Ensure you associate the accounts to the appropriate accounts already listed in QuickBooks. Link to your existing accounts in the drop-down options labeled Select Existing or Create New.
Important: Do NOT select “Create New Account” unless you intend to add a new account to QuickBooks. If you are presented with accounts you do not want to track in this data file, choose Do Not Add to QuickBooks. - After all accounts have been matched, click Next and then click Done.
QuickBooks Mac Direct Connect
Before the 1st Action Date - September 14, 2022:
- Backup QuickBooks Mac Data File & Update the
- Choose File > Backup.
- Download the latest QuickBooks Choose QuickBooks > Check for QuickBooks Updates.
- Complete a final transaction
- Complete last transaction update before the change to get all of your transaction history up to date.
- Accept all new transactions into the appropriate (required)
On or After the 2nd Action Date - September 21, 2022:
- Deactivate online banking connection for accounts connected to financial institution that is requesting this change.
- Choose Lists > Chart of Accounts.
- Click the first account you would like to deactivate and choose Edit > Edit Account.
- Choose Online Settings in the Edit Account window.
- In the Online Account Information window, choose Not Enabled from the Download Transactions list and click Save.
- Click OK for any alerts or messages that may appear with the
- Repeat steps for any additional accounts that
- Reconnect online banking connection for accounts that apply.
- Choose Banking > Online Banking Setup.
- Type your institution's name in the search field, then click Next and follow the instructions in the setup screen
- Select Yes, my account has been activated for QuickBooks Online Services in the Online Banking Assistant window. Click Next.
- Enter your Direct Connect credentials. Direct Connect might require credentials that do not match your online banking credentials. Contact your financial institution if your login information does not work.
- For each account you wish to download into QuickBooks, click Select and Account to connect to your existing account’s registers.
- Click Next, and then click Done.
- Repeat this step for each account that you have connected to this institution.
QuickBooks Windows Web Connect
Before the 1st Action Date - September 14, 2022:
- Backup QuickBooks Windows Data File &
- Choose File > Back Up Company > Create Local Backup.
- Download the latest QuickBooks Choose Help > Update QuickBooks Desktop.
- Complete a final transaction download and match downloaded transactions
- Complete one last transaction update before the change to get all of your transaction history up to date.
- Accept all new transactions into the appropriate registers. (required)
On or After the 2nd Action Date - September 21, 2022:
- Deactivate online banking connection for accounts connected to financial institution that is requesting this change.
- Choose Lists menu > Chart of Accounts.
- Right-click the first account you want to deactivate and choose Edit Account.
- Click the Bank Feeds Settings tab in the Edit Account window.
- Select Deactivate All Online Services and click Save & Close.
- Click OK for any alerts or messages that may appear with the deactivation.
- Repeat steps for any additional accounts that you need to deactivate.
- Reconnect online banking connection for accounts that you need to deactivated.
- Log in to your financial institution's online banking site and download your transactions to a QuickBooks (.qbo) file.
- Note: Take note of your last successful upload. Duplicate transactions can occur if you have overlapping transaction dates in the new transaction download.
- In QuickBooks, choose File > Utilities > Import > Web Connect Files. Locate your saved Web Connect file and select to import.
- In the Select Bank Account dialog select Use an existing QuickBooks account.
Important: Do NOT select “Create a new QuickBooks account” unless you intend to add a new account to QuickBooks. - In the drop-down list, choose your QuickBooks account(s) and click Continue. Confirm by selecting OK.
QuickBooks Windows Bill Pay
Only complete these tasks if you currently initiate Bill Payments from within QuickBooks Windows.
Important: These tasks must be completed to avoid possible duplicate payments. If you do not cancel payments scheduled to be paid on or after the 1st Action Date, these payments may still be processed.
Before the 1st Action Date - September 14, 2022
Cancel Existing Bill Payments.
- Open the Register of the account you made the payment from.
- Choose Company > Chart of Accounts.
- Double-click the proper
- In the register, locate the transaction to be canceled.
- Click the transaction to be deleted.
- Choose Edit > Cancel Payment.
On or After the 2nd Action Date
Note: This section only applies if your institution will support Bill Payments initiated from within QuickBooks Windows after the system change.
Re-create Your Bill Payments.
If you need help re-creating payments, choose Help > QuickBooks Help. Search for Pay a Vendor Online and follow the instructions.
QuickBooks Online Express Web Connect
On the 1st Action Date - September 14, 2022:
- Complete a final transaction download.
- Complete last transaction update before the change to get all of your transaction history up to date.
- Accept all new transactions into the appropriate registers.
On the 2nd Action Date - September 21, 2022:
Disconnect online banking connection for accounts connected to the financial institution that is requesting this change.
- Select Banking from the left column
- Click the account you want to disconnect, then click the Pencil Icon on the corner of that account box
- Click Edit Account Info.
- Check the box next to Disconnect this Account on Save.
- Select Save and Close
- Repeat steps for any additional accounts that apply.
Complete 5 business days after 2nd Deadline Date - September 21, 2022:
- Reconnect online banking connection for accounts that apply.
- On the Banking page, click Add Account in the upper-right side of the screen.
- Type your financial institution’s name and choose the correct option from the results.
- Enter your financial institution credentials and click Continue. Express Web Connect uses the same credentials you use for your institution’s online banking.
- Provide additional information, if requested.
- Ensure you associate the accounts for your financial institution to the appropriate account already listed under Which accounts do you want to connect? Choose the matching accounts in the drop-down menu.
Important: Do NOT select “+Add New” unless you intend to add a new account to QuickBooks Online. If you are presented with accounts you do not want to track in this QuickBooks Online Company, Uncheck the box next to the Account Name. - After all accounts have been matched, click Connect and then click Finish.
- Exclude Duplicate Transactions.
QuickBooks Online Web Connect
On the 1st Action Date:
- Complete a final transaction download.
- Complete last transaction update before the change to get all of your transaction history up to date.
- Accept all new transactions into the appropriate registers
On the 2nd Action Date:
- Disconnect online banking connection for accounts connected to financial institution that is requesting this change.
- Select Banking from the left column.
- Click on the account you would like to disconnect, then click the Pencil Icon on the corner of that account box.
- Click Edit Account Info.
- Check the box next to Disconnect this Account on Save.
- Click Save and Close.
- Repeat steps for any additional accounts that apply.
- Reconnect online banking connection for accounts that apply.
- Download a Web Connect file (.qbo or .qfx) from your financial institution’s online banking site.
- In QuickBooks Online, choose Banking from the left
- Click File Upload in the upper-right side of the screen and use the upload dialog to locate the Web Connect file you downloaded in first step.
- Choose the appropriate account from the drop-down menu under QuickBooks Account and then click Next.
Important: Do NOT choose “+Add New” in the drop-down menu unless you intend to add a new account to QuickBooks Online. - When the import is finished, click Let's go!
- Review the For Review tab on the Banking page to view what was downloaded.
- Click Next, and then click Done.
- Repeat this step for each account that you have connected to this institution.
Quickbooks is a registered trademark
