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

Reconciling cc statement won't zero. Opening and ending balances are correct. All entries are correct. My total payments & cash advances entered = statement totals.

My statement opening balance and the opening balance in QB are the same

My statement ending balance and the ending balance in QB are the same

My Statement Payments and Credits total is the same as the QB Payments and Credits.

My statement Charges, Interest and Cash advances total and the Charges and Cash/Advances total in QB are the same.

My Difference will not zero out and it should. 

Solved
Best answer March 29, 2019

Best Answers
Anonymous
Not applicable

Reconciling cc statement won't zero. Opening and ending balances are correct. All entries are correct. My total payments & cash advances entered = statement totals.

Let's check the discrepancy report to see what's causing this error, Xty214. 

 

 

  1. From the Reports menu, select Banking Reconciliation Discrepancy.
  2. Choose the appropriate account, then select OK.
  3. Review the report to identify any discrepancies.

If you're able to find the transactions that is the reason of this issue, please go to the Audit Trail Report to see the transaction's history details. Here's an article for a reference: Fix Reconciliation Discrepancies.

 

Let us know if you have any questions. Thanks! 

View solution in original post

11 Comments 11
lyndaartesani
Level 6

Reconciling cc statement won't zero. Opening and ending balances are correct. All entries are correct. My total payments & cash advances entered = statement totals.

Go to bed.

Check figures in the morning.  

I cannot tell you how many times I “see” a number but it is not correct.

Double check the beginnng and ending balances.  Ask someone else to check for you too,

qbsurva
Level 1

Reconciling cc statement won't zero. Opening and ending balances are correct. All entries are correct. My total payments & cash advances entered = statement totals.

It is not a matter of an incorrect entry.  It is a $10K difference that should not be there.  I have checked and double checked the entries many times.  I am wondering if it is a QB glitch.  I have never had this happen before.  Been working with QB for over 10 years now.
qbsurva
Level 1

Reconciling cc statement won't zero. Opening and ending balances are correct. All entries are correct. My total payments & cash advances entered = statement totals.

For instance I just unreconciled the previous month that had a zero difference.  All I did was reenter the date and ending balance, hid transactions after ending date and then marked all.  Now there is a difference.  This does not make sense to me.
qbsurva
Level 1

Reconciling cc statement won't zero. Opening and ending balances are correct. All entries are correct. My total payments & cash advances entered = statement totals.

And I double checked to ensure the numbers were correct :)
lyndaartesani
Level 6

Reconciling cc statement won't zero. Opening and ending balances are correct. All entries are correct. My total payments & cash advances entered = statement totals.

Is it 10k even?  If your beginning balance is correct, the ending balance is correct, the total checks/debits equal and deposits equal, it has to equal. 


I have accidentally taken the wrong ending balance off of a statement (grabbed a daily balance instead of ending balance.  Could that be it?

qbteachmt
Level 15

Reconciling cc statement won't zero. Opening and ending balances are correct. All entries are correct. My total payments & cash advances entered = statement totals.

"hid transactions after ending date and then marked all."

Did you Unhide, to see if there is something that crosses the Ending Date?

And is the difference divisible by 9 without a leftover? That would point to a transposition error.


QBfrustrated1
Level 1

Reconciling cc statement won't zero. Opening and ending balances are correct. All entries are correct. My total payments & cash advances entered = statement totals.

Having the same problem. Beginning Balance on statement and QB are the same and correct. Ending Bal. on statement and QB are the same and correct. The total checks/debits equal and deposits equal. It has to be equal but it is NOT! HELP!
qbteachmt
Level 15

Reconciling cc statement won't zero. Opening and ending balances are correct. All entries are correct. My total payments & cash advances entered = statement totals.

This is Not a given: "The total checks/debits equal and deposits equal. It has to be equal but it is NOT! HELP!"

I even teach this lesson. In class, we put the Interest earned in the First screen. In the second step, then, bottom left, it does Not include this in the Number of transactions or the Total.

What you must be able to confirm is bottom Right, the Difference is 0. If that is Not 0, you have some more work to do.

And we cannot help without more info.


qbteachmt
Level 15

Reconciling cc statement won't zero. Opening and ending balances are correct. All entries are correct. My total payments & cash advances entered = statement totals.

I worked with a client on an issue like this; we logged into the CC website and pulled a Transaction Listing. There was one transaction that hit at 11:59:59 pm; it wasn't on the statement, but it was affecting the balance.

It isn't always our fault :)

Xty214
Level 1

Reconciling cc statement won't zero. Opening and ending balances are correct. All entries are correct. My total payments & cash advances entered = statement totals.

Where you able to figure it out?

I used to have a "0" but for some reason now I'm off. When I go to the reconciliation discrepancy screen there's no transaction to help fix issue. I un-did 2 reconciled months and it keeps telling me I'm off!!!! My deposits and withdrawals match up perfectly but the "difference" is throwing my beginning balance off.

Anonymous
Not applicable

Reconciling cc statement won't zero. Opening and ending balances are correct. All entries are correct. My total payments & cash advances entered = statement totals.

Let's check the discrepancy report to see what's causing this error, Xty214. 

 

 

  1. From the Reports menu, select Banking Reconciliation Discrepancy.
  2. Choose the appropriate account, then select OK.
  3. Review the report to identify any discrepancies.

If you're able to find the transactions that is the reason of this issue, please go to the Audit Trail Report to see the transaction's history details. Here's an article for a reference: Fix Reconciliation Discrepancies.

 

Let us know if you have any questions. Thanks! 

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

Need to get in touch?

Contact us