Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Jul 27, 2022 2:37 PM UTC
Question

How do I match the Payroll transactions

I don’t seem to be able to match the payments to 'HMRC, Nest & Net wages', they are showing in the journals but I cannot match them to the payments from my business bank account

 

I can also see the Net wages they are in a ‘Bank (cash at bank and in hand)’account  but I cannot match them with the business bank account transactions  

5 replies

Level 13
Jul 27, 2022 3:12 PM UTC

Hi Monty250, thanks for your post - are the transactions showing in the net wages account the same amounts as the individual payments in the business bank account, and is the journal date the same as the payment date? 

Monty250Author
Jul 27, 2022 3:41 PM UTC

Yes, the payments are exactly the same, and the dates on the net wages are the same. the payments to HMRC & Nest are after the journal entry dates.

 

Could this be an issue with the mapped bank account?

Level 13
Jul 27, 2022 3:57 PM UTC

Thanks Monty250, yes, if the mapped journal is posting to bank (cash at bank and in hand) and not the linked business bank account then you won't be able to match this. You can change the mapped bank account by clicking the Cog > Account & settings > Payroll > Journal mapping - this will the update for all journals going forward. For the existing journals, you can manually edit these to change to the correct bank account or create individual transfers (+ new > transfer) from the bank (cash at bank and in hand) to the business bank account for the payments which you'll then be able to match. 

Monty250Author
Jul 27, 2022 4:18 PM UTC

Excellent, thank you

Level 9
Jul 27, 2022 5:13 PM UTC

You're always welcome, Monty250.

 

We're glad that the information provided by my peer solves your issue about matching your payroll transactions.

 

Please know that you can always visit us if you need help managing your account in QBO.