QuickBooks HelpQuickBooksHelpIntuit

Get bank statements directly from Lloyds Bank when you reconcile

SOLVEDby QuickBooks2Updated December 01, 2023

Learn how to import bank statements to help you reconcile an account.

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.

Step 1: Connect your bank account

If you haven't already, connect your bank account to online banking.

Note: At present, only clients of Lloyds Bank can view their bank statements. Connecting to the bank will give you authorisation for 45 minutes and you must re-confirm the connection every 45 minutes to get up-to-date statements.

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.

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.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Online EssentialsQuickBooks Online Plus

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this