cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Have a question about HMRC's VAT portal closure on November 1st? - Ask it here!
mt33
Level 1

Match bank payments of wages to journal entry created by QB advanced payroll

Hi

I'm using QB advanced payroll - this is generating a journal entry into Wages Expenses (that it created) when payroll is done.

 

I had been manually entering transactions from the banking feed as hadn't realised  so now have duplicate transactions.

 

My questions is how do i match the individual employee payments from the banking feed to the journal entry created by QB advanced payroll?  I have 9 separate payments out that i wanted to link to the one journal entry?

 

Thanks

2 REPLIES 2
GeorgiaC
QuickBooks Team

Match bank payments of wages to journal entry created by QB advanced payroll

Hi mt33 👋🏼

 

Thanks for your post.

 

What account do you have selected as the 'Payment account' on the journal? 

 

You can check this by going to Employees > Payroll settings > Chart of accounts > Default accounts. This is separate to the Wage Expenses account and is used to account for the wages paid to employees. The usual default for this is 'Payroll Clearing' which is a liability-type account. 

 

If you are using this account, you can record an expense transaction manually for each employee which will then allow you to match to the individual transactions in the bank (on the expense, enter the employee under 'payee', the date this was paid, the bank account, and in the 'Category' field select the 'Payroll Clearing' account). 

 

To remove the existing duplications, go to Banking > Reviewed and select 'Undo' against the transaction. This will move the transaction back to the For-Review tab where you can select 'find match'. 

 

You can also change the default Payment Account from Payroll Clearing to the bank account so that the journal automatically posts to the bank. This way, the wages will be posted to the bank automatically as one sum and you can exclude the individual transactions from the bank feed.

 

Thanks :)

 

tme
Level 1

Match bank payments of wages to journal entry created by QB advanced payroll

To " change the default Payment Account from Payroll Clearing to the bank account " you may need to do what i had to, which was go to Payroll settings -chart of accounts - import accounts (button on right) and say you want to be able to select the bank account.

Need to get in touch?

Contact us