Skip to content
logo Knowledgebase

How to record a salary journal - ROI only

Created on  | Last modified on 

Summary

At the end of each payroll period, you should update your accounts to include any payments relating to your employees, for example wages, pay related social insurance (PRSI), universal social charge (USC) and PAYE.

Description

Posting a salary journal to your Nominal Ledger ensures that the relevant profit and loss and balance sheet nominal codes are correctly updated.

When you pay your liabilities, posting bank payments to the balance sheet liability nominal codes ensures that the liabilities are cleared and your bank accounts are reduced by the relevant costs.

NOTE: If you're using Sage Payroll (Micropay) you can use the process nominal option to quickly and easily transfer your payroll values to Sage 50 Accounts.

Resolution

Common abbreviations used in this article

We use the following common abbreviations in this article:

  • USC - Universal Social Charge
  • PRSI - Pay Related Social Insurance
  • PAYE - Pay As You Earn
  • LPT - Local Property Tax
Payroll information required

To post your salary journal you will need the total values for the following items:

  • PAYE
  • Employee USC contributions
  • Employee PRSI contributions
  • Total gross pay
  • Net pay
  • Employee pension contributions
  • Deductions
  • Employer’s PRSI contributions
  • Employer pension contributions, if applicable
  • Local property tax deductions, if applicable
Salary journal nominal codes

If you're using the Sage default nominal structure, you should already have some of the following nominal codes. If these codes don't exist, you may need to create them before proceeding.

NOTE: In addition to nominal code 7000, the default nominal structure includes nominal codes 7001 to 7005. These are optional codes that you can use to split your gross wages into subcategories. For simplicity, the examples in this article use nominal code 7000 for gross wages.

Nominal codeNameReportReport section
2210PAYEBalance SheetCurrent Liabilities
2211Pay Related Social Insurance (PRSI)Balance SheetCurrent Liabilities
2212Universal Social Charge (USC)Balance SheetCurrent Liabilities
2216Local Property Tax (LPT)Balance SheetCurrent Liabilities
2220Net WagesBalance SheetCurrent Liabilities
2230Pension FundBalance SheetCurrent Liabilities
7000Gross WagesProfit and LossOverheads
7006Employer's NIProfit and LossOverheads
7007Employer's PensionProfit and LossOverheads
7009AdjustmentsProfit and LossOverheads
Create a nominal code
  1. Click Nominal codes then click New.
  2. Complete the Nominal Record window as follows:
    N/CEnter the number for the nominal code you want to create, for example, 2212.
    NameEnter the name for the new nominal code, for example Universal Social Charge.
  3. Click Save then click Close.

NOTE: When you create a new nominal code you must check your Chart of Accounts to ensure this nominal code is included.

Post the salary journal

NOTE: If you use Sage 50 Accounts Plus or Sage 50 Accounts Professional you can use the Memorise and Recall option to create a skeleton salary journal.

  1. Click Nominal codes then click Journal entry.
  2. Enter a reference and the date for the salary journal, then enter the relevant details on the Nominal Ledger Journals window, for example:

    The balance for the whole salary journal must equal zero before you can save.
    N/CName
    T/C
    Debit
    Credit
    2210PAYE or PAYE and Social Welfare Costs depending on your client’s service.

    Total tax deducted.
    T9

    Credit
    2211Other taxes to pay to Revenue

    Total of employee and employer PRSI contributions.
    T9

    Credit
    2212Universal Social Charge

    The total USC deducted.
    T9

    Credit
    2216Local Property Tax (LPT)

    If applicable, the total value of LPT.
    T9

    Credit
    2220Net Wages

    The total value of the employees’ take home pay.
    T9

    Credit
    2230Pension

    Total employee and employer contributions.
    T9

    Credit
    7000Staff or Employee Costs, depending on your client’s service.

    The gross wages for all employees, not including statutory payments.
    T9
    Debit

    7006Employers PRSI Contribution

    The total employer PRSI contributions.
    T9
    Debit

    7007Employer’s Pension

    Total employer pension contributions.
    T9
    Debit

    7009Other Deductions

    If applicable, the total of remaining employee deductions, excluding attachments and student loans.
    T9

    Credit
  3. Click Save then click Close.
Post bank payments to clear the liabilities

EXAMPLE: In this example, we are posting a bank payment for net wages.

Once the journals have been posted, a liability is created on certain nominal codes. This prepares the way for you to post any required bank payments to represent the money you have paid out and affect your bank balance correctly.

  1. Click Bank accounts then click Bank payment.
  2. Enter the relevant details on the Bank Payments window, for example:
    BankDateRefN/CDetailsNetT/CTax
    Bank nominal codeTransaction dateReferenceNet wages, for example 2220WagesNet wages value T90.00

    NOTE: The bank payments to clear the liabilities should always use the non-vatable tax code, T9 by default. This ensures that they do not appear on your VAT Return.

  3. Click Save then click Close.

When required, repeat this procedure to post bank payments for PAYE, PRSI, USC and LPT.