Payroll Journal Posting

[BIRCHALL987]

Hi

Please can someone help me with my journal posting, I have been following previous peoples posting of the wages journals and I'm not sure they are right.

Journal for Sage 50 Payroll:

7000 Gross wages - Debit 13255.24 I split this into various different types of Gross wages i.e. office staff, gym staff, cleaning staff etc but all into a range of 7001 etc codes.
7006 Employers NIC - Debit 569.11
2210 PAYE & NI EE & ER - Credit 1694.23
2214 Student Loan - Credit 61.00
2215 Attachments - Credit 0.00
2216 Deductions - Credit 17.25
4006 Personal Trainer Rent Deduction - Credit 450.00
2220 Net wages - Credit 11625.58
2230 Total Pensions EE & ER - Credit 83.92
7007 Employers Pensions - Debit 46.63
7011 SMP Reclaimed - Credit 643.08
2210 NI SMP Reclaimed - Debit 643.08 (Taken from P32 (Is SMP recovered + NIC Comp SMP)
7006 Employers NIC EE Allowance - Credit 253.78 (Taken from P32)
2210 NI EE Allowance - Debit 253.78

As I pay the P32 value whilst paying the Net Wages the bank payment is a bulk pmt so I have to journal out the PAYE/ NI figures out of the Net wages (where I've coded the bank pmt to)

2220 Net Wages Bank pmt - Credit 1301.51 (Taken from P32)
2210 PAYE & NI Bank pmt - Debit 1301.51

Therefore am I right in thinking the 2210 PAYE / NI account should be a zero balance and also the 2220 Net wages account be zero too.

Where does the other side of the student loan go as I'm out by that value.

Thanks in advance.

Ellie

 

[NicoJ]

Yes you are right, both of those codes should be zero. My guess is you've included the student loan twice, so it's either included in the PAYE total and then you've posted it separately again or it's not been taken off the net wage.

 

[BIRCHALL987]

Ok thanks, I've tried to use the Sage Nominal Code link to input into Sage accounts but that confused me more.

Its put the SMP recovered to 7011 but as the SMP and NI comp together as a credit and the other side to the same code but as just the SMP recovered amount as a debit then the whole amount again to 2210 as a debit??

 

[NicoJ]

Can you write the journals how SAGE has posted please? It's a bit confusing. Eg
N/C
7000 £100Dr
2210 £100Cr

 

[BIRCHALL987]

Ok here goes, this is for last month:

2210 £643.08 Dr
2210 £1338.50 Cr
2210 £1048 Cr
2214 £61 Cr
2220 £11179.25 Cr
2230 £122.90 Cr
7000 £450 Cr
7000 £12791.09 Dr
7006 £715.94 Dr
7007 £68.28 Dr
7011 £643.08 Cr
7011 £624.34 Dr

Why would you be putting the SMP recovered to the same code as a Dr & Cr with just the NI recovered as the difference, surely thats only showing the NI recovered as a saving?

Also the £450 to the 7000 is a deduction from the wages which needs to be offset to a sales income nominal. Its an employee who we pay their wages but deduct £450 a month for a rental cost where she does her personal training and gets paid directly from her PT clients.