Visma Enterprise and Prowi: From Commission to Payroll Without Manual Handling
Visma Enterprise is a comprehensive ERP solution for medium and large businesses. With modules for finance, HR, and payroll administration, Visma Enterprise gives companies a unified overview of their business operations.
Prowi calculates commission and bonus on data from your CRM. Once the period is approved, Prowi builds a file in Visma Enterprise’s import format, so the amounts can be imported into Visma Enterprise without being typed again.
From Calculation to Payment Without Manual Steps
Many companies use Prowi to calculate commission and bonus, but when the figures need to be transferred to the payroll system, it still often happens manually. This creates duplicate work and risk of errors.
With Prowi the typing disappears. The rep confirms their statement, finance approves the period, and Prowi collects the amounts in a file with one line per employee and pay type. The file is imported into Visma Enterprise, and commission is paid with the normal salary.
What syncs to Visma Enterprise
The integration runs one way: from Prowi to Visma Enterprise. Prowi does not read payroll data from Visma Enterprise, and nothing reaches payroll before the period is approved.
- Content: employee number, pay type, amount and date for each approved commission. If a rep has commission and bonus on separate pay types, each becomes its own line.
- Format: a CSV file in Visma Enterprise’s import format. You set up the columns and date format once.
- Frequency: one file per payout, usually once a month when the period is approved.
- Corrections: changes from earlier periods are included in the amount on the next file.
Menus and import formats change, so always follow Visma Enterprise’s current guide when you set up the file import the first time.
How to set it up with Visma Enterprise
- Create pay types in Visma Enterprise for commission, and ideally for bonus and corrections too. Check they are set up correctly for labour market contribution, holiday pay and pension.
- Add each rep’s payroll number in Prowi so it matches the employee number in Visma Enterprise.
- Link each commission model in Prowi to the right pay type, and set up the file’s columns and date format to match Visma Enterprise’s import format.
- Make a test file for a closed period and check the amounts against your current statement before the first real payroll run.
- Every period: approve the statements in Prowi, download the file and import it into Visma Enterprise.
What you can calculate and send to Visma Enterprise
Visma Enterprise only receives the final amount. The calculation happens in Prowi on data from your CRM: flat rate, tiered rates, bonus on target attainment or a mix. Visma Enterprise is typically used by larger organisations with many employees, several plans and a need to reconcile.
Cancelled deals are handled as rules, for example with clawbacks, and appear as a negative line in the next file. The amount lands on the payslip as variable compensation, and the guide on commission automation from Excel to API explains how the payroll step can be automated.
Benefits of the Integration
No typing: The amounts come from Prowi in a file, so nobody has to copy commission figures from a spreadsheet.
The right pay type every time: Each commission model is linked to a pay type once. The pay type’s setup in Visma Enterprise controls tax, holiday pay and pension.
Full traceability: Each payment can be traced back to the specific commission calculation in Prowi. This makes auditing and control simpler.
Corrections without reopening payroll: If a deal changes after payout, the difference is included in the next file. A closed payroll run is never touched.
Fewer errors: When figures are not typed again, typing errors and wrong pay types go away.
Who Benefits from the Integration
For HR and payroll administration, the integration means less manual work and fewer errors. Commission figures come from Prowi in a file that is ready for Visma Enterprise.
For employees, the integration means commission is paid out quickly and correctly. They can trust that their earnings are processed correctly every month.
For management, the integration provides oversight of commission payments and ensures compliance with Danish rules for salary and tax.
To see the flow on your own data, book a demo.
