Skip to main content
A
arkvalleyinfo
December 11, 2018
Solved

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

  • December 11, 2018
  • 5 replies
  • 0 views

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. 

Best answer by

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! 

5 replies

lynda11_2
lynda11_2
December 11, 2018

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,

A
arkvalleyinfoAuthor
December 11, 2018
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.
lynda11_2
lynda11_2
December 11, 2018

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
qbteachmt
December 11, 2018

"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.


Q
QBfrustrated1
December 11, 2018
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
qbteachmt
December 11, 2018

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.


X
Xty214
March 30, 2019

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.

A
Anonymous
Answer
March 30, 2019

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! 

qbteachmt
qbteachmt
December 11, 2018

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 :)

Terms & ConditionsAccessibility statement