cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
gmeco
Level 1

Problem reconciling CC account

Hello,

 

I recently imported information from my old desktop QB to QBO. I have an issue with the opening balance of the CC account. The CC account was opened in June 2018 and the very first transaction made was June 4, 2018. However, it shows a large negative balance that supposedly exists before this date. I tried adding an opening balance entry for $0.00 but it didn't change anything. I'm not sure what the problem is. I have attached pictures.

 

 

8 Comments 8
gmeco
Level 1

Problem reconciling CC account

openingbalancedifference.pngopeningbalance.png

gmeco
Level 1

Problem reconciling CC account

beginning.png

 

When reconciling the very first bank statement it says the beginning balance is $7510.11 despite there being no transactions before this first bank statement. I don't know where this amount is coming from or how to fix it.

Rose-A
Moderator

Problem reconciling CC account

I appreciate the screenshot you've provided, gmeco. Let's get this sorted out.

 

If you're reconciling for the first time, you have the option to edit or enter the correct opening balance to your account. For detailed instructions, you can follow the outlined steps below.

 

  1. Click Accounting in the left panel, and choose Chart of Accounts.
  2. Find the account and select View register from the Action column (see the sample screenshots).
  3. Search your register for an opening balance. It should have Opening Balance Equity in the Payee/Account column and Opening Balance in the Memo column.
  4. You can enter and change the opening balance from there.

 

You can refer to this article for other recommended steps (proceed to Step 2 and 3): What to do if you didn't enter an opening balance in QuickBooks Online.

 

However, if you've already reconciled previous transactions, You can refer to the following article: Fix issues for accounts you've reconciled in the past in QuickBooks Online. This will provide you with steps on how to deal with reconciliation discrepancies in QuickBooks Online.


I'll be adding a write-up to help you accomplish a successful reconciliation. On the same link, you'll find an article related to reconciliation adjustment: Learn the reconcile workflow in QuickBooks.

 

I want to make sure I've got you covered, so please let me know if there's anything else I can help you with. Have a great rest of your day!

gmeco
Level 1

Problem reconciling CC account

Hi,

 

I found the opening balance equity, changed the date and amount. The beginning balance is still not accurate and reconciling the first bank statement still does not go to $0.

Fiat Lux - ASIA
Level 15

Problem reconciling CC account

@gmeco 

Have you compared the trial balance between your data in QBD and QBO?

gmeco
Level 1

Problem reconciling CC account

How do I do that?

Fiat Lux - ASIA
Level 15

Problem reconciling CC account

Go to the Report menu to run the Trial Balance

https:// quickbooks.intuit.com/learn-support/en-za/reports/how-do-i-create-a-proper-trial-balance-report-in-qbo-it-seems/00/916730#M291

 

RCV
QuickBooks Team
QuickBooks Team

Problem reconciling CC account

I appreciate the effort of going through the troubleshooting steps provided by colleagues, @gmeco

 

Since the issue still persists, I recommend reaching our Support Team to help you with this one and conduct a further investigation into the unusual behavior. Here's how:

 

  1. Go to (?) Help.
  2. Choose Talk to a Human.
  3. Put a short description of your concern and press Enter.
  4. Select I still need a human.
  5. Click Contact Us to connect with our live support.
  6. Choose Start a chat.

 

You can also use this link to contact them outside QuickBooks: https://help.quickbooks.intuit.com/en/contact

 

Please leave a comment if you need anything else. I'm always here to help. Take care and enjoy your day!