Learn how to import bank statements to help you reconcile an account. This is available for QuickBooks Online Plus, Accountant, and QuickBooks Live users.
When you reconcile an account in QuickBooks, you compare what you recorded with your bank statement to make sure everything matches.
Some banks now let you view your bank statements right from QuickBooks. No need to shuffle paper statements or sign in to multiple online bank websites. This is especially useful if you're reconciling accounts for multiple clients, or reconciling several statements for the same account. Here's how to view your bank statements in QuickBooks.
Step 1: Connect your bank account
If you haven't already, connect your bank account to online banking.
If your bank supports this feature, you'll get bank statements automatically when you reconcile. We're working with banks to make this feature more widely available. Here's the list of supported banks.
Step 2: Get your bank statements
- In QuickBooks, go to Bookkeeping. Or if you're an accountant, open your client's QuickBooks Online company file first.
- Select Reconcile (Take me there).
- From the Account dropdown, select the account you want to reconcile.
- If you see the View statements option, you can get your bank statements directly from your bank for this account. Select View statements to see your available statements.
- When you're ready to start, select Start reconciliation or Resume reconciliation.
If you don’t see this option, your bank may not support this feature yet. We're working to add more banks soon.
Manually attach a bank statement to a reconciliation
You can also attach bank statements manually when you pause or finish a reconciliation.
- Follow the steps to reconcile the account.
- When you finish, select Finish now.
- Select Attach statement to add the statement.
This saves your bank statement with the reconciliation so you have it for your records.
Which banks support the statement feature?
- Royal Bank of Canada
- TD Canada Trust - Easy Web
- Bank of Montreal
- ATB Financial
- Desjardins AccesD Affaires
- RBC Banque Royale (Canada)
- Canadian Tire Bank
- American Express Credit Card (Canada)
- Canadian Imperial Bank of Commerce
Step 3: Reconcile the account
Now that you have your bank statement, follow the steps to reconcile the account.
Next steps: View bank statements in QuickBooks
Review your reconciled bank statements any time:
- Go to Bookkeeping and select Reconcile (Take me there).
- Select History by account.
- Look for the statement.
- Select Attachments in the Statements column to open the statement