Wednesday, May 21, 2008

DIY Accounting Payroll Software Questions And Answers

DIY Accounting Payroll Software Questions And Answers
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 designing
Accounting Software at http://www.diyaccounting.co.uk/
providing complete accounting solutions for small to medium
sized business in the UK with payroll software at
http://www.diyaccounting.co.uk/payroll.htm for up to 20
employees

No comments: