Data pays only with KPIs you can measure and trace: a 7-line KPI sheet and one worked example

A KPI, or key performance indicator, is worth tracking only if you can say which records it is calculated from, who owns it and what counts. Without that, two people produce two answers to one question. Gulf regulators already work this way, and a seven-line sheet lets you do the same for your own numbers.

This is the second post in our series on data and digital transformation for Gulf companies. This one is about the numbers you build on top of those records.

Why "traceable" is the test

Most dashboards fail quietly. The number on the screen looks plausible, a manager repeats it in a meeting, and then someone from finance gets a different figure from the ledger. Nobody lied. The two numbers were calculated from different records or by different rules.

A traceable KPI survives that argument because you can answer four questions about it:

1. Which records is it calculated from? Not "the HR system", but the employees on the payroll, or the invoices still open.
2. What counts and what does not? Active employees only? Disputed invoices in or out?
3. Who owns it? One named person who explains the number and fixes the records when it looks wrong.
4. Can you see the rows behind it? If you click the number you can list the records, and they add up to the number.

This matters more as software starts to answer questions in plain language. In our view, an assistant can only quote the number that your records produce. If the definition lives in one analyst's head, the assistant, and the next analyst, will guess it.

What regulators teach us about KPIs

The Gulf ministries are the best examples of traceable KPIs available to a company, because each of their numbers is calculated from company records. The facts below are from the ministries' own pages.

Three habits stand out, and each is worth copying:

• The rule says which records count. A Saudi employee with no documented contract does not count towards the rate. Your "active customer" or "billable employee" needs the same kind of sentence.
• The number comes from a system of record, not from a report someone typed. WPS runs on salary payments made through institutions linked to the ministry's systems by secure APIs, so the data comes from the payment itself (our reading), not from a separate report.
• There is a date and a target. 1% more by 31 December is a KPI with an owner's deadline, not a vague aim.

For the detail behind each regime, read our guides on the Wage Protection System and Nitaqat bands in 2026. Our reading: a company that tracks the same numbers the same way will never be surprised by the regulator's version.

The 7-line KPI sheet

Keep one sheet per KPI, in a shared document or in the tool that shows the number. Seven lines are enough:

Line 4 is the one that most sheets are missing, and the next section shows what it costs.

A worked example: "overdue" has three answers

The figures below are illustrative, made up to show the arithmetic; they do not come from any company. A company has eight open customer invoices on 31 October. Amounts are in AED.

Open invoices total AED 120,000. Invoices past their due date total AED 49,000 (D + E + F + G + H). Three teams calculate "overdue %" and each is reasonable:

Nobody is wrong, and the gap between 37.5% and 40.83% is more than three points. If the leadership threshold in line 7 is "above 40%", whether credit control chases customers this week depends on which team's number reaches the meeting. The sheet's line 4 settles it: write "past due date, disputed invoices included, no grace period", and the number becomes 40.83% for everyone.

The lesson is general. Before you debate a KPI, write the rule for the edge cases; before you buy a dashboard, check that it can show the rows behind the number.

Seven KPIs to adapt

These are our suggestions, not regulatory requirements, written as formulas you can put on the sheet. Adapt the rule on line 4 to your business.

The e-invoicing line is not decoration. In the UAE, businesses with revenue of AED 50 million or more must implement e-invoicing by 1 January 2027, smaller ones by 1 July 2027 and government entities by 1 October 2027. Each tax invoice carries 51 mandatory fields, including buyer name, buyer tax identifier and buyer address, so a KPI on customer-record completeness is an early warning you can build from records you already hold. Our e-invoicing timeline has the dates.

The reconciliation test

Before a KPI goes on the leadership page, run four checks. All four must pass.

1. Two ways, one number. Two people, or a report and an export, calculate the KPI from the raw records independently. The results match to the last digit.
2. Rows add up. List the records behind the number; their total equals the KPI.
3. One change moves it. Edit one record in a test copy, such as marking an invoice disputed, and the KPI moves by exactly the amount you expect.
4. The owner can explain a surprise. Ask the owner why the number moved last month. If the answer needs a day of digging, the sheet is incomplete.

Repeat the test each quarter, and every time a definition changes. Write the date on the sheet.

The federal government's own project points the same way. On 1 November 2026 the UAE Ministry of Finance and the Federal Authority for Government Human Resources announced the move of federal finance and HR systems to cloud ERP. They name the aims in plain words: improve data quality, enhance the use of data to support decision-making, and integrate financial and human resources systems.

How Tarleaks helps

Insights works out every number under the reader's own access, and a click on a value can show the records behind it, or open them in the module that owns them. Reports & Dashboards runs ready-made HR and attendance reports, and payroll cost and the trial balance open from the Report library. Contacts & Partners keeps each customer and supplier once, with duplicate review and merging, so counts do not double.

What to do next

• Pick the three numbers your leadership team argues about most and write a 7-line sheet for each, starting with line 4.
• Run the four-step reconciliation test on each; fix the records before you fix the dashboard.
• Decide who owns each number, and put them on one weekly page of ten or fewer.
• Weighing software? Our questions for an HR and payroll demo include how to trace a number to its records.
• Book a demo and ask us to click from a number to the records behind it, with sample data.

What comes next in this series

Next: secure and organised, and why where your data lives sets its value; then the numbers a Gulf chief executive should see every Monday.

Questions people ask

How do you measure a KPI?

Write one sheet per KPI: the question it answers, the formula, the records it reads, what is included and excluded, the owner, the review rhythm and the action when it moves. Then calculate it from the records in two independent ways and check that both agree.

What makes a KPI traceable?

You can click from the number to the individual records behind it, and the total of those records equals the number. If a KPI can only be reproduced by the person who built the spreadsheet, it is not traceable.

How many KPIs should a company track?

Few enough that each has an owner who reviews it every week. We suggest ten or fewer for the leadership team. Departments can keep more, as long as each has the 7-line sheet.

What is the difference between a KPI and a metric?

A metric is any number you can measure. A KPI is a metric that you review on a schedule, that has an owner and that triggers a decision when it moves. Many companies track metrics and call them KPIs.

Which KPIs do Gulf regulators already measure?

Regulators calculate their own numbers from company records. In the UAE, WPS wage payments and the Emiratisation rate of skilled jobs; in Saudi Arabia, Saudization rates under Nitaqat from contracts documented on Qiwa. Track the same numbers internally the way the regulator counts them, so your figure and theirs match.

---

General information, not legal advice. Checked against the official sources listed on this page on 4 November 2026. Regulators' rules and dates change: check the current position on each regulator's site, and confirm your own case with your adviser.