cancel
Showing results for 
Search instead for 
Did you mean: 
nolabookkeeper
Level 3

Payroll Check Transactions Not Matching

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.

 

 

Solved
Best answer February 11, 2021

Best Answers
abobkov
Level 1

Payroll Check Transactions Not Matching

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.

View solution in original post

46 Comments 46
Maybelle_S
QuickBooks Team

Payroll Check Transactions Not Matching

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
Level 3

Payroll Check Transactions Not Matching

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?

Catherine_B
QuickBooks Team

Payroll Check Transactions Not Matching

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!

tfwilson
Level 2

Payroll Check Transactions Not Matching

I am having a similar issue.  First pay check of 2021 transaction downloaded from bank matched perfectly.  Second paycheck transaction downloaded from bank and QB can't seem to find a match, but the payroll entry is there and the amount, date, everything should match.  How do I fix this?

Pabz_L
QuickBooks Team

Payroll Check Transactions Not Matching

Let me help you sort this out, @tfwilson.

 

There are several reasons why QuickBooks may not recognize a match:

 

  • The transaction is older than 180 days.
  • The dollar amount in QuickBooks is different than what cleared the bank.
  • The transaction type is different in QuickBooks than at the bank. QuickBooks wants to match a check with a check and an expense with an ACH or debit/credit card swipe.
  • The transaction was recorded in a different bank account.
  • The transaction from the bank is a payment/ deposit of two or more open transactions in QuickBooks.

 

It's also possible that the downloaded paycheck transactions were already added to your bank register. 

 

I suggest putting the transaction back to the For Review tab so you'll be able to match it.

 

Here’s how:

  1. Go to the Banking menu.
  2. Select the Banking tab.
  3. Pick the Reviewed tab.
  4. Search for the added paychecks.
  5. From the Action column, click Undo

 

Once done, view the transaction in the For Review tab. Then, match your downloaded paycheck. 

 

In addition, here's an article you can read to learn more about how you can categorize and match your downloaded transactions:  Download, Match, and Categorize your Bank Transactions in QuickBooks Online.

 

Please let me know how it goes in the comment section down below. I'd be always around ready to lend a helping hand.

MC Tax Consultant
Level 2

Payroll Check Transactions Not Matching

I'm having the same issue - the normal matching function isn't matching for several payroll items in January 2021. This is clearly a QBO glitch that needs to be fixed by QBO - the normal find match or auto-match functions both aren't working properly, even with checks or payroll transactions that meet the normal criteria (proper date, exact amount, proper bank account, etc.). Please fix this glitch, QuickBooks.

JonpriL
Moderator

Payroll Check Transactions Not Matching

I wish I could make it better, @MC Tax Consultant.

 

As much as I'd love to offer help and share how you can able to find a match for your payroll checks with your existing entries, we've got separate support who can address this in no time.

 

That being said, I'd recommend contacting our Customer Care Support. With their tools, one of our specialists can pull up the account on file and investigate the root cause of this unexpected behavior in question. To do so:

  1. Go to Help.
  2. Select Contact Us.
  3. Enter Unable to match - Payroll Checks in the What can we help you with? field.
  4. Click Continue.
  5. Choose a channel where you wish to connect with our dedicated support.

Lastly, I've also included this reference for a compilation of articles you can use while working with us: Banking for QuickBooks Online.

 

If you have any other questions, please let me know by leaving any comments below. I'll be here to lend a hand.

jdragnich
Level 1

Payroll Check Transactions Not Matching

I am having the same issue as well, has anyone been able to fix this ?

Jen_D
Moderator

Payroll Check Transactions Not Matching

Thanks for joining the discussion, @jdragnich,

 

We want to make sure you're able to match your transactions. If you're unable to link the payroll entries with the bank feeds, you can try the steps I shared for a customer with the same issue. Click this link here: https://quickbooks.intuit.com/learn-support/en-us/employees-and-payroll/quickbooks-will-not-find-a-m...

 

If the same thing happens, I highly recommend contacting our Support Team to report this problem to our engineers. To contact our representatives, follow these steps:

 

  1. Go to the Help menu then select Contact us.
  2. Enter the keyword Payroll, Account Management and Billing in the What can we help you with? box.
  3. On the next screen, scroll down to the Choose a way to connect with us section.
  4. Choose Start messaging to initiate a discussion with a live agent or Get a call for callbacks.
  5. When using the messaging option, make sure to enable pop-up windows. The chat box will appear at the bottom right section of your monitor, and an agent will be with you after filling in the information needed. See this:

 

