cancel
Showing results for 
Search instead for 
Did you mean: 
toniaslate
Level 1

How do I match bank transaction to employee payroll.

This used to happen automatically with Quickbooks Payroll, but I changed the bank account that I pay payroll from and now it doesn't work anymore and I can't even figure out how to set up a match to a single paycheck, let alone get the automation to work anymore.
Solved
Best answer July 19, 2021

Best Answers
AlexV
QuickBooks Team

How do I match bank transaction to employee payroll.

Hi toniaslate!

 

Let me join this thread so I can help you with the paychecks.

 

The Paid by is the payment method for processing the paychecks while the Paid from is the bank account you selected on your accounting preferences. Please follow these steps on how to update it:

  1. Click the Gear icon and select Payroll settings.
  2. Find and select Accounting
  3. From the Accounting preferences page, edit the Bank Account and update it.
  4. Select Done to save it.

 

Please note that updating the bank account from your preferences is not retroactive. You'll want to create a journal entry so that you can reconcile the account. Also, you can match the downloaded transactions from your banking to the journal entries.

 

Do you need payroll-related reports? Check this link: Run payroll reports in QuickBooks Online.

 

Keep on posting here if you have other concerns with payroll. Take care!

View solution in original post

6 Comments 6
SashaMC
Moderator

How do I match bank transaction to employee payroll.

Hello toniaslate,

 

Nice seeing you here in the Community. I will be delighted to help you get this sorted out! Now that you have connected the bank, you would need to add the bank rules. If there aren't any bank rules, it would not automatically match to transactions that are downloaded. To assist you with this, this article lays out the steps such as creating the bank rule, review the recognized transition, and setting up the auto-add feature.

 

 

Once completed and you are still receiving problems, please reach out to me and let me know. I will be here to help! Keep me posted and take care.

toniaslate
Level 1

How do I match bank transaction to employee payroll.

I have reviewed the article, but it isn't what I need. I know how to set up rules and have many of them set up already... this is not a rule problem, this is a payroll specific problem.

 

Prior to changing bank accounts, when I would pay my employees, their checks would automatically get assigned the category that indicated what week it was for such as: "Payroll Check: Direct Deposit Payable DD 04/30/2021 $739.64". Even if I try to manually categorize my payroll now, I don't have any Payroll Checks in the list to match on.

AileneA
QuickBooks Team

How do I match bank transaction to employee payroll.

Hello, toniaslate.

 

There are possible reason why there are missing transactions in the Banking page. It could be: 

 

  • the transactions are associated to a different account 

  

Let's go ahead and check the payroll settings and change the necessary info if possible. 

 

Here's how: 

  

  1. Click the Gear icon and select Payroll settings.
  2. Locate and tap Accounting
  3. From the Accounting preferences page, edit the Bank Account and update it.
  4. Press Done

 

I've attached an article you can read to learn more about matching downloaded transactions: Add and Match Downloaded Banking Transactions?

 

Let me know if you have additional questions. I'm always here to help. Stay safe!

toniaslate
Level 1

How do I match bank transaction to employee payroll.

Looking at the register from the chart of accounts provided some help. The paychecks are not showing up in the register under the correct account. Further, if I go in and look at the individual paychecks, it says that they were "Paid from" the original account I was using, but "Paid by" the new account. How do I fix the "Paid from" for the past checks that came out of the new account AND for any future payroll checks?

AlexV
QuickBooks Team

How do I match bank transaction to employee payroll.

Hi toniaslate!

 

Let me join this thread so I can help you with the paychecks.

 

The Paid by is the payment method for processing the paychecks while the Paid from is the bank account you selected on your accounting preferences. Please follow these steps on how to update it:

  1. Click the Gear icon and select Payroll settings.
  2. Find and select Accounting
  3. From the Accounting preferences page, edit the Bank Account and update it.
  4. Select Done to save it.

 

Please note that updating the bank account from your preferences is not retroactive. You'll want to create a journal entry so that you can reconcile the account. Also, you can match the downloaded transactions from your banking to the journal entries.

 

Do you need payroll-related reports? Check this link: Run payroll reports in QuickBooks Online.

 

Keep on posting here if you have other concerns with payroll. Take care!

mgreenlief
Level 1

How do I match bank transaction to employee payroll.

The solution says that it doesn't work retroactively and to create journal entries to resolve. I can easily create journal entries, but between which accounts? I'm experiencing the same issue as the person in the original post. I was able to resolve my issue going forward, but am unable to balance with the payroll entries that did not match. Any ideas on which accounts I can use to 1) match to the bank feed transactions and 2) stay in balance? I'm at a loss here.

Need to get in touch?

Contact us