1. Administering Payroll for Bahrain
  2. Number Formatting in Payroll Reports

Number Formatting in Payroll Reports

Use the Unit of Measurement (UOM) option to define how numbers are formatted and how payroll reports display Balance values based on its UOM definition.

You can format precision or number of decimal values for the following in payroll reports:
  • Hours
  • Amount
  • Time

However, when you use the MS Excel format for a payroll report output and view the output on your local computer, MS Excel does its own formatting based on the settings on your local computer. In order to maintain consistency across the various output formats of MS Excel, PDF, Text, ensure that the settings on your machine are consistent with the UOM definition. and following standards as given here:

Follow these standards while formatting the values:
  • Currencies are always shown as two decimal values after the separator, example, 151.25 or 130.10. The zeros shouldn't be truncated.
  • Date and Time values are as per the UOM definition and they don't follow your preference settings.
  • Time is displayed as HH, HHMM, HHMMSS each representing hours, hours and minutes, and hours, minutes, and seconds, and separated by colons(:). For example, 4:15:00.