Skip to main content
January 19, 2022
Question

2 payroll checks are on my statement but not showing on QB

  • January 19, 2022
  • 1 reply
  • 0 views

2 payroll checks are in my bank statement but not showing in QB's.  Now my W2's are going to be off and I will have to file amendment.

How can I get those checks in to QB's?

1 reply

JessT
January 19, 2022

Welcome to the QuickBooks Community, bjjohnson2010!

 

I understand how the missing paychecks will affect your forms, so let’s find them in your records and recreate them if we can’t find them. I will guide you through the process.

 

Please check your bank registers thoroughly. The paycheck dates might have been changed. Try searching the transactions by their amounts or payee's name.

 

  1. Press Crtl+F while you're on QuickBooks. This will open the Find window.
  2. Under the Simple tab, click the Transaction Type drop list and select Check.
  3. Enter the amount (net amount) and click Find. You may choose a payee before clicking Find.
  4. (Optional) Click Export to export the report to Excel and to easily find the transactions.

 

When you really can’t find the paychecks on your record, you can recreate them to calculate taxes. However, please be sure to back you your company file first to keep a copy of your current data.

 

If these transactions were direct deposit checks, you can refer to this article: Recreate a missing or voided direct deposit paycheck in QuickBooks Desktop Payroll. If they were just regular paychecks, you can follow this article: Gross up a paycheck in QuickBooks Desktop Payroll.

 

Lastly, you can check the Audit trail report to find out what happened to the transactions. The Audit trail contains the logs of all the things you do in QuickBooks and they are dated based on the time (date-time logs) you do those things and not based on transaction dates. Were they actually entered in QuickBooks, or just hand-written and not yet recorded in QuickBooks? That's the way to find out. This happens sometimes to other users.

 

  1. Go to Report.
  2. Choose Accountant & Taxes and select Audit Trail.
  3. Click Customize Report and go to Filters.
  4. Above FILTER, type in TransactionType to only filter the transactions.
  5. In the TransactionType drop list, select Paychecks to only filter the paycheck transaction logs.
  6. Click OK.
  7. On the report page, change the date range. Think of a date range that covers the creation date of those paychecks on your bank account.

 

Let me know if you have other questions about your missing transactions. I'll be happy to lend a helping hand.