Skip to main content
F
Finaco
October 30, 2023
Question

Missing Check after data migration

  • October 30, 2023
  • 1 reply
  • 0 views

We started using Quickbooks in 2016 with Quickbooks Desktop.  Earlier this year we migrated from Quickbooks Desktop 2020 to Quickbooks Online and then in September of this year we migrated again to Quickbooks Desktop Enterprise.  We entered payroll information as a part of the data migration. 

When I look at the payroll transactions in the Employee Center, for the payroll data that came from QB Desktop 2020 there are two transactions for each paycheck, a line called "Check" which has most of the detail of the check (amount paid for work on particular jobs, various types of withholding and taxes, and a second line (same date) called YTD Adjustment which seems to have that same data but in a different format.  I am assuming that is a result of the migration process.

 

For the payroll checks that were done in QB Online, there are 3 lines per payroll check:  1.  Check (which has only the net amount of the check, 2.  General Journal (which has the payroll liability and witholding details), and 3.  YTD Adjustment, which again has that same data but in a different format.

 

My question is, there are about 4 checks (from before the migration to QB Desktop Enterprise) that have the line for YTD Adjustment, but do not have a corresponding "Check" line, and these missing checks are making my reports not show all the payroll data.  How can I create these missing checks?

Thank you!

1 reply

R
Rea_M
October 30, 2023

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.

F
FinacoAuthor
October 31, 2023

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?

J
JamaicaA
October 31, 2023

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:

 

 

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!

Terms & ConditionsAccessibility statement