Payroll Check Tool: automatic checks of payroll administrations in Nmbrs
A checking tool that tests a payroll administration in Nmbrs on 100 points and shows straight away what is not right yet: from contracts and personal details to wage tax settings and wage codes. Built as a plugin on Nmbrs, so a firm can run the checks at any moment, for example before the year-end transition.
Works with
The question
What it was about
A mistake in a payroll administration is easily made and often only surfaces at the year-end transition or when an employee asks a question. Checking by hand means going through the same lists every period for every administration: contracts, hours, personal details, wage tax settings, wage codes. The request was to automate those checks as a plugin on Nmbrs, so a firm can see at any moment where things go wrong and December and January are no longer dominated by searching.
What we built
The solution
The checking logic: 100 control points that test the set-up and use of the payroll administration, including WAB checks on contracts, contract hours, personal details, LIV borderline cases and LKV end dates, missing fields in the wage tax settings, employee insurance schemes, a new income relationship (IKV) number at retirement age, deviating special rate (BT) percentages, unusual input values for deductions, differences in the payroll journals and unlinked wage codes.
The integration with the Nmbrs API that retrieves the data of a whole administration or part of it, and the reporting that shows per check which employee or setting deviates and what was expected.
A set-up in which checks are recorded as separate, tested rules, so that new control points can be added and the tool can later be extended to other payroll packages.
In brief
For whom
Payroll administrators and accountants working with Nmbrs
Client
HRplugin (Waalwijk), which offers the tool as a plugin
Role of LK Software
Design and development of the checking logic, the reporting and the integration with Nmbrs
Packages
Nmbrs
Status
In production, used by firms
How it works
In four steps
01
Connect
The tool is connected once to the firm's Nmbrs environment.
02
Retrieve
The tool reads the administration via the Nmbrs API: employees, contracts, settings and wage codes.
03
Check
100 control points are run over the whole administration or a selection.
04
Fix
The firm works through the deviations found, for example before the year-end closing or before a pay run.
Result
What it delivers
Firms see straight away what is not right in the payroll administration, instead of after hours of manual checking.
Especially around the year-end transition that saves a lot of time: the year-end closing is faster and needs fewer corrections.
Checks are recorded as tested rules; we apply the same approach for other firms or packages.
More projects
Also interesting
WAZO daily wage
The UWV, the Dutch employee insurance agency, only tells you afterwards how high a WAZO benefit should have been.
View projectPension filing taxi & transport
Pensioenfonds Vervoer, the Dutch pension fund for the transport sector, has no automatic integration with payroll packages, so transport companies with many on-call workers process dozens of changes by hand every month.
View projectNmbrs SDK
Two open source Python packages that reduce working with the Nmbrs API to a few lines of code: nmbrs for the SOAP API and nmbrs-rest-api for the new REST API.
Want something similar?
Describe your situation and the packages you use in a few sentences. Within one working day you get an honest estimate of approach, lead time and costs.