Rounding problems - General Operations

Web Site

17 May 2012

Download Free Payroll Software
Download the 12Pay payroll software.
2 Minute Demo Video
Nought to Payslips in 80 seconds...
Introductory Training Video
A movie describing the basics of how to use the 12Pay software.
More Videos
Movies covering a variety of aspects of using the software can be found here.
Prices
Buy or Renew Licence
Go to the "My 12Pay" page, where registered users can buy or renew their licence.
Enterprise Payroll Software
Here is some information about our Enterprise Payroll Software solution
Discussion Forum
The Official 12Pay Discussion Forum
What Our Users Say...
Many comments from users of the 12Pay software who find the payroll easy and accurate (and even fun!)
Adobe Acrobat Reader
The 12Pay payroll produces reports in the form of Adobe Acrobat files. You need the (free) acrobat reader to read them and to print them. Many PCs will already have this software installed.
HMRC Advice
HMRC advice for new employers
Contact Us
Please send us your feedback concerning our product
Year End Instructions

10,000 employers pay 90,000 employees using 12Pay

Please Use the Forum...

But before posting a message in the forum or emailing us please read the Frequently Asked Payroll Questions and also our Getting the most out of 12Pay's Payroll Software Usage Guide first.

You can post your questions in this forum but many users still prefer to send us direct emails.

Please consider asking your questions here. If you ask your questions here then everyone can see them, and they may be able to share your answers if they have the same question. We automatically get an email anyway whenever an entry is made in the forum, and you can tick a box to get emails whenever your question gets a reply. Other users will not see your email address unless you openly post it in the forum.

Search Home

01/02/2012 13:34

Bill

Joined: 10/03/2010

Posts: 3

Rounding problems

I have noticed a problem that has only occurred (I think) since I upgraded to version 1.12.11.

I pay people based on hours worked and at a variety of different hourly pay rates. Each week I import a text file with the staff codes, pay codes, rates and hours. As you would expect my import file shows pay rates in 99.99 format. But after I have imported the file and the payroll has been calculated about 10% of my pay rates have been changed by 12Pay. For example, £8.50 may have changed to £8.5007. The import file definitely shows £8.50.

01/02/2012 13:55

12Pay Support

Joined: 13/02/2007

Posts: 1336

Re: Rounding problems

Bill, Could you please give us a specific example of a number of hours and a rate that exhibit this problem, please? We've made some changes to the way imports work and we'll see if we can see what is happening.

12Pay Support

01/02/2012 14:34

Bill

Joined: 10/03/2010

Posts: 3

Re: Rounding problems

I'll send you a sample import file. Thanks.

02/02/2012 06:47

12Pay Support

Joined: 13/02/2007

Posts: 1336

Re: Rounding problems

Bill, It is because your rounding rules aren't quite the same as the ones the software employs, so for example the software has 16.5 x 8.57 as 141.40, not 141.41, and corrects the rate to get your desired result of 141.41. Neither rule is right nor wrong.

The easiest fix is to not include the amount in your csv. But do include the comma, like this...

00234,WKD2,16.5,8.57,

Or put a heading on the csv file like this:

employee code, payment code, hours, rate, ignore
00234,OT2,16.5,8.57,141.41

etc

12Pay Support

Page 1 of 1