Løn

Danløn + Prowi

Fast CSV integration between Danløn and Prowi. Automate commissions and bonuses from CRM to payroll, gain real-time transparency for salespeople, and give management full control with audit trails and fewer manual tasks.

Anders Goosmann, CEO @ Prowi

“CSV integration with Danløn makes commission and bonus simple, accurate and traceable. We connect CRM, calculation, and payroll, so salespeople get real-time insights and give management peace of mind.”

image of tech solutions demonstration (for a hr tech)

Danløn is a widely used Danish online payroll system for small and medium-sized companies in particular. It is user-friendly, inexpensive and cloud-based, and has been around for more than 20 years with tens of thousands of companies as customers. The system offers payroll, HR and integrations in one solution so that payroll can be run correctly and on time.

When a direct API integration is not available, Danløn can handle data exchange via CSV files. This applies to both exporting accounting data and transferring it to other systems, making CSV a simple, robust path to automatic commission and bonus in Prowi without major IT projects.

Why choose CSV between Danløn and Prowi

  • Fast deployment without long development
  • Stable data flow from CRM to Prowi and beyond to payroll
  • Correct calculation of commission and bonus with full audit trail
  • Less manual work for finance and HR
  • Transparent insights for both employees and management

Danløn is positioned as an easy, secure and low-cost system for payroll and HR. This makes the CSV path obvious for many SMEs who want to start automated commission settlement quickly.

How the data flow works

  1. CRM and finance provide data base for CSV
  2. CSV is securely uploaded to Prowi
  3. Prowi calculates commissions and bonuses according to your rules
  4. Managers approve with audit trail
  5. Approved amounts are exported to Danløn for salary driving

Danløn already supports importing and exporting files in various workflows, reducing duplicate entries and errors.

What fields should the CSV contain

  • Employee ID, department, role
  • Order number, closed date, invoice date
  • Revenue, Diet, Gross Margin
  • Product line or subscription type
  • Customer ID and customer type
  • Commission model, rate and period
  • Corrections and reference to the credit note

A clear file specification makes the integration robust and audit-ready. Several Danish tools show that CSV is a normal integration path when there is no direct API and that it reduces errors and administration.

Commission models Prowi supports

  • Percentage of sales
  • Steps and Accelerator
  • Advance-based calculation
  • Subscription-based payout
  • Team or pool
  • Advances against commission in ramp up

Example of calculation

Turnover 250,000 kr.
Step 0 to DKK 100,000 gives 3 percent
Step 100,001 to DKK 250,000 gives 5 percent
Commission 3,000 DKK plus 7,500 kr.
Total DKK 10,500 with full audit trail

Approval, control and compliance

  • Rules are bound to specific data fields
  • Voting against source data
  • Clear logs for corrections and credits
  • Export files with unique references to Dan

Danløn emphasizes safe, stable operation and a large volume of paychecks per month, which emphasizes the importance of traceability and proper file management in your process.

Security and data protection

CSV files are handled through secure channels, access is managed by role, and Prowi follows principles of data minimization and retention. Setup is adapted to your internal controls and GDPR, while Danløn provides the salary professional engine at the last stage.

Low Risk Deployment

  • Week 1: File specification, mapping and test data
  • Week 2: Pilot import, validation and correction rules
  • Week 3: Approval flow, export to Danløn and go live

This step-by-step model has been proven in Danish integrations, where file exchange is a normal method to avoid double entry and minimize errors.

FAQs

Can we change rules without changing CSV
Yes. In adjusts rules in Prowi, while preserving the CSV structure. New rules are being tested in sandbox.

Can we combine revenue and profit margin
Yes. Choose revenue for simplicity or margin for margin focus. Models can be combined per product line.

How to handle credit note and corrections
Lines with reference to the original order are loaded as correction. Prowi updates computation and log for full traceability.

How often should we exchange files
Daily, weekly or monthly. A fixed rhythm provides up-to-date figures for employees and makes ongoing approvals easy.