Skip to main content
February 6, 2024
Question

I am having a problem reconciling a bank account. Cansomeone help me?

  • February 6, 2024
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

Clark_B
February 14, 2024

Hi there, Ilangan431.

 

Let me help and provide information for you to properly reconcile your bank account in QuickBooks Online (QBO).

 

To begin with, May I know the specific problem that you encountered while reconciling your bank account? Any additional information would help me check for solutions to address your concerns better. If you're reconciling an account for the first time and the beginning balance is off, don't worry. Most beginning balance issues are caused by an incorrect opening balance. Correcting the opening balance should also fix your beginning balance issues. Here's what to review:

 

Step 1: Review your opening balance. Sometimes, your opening balance doesn't include transactions that were still pending when you 

created the account. Note: If you recently entered older transactions dated before your opening balance, here's how to reconcile them. Then continue with these steps.

 

  1. Go to Settings, then Chart of Accounts.
  2. Find the account on the list and select View Register.
  3. Search for the opening balance entry. It should have "Opening Balance Equity" in the Account column. Also, take note of the date and balance.

 

If you forgot to enter an opening balance, here's how to manually enter an opening balance later.

 

Step 2: Compare the opening balance with your real-life account. After knowing the date and amount of the opening balance in QuickBooks. Check it against your bank records:

  1. Sign in to your bank's website, or find your bank statement.
  2. Check the account's balance for the same day as the opening balance in QuickBooks. And then, Compare the two balances.

 

If the balances match, you entered the opening balance correctly. Move on to Step 3.

 

If the opening balance in QuickBooks doesn't match your bank records, correct it:

  1. In QuickBooks, select the opening balance entry to expand the view.
  2. In the Deposit column, edit the balance so it matches your bank records.
  3. Select Save.

 

Step 3: When you reconcile an account for the first time, the opening balance is the only entry that is reconciled. No other transactions should be reconciled. To review your account register, here's how:

  1. Go to Settings, then Chart of Accounts.
  2. Find the account on the list, select View Register to get more details, and search for the opening balance entry. It should have "Opening Balance Equity" in the Account column.
  3. In the checkmark column, there should be an after that, check the other transactions. The checkmark column should either be blank or have a C.
  4. If there's an R on any other transactions, select the transaction to expand the view. Then, select the box in the checkmark column. Keep selecting it until the box is blank. Then select Save.

 

For more detailed information and to guide you about the reconciling workflow, refer to this article: Learn the reconcile workflow in QBO.

 

I'll also add this article to help you view your reconciliation report: View, print, or export a reconciliation report.

 

Don't hesitate to leave a comment below If you have follow-up questions about reconciling your bank account. I will answer them in any possible way.