When you're connected, provide all the information about your concern or request a viewing session with out representative.

 

Kindly update me with the result. I want to make sure this is taken care of and the issue is resolved immediately. Have a good one!

jalibh
Level 1

Payroll Check Transactions Not Matching

I am having the same issue! We use Quickbooks payroll. In December, all my payroll transactions had a match. In Jan 2021 it is not finding the match. 

 

Did anyone get this resolved?

officeperio
Level 1

Payroll Check Transactions Not Matching

Hello, I am having the same issue.  I have tried contacting quickbooks support and they have not been able to help me.  I have had no issues matching bank transactions to payroll transactions but the problems has happened for the last three payrolls.  I have tried contacting support over phone and chat and no one has been able to help me.  Do you have any suggestions on how to fix this?  Thank you.

JonpriL
Moderator

Payroll Check Transactions Not Matching

Hello @jalibh and @officeperio,

 

Currently, we have an on-going issue where users, like you, are unable to match downloaded transactions with payroll checks. Rest assured that we've already informed our engineering team and they're in all hands working to fix this as soon as possible.

 

Even if you've already reached out to our Customer Care Support, I'd still recommend contacting them as they haven't shared a workaround yet. With their tools, one of our specialists can associate your account on file to the said investigation so you'll receive all updates via email message.

 

To do so, you can connect with our specialist by following the steps shared by my colleague, @Jen_D above.

 

Lastly, I've also included this helpful reference for a compilation of articles you can use while working with us: Banking for QuickBooks Online.

 

We appreciate your patience as we're working on this, please let me know in the comments if you have any other questions. Stay safe!

kdanelle0802
Level 1

Payroll Check Transactions Not Matching

I, too, have noticed this issue the last few payrolls and thought maybe I changed a setting. I have been searching and searching to find the issue. Happy to see it's not a problem on my end, but bummed to know this is still an ongoing issue that other's have been dealing with for some time now. Hopefully QB gets it together soon!

abobkov
Level 1

Payroll Check Transactions Not Matching

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.

nikki1985
Level 1

Payroll Check Transactions Not Matching

This worked! Thank you. 

Azdirectsatellite
Level 2

Payroll Check Transactions Not Matching

This has been an ongoing issue since December that has not been fixed.  i have checks going back to November that aren't matching.  In my case quickbooks is automatically adding a bank transaction for paychecks but the amount is different than the paycheck, different than the amount given in payroll, different than the amount pulled from my bank account.   I can click on the incorrect amount bank transaction and it pulls up the paycheck/transaction detail and has the correct amount.  the only place it is wrong is in the register, and i never added it to the register as it still shows Uncategorized in my bank feed.  

I have called and called and chatted and spent over a dozen hours on the phone with low level support personnel and I've gotten no where.  they say its handled by this super secretive programming group that they have no contact with.  its been almost 2 months since I've reported this issue and ive gotten no updates no fixes. This has been preventing me from closing my books for 2020 and filing my business and personal taxes.  i am super fed up and frustrated with the lack of communication and speediness of a fix.  I will never recommend quickbooks to any other business owners EVER, as soon as this is fixed and i can close my books i will be cancelling all my intuit accounts and moving to other platforms.  There is no reason i should be waiting months for such a high level issue such as multiple recurring payroll problems to be fixed, especially when it's preventing me from completing extremely important business tasks.

Azdirectsatellite
Level 2

Payroll Check Transactions Not Matching

This has been an ongoing issue since December that has not been fixed.  i have checks going back to November that aren't matching.  In my case quickbooks is automatically adding a bank transaction for paychecks but the amount is different than the paycheck, different than the amount given in payroll, different than the amount pulled from my bank account.   I can click on the incorrect amount bank transaction and it pulls up the paycheck/transaction detail and has the correct amount.  the only place it is wrong is in the register, and i never added it to the register as it still shows Uncategorized in my bank feed.  

