cancel
Showing results for 
Search instead for 
Did you mean: 
mistymossy
Level 4

Reconcile From Import

Hello,

I have imported my bank statement. I added them all and they each show a lightning bolt.

When I go to reconcile, I still have to do it manually.

How can I auto reconcile?

I use quicken for home use and once the statement is downloaded, it automatically reconciles. It would be nice to do this with checking account in QB. I am using Qb Pro Plus 2024 desktop.

Thanks.
Melissa

Solved
Best answer February 01, 2024

Best Answers
RCV
QuickBooks Team
QuickBooks Team

Reconcile From Import

Let me share some information about reconciling your bank transactions in QuickBooks Desktop, mistymossy.

 

The option to automatically reconcile your imported bank statements in QuickBooks is unavailable. We'll need to manually reconcile the entries once you get your bank statement. If you're reconciling multiple months, start with your oldest bank statement. Reconcile each month separately, one statement at a time. Here's how:

 

  1. Go to the Banking menu, then select Reconcile.
  2. In the Account field, choose the bank or credit card account you want to reconcile.
  3. The Statement Date is automatically filled in. Usually, it's 30 or 31 days after the statement date of the previous reconciliation. Change it as needed to match your bank statement.
  4. QuickBooks also automatically enters the Beginning Balance. It uses the ending balance from your last reconciliation to get this number.
  5. Enter the Ending Balance based on your bank statement.
  6. Enter the Service Charge and Interest Earned based on your bank statement. Don't enter charges you've already entered in QuickBooks.
  7. Review the fields. If the info is correct, press Continue or OK.

 

To learn more about this one, check out this article: Reconcile an account in QuickBooks Desktop. We can also create rules to categorize transactions for things you often spend money on, like supplies or business expenses. Just follow the steps and details in this article: Create rules to categorize transactions in QuickBooks Desktop.

 

Feel free to visit our Banking page for more insights about managing your bank feeds and reconciling accounts.

 

I'm looking forward to hearing from you. Let me know if you have any clarifications. I'm here to help enlighten them for you. Have a good one.

View solution in original post

3 Comments 3
RCV
QuickBooks Team
QuickBooks Team

Reconcile From Import

Let me share some information about reconciling your bank transactions in QuickBooks Desktop, mistymossy.

 

The option to automatically reconcile your imported bank statements in QuickBooks is unavailable. We'll need to manually reconcile the entries once you get your bank statement. If you're reconciling multiple months, start with your oldest bank statement. Reconcile each month separately, one statement at a time. Here's how:

 

  1. Go to the Banking menu, then select Reconcile.
  2. In the Account field, choose the bank or credit card account you want to reconcile.
  3. The Statement Date is automatically filled in. Usually, it's 30 or 31 days after the statement date of the previous reconciliation. Change it as needed to match your bank statement.
  4. QuickBooks also automatically enters the Beginning Balance. It uses the ending balance from your last reconciliation to get this number.
  5. Enter the Ending Balance based on your bank statement.
  6. Enter the Service Charge and Interest Earned based on your bank statement. Don't enter charges you've already entered in QuickBooks.
  7. Review the fields. If the info is correct, press Continue or OK.

 

To learn more about this one, check out this article: Reconcile an account in QuickBooks Desktop. We can also create rules to categorize transactions for things you often spend money on, like supplies or business expenses. Just follow the steps and details in this article: Create rules to categorize transactions in QuickBooks Desktop.

 

Feel free to visit our Banking page for more insights about managing your bank feeds and reconciling accounts.

 

I'm looking forward to hearing from you. Let me know if you have any clarifications. I'm here to help enlighten them for you. Have a good one.

mistymossy
Level 4

Reconcile From Import

Thanks for the information. I do know how to manually reconcile.

Ivan_G
QuickBooks Team

Reconcile From Import

Thank you for returning to this thread and confirming that my colleague's suggestions above worked for you, mistymossy. It's our main goal to help you navigate through QuickBooks with ease.

 

We're always glad to help you with any issues related to QuickBooks. If there's more, feel free to reach us out again here in the Community. We're one click away. Take care!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us