Migrated from desktop to online version. When I reconcile last January, there is a $750 discrepancy. Can't access old account so no idea what it's from or how to fix?

Which QB Desktop year version did you use?

I'm not sure. I think 2017?

Not sure but I believe 2017. It didn't migrate properly and i just need an idea of a good journal entry to track it rather than worrying about it at this point.

Open your last backup file on the trial version of QB Desktop 2024. Then run the comparative trial balance report to find the discrepancies and use JE in QBO to fix it.

Welcome to the Community space, Macrav. We'll share details to help you through this situation and fix discrepancies to continue reconciling the account inside QuickBooks Online (QBO).

Inside the program, there's an option that allows you to determine and review discrepancies and address them to fix your reconciliation. We'll gladly write down the steps to get you going:

1. Access your QuickBooks Online company.
2. Go to the Transaction tab, and then select Reconcile.
3. Choose the account you want to fix.
4. Click We can help you fix it.
5. Review the discrepancy report. Use it to decide if and how to make changes.
6. Make edits based on the message in the Change Type column.

For more details, please see this page: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

Also, can you tell us the error you encountered when accessing your QuickBooks Desktop? This way, we can provide the appropriate troubleshooting steps to address this so you can have access to the company file again.In addition, here's to know more about migrating from QBDT to QBO:

• Learn about switching from QuickBooks Desktop to QuickBooks Online.
• Fix errors when you move from QuickBooks Desktop to QuickBooks Online.

Feel free to comment below anytime if you need further assistance fixing reconciliation inside QuickBooks, Macrav. We'll be around to help you out again. Keep safe.

i have tried to do this but there is no "we can help you fix" like you state in step 4. I can't get past this. The issue is the beginning balance is wrong. It was correct before I migrated the data. I don't know how to fix that without causing other reporting issues. What type of journal entry will not impact my other reports? The reconciled balance was correct before I migrated. This is frustrating.

I have lost access to the desktop version and support is being difficult about temporarily restoring it.

I have lost access to the desktop version

Which QB Desktop year version did you use?

Hi, macrav. Thanks for coming back to this thread. 

I understand how crucial it is to rectify the beginning balance discrepancy without impacting your other financial reports, particularly after migrating from QuickBooks Desktop (QBDT) to QuickBooks Online (QBO). Let's address the discrepancy in a way that minimizes disruption to your other reports.

First, let's verify the opening balance correctness, as it's the starting point for your accounts in QuickBooks. Here's how:

1. Go to the Gear icon, then Chart of accounts.
2. Find the account on the list.
3. Select View register.
4. Search for the opening balance entry. It should have "Opening Balance Equity" in the Account column.
5. Take note of the date and balance.

Your bank statement is the source of truth. After checking your opening balance in your account's register, compare it with your real-life account. You can do this by signing in to your bank's website or finding your bank statement, then, comparing the two balances.

If you don't find issues with your bank statement and your account register's opening balances, it's possible that certain transactions were either duplicated, missed, or modified during the migration process. To fix this, compare the reconciled transaction dates and amounts of your bank's statement to your account's register. Then, you can either manually recreate the transactions or create a journal entry (JE) to make the necessary adjustments. Since the choice of accounts in your JE will depend on identifying the root cause of the discrepancy, I recommend consulting an accounting professional for this.

Regarding the issue accessing your QBDT, could you provide us with more details about this? If your subscription has expired, you'll have to renew your plan to continue using the program. Otherwise, consider exporting your data.

Additionally, you can refer to this article as a guide in fixing issues with account's reconciled in the past: Fix issues for accounts you've reconciled in the past in QuickBooks Online.

When this is resolved, I'm adding this link as a guide in navigating QBO: Get Started QuickBooks Tutorials US.  

Keep us posted if you have any updates about the reconciliation discrepancy you encountered in QBO. We're committed to offering ongoing support. Take care. 

Hello I know this is an old post but I am experiencing the same issue after I migrated from Desktop to Online. Did you ever find a JE to use or figure out a way to remedy this? 

Hello, bufrecs. Thank you for reaching out to the QuickBooks Live Community. It appears you're dealing with the same discrepancy above. Managing your business finances is vital, especially during such transitions. Let's work together to identify the issue and ensure your financial records reflect accurately, giving you the clarity and confidence you need.

To begin, let's review your opening balance and transactions to check if some changes or amounts didn't add up upon migrating from your QuickBooks Desktop to your QuickBooks Online. Ensure all of it are correct. Once confirmed, you can use your bank statement as a reference to verify you're reconciling the exact account for the correct month.

Here's how you do it:

1. Go to Transactions, then select Reconcile.
2. Select the account that you want to reconcile from the Account ▼ dropdown.
   
   
   

Moreover, for more details and guidance on how to fix and edit changes in your balance and to know how features and data moved, you can refer to this article:

• Fix issues for accounts you've reconciled in the past in QuickBooks Online.
• Learn the process of moving of data  from QuickBooks Desktop to QuickBooks Online.
   

Simplify your accounting processes with QuickBooks Live, offering expert support whenever you need it. Connect with professional CPAs and accountants. QuickBooks Live provides customized bookkeeping services designed to meet your specific business requirements. Ready to take the next step? Explore QuickBooks Live now! Empowering your business, one transaction at a time.

Additionally, I'll be adding this article you can use in setting up future preferences: Run reports in QBO.
 

Ensuring your financial records are accurate is crucial for your business operations. I hope the steps we discussed today will help you resolve the issue seamlessly. If you have any more questions or need further support, please don’t hesitate to reach out. We're always here to help. Have a great day ahead and continue success with your business!