Skip to main content
nolabookkeeper
January 11, 2021
Solved

Payroll Check Transactions Not Matching

  • January 11, 2021
  • 3 replies
  • 0 views

For some reason, the last three payrolls in December refuse to match. I can't find payroll checks in the register, or on the "Find Match" page.  We have three employees all on Direct Deposit, and I can see that those directly deposited amounts match the bank transactions, but I can't make them match! 

 

I know how to match transactions, and the dates align also. I matched the first payroll in December, and literally nothing else has changed.

 

 

Best answer by abobkov

Hi,

I had the same issue, and fix was very quick and easy.

In my case it happened because Bank account name in Chart of Accounts was different from that in Payroll settings. So, payroll cheques would be posted in the different account.

 

To fix it, go to Gear Icon -> Payroll Settings -> Accounting, and then choose the correct bank account to be used. Save and close.

 

Then, using the Payroll section, open details of paycheque you are unable to match. Note the name of bank account that was used. In my case, it had wrong name. 

 

Finally, go to the Chart of Accounts, and locate that account you identified in the step above. It would contain the balance/transaction for payroll cheque you are unable to match. To fix, mere these two bank accounts (i.e. the proper one with the one where unmatched payroll cheque was posted), i.e. merge this account with proper bank account. Merge can be done by giving account the same name. QBO will prompt you if you want to merge.

 

So, after merge is done, head to the Bank feed, and this paycheque will have its matching entry.

 

Alex.

3 replies

January 11, 2021

I want to ensure this is taken care of @nolabookkeeper.

 

If you've run payroll in QuickBooks Online (QBO), make sure to not create any expenses. If the wages of the employee show up on the Banking page, do a Find Match and look for the employees' paychecks.

 

To make a match, QuickBooks looks at the following:

  • Check numbers: If these match, the transactions may match.
  • Amounts: If the amounts are the same, the transactions may match.
  • Dates: If the transaction was recorded in QuickBooks within a few days of it clearing the bank, the transactions may match.
  • Payees: If the payees are the same or if the payee in the downloaded transaction has a renaming rule to a name in QuickBooks, the transactions may match.

To check the transactions under the register:

  1. Go to the Accounting menu.
  2. Select Chart of Accounts.
  3. Choose the specific bank, and then click View register.
  4. From the Banking page, click the Find match radio button.

I've added these articles for some tips when matching transactions in QBO:

Don't hold your back to drop a comment below if you have other questions. I'm always here to help. Take care!

nolabookkeeper
January 11, 2021

I have looked at all of the past answers on here that have the same instructions and they're not helping.

 

Dates are the same, amounts are the same, employees are the same, everything is the same, and there are no expenses on the paychecks. In fact, the three paychecks generated on 12/08 do match, but not the ones created on 12/14 or 12/28.

 

Is there a known issue? Can I create payroll liability checks in the register manually?

January 12, 2021

I do appreciate your time in reviewing your payroll transactions, nolabookkeeper.

 

Yes, you can manually enter payroll liability check on your register and then match it to the ones downloaded in your bank feeds. It's also possible that you weren't able to record paychecks within the system that's why you're unable to see them in your register. Instead of finding a match to the bank downloaded payroll transactions, you'll want to add them. No worries it won't create duplicates since there were no paychecks created.

 

Before doing so, I'd still suggest rechecking your register in case the transactions were matched to a different bank downloaded payroll transactions. You'll see a green box on these transactions under the reconciliation status column. If a transaction already has a match then the system will not pull up this transaction in the Find match window.

 

I'd also recommend contacting our Phone Support Team if you're unsure about the steps you'll perform just for us not to mess up your books. They have resources to remotely screen share with you and look into the issue you're currently experiencing. 

 

Let me know if you have other questions. You take care and have a great day!

abobkovAnswer
February 12, 2021

Hi,

I had the same issue, and fix was very quick and easy.

In my case it happened because Bank account name in Chart of Accounts was different from that in Payroll settings. So, payroll cheques would be posted in the different account.

 

To fix it, go to Gear Icon -> Payroll Settings -> Accounting, and then choose the correct bank account to be used. Save and close.

 

Then, using the Payroll section, open details of paycheque you are unable to match. Note the name of bank account that was used. In my case, it had wrong name. 

 

Finally, go to the Chart of Accounts, and locate that account you identified in the step above. It would contain the balance/transaction for payroll cheque you are unable to match. To fix, mere these two bank accounts (i.e. the proper one with the one where unmatched payroll cheque was posted), i.e. merge this account with proper bank account. Merge can be done by giving account the same name. QBO will prompt you if you want to merge.

 

So, after merge is done, head to the Bank feed, and this paycheque will have its matching entry.

 

Alex.

February 15, 2021

This worked! Thank you. 

March 31, 2022

Hi,

Yes, I have had a problem in March 2022.

I can tell you that it will not work just by changing the date under review.
You all had the payroll tax date cutoff to be paid via e payment by 3/11/2022.
Your payroll system would not let me pay it after 3/11/2022.  I tried to pay it on 3/12/2022 and your system would not accept it.
Your payroll software is bad??????
We were not late paying the payment because your system would not allow it. I called for assistance and I was told that the system need at least two days prior to the due date to be paid.
I have been a Certified Pro advisor for years and your payroll software is not user friendly.
My client will get a penalty because of your software.
Thanks

 

Candice C
March 31, 2022

Good afternoon, @Brenda100000

 

Thanks for joining in on this thread. I want to ensure that you get your situation taken care of. 

 

I recommend contacting our Customer Support Team so they can take a closer look at your account to see why this is happening. Here's how: 

 

  1. Go to the Help (?) icon in the top right-hand corner. 
  2. Click the Contact Us button. 
  3. Enter your question and tap Let's talk
  4. Scroll down and choose to Get a callback

 

It's that easy! 

 

Feel free to come back if you have any other questions or concerns. It's my priority that your payroll tax issue is resolved. Have a great day! 

April 1, 2022

Hello,

QBO Support has not been able to fix the situation that was caused by the software.

I spoke to support yesterday two times and one of the support individuals will get back to me on Monday with a possible fix.

The problem is as follows:

Should the payroll tax E payments is not paid by the date fixed by QBO Payroll, then the system is locked and the E payment cannot be made until after the 15th of the month.

In my case, I made the E payment on 16th of the month after trying to make the payment on 12th, 13th, 14th, and 15th.  (The QBO Payroll E payment was locked)

The 16th E payments downloaded to the review window in QBO, but the transactions will not match the payroll system.  (Usually, the E payments will match automatically)

It is a system issue with QBO Payroll.

Thank you, Brenda