Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
February 24, 2020
Question

This is my 1st time reconciling. The beginning bal date doesn't align with my CC statement date (01/01 vs 01/14). My beginning bal isn't correct. How can I reconcile?

  • February 24, 2020
  • 1 reply
  • 1 view
QBO automatically populated the beginning balance for this CC since the CC is linked to the QBO account. Should I manually pull all transactions from my CC account to match the QBO dates? I feel like there has to be an easier way to fix this issue. Any guidance is appreciated. Thank you!

1 reply

Anna S
February 24, 2020

Hello, @emilio4.

 

I hope you have an excellent start to your week. Based on the details you provided, I suggest disconnecting the card from your bank feeds and reconnect it using the correct date range you need to reconcile the credit card account. The steps below will show you how:

 

Disconnect Bank Account:

  1. Go to the Banking tab and select the account that is showing the incorrect beginning balance.
  2. Click the pencil icon located in the highlighted blue box.

 

       3. At the bottom of the account settings, check the Disconnect this account on save box.

       4. Press Save and Close.

 

Reconnect Bank Account:

  1. In the Banking tab, hit Add Account.
  2. Search for your bank and login.
  3. Choose a date range and account for your transactions.
  4. After following the onscreen steps, push Let's Go!

Now your transactions should have the correct date range and are ready to reconcile. You may find this article about connecting bank accounts helpful too.

 

Feel free to reply below if you have any other questions. Enjoy the rest of your week.

emilio4Author
February 26, 2020

Thank you for your reply! Unfortunately, this didn't work. I tried adjusting the date range to match the CC statement start date (01/11) instead of the calendar year (01/01) but the totals displayed in all areas remain the same. Any other ideas? 

MariaSoledadG
QuickBooks Team
February 26, 2020

Hi emilio4,

 

Let's double-check if the opening balance entered doesn't include the pending transactions.

  1. If older transactions are entered that come before your opening balance, here's how to reconcile them. Then continue with these steps.
  2. Click the Accounting menu, then select Chart of Accounts.
  3. Find the account on the list.
  4. Select View register.
  5. Search for the opening balance entry. It should have Opening Balance Equity in the Account column.
  6. If you haven't entered an opening, don't worry. Here's how to enter an opening balance manually so your accounts stay balanced.

Once done, compare to see the balance to the real account. After, reviewing the account register, start reconciling again. For detailed steps and more information, please check out this article: Fix Beginning Balance Issues During Your First Reconciliation in QuickBooks Online.

 

You'll want to generate a reconciliation report after your reconciliation: How Do I View, Print, or Export a Reconciliation Report?

 

If there's any help that you want, please let us know so we can get back to you.