Skip to main content

How to Read Your Payroll Reconciliation Report

A column-by-column walkthrough of the Payroll Reconciliation Report, with a worked example using a fictional employee and customer.

S
Written by Steve Waters

The Payroll Reconciliation Report has several column groups for each employee. Here's how to read it:

  1. Find the employee you want to investigate.

  2. Read across the row — left to right, you'll see actual amounts paid in the employee's local currency, the exchange rate used for reconciliation, the same actuals converted to your billing currency, what we billed on the subscription, and the line-by-line difference.

  3. Look at the differences — positive numbers are debits (we'll bill you on the debit invoice for this month); negative numbers are credits (a credit note will be applied to your original subscription invoice).

  4. Total at the right — combined credits/debits for that employee, plus any cross-border fee and country-specific taxes.

Worked example — illustrative only

Employee: John Doe (Singapore-based) · Customer: Acme Corp · Month: March

Line item

What we billed (USD, locked rate)

What was actually paid (USD, recon rate)

Difference

Treatment

Gross salary

$12,000.00

$12,700.00

+$700.00

Debit on the March debit invoice (Gross Salary line)

Employer pension (CPF)

$2,000.00

$1,100.00

−$900.00

Credit applied to the CPF line under John Doe on the original March invoice

Skills Development Levy

$9.00

$9.50

+$0.50

Debit on the March debit invoice (SDL line)

Other allowances

$12,000.00

$12,700.00

+$700.00

Debit on the March debit invoice (Other Allowances line)

For John Doe alone the net is: $500.50 plus a cross-border fee = the debit total on Acme Corp's March debit invoice (combined with any other employees' variances under the same line items), plus a $900 credit applied to John Doe's CPF line on the original March invoice.

This example uses a fictional employee and customer name. The structure of credits and debits is accurate; the names and amounts are illustrative only.

If you'd like a walkthrough specific to your business, your dedicated HR Manager is happy to help.

Did this answer your question?