Number format and rounding in Jems

In this section the rules for number formatting, conversion and rounding are provided.

General rules for budget formatting in Jems

• Numbers and percentages are displayed with two decimals with the exception of flat rates, they are without decimals.

• There is a dot as 1000’s separator, comma as a decimal separator (both in exports and in the system)

Rounding of percentages (co-financing)

Due to rounding it is generally advisable to not use aggregated percentages (e.g. Total project ERDF fund rate) to calculate values but rather take individual percentages on the same level as they were entered into the system and sum up the calculated amounts (e.g. rather use partner ERDF fund rates and sum up the values).

Funds

• Are always rounded down to 2 decimals (cut off)

• further calculations are done with rounded amounts

Contributions

• Are always calculated as the difference between the sum of the calculated funded amounts (rounded down to 2 decimals) and the total.

Of which … contributions (public/private/automatic public)

• Are a sum of input fields (2 decimals) in the Application Form

• The of which … contribution percentage rate is rounded down to two decimals.

• In reporting the of which … contributions are calculated using the rounded down percentages of the Application Form.

Flat rates

• Are always calculated based on totals of cost categories and not on single budget or expenditure items (in both Application Form and Reporting)

• Are always rounded down to 2 decimals (cut off)

• Further calculations are done with rounded amounts (e.g. flat rates on flat rates)

Example: Flat rate for Office and administrative costs calculated in the budget tables

Other percentages across all parts of the system (e.g. budget remaining, % of total, share per partner, etc)

• Are calculated through mathematical rounding to two decimals.

• There is no recalculation done using these percentages but amounts might be summed up and the percentage is then freshly calculated.

Currencies & Conversion in Jems

• Figures in the AF are inserted as Euro amounts

• In reporting figures can be inserted in any other currency than Euro

• Example: Unit costs can be setup in the programme setup as both Euro and another currency. In the AF the Euro is represented, while in the Partner report either currency can be chosen.

• Exchange rates are taken from InforEuro with full decimals.

• Conversion is done in the partner report through Mathematical rounding to two decimals.

Negative amounts

In several sections it is possible to enter negative amounts into number fields by entering the number and a “-” afterwards.

Please be aware, a “-” cannot be entered in front of a 0,00 - this is why it has to be entered after entering the number.

Negative declared amounts in the List of Expenditure

It is possible to report cost items with a negative Declared amount in the Partner report List of expenditures. Negative amounts shall only be reported in exceptional cases in the list of expenditure.

Negative amounts in the List of Expenditures shall not be used to register corrections for irregularities, as those corrections shall be registered in the section Corrections.

Please be aware:

• In case of a Partner report, where cost categorie(s) forming the basis for a flat rate have a total negative declared amount, the flat rate calculated will be rounded in favour of the beneficiary (cut off after 2 negative decimals) in this report.

• In case of a Partner report, where the total declared amount in the report is negative, the fund amounts calculated will be rounded in favour of the beneficiary (cut off after 2 negative decimals) in this report.