Seeming P&L anomaly

I suspect there’s two things getting mixed up here. QuickFile has two different modes of operation when you tag a bank transaction as a “salary payment”. By default (with the “post net wages to balance sheet only” setting turned off) it uses a simplified mechanism that works for things like small company directors who are paying themselves salary below the NI threshold and therefore don’t have any NI, income tax or other deductions to make. In this mode when you tag a salary payment QuickFile creates a journal that does

  • Cr bank
  • Dr “net wages” (balance sheet code 2xxx)
  • Cr “net wages”
  • Dr “net staff salaries paid” (a P&L code 7003)

This results in the wages that have been paid out showing as an expense on the P&L without you having to actively journal them.

If you do have deductions to make then you should switch “post net wages to balance sheet only” on. In this mode, when you tag a salary payment it simply posts the contra entry to the “net wages” code on the balance sheet without affecting the P&L. It’s then up to you to create your own journal like the one in @QFSteve’s screenshot to put the gross wage cost, employer’s NI and pension (all debit) onto your P&L, the net wages due as a credit onto the “net wages” balance sheet code (to net off against the debits when you tag the bank transactions), and anything you owe to HMRC onto the “PAYE” balance sheet code - income tax deductions, employee NI deductions, and employer NI contributions - and similarly anything you owe to the pension provider onto its own balance sheet code - employee deductions plus employer contributions.

If you are seeing a non-zero balance on both 7000 and 7003 then that means you’ve done a mixture of the two approaches, probably you’ve created a proper journal at some point but you’ve not known to enable the “post net wages…” setting so you’ve ended up with your net wages debit on P&L rather than it cancelling out the credit on the balance sheet code. If this is the case then the fix going forward is to correct that setting, and then edit any previous journals created by salary payment tagging to remove the second pair of lines that moved the net from BS to P&L.

2 Likes