HMRC will advise the new tax code change from 543 to 603 which was announced in May 2008 and the date the new tax code to be applied which is expected to be September 2008. The amended tax code is entered as a new tax code on the employee details tax amendments section of the payroll file and the tax reduction is then automated at the date the new tax code is applied. The income tax deduction calculated by the DIY Accounting payroll package is different to the inland revenue CD Rom.
Small differences can occur because the DIY Accounting payroll system has in the past used the revenue manual tax tables whereas the inland revenue employers CD Rom uses a percentage calculation. In fact the manual tables jump in pounds and tax tables can increase by four pounds between different look up rates which can create small differences.
In the current financial year many of the financial income tax and national insurance calculations have been changed in the DIY Accounting payroll calculations to a mathematical percentage basis. Differences can still occur where the subject of the calculation is rounded to ignore the pence.
All these differences are minor and immaterial and adjust themselves since tax is calculated on a cumulative basis Employee gross pay was entered and no national insurance was calculated.
The national insurance table applied is shown in the column to the left of the employees name on the payroll sheet and you will probably see the letter C when because this employee is of working age and not a second employment the national insurance table letter should be A. Check the date for both for this employee which may have been omitted or entered wrongly. Income deducted for my employee who is on a normal tax code was much higher than normal.
The tax code column to the left of the employees name on the payroll sheet may appear as zero which should show the tax code. To resolve the tax code check the employee starting date has been entered and the numerical value of the tax code in the employees details and the date that tax code should be applied. When I try to enter wages on the payslips the sheet comes up protected
No entries are required to the payslips file. All entries are automated from the payroll file and the protection prevents corruption of the formulae in the payslip file. The entry on the payslip file can be changed by entering the required gross pay on the payroll workbook and the payslip will automatically update itself from there as part of the paye system.. I cannot see any tabs at the bottom of the payroll software workbook.
After entering the employee details navigate to the month in which you wish to enter gross pay by clicking the tab buttons at the bottom of the excel spreadsheet. If you do not see any tabs at the bottom of the sheet you may not be viewing the full sheet. Click the square box at the top of the menu bar to view the full sheet and the tabs should then be visible. When I open the payslips file I receive an error message saying read only, un repairable error has occurred.
This is likely to have been an interruption during the download process that has corrupted the payslip file. Download the payslip workbook again direct from the confirmation email sent to you after purchase. We bought the up to 20 employee payroll package and now have 23 employees.
Make a second copy of the payroll software, saved into a separate folder and split the payroll into 2. Perhaps use one package for one department and the other package for a different department or use one for existing employees and the other for new starters
Do I purchase a new payroll software package each financial year or can the payroll software be updated for more than one year paye purposes
The payroll software include that years tax rules to enable the packages to automate the production of that years tax returns. Each year has new tax rules embedded and being on excel rather than a database then it is necessary to purchase a new package each year. Does the payroll software automatically generate the amount payable to the inland revenue each month.
The payroll package automatically calculates the income tax and national insurance and collects the information on a paye payments schedule so you know exactly how much to pay each month. The paye calculations also complete all the revenue forms including the P35 annual employers return which is required when you file the paye information with the revenue at the end of the financial year. The payslip workbook is not automatically updating from the payroll.
The payslip updates automatically and there are no calculations on the payslip file or links out of that file. The most likely cause is that the payslip file was renamed and has broken the links from the payroll file. If you have saved the file after breaking the links by renaming the solution is to download the payslips file again without changing the name
Terry Cartwright is a qualified accountant in the UK designs Accounting Software UK on excel spreadsheets providing complete Small Business Accounting Software solutions for small to medium sized business with Paye Payroll Software packages producing payslips for up to 20 employee that automates the revenue payroll tax return