Local Content Certification Readiness & Evidence Pack
An anonymized case study showing how a complex Local Content renewal requirement was converted into a controlled finance workstream — workforce analysis, GOSI, supplier spend, asset depreciation, evidence indexing, sampling logic and audit-ready support schedules.
1. The assignment
The objective was not simply to “fill a template.” The work required a defensible bridge between accounting records, workforce data, procurement evidence and the documentary requirements expected for Local Content review.
From scattered documents to one controlled submission pack
The source data was distributed across payroll records, GOSI invoices, employee contracts, supplier statements, Local Content certificates, corporate documents and the trial balance. I structured the work into linked analytical schedules and an indexed evidence pack so each figure could be traced back to supporting documentation.
2. Certified score progression
The source workbook records the prior three Local Content percentages. The latest uploaded official certificate independently verifies the 55.9% score for FY2024.
Two-year progression
Increase in the recorded Local Content score from 2022 to 2024.
Renewal control objective
Maintain documentary traceability and identify the workforce, procurement and asset levers that can sustain or improve the score.
3. Workforce analysis
The workforce schedule was built at employee level and linked to monthly salary, nationality, gender, residency and GOSI status fields — giving management a transparent view of the Local Content workforce base.
Payroll population
80 Saudi and 86 non-Saudi employee records in the populated payroll schedule.
Total payroll mapped
Annual salary value captured in the source workbook.
Saudi payroll value
Approximately 73.2% of the mapped payroll value.
GOSI analysis
12 months of Saudi and non-Saudi GOSI expense analyzed separately.
| Workforce component | Saudi / Local | Non-Saudi | Total | Control performed |
|---|---|---|---|---|
| Annual payroll | SAR 4,001,916 | SAR 1,468,800 | SAR 5,470,716 | Employee-level monthly schedule |
| GOSI contribution expense | SAR 565,732 | SAR 28,760 | SAR 594,492 | 12-month reconciliation schedule |
| EOSB supporting population | 59 records | 81 records | 140 records | Employee-level supporting schedule |
4. Procurement & supplier-spend mapping
The supplier schedule separates goods from services, gross invoice value, VAT and net spend, while recording supplier locality and product/service descriptions for Local Content classification.
Populated suppliers
Supplier records classified and supported in the current schedule.
Net spend analyzed
Net of VAT in the populated supplier schedule.
Recorded local spend
All 16 populated suppliers are classified as local in the source schedule.
Supplier sampling
The template embeds a 70% supplier-value sampling threshold for audit support.
Services
Two service suppliers represent the majority of mapped net supplier value.
Goods
Fourteen goods suppliers covering vehicles, agricultural items, fuel, lighting, food and operating materials.
5. Asset & depreciation workstream
Depreciation was not left as one financial-statement line. It was broken down by asset category and operating location so locally productive assets could be reviewed under the relevant Local Content treatment.
Asset categories analyzed
Equipment, office devices, vehicles, air-conditioning and furniture.
Total depreciation mapped
Annual depreciation captured in the source asset schedule.
Vehicles concentration
SAR 501.8k of mapped depreciation relates to vehicles, making it a key review item.
6. Evidence pack architecture
The strength of the work was not only the calculations. The supporting files were organized into a review-ready structure so the auditor could move from a schedule to its evidence quickly.
7. My working method
This case demonstrates a repeatable compliance process rather than a one-off spreadsheet exercise.
Requirement mapping
Converted the Local Content request list into a document and data checklist with clear ownership.
Data extraction
Built detailed schedules for payroll, GOSI, EOSB, suppliers and depreciation.
Classification
Separated Saudi/non-Saudi workforce, goods/services and local/foreign procurement classifications.
Financial reconciliation
Designed tie-out points to the trial balance and audited financial statement lines before submission.
Sampling
Applied the workpaper sampling logic to identify evidence that should be ready for review.
Document indexing
Created a structured evidence folder architecture so supporting files can be located quickly.
Exception review
Used difference and “unidentified amount” controls to surface gaps that require resolution.
Management view
Translated raw compliance data into understandable indicators for decision-making.
Audit readiness
Prepared the package to reduce back-and-forth and make verification more efficient.
8. What this case demonstrates
High-volume data discipline
Managing employee, supplier and asset records without losing traceability.
Saudi compliance knowledge
Understanding Local Content evidence, classification and review requirements.
Audit-ready workpapers
Building schedules that connect financial figures to documentary proof.
Document control
Organizing evidence so reviewers can navigate the file quickly and consistently.
Financial reconciliation
Using trial-balance and financial-statement tie-outs as control points.
Procurement analysis
Separating supplier locality, goods/services and VAT-adjusted spend.
Workforce analytics
Connecting payroll, GOSI and employee classifications into one control framework.
Management support
Turning a regulatory submission into clear indicators and action points.