Difference between revisions of "How do I post the wages journal?"

From Catalyst
Jump to: navigation, search
 
(35 intermediate revisions by 9 users not shown)
Line 1: Line 1:
−
{{Incomplete}}
+
== Summary ==
−
= Summary =
+
The following article explains how to post a wages journal using [[Posting journals|Journal Entries]].
−
The following article explains how to post the wages journal via [[Posting Journals|journal entries]].
+
You should have the following Nominal Centres (or similar) set up in Platinum:
−
You should have the following Nominal Centres, or similar setup within Platinum:
 
  
−
*Gross Wages (P/L Centre – B: Overhead)
+
* Gross Wages (Sales,W/S,Parts etc) (Profit & Loss Indicator - Overhead)
−
*Directors Remuneration (P/L Centre – B: Overhead)
+
* Directors Remuneration (Profit & Loss Indicator - Overhead)
−
*Employers NI (P/L Centre – B Overhead)
+
* Employers NI (Profit & Loss Indicator - Overhead)
−
*Wages Control Account (Balance Sheet Centre – B: Asset/Liability)
+
* Employers Pension Charges (Profit & Loss Indicator - Overhead)
−
*Paye & NI Control Account (Balance Sheet Centre – B: Asset/Liability)
+
* Wages Control Account (Balance Sheet Indicator - Asset/Liability)
 +
* PAYE & NI Control Account (Balance Sheet Indicator - Asset/Liability)
 +
* Pension Control Account (Balance Sheet Indicator - Asset/Liability)
 +
* Employment Allowance (Profit & Loss Indicator - Overhead)
  
−
= In Detail =
+
== More Information ==
−
There are three journals to carry out when dealing with wages. One to post the payroll information e.g. the Gross NI & PAYE values owed, one to transfer the money out of the bank account when you actually pay the employees and a third to transfer the money out of the bank when you pay the Inland Revenue.
+
There are three journals to carry out when dealing with wages:
 +
* First - to post the payroll costs, i.e. the Gross Wages and Employers NI.
 +
* Second - to transfer the money out of the bank account when you actually pay the employees.
 +
* Third - to transfer the money out of the bank when you pay the Inland Revenue.
  
−
= Posting Payroll Information =
+
=== Posting Payroll Costs ===
−
Go to "Nominal Ledger"->"Journal Entries"->"Multiple Entry"
+
Go to {{Menu|{{NL}}|Journal Entries}}
−
*Enter a suitable date for the journal e.g. the date the wages were processed. Follow the steps below. Also ensure the entries are posted on the same journal.
+
* At {{DataPrompt|Entry mode}}, choose {{DataValue|Multiple}}.
  
−
== Post the Gross Wages ==
+
* At {{DataPrompt|Date}}, enter a suitable date for the journal.
−
* Enter the centre for Wages. If you would like to split the wages into departments or separate Directors pay from employees then enter the appropriate centres.
 
−
* The value should be the Total Gross Pay for the appropriate centre and is a positive value.  This amount is what it has cost the company.
 
−
* The comment should be the period e.g. M1 or WK1 and GROSS PAY.
 
−
* Enter the Wages Control Account centre and post the same Total Gross Pay again as a negative value.
 
−
* Press {{KeyPress|F6}} on the Comment field to pick up the same comment as above.
 
  
−
== Post the Tax ==
+
{{Example|text=The date the wages were processed.}}
−
* Enter the Wages Control Account centre.
 
−
* The value should be the Total PAYE for the period and is a positive value.
 
−
* The comment should be the period e.g. M1 or WK1 and PAYE.
 
−
* Enter the PAYE & NI Control Account and post the Total PAYE again as a negative value.
 
−
* Press {{KeyPress|F6}} on the Comment field to pick up the same comment as above.
 
−
* The above processes has the effect of reducing the amount that you owe the employees and showing the Tax figure as an amount you owe HMRC.
 
  
−
== Employees National Insurance ==
+
* Follow the steps below and post all entries on the same journal.
−
* Enter the Wages Control Account centre.
 
−
* The value should be the Total Employee’s National Insurance for the period and is a positive value.
 
