cancel
Showing results for 
Search instead for 
Did you mean: 
TTB76
Level 1

Reconciling using the bank feed

Is it possible to reconcile your checking account using the bank feed?  I already have all my entries made into the checking account at the end of the month but wondered if there was some way to use the bank feed to reconcile the checking account.  I didn't know if you could import just the items from your bank statement, match them up and complete the reconciliation.  

Solved
Best answer February 26, 2021

Best Answers
CharleneMae_F
QuickBooks Team

Reconciling using the bank feed

Hi there, TTB76.

 

I'm here to share some details about the reconciliation process. When reconciling an account in QuickBooks Desktop, this can only be done on the Reconcile page. Once you have your bank statement, you can start the process.

 

Before proceeding, secure a backup of your company file. If this is your first time, review the opening balance. This needs to be matched to your real-life checking account. You also have to make sure you enter all transactions for the bank statement period you plan to reconcile. 

 

Once done, let's reconcile your checking account. Here's how:

 

  1. Go to the Banking menu and then select Reconcile.
  2. In the Account field, select the checking account.
  3. The Statement Date is automatically filled in. Change it as needed to match your bank statement.
  4. QuickBooks automatically enters the Beginning Balance. Make sure it matches the beginning balance on your bank statement.
  5. In the Ending Balance field, enter the ending balance which appears on your bank statement.
  6. Enter the amounts in the Service Charge and Interest Earned section. Don't enter charges you've already entered in QuickBooks.
  7. Review the fields. 
  8. If the info is correct, select Continue to start reconciling.

 

For further guidance with the process, please see this article: Reconcile an Account in QuickBooks Desktop.

 

Once done, you can click on Display to view the Reconciliation report or click Print to have a handy copy of the data.

  1. Go to the Reports menu and select Reports Center.
  2. Search for and open a Previous Reconciliation report.
  3. Select the account you reconciled and then either DetailSummary, or Both.

 

I suggest keeping me posted if you need a hand with running your business in QuickBooks. Assistance is just one click away.

View solution in original post

5 Comments
CharleneMae_F
QuickBooks Team

Reconciling using the bank feed

Hi there, TTB76.

 

I'm here to share some details about the reconciliation process. When reconciling an account in QuickBooks Desktop, this can only be done on the Reconcile page. Once you have your bank statement, you can start the process.

 

Before proceeding, secure a backup of your company file. If this is your first time, review the opening balance. This needs to be matched to your real-life checking account. You also have to make sure you enter all transactions for the bank statement period you plan to reconcile. 

 

Once done, let's reconcile your checking account. Here's how:

 

  1. Go to the Banking menu and then select Reconcile.
  2. In the Account field, select the checking account.
  3. The Statement Date is automatically filled in. Change it as needed to match your bank statement.
  4. QuickBooks automatically enters the Beginning Balance. Make sure it matches the beginning balance on your bank statement.
  5. In the Ending Balance field, enter the ending balance which appears on your bank statement.
  6. Enter the amounts in the Service Charge and Interest Earned section. Don't enter charges you've already entered in QuickBooks.
  7. Review the fields. 
  8. If the info is correct, select Continue to start reconciling.

 

For further guidance with the process, please see this article: Reconcile an Account in QuickBooks Desktop.

 

Once done, you can click on Display to view the Reconciliation report or click Print to have a handy copy of the data.

  1. Go to the Reports menu and select Reports Center.
  2. Search for and open a Previous Reconciliation report.
  3. Select the account you reconciled and then either DetailSummary, or Both.

 

I suggest keeping me posted if you need a hand with running your business in QuickBooks. Assistance is just one click away.

View solution in original post

Its-electric
Level 2

Reconciling using the bank feed

I am trying to find an answer to the same question. My entries are posted in Quickbooks daily so I don't necessarily need to use bank feeds to add transactions, but if it could speed up the matching process of the reconciliation that would be extremely helpful. If it is not capable of this, it should be. 

 

Any input on this topic would be appreciated.

Joesem M
QuickBooks Team

Reconciling using the bank feed

Thanks for joining this thread, @Its-electric.

 

You can create a bank rule in QuickBooks Desktop. This will auto-check all transactions with the same information to speed up the matching process.

 

To get started, let's turn on this feature in the Edit menu, here's how:

 

  1. Click Edit at the top menu bar and choose Preferences.
  2. From the left panel, click Checking and go to the Company Preferences.
  3. Under the Bank Feeds section, enable the options for Create rules automatically and Always ask before creating a rule.
  4. Hit OK.

 

Once done, you can now create a bank rule. Let me show you how.

 

  1. Go to Banking on the menu.
  2. Choose Bank Feeds, then Bank Feed Center.
  3. Click the Rules icon.
  4. Select Manage Rules drop-down then choose Add New.
  5. Add Rules Details.
  6. Enter a word or phrase you want to use as the condition for the rule.
  7. In the Do This section, enter the Payee name or the Account name.
  8. Click Save.

 

After you download transactions into your Bank Feeds, they are usually categorized as:

 

  • (Auto) Matched: The downloaded transaction corresponds to the one you’ve entered into this account register in QuickBooks.
  • (Need Your Review) Unmatched: The downloaded transactions don’t match any transaction in this account in QuickBooks.

 

To know more about how bank rules work in QuickBooks Desktop, check out this write-up: Use renaming rules for Bank Feeds. This will provide you steps on how to fix common issues with this feature.

 

Additionally, I've also included these helpful articles for the troubleshooting steps in case you'll bump into issues while working with your bank transactions and how to reconcile your account:

 

 

Let me know if you have any other bank feed concerns or if you have other questions in mind. I want to make sure I've got you covered. I'll get back to you as quickly as I can if you need further assistance.

 

Its-electric
Level 2

Reconciling using the bank feed

That is helpful information. Maybe you can clarify something for me. When I go in to reconcile, will all of the transactions matched through the bank feeds be checked as reconciled? That is what I would like to see happen.  I haven't used bank feeds yet and want to make sure it does what I need before I start.

 

I don't want to use it if I will have to match the transaction in bank feeds and then match again to the bank statement when I reconcile.

 

 

JasroV
QuickBooks Team

Reconciling using the bank feed

I appreciate your prompt reply and for adding some clarifications, @Its-electric.

 

Allow me to share with you some insights about reconciling your accounts in QuickBooks Desktop (QBDT).

 

If QuickBooks finds a match from your bank statement, the transactions will be checked in your Reconciliation window. However, if QuickBooks doesn’t find a match, you’ll need to manually match your transactions to reconcile them.

 

To be guided through the process seamlessly, check out this article for your reference: Reconcile an account in QuickBooks Desktop.

 

In case you run into some issues when reconciling your account, you can utilize this link on how to get around the issue: Learn the reconcile workflow in QuickBooks.

 

If you have any concerns or questions matching your bank balance and QuickBooks balance, tag me in your reply. I’ll be around to help and back you up. Have a good one and keep safe!

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us