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 🙂