Skip to main content
December 11, 2018
Solved

What statement ending date do I use on statement to reconcile?!

  • December 11, 2018
  • 3 replies
  • 0 views

Hey just abit confused with my bank statements. Doing first reconciliation for January.

Online bank says the statement for January was available on the 29th. January goes all the way to the 31st. The 30th and 31st was Saturday and Sunday. Did those days get cut off? 

If I use the 31st, there is a difference of just under $2k. But if I use the 29th im off by just like $500 or so. Which date should I use, so I accurately reconcile.

By the way Have Bank of America. 

Best answer by qbteachmt

"I didnt mark anything cleared. I was just entering the dates to start the reconciling process. And noticed the differences."

Until you start processing, any difference here is meaningless. You are ready to work.

"The transactions posted on the 31st, or from what I have entered on quickbooks dont show on the statement it also cuts off at the 29ths transactions."

"Don't show on the Statement" is the Meaningful Phrase. You are using that statement; it is your Outside Source of Reference. Your entries are Newer and More Inclusive = your perspective. You are matching your perspective to the bank's, which is that Statement.

"Will the transactions I have recorded pass on to the next months reconciliation process?"

We don't know that, yet. They will sit there as Uncleared, until you see the bank processed them.

It is like this example:

You pay me in Nov. I don't take that check to my bank until Jan. That still is your Nov expense. You Don't mark it as cleared until it finally shows on your statement, which = I finally submitted it and it Actually has hit Your bank and you see they also processed it for the Same amount that you entered.

Reconciliation = Verification.

Do your data and that Outside Source of Reference Agree? Same amounts, same entries for what Has been processed.

Another example: 3 months in row, I could not reconcile each time because I was off by nearly $2,500 each time, and it was Not My Money on those statements. B of A made electronic deposits to my account in error, 3 months in a row, so until I got statements, I didn't even know about this. I would make an entry to a Liability account = Not my money, and then I would reconcile. Finally, they took it all back = in QB I showed I had paid out the liability.


3 replies

qbteachmt
qbteachmtAnswer
December 11, 2018

"I didnt mark anything cleared. I was just entering the dates to start the reconciling process. And noticed the differences."

Until you start processing, any difference here is meaningless. You are ready to work.

"The transactions posted on the 31st, or from what I have entered on quickbooks dont show on the statement it also cuts off at the 29ths transactions."

"Don't show on the Statement" is the Meaningful Phrase. You are using that statement; it is your Outside Source of Reference. Your entries are Newer and More Inclusive = your perspective. You are matching your perspective to the bank's, which is that Statement.

"Will the transactions I have recorded pass on to the next months reconciliation process?"

We don't know that, yet. They will sit there as Uncleared, until you see the bank processed them.

It is like this example:

You pay me in Nov. I don't take that check to my bank until Jan. That still is your Nov expense. You Don't mark it as cleared until it finally shows on your statement, which = I finally submitted it and it Actually has hit Your bank and you see they also processed it for the Same amount that you entered.

Reconciliation = Verification.

Do your data and that Outside Source of Reference Agree? Same amounts, same entries for what Has been processed.

Another example: 3 months in row, I could not reconcile each time because I was off by nearly $2,500 each time, and it was Not My Money on those statements. B of A made electronic deposits to my account in error, 3 months in a row, so until I got statements, I didn't even know about this. I would make an entry to a Liability account = Not my money, and then I would reconcile. Finally, they took it all back = in QB I showed I had paid out the liability.


qbteachmt
December 11, 2018

You use the Statement's Cut Off date. For instance, Statement dated Jun 1, for Transactions from May 1-May 31 = Statement Ending May 31.

"If I use the 31st, there is a difference of just under $2k. But if I use the 29th im off by just like $500 or so. Which date should I use, so I accurately reconcile."

Actually, no matter which date you put in or use, you Never have a difference, if you are reconciling correctly.

The date is not the important piece of Info. The Ending Balance is your goal.

I can put in a date that is Wrong as a typo, but I would still reconcile to a known Ending Balance. In other words, the date is Notational to reflect my outside source of reference = the statement or document that has the ending balance which is my Target to "be in balance."

It is best to never reconcile and end other than difference of 0, without resolving that difference. A difference of .25 might seem minor, but that could be an overlooked $1,000 deposit and two checks totaling $999.75, as an example.

It seems perhaps you are trying to mark Everything as cleared in that period, but that is not Reconciling. Reconciling is marking as cleared only those transactions you can see that the bank also processed.

For instance, I just reconciled May, and two checks were not on that statement, and I know they got mailed out at the end of the month, so the payees didn't cash them in time to make that statement = I do not clear these until they finally show on my statement.


Rudy-LAuthor
December 11, 2018
I still haven't reviewed or reconciled the transactions. I would like to start it, and find out where those differences are to get it to $00.00.

I didnt mark anything cleared. I was just entering the dates to start the reconciling process. And noticed the differences.

The transactions posted on the 31st, or from what I have entered on quickbooks dont show on the statement it also cuts off at the 29ths transactions.

Will the transactions I have recorded pass on to the next months reconciliation process?
December 9, 2022

The most Simple and Best Answer is to pull a Bank Transaction History for the 2 days after the Statement Cut off and Reconcile up to the 31st.  In essence, you are still verfiying your accounting transactions against an outside source, but in this case, it's more like an "addendum".  That's it.  That simple.