Every month-end, the same race begins again. The finance coordinator puts together a payroll spreadsheet for the Mali mission, a second for Chad, a third for headquarters. Payslips are calculated by hand, social charges change from one country to another, and no one is entirely sure that the latest approved salary scale has actually been applied everywhere. When the donor's auditor asks for the breakdown of salaries by project, you have to reconstruct, from scattered files and multiple versions, who worked on which grant and at what percentage. For many NGOs and CSOs, payroll management remains one of the most risky — and yet most invisible — processes in the entire financial chain.
Personnel costs often represent 40 to 60% of a project's budget: it is the first line examined during an audit and one of the main sources of rejected expenditure. This article unpacks the issues of compliant and auditable NGO payroll management, from the specificities of national and international staff to the traceability required by donors. We will see how to structure this process, what best practices to adopt, and how a platform like Abvius makes it possible to centralise payroll, allocate it automatically to grants and guarantee its audit trail from end to end.
NGO payroll management: securing the leading budget line of your projects
Reading time: ~12 min
- Payroll, the blind spot of donor compliance
- The challenges specific to payroll in an NGO
- Payroll and the audit trail: what donors actually check
- Spreadsheets, local providers or ERP: which approach for your payroll?
- Centralising and securing payroll with Abvius
- Five steps to set up compliant and auditable payroll
- Mini-FAQ
- Summary and resources
Payroll, the blind spot of donor compliance
In the collective imagination, an NGO's financial risk lies in procurement, field advances or petty cash. The reality is more prosaic: it is the payroll mass that weighs most heavily on budgets and therefore concentrates the most systemic risk. A rate error applied for six months, a forgotten social charge or a salary allocation that cannot be justified does not amount to a few euros, but sometimes to tens of thousands — with, as a result, amounts declared ineligible that the organisation will have to repay out of its own funds.
Why personnel costs concentrate the risk
Institutional donors — whether the European Union, ECHO, AFD or United Nations agencies — share a common requirement: every euro of salary charged to a grant must be real, incurred during the eligibility period, and tied to a project activity. This rule, simple on paper, becomes formidable at the scale of an organisation that employs staff across several missions, in several currencies, under several contractual regimes. The slightest documentation gap translates into a risk of rejection.
In concrete terms, personnel costs combine several risk factors:
- Volume: being the leading budget line, they are systematically sampled during an audit.
- Recurrence: a structural error (wrong charge rate, incorrect allocation key) repeats every month and propagates over the entire duration of the project.
- Documentary complexity: an eligible salary requires a contract, a payslip, proof of payment, a timesheet and a consistent allocation key.
- Sensitivity: remuneration touches on confidentiality, the gaps between national and international staff, and pay equity — all closely watched topics.
The hidden cost of spreadsheet-based payroll
The majority of international solidarity organisations still manage their payroll on spreadsheets, often one file per country, maintained by a single person. This way of working seems economical, but its real cost is high: it relies on individual knowledge that is rarely documented, multiplies versions, and makes any headquarters-field consolidation laborious. Above all, the spreadsheet keeps no reliable record of changes. When an auditor asks who changed a salary, when and under what authorisation, there simply is no answer. This absence of an audit trail turns a routine process into a permanent grey area, and undermines the relationship of trust with donors.
The challenges specific to payroll in an NGO
An NGO's payroll is unlike that of a conventional single-country company. It accumulates constraints that few standard tools are able to absorb simultaneously. Understanding these specificities is the indispensable prerequisite for any improvement effort.
National staff, expatriates and volunteers: several regimes, a single payroll
A mission typically employs three broad categories of staff, each with its own rules. National staff are subject to the labour law and social security regime of the country of intervention: local scale, contributions, tax withholdings, sometimes sector agreements. International (expatriate) staff often fall under the headquarters country or a specific contractual framework, with elements such as expatriation allowances, housing or international health coverage. International solidarity volunteers, for their part, are governed by a still distinct status, with dedicated allowances and social protection. Making these regimes coexist within a single, consistent and traceable process is one of the main challenges of the payroll function.
Multi-country, multi-currency, multi-regulation
An organisation present in five countries effectively manages five regulatory environments, five social and tax reporting calendars, and often several currencies. National salaries are paid in local currency, certain budget lines are denominated in euros or dollars, and the exchange rate used to value a personnel expense must be documented and compliant with the donor's rules. A study of local salaries carried out ahead of budget finalisation is essential: an underestimated "national staff remuneration" budget hampers recruitment and retention, while a poorly built budget complicates every subsequent trade-off.
The allocation of salaries to grants
This is the technical heart of the matter. The same employee — a logistician, a MEAL officer, a finance coordinator — frequently works on several projects funded by different donors. Their salary must therefore be split between these grants according to a justifiable allocation key, ideally backed by timesheets. If the percentage charged to a project does not correspond to the time actually spent, the expense becomes contestable. Payroll management cannot therefore be conceived independently of time tracking or cost accounting: the three form a single system. Any tool that treats them in silos mechanically recreates the very risk it claims to reduce.
Payroll and the audit trail: what donors actually check
During an audit, the examination of personnel costs follows a logic of reconstruction: the auditor starts from an amount charged to the project and works back up the chain of evidence to the ultimate justification. At every missing link, the risk of rejection increases. Anticipating this logic means preparing your payroll like a permanent audit file rather than a monthly formality.
Here are the documents the auditor seeks to link for each sampled salary:
- The employment contract and its amendments, dated and signed, setting the remuneration and the role.
- The organisation's salary scale, which demonstrates the consistency and fairness of remuneration.
- The payslip detailing gross salary, charges, deductions and net pay.
- The consolidated payroll register, a month-by-month summary document.
- Proof of payment (bank statement, transfer, signed receipt for cash payments).
- Timesheets attesting to the split between projects.
- The allocation key applied and its calculation method.
- Social and tax declarations and the proof of their payment to the local authorities.
Beyond these documents, the auditor expects overall consistency: the total of salaries charged to the various donors must never exceed 100% of a person's real salary, the exchange rate must be justified, and any change in remuneration must be supported by a documented authorisation. This is precisely where the digital audit trail makes the difference: being able to show, on a single screen, who entered, who validated and when, turns an anxiety-inducing control into a demonstration of mastery.
Spreadsheets, local providers or ERP: which approach for your payroll?
Three broad approaches coexist in the sector. The in-house spreadsheet, ubiquitous out of habit. The use of a local payroll provider in each country of intervention, which secures local compliance but fragments the information. And the payroll module integrated into an ERP, which centralises and links payroll to the rest of financial management. The table below compares these options on the criteria that matter for an NGO.
| Criterion | Spreadsheets (Excel) | Local providers by country | Integrated payroll module (ERP) |
|---|---|---|---|
| Headquarters-field centralisation | Low: one file per country, manual consolidation | Low: data scattered across several providers | High: a single real-time view |
| Local compliance | Depends on internal expertise | Strong: it is their core business | Variable, to be configured or coupled with providers |
| Allocation to grants | Manual, a source of errors | Outside the provider's scope | Automated and linked to cost accounting |
| Multi-currency | Fragile formulas, untracked rates | Local currency only | Native handling, historised rates |
| Audit trail | Non-existent | Partial, specific to each provider | Complete and timestamped |
| Validation workflows | Informal, by email | Outsourced, with little visibility | Integrated and electronically signed |
| Donor reporting | Manual reconstruction for each report | To be recompiled from several sources | Generated automatically by project |
| Overall error risk | High | Medium (strong compliance, weak integration) | Low |
No approach is intrinsically perfect: local providers bring valuable regulatory security, and many organisations will choose to keep them for payroll calculation in certain countries. The real question is therefore not "spreadsheet or provider", but: how to connect these sources to a single financial view, allocated to grants and auditable? This is the role of an ERP that orchestrates payroll within overall management, rather than treating it as an isolated island.
Centralising and securing payroll with Abvius
At Abvius, we design the first Finance, Operations and MEAL ERP conceived for NGOs, CSOs and international solidarity organisations, as well as for their partners. Our conviction is simple: payroll should not live apart, but integrate naturally into budget monitoring and the audit trail. Here is how we approach this process.
- Real-time budget monitoring: each salary charged to a grant instantly updates the budget consumption of the "personnel" line, which avoids nasty surprises at the end of a project and facilitates trade-offs.
- Traceability and audit trail: every entry, modification or validation of a payroll item is timestamped and attributed to a user, forming a complete log that is directly usable during a donor audit.
- Validation workflows: the preparation, control and approval of payroll follow a defined circuit, compliant with the principle of segregation of duties, without informal email exchanges.
- Electronic signature: payslips, salary-change authorisations and payroll statements are signed electronically, with evidential value and time savings for both field teams and headquarters.
- Headquarters-field centralisation: missions and headquarters work on a single base, multi-country and multi-currency, putting an end to the fragmentation of files.
- Automatic donor reporting: the breakdown of salaries by project, already linked to timesheets and cost accounting, directly feeds the financial reports expected by donors.
The aim is not to replace local payroll expertise where it is needed, but to connect it to a single financial backbone, where payroll data becomes usable, controllable and defensible. To discover the Abvius approach, visit https://abvius.org.
Five steps to set up compliant and auditable payroll
Securing payroll does not require reforming everything overnight. A gradual approach, in five steps, makes it possible to reduce risk quickly while building a durable foundation.
1. Map the existing situation and obligations by country
For each country of intervention, inventory the applicable regimes (national, international, volunteering), the contribution rates, the reporting calendars and any providers. This mapping reveals areas of fragility and forms the reference for any subsequent control.
2. Formalise a salary scale and a payroll procedure
A clear scale and a procedures manual describing the circuit for preparation, control and validation provide an enforceable framework. They demonstrate to donors the fairness of remuneration and command of the process, two points that are systematically examined.
3. Link payroll to time tracking and cost accounting
Put in place reliable timesheets and documented allocation keys, so that every percentage charged to a grant is justifiable. This is the step that most directly secures the eligibility of personnel costs.
4. Establish controls and segregation of duties
The person who prepares the payroll must not be the one who validates it or the one who executes it. Cross-checks and a documented validation circuit reduce both the risk of error and the risk of fraud.
5. Centralise and trace in a single tool
Finally, bring everything together in a system that records each action, generates the audit trail and produces the donor reporting. It is this shift from the scattered file to centralised data that durably transforms the payroll function.
Mini-FAQ
Is spreadsheet payroll sufficient to pass an audit?
It may suffice occasionally if the accompanying documentation is impeccable, but it exposes you to a high risk: absence of an audit trail, multiple versions, recurring errors. As soon as the organisation manages several countries or several donors, the spreadsheet quickly reaches its limits.
How do you justify the allocation of a salary to several projects?
Through an allocation key backed by timesheets. The percentage charged to each grant must reflect the time actually spent, and the sum of the allocations must never exceed 100% of the person's real salary.
Should you abandon local payroll providers?
No. Their regulatory expertise remains valuable in many countries. The challenge is to connect their data to a centralised financial view, allocated to projects and auditable, rather than letting them operate in silos.
How do you manage national and international staff in the same payroll?
By handling each regime according to its own rules while consolidating them in a single system. A centralised tool makes it possible to have local scales, expatriation allowances and volunteering statuses coexist without multiplying files or risks of inconsistency.
Summary and resources
NGO payroll management is not a secondary administrative task: it is the leading budget line of your projects and, as such, the first ground for an audit. Securing this process requires moving beyond the spreadsheet, linking payroll to time tracking and cost accounting, establishing controls and segregation of duties, and tracing everything in a single system capable of producing a reliable audit trail and donor reporting. This is exactly the promise of Abvius: making payroll a compliance asset rather than a risk area. To go further, talk to our team via the contact page and explore our complementary resources: time tracking for donor audits, expenditure justification, mastering indirect costs, segregation of duties and the digital audit trail.