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

Quickbooks will not find a match for last week in january paychecks. We use payroll in quick books. I have tried all the ways to "find a match"

The first week of paychecks matched with my bank transaction. The last week will not find a match and is posting the expense twice. ( gross check and net check)
5 Comments 5
Jen_D
Moderator

Quickbooks will not find a match for last week in january paychecks. We use payroll in quick books. I have tried all the ways to "find a match"

It's great to see you here, @jdragnich,

 

I can share some insights on how you can match expense transactions with the 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 expense is saved.
  • Note the date of the transactions matches.
  • The description and the payee, and amount spent must also be the same.

 

See this screenshot as an example:

 

If the match is not detected in 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

 

Other than that, you also need to check if the entry was marked as reconciled. Anything previously reconciled will no longer show up when you do the match.

 

To check the transaction status and make sure it isn't tagged as reconciled, follow the steps below:

 

  1. Click the Gear icon.
  2. Tap Chart of Accounts.
  3. Find the account you want to review.
  4. From the Action column, click View register.
  5. Locate the entry from the list and make sure the status column (indicated by a check mark) doesn't show a code R (Reconciled).
  6. If it does, click the field to remove the reconciled status. Leave the status Blank -(Not cleared or reconciled).
  7. Once done press Save.
  8. To give you an idea on how it looks like in QBO, see this screenshot:

     

You can also find these steps from this article: How to unreconcile a transaction or undo a reconciliation.

 

Let me know how it goes after trying out the steps. I'll be right here to ensure you're able to match the transactions properly. Have a good one!

jdragnich
Level 1

Quickbooks will not find a match for last week in january paychecks. We use payroll in quick books. I have tried all the ways to "find a match"

thanks. i figured out quickbooks put some of my payroll tranactions in a cash account and not the bank account. how do i move these tranactions from cash to bank account?

Ryan_M
Moderator

Quickbooks will not find a match for last week in january paychecks. We use payroll in quick books. I have tried all the ways to "find a match"

Hi @jdragnich,

 

Thank you for your prompt reply. Let me answer this question for you about payroll accounts in QuickBooks Online (QBO).

 

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.

jdragnich
Level 1

Quickbooks will not find a match for last week in january paychecks. We use payroll in quick books. I have tried all the ways to "find a match"

Thanks, I did this but the transactions that I wished to be changed from a week ago did not change when I updated the accounting settings under payroll settings. I even tried to use the back date change feature but the transactions from a week ago are still in the wrong account. Please advise. 

MJoy_D
Moderator

Quickbooks will not find a match for last week in january paychecks. We use payroll in quick books. I have tried all the ways to "find a match"

I can show you how to move these transactions to the right posting account, @jdragnich.

 

You can create a journal entry to move money between these accounts. It'll be best to use them only if you understand accounting or you’re following the advice of your accountant. 

 

To create a journal entry:

 

  1. Go to the + New and select Journal entryjournal entry.JPG
  2. On the first line, select an account from the Account field. 
  3. On the next line, select the other account you're moving money to or from.
  4. Provide all the necessary information.
  5. Click Save and new or Save and close.

 

Here are some articles that will tell you more about journal entries:

 

I’m always here if you need more help in posting these transactions to the right account. Take care and have a great rest of the day!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us