Sage Accounting and Payroll
Are you on the latest version of 50 Accounts and Payroll?
Are you on the latest version of Sage 50 Accounts?
To ensure that you are benefitting from the latest Updates, go to Help > About > on your system and check that you have one of the following. If you have a Network version, all users must be on the same version:
50 Accounts and Instant Accounts
v2020 – 26.3.245.0 (after loading Update 3 23 May 20)
v2019 – 25.1.128.0 (after loading 25.1 Update 19 Apr 19 )
v2018 – 24.2.228.0 (after loading Update 2)
The following versions will not be compatible with Making Tax Digital:
v2017 – 23.2.4.279 (after loading the May 2017 Improvements Update and Service Pack 3)
v2016 – 22.1.10.394
50 Payroll
Payrolls are updated with a completely new version each Tax Year End.
Each year there is the Update which will include the Tax Tables for the New Tax Year as well as the Year End function for the current tax year.
For the Tax Year End 2019/20, because of delays in the Budget, there have been three phased releases of Updates.
After loading the two Updates 1 & 2 and the two Job Retention Modules the version becomes 26.01.244.
Accounting By Computer is as easy as ABC
Employer’s Allowance for National Insurance
How to process the Employer’s Allowance for National Insurance.
This is £4,000 for the 2020/21 Tax Year. But there are certain changes to the rules, you need to apply again, see below for change of procedure.
The reduction in the NI you pay is reclaimed over the first few months depending on the amount of Employer’s NI you pay each month. It is deducted each month until the total of £4,000 has been recovered.
In the Payroll:
- In Company > Settings > there is a new button (bottom left) “Apply for EA”. You cannot take the deduction until HMRC have confirmed.
- As usual print the monthly P32 Employer Payment Record which shows the Tax & NI payable for the month and the Employer’s Allowance.
In the Accounts:
There is no automatic inclusion of the Employer’s Allowance in the Nominal link, so it has to be processed manually.
- Select Nominal > Journal. Create a new Memorised Journal to Debit the PAYE/NI Control Account in the Balance Sheet and Credit the Employer’s NI account(s) in the Profit & Loss Account. (Note – if you have more than one you may have to calculate an approximate percentage to each account.)
- From the P32 Payment Record report extract the Employer’s Allowance and enter it the Memorised Journal that you have created each month until the Allowance has been totally used.
Coronavirus Job Retention Scheme
It is assumed that you have already been to the Govt. Website explaining the Scheme:
https://www.gov.uk/guidance/claim-for-wage-costs-through-the-coronavirus-job-retention-scheme
There is new “Job Retention Scheme” Module available free for Sage Payroll Systems. If you cannot access it from the link on opening the Payroll, go to the Sage Website> Support > Download and download it to your computer to install it.
Calculating the Claim.
Before making the claim ensure that you have all the information noted in the HMRC website
You can either use the Payroll Module to calculate the claim or use the Calculator on the HMRC website. Be warned, if you have a Weekly Payroll, or need to calculate part of a month, the HMRC calculator needs Saturday and Sunday to be included.
Be warned that you must have all the info before you start, the system will throw you out after 30 minutes, so you don’t have time to leave it to ferret out information.
The claim is made for the whole Company for each of the three costs, (i.e. Gross Pay, Employer’s NI and Employer’s Pension Contributions) you will not have to claim for each individual employee.
Making Changes to the Accounts and Payroll.
- In Accounts set up a new Nominal Account, in the Overheads, close to your Wages costs, for “Furlough Pay”. Set up another, adjacent to that, for “Furlough Pay Grant”; you should be aware that this is treated as “taxable income” in your Corporation Tax/Income Tax Computations, so your Tax Accountant will need to identify it. These should offset one another, but there may be timing differences.
- In Payroll set up a new Pay Element for “Furlough Pay”. Untick the two boxes“Value” and “Hours” for Minimum Living Wage; leave all the other boxes ticked if they apply in your Company’s case.
- In Payroll> Nominal Settings set Furlough Pay to post to the new Nominal Code set up in para 1 above.
Points to Note
- You should also be aware, when making the claim, that, if you get the Small Employer’s Relief of up to £4,000 this year, you may not be paying any Employer’s NI for a while.
- When Payroll posts the Employer’s NI Contribution to the Nominal Ledger, there will be one figure. I suggest you calculate the amount relating a manual journal for these costs (for only the Furloughed Staff) to the same account.
Working From Home – Coronavirus
If you have a Sage 50Cloud Accounts, do you realise that it has Sage Drive as standard in the system? This will enable you to link a computer outside to a computer in the office.
This link will take you to Sage’s website where it is explained:
https://ask.sage.co.uk/scripts/ask.cfg/php.exe/enduser/std_adp.php?p_faqid=46314
As always, if you need more help contact me.
The Government has announced that, for staff off work due to self isolation, here is the advice from Sage to calculate Statutory Sick Pay without the three Waiting Days:
https://ask.sage.co.uk/scripts/ask.cfg/php.exe/enduser/std_adp.php?p_faqid=11698&p_pv=0