Skip to main content
T
toniaslate
July 19, 2021
Solved

How do I match bank transaction to employee payroll.

  • July 19, 2021
  • 1 reply
  • 0 views
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.
Best answer by AlexV

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?


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!

1 reply

S
SashaMC
July 19, 2021

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.

T
toniaslateAuthor
July 19, 2021

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.

A
AileneA
July 19, 2021

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!

Terms & ConditionsAccessibility statement