Skip to content
logo Knowledgebase

How Sage Payroll integration works with Sage Accounting

Created on  | Last modified on 

Summary

How Sage Payroll integrates with Sage Accounting. Learn about salary postings, HMRC payments and pension payments.

Resolution

Once set up, you can make three types of postings.

Salary postings

Salary Journals

Sage Payroll automatically creates a journal in Sage Accounting every time you complete a pay run in Payroll. It posts with the date you’ve used for your pay date when processing the pay run.

The journal uses the default ledger accounts in Sage Accounting.

To record the journals using your own ledger accounts, create manual journals instead. For a list of the journals posted, read what's posted to Accounting when integrated with Payroll.

Net wage payment

Sage Payroll records the value of your net wages in two different ways. You can record it as a bank payment or as a liability.

▼ Record your net wages as a bank payment

As you'll actually be paying money to your employees, you can save time by recording this bank payment automatically. This line of the journal will post to the bank account chosen when you enabled Payroll integration.

Use this when you pay all your employees from the same bank account. It shows as a single payment, rather than as individual amounts to your employees.

▼ Record your net wages as a liability

If you want to post this later, Sage will instead record the total net wages against the Net Wages ledger account.

Choose Post employee net wages to liability account when enabling Payroll integration.

When you make the real-life payment, manually enter these details into Accounting.

HMRC payment details

When all pay runs are complete for your reporting period (monthly or quarterly), you can record your payment details to HMRC. You complete this using Record payment/ EPS. 

▼ View steps
  1. Select Summary from the menu bar.
  2. Under EPS submission, select Action. 
  3. Select Record payment/ EPS.
  4. Check the Record amount paid to HMRC is correct. This is what posts to Accounting.
  5. Enter a Payment date. This is the date the journals and payment will use.
  6. Continue with the rest of the EPS process.

HMRC journals

The journal uses the default ledger accounts in Sage Accounting.

If you want to record the journal using your own ledger accounts, you need to create a manual journal instead. This is useful if you require more detailed reporting. For a list of the journals posted, read what's posted to Accounting when integrated with Payroll.

HMRC liability payment

The journal includes the amount you owe HMRC as a payment from your bank.

This uses the same bank account where your net wages post to. You choose which account to use when enabling Payroll integration.

Pension payment details

To help you track your pension payments, record the total amount of pension contributions. You can do this after processing the pay run by using Review contributions and record payments.

▼ View steps
  1. Select Pensions.
  2. Select Review contributions and record payments.
     NOTE:     This option is available for each pension scheme you have set up.
  3.  Check the Record amount to pay to Pension Provider amount is correct and select the Payment date. This is what posts to Accounting.
  4. Select Record Payment.

Pension journals

The journal uses the default ledger accounts in Sage Accounting.

If you want to record the journal using your own ledger accounts, you need to create a manual journal instead. You may also want to do this if you require more detailed reporting. For a list of the journals posted, read what's posted to Accounting when integrated with Payroll.

Pension payment

The journal includes the amount you owe the pension provider as a payment from your bank.

This uses the same bank account where your net wages post to. You choose which account to use when enabling Payroll integration.

You'll need to repeat this process for every pension scheme you have set up.  

Related Solutions