−
* The comment should be the period e.g. M1 or WK1 and EE’S NI.
 
−
* Enter the PAYE & NI Control Account and post the Total Employee’s National Insurance again as a negative value.
 
−
* Press {{KeyPress|F6}} on the Comment field to pick up the same comment as above.
 
  
−
= Posting the payment of the Wages & PAYE & NI to the Inland Revenue =
+
=== Gross Wages ===
 +
On a line on the list:
 +
* In the {{DataPrompt|Centre}} column, enter the centre for Wages. If you would like to split the wages into departments or separate Directors pay from employees then enter the appropriate centres.
 +
* In the {{DataPrompt|Debit}} column, enter the Total Gross Pay for the appropriate centre.
 +
* In the {{DataPrompt|Comment}}, enter a comment.
 +
{{Example|text={{DataValue|Gross M6}}.}}
  
−
== Paying the Wages ==
+
On the next line:
−
* Go to "Nominal Ledger"->"Journal Entries"->"Cashbook Entry"
+
* In the {{DataPrompt|Centre}} column, enter the Wages Control Account centre and post the same Total Gross Pay again, but this time in the {{DataPrompt|Credit}} column.
−
* Enter the Bank Centre (Z992) at the top of the screen.
+
* Press {{KeyPress|C-F6}} on the {{DataPrompt|Comment}} field to pick up the same comment as above.
−
* The Money In/Out flag should be set to “O” as you are paying money out of the bank account.
 
−
* Enter the date you are paying the money out
 
−
* The centre is the Wages Control Centre
 
−
* Enter the amount to pay (do not enter this as a negative value)
 
−
* The comment should be the period e.g. M1 WAGES.
 
  
−
== Paying the Inland Revenue ==
+
Repeat as many times as necessary if you are splitting Gross Wages into departments.
−
* Go to "Nominal Ledger"->"Journal Entries"->"Cashbook Entry"
 
−
* Enter the Bank Centre (Z992) at the top of the screen.
 
−
* The Money In/Out flag should be set to “O” as you are paying money out of the bank account.
 
−
* Enter the date you are paying the money out
 
−
* The centre is the PAYE & NI Control Centre
 
−
* Enter the amount to pay (do not enter this as a negative value)
 
−
* The comment should be the period e.g. M1 PAYE & NI
 
  
−
== Paying money to other bodies e.g. Student Loan Company, Council, CSA and Pension Companies ==
+
=== Tax (PAYE) ===
−
* Go to "Nominal Ledger"->"Journal Entries"->"Cashbook Entry"
+
On a line on the list:
−
* Enter the Bank Centre (Z992) at the top of the screen.
+
* In the {{DataPrompt|Centre}} column, enter the Wages Control Account centre.
−
* The Money In/Out flag should be set to “O” as you are paying money out of the bank account.
+
* In the {{DataPrompt|Debit}} column, enter the Total Tax for the period.
−
* Enter the date you are paying the money out
+
* In the {{DataPrompt|Comment}}, enter a comment.
−
* The centre is the relevant code which you have been posting the payroll details to e.g. Student Loan Deductions
+
{{Example|text={{DataValue|Tax M6}}.}}
−
* Enter the amount to pay (do not enter this as a negative value)
 
−
* The comment should be the period e.g. M1 STUDENT LOAN
 
  
−
== See Also ==
+
On the next line:
−
*[[Posting Journals]]
+
* In the {{DataPrompt|Centre}} column, enter the PAYE & NI Control Account and post the Total Tax in the {{DataPrompt|Credit}} column.
−
*[[Posting Cashbook entries]]
+
* Press {{KeyPress|C-F6}} on the {{DataPrompt|Comment}} field to pick up the same comment as above.
−
*[[What is a Nominal Code?]]
 
−
*[[Recommended Accounting Routines]]
 
  
−
{{KB_Tags|wages, journal, HMRC}}{{KB_NL}}
+
{{Note|text=This reduces the amount that you owe to the employees by the Tax figure since you owe this to HMRC.}}
 +
 
 +
