Missing Check after data migration

Hello, Finaco. I understand the impact that the missing checks have on your payroll reports. Let's perform a YTD adjustment to ensure that your payroll data is accurately reflected in your reports. I'll guide you through the process.

Since you've already figured out the discrepancies, we can go directly into creating an adjustment to your YTD payroll data. Here's how:

1. Go to the Employees menu.
2. Select Payroll Taxes and Liabilities, then Adjust Payroll Liabilities.
3. In the Date and Effective Date fields, select the last paycheck date of the affected month or quarter.
4. Select Employee Adjustment to correct your employee’s YTD info.
5. Under the Item Name column, select the payroll item you want to adjust and enter the amount.
6. Complete the Taxes and Liabilities fields.
7. Select Accounts Affected and then OK.
8. Repeat for other employees if you need to, and select OK.

Then, run the Payroll Summary report to make sure your liabilities are updated. For the step-by-step guide, please refer to this article: Adjust payroll liabilities in QuickBooks Desktop.

Also, to assist you in preparing your tax forms and completing this year's payroll in QuickBooks Desktop Payroll, I recommend referring to this article: Year-end checklist for QuickBooks Desktop Payroll.

Please let me know if you have other payroll concerns and questions about migrating data from QuickBooks Online (QBO) to QuickBooks Desktop (QBDT). Drop a comment below, and I'll gladly help.

The problem is that the missing checks were for checks that were all vacation hours.  There is a YTD adjustment already in the system for those missing checks, and the YTD adjustment shows the vacation hours.  When I run a payroll summary report, those vacation hours show up.  BUT when I run a profit and loss standard report, those vacation hours do NOT show up in Enterprise 2023 (although they DID show up in Desktop 2020).  Perhaps the issue is a different problem though, since NO vacation hours are showing in the P&L...even ones that were paid after the migration.  Did the migration somehow redefine how vacation hours are or are not included in the P&L?

Thank you for the complete information you shared regarding the missing vacation hours after migration, @Finaco. I'll share some information about their limitations and direct you to our developers.

When shifting from QBDT to QBO, paychecks are moved as regular checks to ensure that your financial reports remain accurate. It copies the current year's paycheck information as lump sums, but the details behind the transactions do not convert, such as the payroll item breakdown. That's why there are no vacation hours before and after the migration on the Profit & Loss report. 

On the other hand, payroll data does not transfer to QBDT when transitioning from QBO. Although the employee list carries over, you'll need to set up sick and vacation data again. It's important to note that paychecks and liability adjustments become checks. 

Furthermore, it's a good idea to review the account assigned when mapping the payroll item list and the YTD Amounts. Adjust the date to correct the period balances and affected accounts. To proceed, go to the Help icon and select About QuickBooks Accountant Desktop 2023, then hold Ctrl + Alt + Y.

Lastly, I understand the convenience of viewing the vacation hours directly on the P & L report after migrating from one product to another. You can submit a request for this feature so our product developers can consider it for future updates. I'll show you how:

1. Go to the Help icon at the top menu.
2. Select Send Feedback Online and then click Product Suggestion.
3. Enter your request, then tap Send Feedback.

Track your suggestions through this website or visit our blog to keep up with recent events and developments.

See these articles to learn more about their differences and processes:

• Learn how features and data move from QuickBooks Desktop to QuickBooks Online
• Learn how features and data move from QuickBooks Online to QuickBooks Desktop

If you need to correct the sick and vacation time for your employees, check out this guide: Fix incorrect sick and vacation accruals in QuickBooks Desktop Payroll.

I've got you covered if you have more questions about transitioning payroll transactions. Please let me know by using the Reply option below. Take care always!

I am sorry I was not more clear.  It is not that the vacation hours are not showing in the P&L as vacation hours...they are not showing in the P&L at ALL.  When I run the P&L on QBDT2020 and run the same period on QBEnterprise 2023, they do not match.  The Net Income does not match for the exact same period between the premigration data (QBDT 2020) and the post migration data QBEnterprise 2023.

Perhaps the issue is a different problem though, since NO vacation hours are showing anywhere in the QB Enterprise 2023 P&L...even ones that were paid after the migration. Did the migration somehow redefine how vacation hours are or are not included in the P&L?

Thanks for getting back with the Community, Finaco.
 

The reason your vacation hours aren't showing up when you run profit & loss reports in QuickBooks Desktop (QBDT) 2023 is because when you migrated from QBDT 2020 to QuickBooks Online (QBO), you lost data.
 

When performing this migration, paychecks are moved as regular checks to ensure that the financial reports remain accurate. Your current year's paycheck information is copied as lump sums, but details behind the transactions don't covert, such as your payroll item breakdowns. This is why there were no vacation hours after migrating from QBDT 2020 to QBO.
 

Similarly, when you migrated from QBO to QBDT 2023, payroll data wasn't migrated to QBDT, meaning more data was lost.
 

This is why when you run profit & loss reports in QBDT 2023, they're not matching what you see in QBO or QBDT 2020. It's because there's different data in each company file.
 

If you'd like to, you can update the QBDT 2020 company file to work with QBDT 2023.
 

Here's how:
 

1. Open your QBDT 2020 company file in QBDT 2020, then press F2 to show the Product Information window. Look in your File Information section and make a note of where you save the file on your computer.
2. Confirm all users are signed out of the company file.
3. Open your QBDT 2023 product.
4. In the top menu bar, go to File, then Open or Restore Company.
5. Click Open a company file and hit Next. If you have a backup file (QBB) instead of a company file (QBW), pick Restore a backup copy.
6. Find your file, then highlight it and press Open. If you can't find the file, open your Windows Start menu, then File Exporter and search for the file by name or its .QBW extension. If you're unable to locate it, you'll want to make sure it's not hidden.
7. Sign in to your file as the admin user. When you do this, QuickBooks automatically creates a backup of the existing file.
8. Select Update Now, then Done when it's finished.

In the event you perform these steps and your move fails, you can restore the backup from step 7 and try again. If the move fails again, you'll want to get in touch with our Customer Care team. They'll be able to pull up your account in a secure environment, conduct further research, and create an investigation ticket if necessary.
 

I've also included a detailed resource about updating company files which may come in handy moving forward: Update your company files to a new version
 

Please don't hesitate to send a reply if there's any additional questions. Have a lovely Wednesday!