Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
BJL
Level 1

Reconciliation after migration

We are a non profit and migrated from Desktop on a Mac  to Online Essentials. When we migrated, we ran financial reports before and after for comparison and all matched. When we tried to do the first bank reconciliation, the beginning BANK STATEMENT balance shows zero instead of the last bank balance reconciled on desktop. The software does not allow an edit to that balance. I’ve talked to three employees at intuit and each wants me to make a JV entry adding an opening equity balance. However, that is not the proper fix because it adds the bank balance to the cash book balance and results in a duplication to the book balance in the general ledger. We don’t need a correction to the books at all. We need a correction to the reconciliation window which shows the incorrect previously reconciled BANK balance. Also, I noticed that previous cash entries already reconciled prior to the migration do not show a C or R. And I see that the conversion does not carryover the previous reconciliations. I considered re-doing the migration, but I’m unsure how that would affect the entries made since the migration.  I’m hoping someone can address this issue since I’m at a loss as to how to proceed. 

1 Comment 1
GlinetteC
Moderator

Reconciliation after migration

I'll share some insights on how migration works, BJL.

 

When you switch from QuickBooks Desktop for Mac to QuickBooks Online, you may notice changes in the appearance of your books. 

 

Previously reconciled and cleared transactions should show C & R in the register. You'll want to reconcile & clear them manually. Doing this can avoid affecting entries when re-considering the conversion.

 

Here's how:

 

  1. Go to the Accounting tab and select Chart of accounts.
  2. Locate the account, then click View Register.
    recon.PNG
  3. Choose the transactions to expand the view.
  4. In the checkmark ✔ column, select the box click until you see the R for reconciled and C for cleared transactions.
  5. Click Save.
    recon 2.PNG

I'm sharing this article to help you understand how your books were moved: Learn how features and data transfer from QuickBooks Desktop to QuickBooks Online.

 

I'm always here if you have other questions about migration in QuickBooks. The Community is here to help.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us