=== Employees National Insurance ===
 +
On a line on the list:
 +
* In the {{DataPrompt|Centre}} column, enter the Wages Control Account centre.
 +
* In the {{DataPrompt|Debit}} column, enter the Total Employees' National Insurance for the period.
 +
* In the {{DataPrompt|Comment}}, enter a comment.
 +
{{Example|text={{DataValue|EE NI M6}}.}}
 +
 
 +
On the next line:
 +
* In the {{DataPrompt|Centre}} column, enter the PAYE & NI Control Account and post the Total Employees' National Insurance in the {{DataPrompt|Credit}} column.
 +
* Press {{KeyPress|C-F6}} on the {{DataPrompt|Comment}} field to pick up the same comment as above.
 +
 
 +
{{Note|text=This reduces the amount that you owe to the employees by the Employees National Insurance figure since you owe this to HMRC.}}
 +
 
 +
=== Employers National Insurance ===
 +
On a line on the list:
 +
* In the {{DataPrompt|Centre}} column, enter the Employers NI (P&L Overhead) centre.
 +
* In the {{DataPrompt|Debit}} column, enter the Total Employer's National Insurance for the period.
 +
* In the {{DataPrompt|Comment}}, enter a comment.
 +
{{Example|text={{DataValue|ER NI M6}}.}}
 +
 
 +
On the next line:
 +
* In the {{DataPrompt|Centre}} column, enter the PAYE & NI Control Account and post the Total Employer's National Insurance again in the {{DataPrompt|Credit}} column.
 +
* Press {{KeyPress|C-F6}} on the {{DataPrompt|Comment}} field to pick up the same comment as above.
 +
 
 +
=== Employees Pension Contributions ===
 +
On a line on the list:
 +
* In the {{DataPrompt|Centre}} column, enter the Wages Control centre.
 +
* In the {{DataPrompt|Debit}} column, enter the Total Employee's Pension Contributions for the period.
 +
* In the {{DataPrompt|Comment}}, enter a comment.
 +
{{Example|text={{DataValue|EE PENSION M6}}.}}
 +
 
 +
On the next line:
 +
* In the {{DataPrompt|Centre}} column, enter the Pension Control Account and post the Total Employee's Pension Contributions again in the {{DataPrompt|Credit}} column.
 +
* Press {{KeyPress|C-F6}} on the {{DataPrompt|Comment}} field to pick up the same comment as above.
 +
 
 +
=== Employers Pension Contributions ===
 +
On a line on the list:
 +
* In the {{DataPrompt|Centre}} column, enter the Pension Charges (P&L Overhead) centre.
 +
* In the {{DataPrompt|Debit}} column, enter the Total Employer's Pension Contributions for the period.
 +
* In the {{DataPrompt|Comment}}, enter a comment.
 +
{{Example|text={{DataValue|ER PENSION M6}}.}}
 +
 
 +
On the next line:
 +
* In the {{DataPrompt|Centre}} column, enter the Pension Control Account and post the Total Employer's Pension Contributions again in the {{DataPrompt|Credit}} column.
 +
* Press {{KeyPress|C-F6}} on the {{DataPrompt|Comment}} field to pick up the same comment as above.
 +
 
 +
{{Note|text=Post any other values appropriately.}}
 +
 
 +
{{Example|text=Tax Credits should be posted in the {{DataPrompt|Debit}} column to the PAYE & NI Control Account and in the {{DataPrompt|Credit}} column to the Wages Control Account; Student Loan Deductions could debit Wages Control and credit Student Loan Control etc.}}
 +
 
 +
* Press {{KeyPress|ESC}} and {{KeyPress|Accept}} to post the journal.
 +
 
 +
==== Example Journal ====
 +
{{Information|text=Please click [[Media:Example.pdf|here]] to download an example of a Payroll Analysis and the journal to post.}}
 +
 
 +
=== Employment Allowance ===
 +
If you are entitled to [[How do I claim employment allowance?|employment allowance]] you will need to post an additional journal.
 +
 
 +
* In the {{DataPrompt|Centre}} column, enter the PAYE & NI Control Account centre.
 +
