← All case studies

HR, Payroll & Benefits Administration

Reconciling Medical Aid Billing Against Payroll Deductions Every Month with Nine Automated Checks

A multi-site business with a large workforce used Docwize to reconcile the medical scheme's monthly billing schedule against payroll deductions — nine automated checks, a change report that routes each exception to the right team, and a payroll-outcome column that confirms which corrections actually landed.

Programme administrators reviewing beneficiary compliance records and linked supporting evidence

Nine automated checks per period

Membership gaps on either side, dependant counts, contributions, savings, plan options, terminated-member billing and code mismatches.

Every exception routed to an owner

An action column assigns each flagged row to the scheme, payroll or HR, with the description already written.

Late-joiner penalty detection

Premiums compared against a per-plan-configuration baseline to surface members being charged above the norm.

Reconciled schedule generated, not rebuilt

The monthly payroll schedule and the payroll-outcome check are produced from the reconciled data.

The challenge

Each month the medical scheme issued a billing schedule and the HR team issued a payroll deduction schedule. With frequent joiners, leavers, option switches and dependant changes, keeping the two in step was a manual monthly exercise across contributions, dependant counts, plan options and savings amounts. Future-dated changes were tracked by hand, so deduction errors surfaced only at month-end. Late-joiner penalties were calculated separately with no system check. Every individual's deduction depended on getting it right, and errors had a direct financial impact on employees.

The approach

Both schedules were brought into Docwize as structured period data, matched member by member, and compared with a fixed set of checks. The output is not a spreadsheet of differences but a change report in which every row already carries a diagnosis and an owner.

  • •Ingest the scheme's billing file and the payroll deduction file each period into custom field grids, matching members on identity number and employee code
  • •Build a consolidated billing view per period and a change report comparing the latest period with the prior period and with payroll
  • •Apply nine automated checks — members in billing but not in payroll, members in payroll but not in billing, adult dependant count, child dependant count, contribution amount, savings amount, plan option, terminated members still being billed, and employee code mismatches — with credits and reversals flagged separately
  • •Assign an action to every flagged row: query the scheme, update payroll, or verify with HR — and detect late-joiner penalties by comparing each member's premium to the most common premium for the identical plan configuration in that period
  • •Cross-reference the returned payroll file against the change schedule to mark each change Reconciled or outstanding, trigger reminders for future-dated changes, and generate the reconciled payroll schedule automatically

What the analysis revealed

Most exceptions were timing, not error

Joiners, option switches and terminations frequently landed in different months on the billing and payroll sides. Flagging them by type, with the effective date, separated genuine mistakes from changes still in transit.

Late-joiner penalties were invisible without a baseline

A statistical baseline per plan configuration — option, chronic and hospital cover, adult and child counts — made members paying above the norm visible for the first time, and gave them a dedicated tracking report.

The loop had to be closed

Issuing a change schedule to payroll was not enough. Comparing the returned payroll file to the schedule showed which changes had actually been applied and which needed to be chased.

Outcome

Reconciliation now runs against the same nine checks every month, with exceptions grouped by type and routed to the scheme, payroll or HR. Future-dated changes generate reminders before the payroll run rather than explanations after it. The reconciled payroll schedule is generated from the reconciled data instead of rebuilt from source files, and the payroll-outcome column gives HR a defensible record that each correction was applied — or a list of the ones that were not.

Reconciling benefits billing against payroll by hand every month?

Docwize turns the two schedules into matched records, runs the checks, and tells each team what to fix. Get in touch to discuss your payroll reconciliation.

Get in touchView all case studies