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

Can someone tell me how to match payroll expenses to my payroll bank transactions when the wrong account was used to set up payroll?

I've tried using the match feature in my bank transactions and it's not showing me any payroll transactions. I have corrected the account in payroll settings but it's still not working.

3 Comments 3
JorgetteG
QuickBooks Team

Can someone tell me how to match payroll expenses to my payroll bank transactions when the wrong account was used to set up payroll?

You've made a great start by updating the payroll account settings and ensuring the correct mapping in QuickBooks, Haidagwaiiheatpumps.

 

The issue with the matching feature likely arises because QuickBooks requires a record update to reflect the recent account change. Changing the settings alone does not automatically retroactively link past transactions. 

 

To resolve this, we need to manually edit the transactions recorded under the old account.

 

Here's how:

 

  1. Go to the Transactions tab on your QuickBooks dashboard.
  2. Choose Chart of Accounts and locate the old account.
  3. Click View Register or Account History.
  4. Find the payroll transactions and click on each one to edit.
  5. Change the account to the newly updated payroll account and save the changes.

 

Once the transactions are corrected, navigate back to your Bank Transactions. You should now be able to see the payroll transactions and match them correctly.

 

Furthermore, reconcile your account to ensure everything balances and reflects accurately.

 

Thank you for being proactive in resolving this issue. Please let us know how you progress or if there is anything else we can assist you with.

haidagwaiiheatpumps
Level 1

Can someone tell me how to match payroll expenses to my payroll bank transactions when the wrong account was used to set up payroll?

Sadly, this did not work. It will not allow me to edit the bank account for this type of transaction. 

GlinetteC
Moderator

Can someone tell me how to match payroll expenses to my payroll bank transactions when the wrong account was used to set up payroll?

I have a solution that can help us resolve this issue effectively, haida.

We can exclude and manually clear those transactions, then create a journal entry to correctly transfer the amount to the correct bank account, ensuring your records are precise.


To exclude transactions:

 

  1. Navigate the Transactions, then Bank transactions.
  2. Select the For Review tab.
  3. Pick the checkbox of the transactions to exclude.
  4. Click Exclude.


To clear the transactions:

 

  1. Go to the Settings icon and select Chart of Accounts.
  2. Locate the appropriate account for the transaction.
  3. From the Action column, select Account History.
  4. Locate the transactions
  5. In the reconcile status column, keep selecting the box to change the status of the transaction to C- Cleared.
  6. Click Save.


Finally, create a journal entry. Here's how:

 

  1. Navigate + New.
  2. Select Journal entry
  3. Fill out the fields to create your journal entry.
  4. Select Save and close.


These processes will help rectify errors effectively, helping maintain organized accounts to view your financial standing.

 

Additionally, you can run payroll reports to view useful info about your business and employees.

 

Let me know if you have more queries about managing transactions. Just add a reply to this thread, and I'll be here to assist you promptly.

This widget could not be displayed.
This widget could not be displayed.

Need to get in touch?

Contact us