Connect an Open Banking bank feed to QuickBooks Online
by Intuit•27• Updated about 16 hours ago
Open Banking is a secure way to share your financial data with trusted software, like us! It improves speed, security, and automation by letting you control which apps access your account information.
Before you begin
- Check that you bank supports Open Banking. If not, you can upload your transactions via a bank feed, or manually.
- Enable pop-ups: Make sure pop-ups are turned on in your browser settings.
- Have your ABN ready: You will need your Australian Business Number (ABN) for setup, as Open Banking is for business customers only.
Step 1: Prepare your accounts
Nominate a representative: Check if any of your accounts need a nominated representative. Go to the CDR Ready website and follow the prompts to complete this.
Note: This is different from an authorisation to operate the bank account. If you aren't appointed as a nominated representative, your accounts won't appear in the Open Banking setup.
Step 2: Connect your bank or credit card accounts
- Follow this link to complete the steps in your product.
- Search for your bank by URL or name, or select a bank from the list.
- Sign in with your online banking credentials and follow any required security steps.
- Select the accounts you want to connect (current, savings, or credit card).
Note: Select a new chart of account type that matches your chart of accounts.
Step 3: Refresh and review transactions
Once connected, QuickBooks imports your transactions daily. You can also refresh manually to get the latest data.
Step 4: Disconnect existing Bank Feed
Note: Only complete this step if you’re migrating an existing account.
If you are migrating an existing bank feed, disconnect any accounts you are moving to Open Banking.
- Follow this link to complete the steps in product.
- Select the account, then select the edit.
- Select Edit account details, and tick the Disconnect this account on save box.
Note: When you disconnect your current bank feed, any transactions on the Pending screen will be removed. You can bring them back in when you connect your Open Banking feed.
Step 5: Merge your bank feeds
Note: Only complete this step if you’re migrating an existing account.
- Follow this link to complete the steps in product
- Find the account you want to keep. Then, select the dropdown â–Ľ in the Action column and then Edit.
- Note the Account Name, Account Type, and Detail Type of the account. These must be the same between the accounts you want to merge.
- Check if the account is a subaccount or a parent account. The names of subaccounts are indented in the Name column of the Chart of accounts list. If it is, note the parent account it's tied to.
- Go back to Chart of accounts (Take me there).
- Find the duplicate account (the one you won't keep). Then select the dropdown â–Ľ in the Action column and then Edit.
- Change the Account name and Detail Type to that of the account you want to keep.
- If you need to make this a subaccount, keep in mind:
- If you're merging two parent accounts, make sure they don’t have any subaccounts.
- If you're merging two subaccounts, make sure they both have the same parent account.
- If you’re merging a subaccount and a parent account, change the Account Type to exactly match the other parent account so it becomes a parent account.
- When you're ready, select Save and then Yes, merge accounts. QuickBooks moves past transactions from the duplicate to the account you want to keep.
Note: For more details on merging, check out Merge your bank account feeds.
Step 6: Reconfirm your bank connection every 365 days
To meet Open Banking regulations, you’ll need to reauthorise your bank feed every 365 days.
- QuickBooks will notify you when it’s time to renew.
- Select the original expiry date to retrieve any missed transactions.
- You can manage all connections from the Banking or Transactions page.
Frequently asked questions
More like this