I have called and called and chatted and spent over a dozen hours on the phone with low level support personnel and I've gotten no where.  they say its handled by this super secretive programming group that they have no contact with.  its been almost 2 months since I've reported this issue and ive gotten no updates no fixes. This has been preventing me from closing my books for 2020 and filing my business and personal taxes.  i am super fed up and frustrated with the lack of communication and speediness of a fix.  I will never recommend quickbooks to any other business owners EVER, as soon as this is fixed and i can close my books i will be cancelling all my intuit accounts and moving to other platforms.  There is no reason i should be waiting months for such a high level issue such as multiple recurring payroll problems to be fixed, especially when it's preventing me from completing extremely important business tasks.

MC Tax Consultant
Level 2

Payroll Check Transactions Not Matching

Yes!! This worked for me! Thank you Alex for being able to figure this out! I think Intuit should pay you for your heroic work in figuring a working around when the SEVERAL QBO paid Payroll Support team were only providing frustrating responses / methods we were already aware of that clearly didn't fix this issue.

 

To be clear, this was an obvious BUG that recently came up 3-4 months ago - I know this because previously we were able to rename our payroll bank account name without having this issue (as long as it was simply renaming an account and not using a new one, for new payroll accounts that's of course a different story & the related payroll settings of course always needed to be updated). Anyways, I really hope the paid QBO payroll support staff that are just responding to our posts with frustrating nonsense that doesn't resolve the issue LEARN FROM THIS so that going forward you actually identify when several people have the same problem and that you should report it so the intuit technician/software development team fixes this issue in the back end and maybe be honest by letting us know you're aware of the issue / working on fixing it & working to find a work around for us in the meantime so that we don't have major issues for 3 months.

 

Cheers to Alex!! 

Holarctic
Level 1

Payroll Check Transactions Not Matching

IT WORKED! This was exactly the issue, name of the bank account in payroll settings was different than my actual bank account. Merging the accounts was simple too. Thanks for posting this. I was about to lose my mind trying to resolve this with support. I almost starting making payroll clearing accounts and other weird stuff.

nolabookkeeper
Level 3

Payroll Check Transactions Not Matching

Thank you!!

jilleebean
Level 1

Payroll Check Transactions Not Matching

I thought, there was no way that I would have a different bank account associated with my payroll.  We haven't made any changes or added any new bank accounts.  Plus, this happened in the middle of a payroll....some transactions matched and others in the same exact payroll did not.  However, I took a look and this is EXACTLY what happened.  I was able to get it fixed, but my curiousity on how this happened was peaked.  I took a look through my audit trail and "System Administration" created the account!  We all know who that is...What?  Why?  I am so over this product and this is exactly another reasonn why having a different software in my back pocket is now front and center!  

 

Thank you for the help!

nkastris
Level 1

Payroll Check Transactions Not Matching

Hello I just discovered that if the DD Payable transaction is reconciled in your chart of accounts then it won't show up to match! Once I unreconciled those it matched right away!

Buselli704
Level 1

Payroll Check Transactions Not Matching

I spent 4 hours being transferred from one QuickBooks technician to another today and not one person knew the answer on how to match a direct deposit payroll transaction from my online banking to a paycheck that was ran through payroll on QuickBooks online. All the other employees I had no issues with and all payroll was run at the same time. Please help 

Maybelle_S
QuickBooks Team

Payroll Check Transactions Not Matching

It's great to see you here, @Buselli704.

 

I can share some insights on how you can match direct deposit payroll transactions with online banking entries. Here are some things you need to check when finding a match:

 

• Make sure the register you are finding a match is where the direct deposit is saved.

• Note the date of the transactions matches.

• The description and the payee, and amount spent must also be the same.

 

If the match is not detected on the Banking page, you can click the transaction and use the Find other matches option to reveal other related entries. To get more information on how to handle bank entries in QBO, see this link: Categorize and match online bank transactions in QuickBooks Online

 

Additionally, To ensure that your payroll transactions hit the right accounts, you can review them on your Payroll settings page. 

 

Here's how:

 

1. Go to the Gear icon.

2. Select Payroll settings.

3. Under the Preferences section, click Accounting.

 

Review the accounts assigned and make the necessary changes if necessary.

 

Open this article for additional information: Payroll accounting preferences

 

See this article as well: Change your payroll bank account. In case you wish to change the bank account for direct deposits and payroll taxes. 

 

Post a reply below if you have other questions with your QBO company. I'll be around to help you out.

Need to get in touch?

Contact us