QuickBooks HelpQuickBooksHelpIntuit

Get bank statements directly from your bank when you reconcile in QuickBooks Online

by Intuit Updated 1 month ago

Learn how to import bank statements to help you reconcile an account. This is available for QuickBooks Online Essentials, Plus, Advanced, and Accountant 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. 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. In this article, you'll learn how to:

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

  1. In QuickBooks, go to Settings Settings gear icon., then select Reconcile (Take me there).
    Tip: You can also select Reconcile from the Transactions tab in the MENU ▼.
  2. From the Account drop-down, select the account you want to reconcile.
  3. 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.
  4. When you're ready to start, select Start reconciling or Resume reconciling.

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.

  1. Follow the steps to reconcile the account.
  2. When you finish, select Finish now.
  3. 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
  • Scotiabank
  • Bank of Montreal
  • ATB Financial
  • Desjardins Acces D'Affaires
  • RBC Royal Bank (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:

  1. Go to Bookkeeping and select Reconcile (Take me there).
  2. Select History by account.
  3. Look for the statement.
  4. Select Attachments in the Statements column to open the statement.

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this