Back to Payroll System

Payroll Processing System

A bridge between shift data and payroll systems — tailored to your company

Python notebooks • DK / H3 ready output • Runs locally or in the cloud

Tailored to you

Not you to the system

Bridge between systems

DK / H3 unchanged

No risk

Pay only on success

No need to replace DK, H3, or your existing databases

What the algorithm takes over:
Manual validations
holiday pay · sick-leave · overtime
Transcription errors:
0
automatic validation

The Problem: Current Payroll Process

A typical monthly close

Shift Workers (40 people)

  • • Program A: calculate day/night hours
  • • Manual transcription to Excel
  • • Check each sick leave separately
  • • Manually add meals, mileage
  • All checked by hand

Regular Employees (60 people)

  • • Program B: enter overtime (different interface)
  • • Check sick leaves
  • • Program C: add bonuses, stock
  • • Merge data into DK or H3
  • All checked by hand

Multiple data entry

Same data in 3-4 systems

Transcription errors

Especially with many employees

Manual validations

Hand-checked every month

Algorithms tailored to your company

With most solutions, the company must adapt to the software. Here it's the opposite.

Typical payroll systems

  • Fixed rules — the company must adapt its workflows
  • Fixed shift codes — you must use their names
  • Changes require expensive custom development
  • You pay for features you never use

This solution

  • Algorithms written around your union agreements
  • Your own shift codes — unlimited number
  • Rules change → code updated. No new system needed
  • DK, H3, and your existing database remain untouched

Already on Advania, Origo, or Business Central?

I add the validation you're missing as a separate microservice alongside your system — lighter and cheaper than a vendor change request, because one change in a large system must stay backward-compatible for every other client, while a standalone service just needs a small edit.

Shift codes defined by your company — no limit

The system is not locked into a fixed set of codes. If your existing scheduling system already uses its own codes, we only need to know what they mean.

Hospital

DAY NIGHT ON_CALL SICK_CERT TRAINING

Restaurant

LUNCH DINNER EVENT PREP HOL_PAY

Factory

SHIFT_A SHIFT_B SHIFT_C SICK_1D OVERTIME

Codes can be in any language. New codes can be added without disrupting existing ones.

The Solution: A bridge between data and DK / H3

DK and H3 stay unchanged. Python notebooks, tailored to you, handle the calculations in between.

Shift files

Your own codes

Python Notebooks

Calculations tailored to you

DK / H3 import

Ready Excel

New process

1

Fill / export

Excel with shifts, your codes

2

Upload + click

"Process" in system

Python notebooks

Calculate per your rules

Download result

Excel ready for DK/H3 import

The accountant only prepares the input and reviews — every validation runs automatically.

What the System Does Automatically

Each of these steps is designed around your rules — not a generic standard

1. Sick Leave Validation

For each employee, system automatically checks if sick leave limit was exceeded

Tailored: Sick day limits and handling of excess days are configured based on your specific union agreements

2. Work Hours Classification

System divides each shift into: day, evening, night, holiday hours — results in columns DK/H3 already understands

Tailored: Evening/night thresholds, holiday lists, and pay multipliers configured to your agreements

3. Overtime Calculation

System calculates required hours and compares with actual — result directly into DK/H3 import columns

Tailored: Overtime rate tiers and special rules for different employee groups are built in

Additional System Features

Vacation and December Bonuses

  • • Checks if worked minimum 12 weeks
  • • Identifies shifts qualifying for bonus
  • • Calculates due bonus as of settlement date
  • • Includes in final payment (if employee leaving)

Tailored: Eligibility and calculation follow your specific agreement

Additional Payments

In same Excel — output ready for DK/H3:

  • • Meal costs (+ tax information)
  • • Car usage (cost reimbursement)
  • • Company stock / one-time bonuses

Excel File Structure (input)

Employee ID Start DateTime End DateTime Shift Type Notes
EMP001 2024-01-15 08:00 2024-01-15 16:00 REG -
EMP001 2024-01-16 08:00 2024-01-16 16:00 SICK Sick leave
EMP002 2024-01-15 14:00 2024-01-15 23:00 NIGHT Night shift

Shift codes: These are example codes. Your company defines its own codes — unlimited number, in any language. If your existing scheduling system already uses its own codes, we only need to know what they mean.

Technical Architecture

Data In

Excel, export, SQL — your own codes

Python Notebooks

Algorithms tailored specifically to your rules

Your Data Sources

Azure, SQL, Excel — whatever you already have

DK / H3 import

Excel in your payroll system's format

Python Notebook Execution Options

Local

  • • Data never leaves your environment
  • • Works without internet
  • • Jupyter, VS Code, etc.

Azure

  • • Azure Functions
  • • Microsoft Fabric
  • • Automated scheduled runs

Other platforms

  • • Databricks
  • • JupyterHub
  • • Any Python environment

The same code — tailored to your rules — runs in all environments.

Integration with existing systems — without replacing them

Data input

If scheduling system exports to Excel → use directly as input, with your own codes

Results export

Output format adapted to DK, H3, or any other payroll system's requirements

Modularity

Can use only parts — e.g. only sick leave validation

System Implementation

1

Requirements Analysis

Understanding current data flow, union agreements, shift codes, and formats your DK/H3 accepts

2

Algorithm Configuration

Algorithms adapted to your union agreements, shift codes, and specific needs — not the other way around

This is the key step
3

Testing & Training

Testing on real data, verifying DK/H3 import, accounting team training

No risk — you pay only when it works

If we successfully automate your payroll processing, you pay. If not — you pay nothing.

Pay on success

No charge if it doesn't work

Zero implementation risk

Code doesn't touch DK or H3

You decide usage

Accounting chooses each period

Want to see how it works with your data and rules?

Try the demo or get in touch — we can walk through how the algorithms are tailored to your union agreements, shift codes, and DK/H3

Phone: +354 782 3011 | Darius Domagala