* In the {{DataPrompt|Debit}} column, enter the Employment Allowance which has been deducted from this period's NI contributions for the period.
 +
* In the {{DataPrompt|Comment}}, enter a comment.{{Example|text={{DataValue|EMP ALLOW M6}}.}}
 +
 
 +
On the next line:
 +
* In the {{DataPrompt|Centre}} column, enter the Employment Allowance (P&L Overhead) centre and post the value allowed again in the {{DataPrompt|Credit}} column.
 +
* Press {{KeyPress|C-F6}} on the {{DataPrompt|Comment}} field to pick up the same comment as above.
 +
 
 +
To check the value that has been allowed this period please view the [[How do I close a payroll period?#Employer Payment Summary (EPS)|'''E'''mployer '''P'''ayment '''S'''ummary (EPS)]].
 +
=== Posting the Payment of the Wages ===
 +
 
 +
==== Paying the Wages ====
 +
* Go to {{Menu|{{NL}}|Journal Entries}}
 +
* At {{DataPrompt|Entry mode}}, choose {{DataValue|Cashbook}}.
 +
* At {{DataPrompt|Money in/out}}, choose {{DataValue|out}} as you are paying money out of the bank account.
 +
* On the highlighted line, enter your Bank Centre.
 +
* On the next line:
 +
** In the {{DataPrompt|Centre}} column, enter the Wages Control Centre.
 +
** In the {{DataPrompt|Date}} column, enter the date you are paying the money out.
 +
** In the {{DataPrompt|Debit}} column, enter the amount to pay.
 +
** In the {{DataPrompt|Comment}}, enter a comment.
 +
{{Example|text={{DataValue|WAGES PAID M6}}.}}
 +
 
 +
* Press {{KeyPress|ESC}} and {{KeyPress|Accept}} to post the journal.
 +
 
 +
=== Posting the Payment to HMRC ===
 +
 
 +
==== Paying HMRC ====
 +
* Go to {{Menu|{{NL}}|Journal Entries}}
 +
* At {{DataPrompt|Entry mode}}, choose {{DataValue|Cashbook}}.
 +
* At {{DataPrompt|Money in/out}}, choose {{DataValue|out}} as you are paying money out of the bank account.
 +
* On the highlighted line, enter your Bank Centre.
 +
* On the next line:
 +
** In the {{DataPrompt|Centre}} column, enter the PAYE & NI Control Centre.
 +
** In the {{DataPrompt|Date}} column, enter the date you are paying the money out.
 +
** In the {{DataPrompt|Debit}} column, enter the amount to pay.
 +
** In the {{DataPrompt|Comment}}, enter a comment.
 +
{{Example|text={{DataValue|WAGES PAID M6}}.}}
 +
 
 +
* Press {{KeyPress|ESC}} and {{KeyPress|Accept}} to post the journal.
 +
 
 +
=== Paying Money to Other Bodies ===
 +
{{Example|text=Student Loan Company, Council, CSA and Pension Companies.}}
 +
 
 +
* Go to {{Menu|{{NL}}|Journal Entries}}
 +
* At {{DataPrompt|Entry mode}}, choose {{DataValue|Cashbook}}.
 +
* At {{DataPrompt|Money in/out}}, choose {{DataValue|out}} as you are paying money out of the bank account.
 +
* On the highlighted line, enter your Bank Centre.
 +
* On the next line:
 +
** In the {{DataPrompt|Centre}} column, enter the relevant code to which you have been posting the payroll details e.g. Pension Deductions.
 +
** In the {{DataPrompt|Date}} column, enter the date you are paying the money out.
 +
** In the {{DataPrompt|Debit}} column, enter the amount to pay.
 +
** In the {{DataPrompt|Comment}}, enter a comment.
 +
{{Example|text={{DataValue|PENSIONS M6}}.}}
 +
 
 +
* Press {{KeyPress|ESC}} and {{KeyPress|Accept}} to post the journal.
 +
 
 +
== See also ==
 +
* [[How do I run a payroll period?]]
 +
* [[Posting journals]]
 +
* [[Posting cashbook entries]]
 +
* [[What is a nominal code?]]
 +
* [[How do I journal a Covid19 grant?]]
 +
* [[Recommended accounting routines]]
 +
 
 +
{{KB_Tags|wages, journal, hmrc, gross, paye, national insurance, pension, tax, nett, payroll}}
 +
{{How}}{{KB_NL}}{{KB_PR}}{{ZN_Accounts}}

Latest revision as of 18:26, 13 May 2020

Summary

The following article explains how to post a wages journal using Journal Entries. You should have the following Nominal Centres (or similar) set up in Platinum:

  • Gross Wages (Sales,W/S,Parts etc) (Profit & Loss Indicator - Overhead)
  • Directors Remuneration (Profit & Loss Indicator - Overhead)
  • Employers NI (Profit & Loss Indicator - Overhead)
  • Employers Pension Charges (Profit & Loss Indicator - Overhead)
  • Wages Control Account (Balance Sheet Indicator - Asset/Liability)
  • PAYE & NI Control Account (Balance Sheet Indicator - Asset/Liability)
  • Pension Control Account (Balance Sheet Indicator - Asset/Liability)
  • Employment Allowance (Profit & Loss Indicator - Overhead)

More Information

There are three journals to carry out when dealing with wages:

  • First - to post the payroll costs, i.e. the Gross Wages and Employers NI.
  • Second - to transfer the money out of the bank account when you actually pay the employees.
  • Third - to transfer the money out of the bank when you pay the Inland Revenue.

Posting Payroll Costs

Go to " Nominal Ledger Journal Entries"

  • At "Entry mode", choose 'Multiple'.
  • At "Date", enter a suitable date for the journal.
The date the wages were processed.
  • Follow the steps below and post all entries on the same journal.

Gross Wages

On a line on the list:

  • In the "Centre" column, enter the centre for Wages. If you would like to split the wages into departments or separate Directors pay from employees then enter the appropriate centres.
  • In the "Debit" column, enter the Total Gross Pay for the appropriate centre.
  • In the "Comment", enter a comment.
'Gross M6'.

On the next line:

  • In the "Centre" column, enter the Wages Control Account centre and post the same Total Gross Pay again, but this time in the "Credit" column.
  • Press <Ctrl+F6> on the "Comment" field to pick up the same comment as above.

Repeat as many times as necessary if you are splitting Gross Wages into departments.

Tax (PAYE)

On a line on the list:

  • In the "Centre" column, enter the Wages Control Account centre.
  • In the "Debit" column, enter the Total Tax for the period.
  • In the "Comment", enter a comment.
'Tax M6'.

On the next line:

  • In the "Centre" column, enter the PAYE & NI Control Account and post the Total Tax in the "Credit" column.
  • Press <Ctrl+F6> on the "Comment" field to pick up the same comment as above.
This reduces the amount that you owe to the employees by the Tax figure since you owe this to HMRC.

Employees National Insurance

On a line on the list:

  • In the "Centre" column, enter the Wages Control Account centre.
  • In the "Debit" column, enter the Total Employees' National Insurance for the period.
  • In the "Comment", enter a comment.
'EE NI M6'.

On the next line:

  • In the "Centre" column, enter the PAYE & NI Control Account and post the Total Employees' National Insurance in the "Credit" column.
  • Press <Ctrl+F6> on the "Comment" field to pick up the same comment as above.
This reduces the amount that you owe to the employees by the Employees National Insurance figure since you owe this to HMRC.

Employers National Insurance

On a line on the list:

  • In the "Centre" column, enter the Employers NI (P&L Overhead) centre.
  • In the "Debit" column, enter the Total Employer's National Insurance for the period.
  • In the "Comment", enter a comment.
'ER NI M6'.

On the next line:

  • In the "Centre" column, enter the PAYE & NI Control Account and post the Total Employer's National Insurance again in the "Credit" column.
  • Press <Ctrl+F6> on the "Comment" field to pick up the same comment as above.

Employees Pension Contributions

On a line on the list:

  • In the "Centre" column, enter the Wages Control centre.
  • In the "Debit" column, enter the Total Employee's Pension Contributions for the period.
  • In the "Comment", enter a comment.
'EE PENSION M6'.

On the next line:

  • In the "Centre" column, enter the Pension Control Account and post the Total Employee's Pension Contributions again in the "Credit" column.
  • Press <Ctrl+F6> on the "Comment" field to pick up the same comment as above.

Employers Pension Contributions

On a line on the list:

  • In the "Centre" column, enter the Pension Charges (P&L Overhead) centre.
  • In the "Debit" column, enter the Total Employer's Pension Contributions for the period.
  • In the "Comment", enter a comment.
'ER PENSION M6'.

On the next line:

  • In the "Centre" column, enter the Pension Control Account and post the Total Employer's Pension Contributions again in the "Credit" column.
  • Press <Ctrl+F6> on the "Comment" field to pick up the same comment as above.
Post any other values appropriately.
Tax Credits should be posted in the "Debit" column to the PAYE & NI Control Account and in the "Credit" column to the Wages Control Account; Student Loan Deductions could debit Wages Control and credit Student Loan Control etc.
  • Press <Esc> and <Accept> to post the journal.

Example Journal

Please click here to download an example of a Payroll Analysis and the journal to post.

Employment Allowance

If you are entitled to employment allowance you will need to post an additional journal.

  • In the "Centre" column, enter the PAYE & NI Control Account centre.
  • In the "Debit" column, enter the Employment Allowance which has been deducted from this period's NI contributions for the period.
  • In the "Comment", enter a comment.
    		'EMP ALLOW M6'.

On the next line:

  • In the "Centre" column, enter the Employment Allowance (P&L Overhead) centre and post the value allowed again in the "Credit" column.
  • Press <Ctrl+F6> on the "Comment" field to pick up the same comment as above.

To check the value that has been allowed this period please view the Employer Payment Summary (EPS).

Posting the Payment of the Wages

Paying the Wages

  • Go to " Nominal Ledger Journal Entries"
  • At "Entry mode", choose 'Cashbook'.
  • At "Money in/out", choose 'out' as you are paying money out of the bank account.
  • On the highlighted line, enter your Bank Centre.
  • On the next line:
    • In the "Centre" column, enter the Wages Control Centre.
    • In the "Date" column, enter the date you are paying the money out.
    • In the "Debit" column, enter the amount to pay.
    • In the "Comment", enter a comment.
'WAGES PAID M6'.
  • Press <Esc> and <Accept> to post the journal.

Posting the Payment to HMRC

Paying HMRC

  • Go to " Nominal Ledger Journal Entries"
  • At "Entry mode", choose 'Cashbook'.
  • At "Money in/out", choose 'out' as you are paying money out of the bank account.
  • On the highlighted line, enter your Bank Centre.
  • On the next line:
    • In the "Centre" column, enter the PAYE & NI Control Centre.
    • In the "Date" column, enter the date you are paying the money out.
    • In the "Debit" column, enter the amount to pay.
    • In the "Comment", enter a comment.
'WAGES PAID M6'.
  • Press <Esc> and <Accept> to post the journal.

Paying Money to Other Bodies

Student Loan Company, Council, CSA and Pension Companies.
  • Go to " Nominal Ledger Journal Entries"
  • At "Entry mode", choose 'Cashbook'.
  • At "Money in/out", choose 'out' as you are paying money out of the bank account.
  • On the highlighted line, enter your Bank Centre.
  • On the next line:
    • In the "Centre" column, enter the relevant code to which you have been posting the payroll details e.g. Pension Deductions.
    • In the "Date" column, enter the date you are paying the money out.
    • In the "Debit" column, enter the amount to pay.
    • In the "Comment", enter a comment.
'PENSIONS M6'.
  • Press <Esc> and <Accept> to post the journal.

See also


Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
wages, journal, hmrc, gross, paye, national insurance, pension, tax, nett, payroll
Retrieved from "https://www.catalyst-uk-support.com/kb/index.php?title=How_do_I_post_the_wages_journal%3F&oldid=41953"