Skip to main content
V
vaolivas051909
February 19, 2021
Question

Bank reconciliation

  • February 19, 2021
  • 1 reply
  • 0 views

Hello,

 

I just landed with a client. As I checked his QBO, the books started in 2008. When we had a conversation a while ago, he just did DIY bookkeeping. From 2008 to somewhere in 2014 or 2015 he used QBDT and eventually converted it to Quickbooks Online (2014 or 2015). Now the problem is, I don't know how to start with the clean-up as I can no longer access the QBDT and the bank statements he can only provide is from 2013 onwards. 

 

Can you help how to deal with the reconciling items? There were no reconciliations of 3000+ transactions made ever since. I saw some, but it's only a few days for a month in 2012. Is it okay if I start bank reconciliation in 2013?

1 reply

J
JamesDuanT
February 19, 2021

Let's take care of your reconciliation issues, vaolivas051909.

 

When your client converted their data from QuickBooks Desktop to QuickBooks Online, the reconciliation reports are not included. Hence, you'll see reconciled transactions showing as Reconciled (R) in your QBO register. This is part of the limitations when converting your data.

 

You mentioned that your client provided you the bank statements for 2013 and later. We can start correcting your data from 2013 and reconciling the following years: Reconcile an account in QuickBooks Online.

 

When reconciling year 2013, I'd recommend checking out this article to review the opening balances and your registers: Fix issues the first time you reconcile an account in QuickBooks Online.

 

Once you've reconciled that year, we can proceed to another year with ease. You might also find this link helpful if you encounter issues when reconciling the following year: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

 

We got your back if you have additional queries regarding the process. Have a great day!

Terms & ConditionsAccessibility statement