My client is on a cash basis and we do not close the books at the end of each month which I am not used to doing.
My question is... should the checking account balance on the BS (current Assets) at the end of each period or EOY tie to the ending balance on the end of each period or EOY bank statement? For example, should the checking account balance on the Dec 31st 2018 tie to the BS OR will this amount move based on items that cleared at a later date (i.e. in Jan 2019)...?
Per QBs ProAdvisor Support the balance will continue to change because transactions "post" at a later date but if that's the case then I"ll never have a good - non moving - balance sheet for those accounts, correct?
Thank you for your help!
Hi there, @amyebirchard.
Thank you for joining the Community. Allow me to help share some insights about reconciling accounts in QuickBooks Online.
The account balance should match with your monthly bank statements. When you receive each period's statement, you reconcile your account based on the transactions covered on that statement only.
So, if the transaction was recorded in December but posted in your bank on January, that transaction will be reconciled on January. Technically, that transaction will be included on the January statement.
I've included some articles for additional reference:
For additional help, you can also reach out to our Customer Care support. They have the tools that can help you get this resolved quickly.
These resources should help to get you back on track.
Keep me posted if you have any other questions reconciling accounts in QuickBooks. I'll be happy to help you out. Have a great day ahead.
Please Learn from this input. This is Wrong: "The account balance should match with your monthly bank statements."
Start with Perspective. The Client's data is the Client's Perspective. They enter their inflow and outflow, to keep an eye on Available Funds.
So, for this question: "should the checking account balance on the BS (current Assets) at the end of each period"
"or EOY tie to the ending balance on the end of each period"
"or EOY bank statement?"
None of that.
You use the statements to Reconcile against, as the outside source of reference. You are verifying that what your client has for Activity and what the bank has for Activity, are an Exact Match. But your Client will have info that bank doesn't have. Example: You pay me in Nov, and I don't take that to my bank and cash it until Jan. Your clients needs that entered for their November activity, and to keep an eye on their bank balance, because until I cash that check, the Bank seems to think they have More Available funds; but your Client has Promised me that check will clear when I finally cash it. And it shows in the Jan Statement; so the Nov and Dec reconciliations means you Skip this entry and let it show again, and again, until you the Bank finally processed it.
"For example, should the checking account balance on the Dec 31st 2018 tie to the BS"
You compare the Running Balance in QB against the Balance Sheet for that same As Of Date, because the one is the source of the other, unless there is data corruption. Nothing here needs to match anything the Bank provides. That is a Different comparison task.
"OR will this amount move based on items that cleared at a later date (i.e. in Jan 2019)...?"
No, nothing ever Moves.
Here is what goes Wrong: "So, if the transaction was recorded in December but posted in your bank on January, that transaction will be reconciled on January"
People wait for the Banking download, and then Add to the File. That January date is not your Client's date, but is the Banking Perspective. If that entry wasn't done when it happened and dated when it applies, then waiting for the Banking Download means you are supposed to change the date on the downloaded transaction.
And that is why Intuit has a problem telling everyone to Wait until they get the download. The IRS is going to pick up on this issue, at some point.
Only Debit and Credit Card, ACH and EFT and other Electronic transactions take place Timely = within one or two dates. Everyone else is doing their Bookkeeping using Wrong Dates, if they wait for the Download.
OMG, this is such an Error: "Per QBs ProAdvisor Support the balance will continue to change because transactions "post" at a later date"
They really put that into Pro Advisor Support? Sheesh.