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

Reconciled first time to online banking. Problem QB says I have more in it than correct. Data import from QB Contractor. How do I correct please?

Despite x2 year data conversion account showing transactions back to 2015
1 Comment 1
Jen_D
Moderator

Reconciled first time to online banking. Problem QB says I have more in it than correct. Data import from QB Contractor. How do I correct please?

Hello there, @anconapaint,

 

If you're reconciling this account for the first time, compare each transaction in QuickBooks with what's recorded on the bank statement.

 

Exclude the entries that are not included in the reconciliation period, making sure the real-life balance matches. If you already added the 2015 items in the register, undo it first then exclude them in the Banking page.

 

To undo bank transactions:

 

  1. Click the Banking tab.
  2. Make sure the correct account that you need to work in is highlighted in blue at the top of the page.
  3. Select the In QuickBooks tab, then place a check mark in the box(es) for the transactions you'd like to undo.
  4. Click the Undo button that appears at the top of the list.

 

To exclude, follow the steps below:

 

  1. Go to the For Review tab.
  2. Check the box next to each transaction you want to exclude.
  3. Select the Batch action drop-down menu, and then select Exclude selected.

Excluded transactions are moved to the Excluded tab, and won’t be added to QuickBooks or downloaded again.

 

If it still doesn't fix the balance, check out this article to fix common reconciliation issues: Fix issues when you're reconciling accounts in QuickBooks Online.

 

I'm also enclosing here the reconcile workflow in QBO for your guide: Learn the reconcile workflow in QuickBooks.

 

Let me know how it goes in the comment. I want to make sure this is resolved and I'm here for further assistance. Have a good one!