Expatriate Payroll Articles, Insights and Resources | Certino

Manual vs automated shadow payroll: how to build the business case

Written by Michael De Jongh | 10 August 2021

Shadow payroll is one of those processes that quietly takes over a team’s month. It usually starts with a spreadsheet that works well enough for a handful of assignees, and then the programme grows, new countries are added and the spreadsheet never quite keeps up. If that sounds familiar, this guide walks through what the manual process really involves, what changes when it’s automated, and how to make the case for change internally.

What the manual process looks like

Most manual shadow payroll processes follow a similar pattern each month, once the team has worked out which employees are in scope:

  1. Collect pay and benefits data from each home payroll, often retyping figures from PDF payslips into spreadsheets.
  2. Export relocation expenses from the relocation provider’s system.
  3. Gather equity data and work out which parts are taxable, and where.
  4. Collect travel data to see who worked where, and for how long.
  5. Combine everything and apportion income between countries where needed.
  6. Send the data to a provider to calculate the gross-ups.
  7. Check the results and arrange reruns when something looks wrong.
  8. Post the costs to the general ledger so they can be recharged.

Every step relies on someone getting it right, and each handover is a chance for something to slip. Different people handle the same thing in different ways, questions bounce between teams, and the time it takes grows with every new country and assignee. For a very small population, it can still be manageable. As the programme grows, it rarely stays that way. (We’ve written more about where that time goes in The Hidden Costs of Shadow Payroll.)

What changes when it’s automated

Automation doesn’t remove people from the process, but it changes what they spend their time on. Instead of collecting and retyping data, the team reviews the results and handles the exceptions.

In practice, that means:

  • Data comes in on a schedule from the HR, payroll, travel and relocation systems you already use, rather than being chased by email.
  • Problems are flagged early. Missing or unusual data is picked up as it arrives, so it can be fixed before it reaches a calculation.
  • Pay elements are mapped consistently, so the same item is treated the same way every month, whoever is running the process.
  • Calculations run the same way every time, using tax rules that are kept up to date centrally, with every figure showing how it was reached.
  • Results go where they need to, whether that’s your payroll provider, your finance team or your reporting tools.
  • There’s a full audit trail, so when someone asks why a number changed, the answer is there.

Why it’s worth it

Faster answers. When the tax rules are maintained centrally and calculations run in minutes rather than days, the team can answer questions and react to changes far more quickly.

Lower cost. Less time spent on manual processing and reruns means lower internal costs and fewer adviser fees for routine calculations. Reliefs and allowances are applied consistently rather than depending on who remembers them.

Better use of your people. Mobility and payroll specialists spend their time on judgement, policy and looking after assignees, rather than reconciling spreadsheets.

Knock-on improvements. Cleaner shadow payroll data helps upstream and downstream too, from cost forecasting to recharging and year-end true-ups.

Building the business case

Most change needs a business case, and the strongest ones are specific. Here’s what to cover:

  • Compliance: where your current process creates risk, such as missed income, late reporting or penalties, and how automation reduces it.
  • Time: how many hours your team spends each month on collection, checking and reruns, and what that time could be used for instead.
  • Cost: internal time, adviser fees and the cost of corrections, compared with the cost of an automated solution.
  • Quality: fewer errors, fewer assignee queries and better data for the rest of the business.
  • Visibility: clearer cost reporting for budgeting, recharging and transfer pricing.
  • Scalability: whether the current process can handle the next five countries or fifty assignees without more headcount.

Measure where you can. Even a rough record of a typical month, such as hours spent, reruns needed and queries handled, makes the case far more convincing than general statements. Then find a senior sponsor who can take it to decision-makers and champion it through.

Where Certino fits

Certino is the calculation layer for shadow payroll, hypo tax and gross-ups. We bring together the data you already hold, calculate payroll-ready figures with full workings, and hand them to your payroll provider. We don’t run payroll or replace your tax advisers. We make sure the numbers they rely on are right.

You can run it yourself on the Certino platform, or hand the work to our managed service. If you’re not sure whether you’ve reached that point, six signs it’s time for a managed shadow payroll service is a good place to start.

If you’re building a business case, book a consultation and we’ll help you put real numbers to it.