historical payroll into a checking account register

Hi Kehn Construction,

Thank you for choosing QuickBooks Desktop. I'm here to help you in reconciling your accounts.

It could be that the historical payroll data are posted to a different bank account that's why they're not showing in your payroll checking account register. To isolate the issue, we can open and check the transaction in the Employee Center. Additionally, please make sure to select the Affect liability, expense, and bank accounts so that the Year-To-Date adjustment will show up in the bank register.

Here's how to do it:

1. Select Employees from the top menu bar.
2. Choose Employee Center, then go to the Transactions tab.
3. Select Year-To-Date Adjustments, then locate and open the historical paycheck.
4. Make sure that the bank account is correct.
5. Click the Accounts Affected button.
6. Tick the Affect liability, expense, and bank accounts radio button, then select OK.
7. Click OK again to save the changes.

Once done, we now start reconciling your accounts so they match your bank and credit card statements.

I also encourage reading these articles to learn how to fix mismatches and other reconciliation issues:
 

• Fix Beginning Balance issues in QuickBooks Desktop
• Fix issues while reconciling accounts in QuickBooks Desktop

Feel comfortable to tag me in the comment section if you have follow-up questions or any other concerns. Stay safe and have a great rest of the weekend.

so I tested this on a few transactions and it worked.  I have 2 months of weekly payroll at 35-40 checks per week.  Is there a batch way to do this to all the relevant transactions?  

Thanks for keeping us updated, Kehn Construction.

It's good to know that the steps provided helped you determine what's causing the issue. However, there's no batch action feature to affect the bank account for historical payroll transactions. 

For now, you'll need to open each entry and select Affect liability, expense, and bank accounts. Although, you can click the Next Period button in the upper-right hand corner of the page to move to the next entry.

Since you're new to QuickBooks Payroll, let me share some of our payroll-related articles to give more references on how the feature works:

• Create A Payroll Summary Report
• Get The Latest Payroll Tax Table Update
• What’s New In QuickBooks Payroll
• Set Up Your Company Payroll For Direct Deposit

As always, you can reach out to us anytime you need help. 

okay, this got me part of the way there. For some reason, the payroll liability payments I entered into the historical data part of the payroll set up don't seem to be showing anywhere, that I am currently looking.  I also have jerks that didn't cash their checks in a timely manner, so checks that were not entered individually but as large quarterly entries in the historical payroll data.  How do I account for those in this reconcile without messing up my payroll register or the liabilities register? 

In short, I need to account:

1. for individual paychecks that were part of lump-sum data

2. payroll liabilities that were paid individually from 7/1 on but that I can't find a record of in QB, even though I know I recorded the payments during the setup process.