Discuss a project
EN LT
Discuss a project

Payroll calculation for employees working in Lithuania and Sweden

A module that calculates Lithuanian and Swedish pay together, converts the currency and shows the difference from the accountant's figures.

Client
Company with employees working in Lithuania and Sweden
Area
Process automation, system integrations
Status
In use

The task

Some employees work in Sweden. Their gross pay and Swedish income tax are calculated in a Swedish payroll program, the gross is converted to euros, and Lithuanian social insurance is paid on it. The same employee can also get a separate Lithuanian payslip with base pay, a daily travel allowance and a bonus.

Accountants receive either the net or the gross amount and have to work out the other. Until now the calculation relied on an Excel model that had not been verified.

What we built

  • The module runs inside the client's employee and schedule portal and takes hours, country, project and business-trip dates from it.
  • The Lithuanian and Swedish parts are calculated together, because one employee's month can include hours in both countries.
  • It calculates in both directions, gross to net and net to gross, and shows the difference from the accountant's figures.
  • Currency is converted at the payment-day ECB rate plus the agreed margin. The module fetches the rate itself.
  • Every result comes with an explanation of the calculation.
  • The module does not prepare or file tax declarations.

How we checked it

The specification lists 73 requirements, and about 960 automated tests check the module. When we recalculated the Swedish part of one past month, the income tax, social insurance and net pay matched the accountant's figures for every employee that month.

Have a similar problem?

Discuss a project

Next example Medication management for a care home