Clinical Costing Data Validation

How to Prepare Error-Free Data for DoH Submission in 2026

Clinical costing data validation is one of the most important stages of the Abu Dhabi Department of Health (DoH) Clinical Costing process.

A healthcare facility may have accurate accounting records, detailed patient data, and a well-designed costing model, but errors in mapping, reconciliation, data formatting, or XML preparation can still create problems during submission.

For healthcare providers preparing their 2026 DoH Clinical Costing submission, data quality should therefore be addressed throughout the costing process—not only immediately before uploading the final file.

The DoH's 2026 Clinical Costing Road Map includes Abu Dhabi Clinical Costing Standard V2, Clinical Costing Guideline V2, a Quick Start Guide, updated technical specifications and FAQs. The technical documentation covers submission specifications, validations, data quality requirements and the Shafafiya submission platform.

This guide from Young & Right explains how healthcare providers can build a structured clinical costing data-validation process and reduce avoidable errors before DoH submission.

What Is Clinical Costing Data Validation?

Clinical costing data validation is the process of checking whether financial, operational and patient-level data used for clinical costing is complete, accurate, correctly mapped, reconciled and technically compliant before submission to DoH.

Validation should answer questions such as:

• Are all required General Ledger expenses included?
• Are cost centres classified correctly?
• Are overhead costs allocated appropriately?
• Are patient encounters complete?
• Are required fields populated?
• Are codes mapped correctly?
• Do allocated costs reconcile with the source financial data?
• Does the submission comply with the required XML schema?
• Have critical validation errors been corrected?

DoH's 2026 Quick Start Guide specifically includes General Ledger classification, cost-centre definition, patient encounter extraction, reconciliation, internal validation, XML formatting, Shafafiya upload, error correction and CFO sign-off in its readiness checklist.

Why Is Data Validation Important for DoH Clinical Costing?

DoH uses patient-level clinical costing data as part of its wider objective of understanding healthcare costs and supporting value-based healthcare and funding.

The 2026 technical documentation explains that Shafafiya is used for the submission, validation and analysis of patient-level healthcare costing data.

Poor-quality data can therefore create more than a technical upload problem.

It may affect:

• Accuracy of patient-level costs
• Cost-centre performance analysis
• Service-line profitability analysis
• Cost allocation
• Reconciliation
• Management reporting
• Regulatory compliance
• Confidence in submitted costing information

DoH currently states that clinical costing is mandatory across the Abu Dhabi healthcare market for applicable providers, subject to listed exceptions, and warns that failure to provide costing data in accordance with its standards may result in a facility being considered non-compliant.

Who Needs to Prepare Clinical Costing Data?

According to the current DoH Clinical Costing Road Map, the scope generally includes healthcare facilities providing direct patient care, regardless of facility size, subject to specified exceptions.

DoH currently identifies stand-alone outpatient pharmacies and stand-alone diagnostic centres under particular circumstances among the exceptions described on its Clinical Costing page.

Healthcare organisations should verify their exact scope and obligations against the latest DoH requirements rather than assuming that facility size alone determines applicability.

The Clinical Costing Data Flow

For a healthcare provider, reliable clinical costing requires several datasets and teams to work together.

A simplified data flow can be viewed as:

General Ledger → Cost Centres → Cost Classification → Overhead Allocation → Clinical Activities → Patient Encounters → Patient-Level Costs → Reconciliation → Validation → XML → Shafafiya Submission

A weakness at an early stage can flow through the entire costing model.

For example, an incorrectly mapped General Ledger account can affect a cost centre, which can affect allocation, which can ultimately distort patient-level costs.

This is why validation should happen at multiple stages.

10 Clinical Costing Data Validation Checks Before DoH Submission

1. Validate the General Ledger Extraction

Start with the financial foundation.

Healthcare providers should verify that the General Ledger data used for clinical costing represents the correct reporting period and includes the relevant expenses required for the costing exercise.

Check for:

• Missing GL accounts
• Duplicate accounts
• Incorrect reporting periods
• Unexpected zero values
• Unmapped expenses
• Incorrect account classifications
• Reclassification entries
• Material adjustments

The objective is to establish a reliable financial control total before costs are allocated.

DoH's Quick Start Guide specifically includes extracting and classifying General Ledger expenses as part of submission readiness.

2. Validate Cost Centre Mapping

The next step is to confirm that departments and organisational units have been mapped correctly within the costing model.

Healthcare providers should clearly distinguish between relevant direct and overhead cost centres.

Examples may include clinical departments, support departments and administrative functions depending on the facility's structure.

Questions to ask include:

Does this cost centre directly provide patient care?

Does it support another department?

Is the allocation method appropriate for the nature of the cost?

Has the same cost centre accidentally been mapped more than once?

Incorrect cost-centre classification can affect every downstream allocation.

3. Check for Missing or Duplicate Data

Missing and duplicate records are among the most basic—but potentially significant—data-quality problems.

Review datasets for:

• Duplicate records
• Missing identifiers
• Blank mandatory fields
• Missing encounters
• Missing financial values
• Duplicate patient encounters
• Duplicate activity records
• Unexpected zero totals

The 2026 DoH Quick Start Guide specifically advises providers to perform internal checks before submission and identifies issues such as duplicates, missing fields, zero totals and mismatched codes as items to review.

Automating these checks where possible can significantly reduce manual review effort.

4. Validate Patient Encounter Data

Patient-level costing depends on reliable encounter information.

Healthcare providers should ensure that patient and encounter data extracted from their EMR/HIS can be appropriately connected to the costing model.

Review:

• Encounter identifiers
• Patient identifiers
• Encounter dates
• Service information
• Department or location
• Relevant clinical activities
• Required codes
• Missing encounters

DoH's Quick Start Guide specifically identifies extraction of patient encounter data from the EMR/HIS as part of clinical costing readiness.

5. Validate Allocation Statistics

Not every healthcare cost can be directly attributed to a single patient.

Overhead and support costs therefore require appropriate allocation methods.

Before submission, review whether the allocation statistics used are logical, complete and consistent with the methodology applied by the facility.

Possible allocation drivers can vary according to the nature of the cost.

The key principle is that the selected allocation basis should reasonably represent how the relevant resource is consumed.

DoH's readiness guidance specifically calls for overhead costs to be allocated using logical statistics.

6. Reconcile Costing Results With Financial Data

Reconciliation is one of the most important clinical costing controls.

After allocation, finance teams should verify that costs have not disappeared, been duplicated or been incorrectly introduced during processing.

At a high level, the costing model should be capable of demonstrating how the relevant source costs move through the allocation methodology into the final costing outputs.

Investigate unexplained differences before submission.

The DoH Quick Start Guide explicitly requires reconciliation to be completed before submission.

A strong reconciliation file also creates a useful audit trail for internal review.

7. Check Coding and Mapping Consistency

Clinical costing brings together information from several systems.

The same department, service, provider or activity can sometimes be represented differently across:

• General Ledger
• ERP
• HIS/EMR
• Billing system
• Costing system
• Other operational datasets

Create controlled mapping tables rather than relying on manual assumptions.

Each mapping should ideally have:

Source code → Source description → Costing classification → Target code/category → Validation status

DoH's Shafafiya environment uses defined data-exchange standards and validation rules, making consistent coding and data structure particularly important.

8. Validate Required Fields and Data Types

A dataset can be financially correct but technically invalid.

Before generating the final submission, validate required fields against the applicable DoH technical specifications.

Check for:

• Missing mandatory fields
• Invalid formats
• Invalid codes
• Incorrect dates
• Unexpected negative values
• Incorrect numeric formats
• Invalid identifiers
• Schema inconsistencies

DoH's 2026 technical documentation specifically covers data specifications, submission validations, data quality and internal validation requirements.

The validation logic should therefore be built around the current technical specification rather than a previous submission template.

9. Validate the XML File Before Production Submission

DoH requires the clinical costing submission to be prepared according to the applicable XML schema.

The 2026 Quick Start Guide instructs providers to format data according to the DoH XML schema, complete internal validation and prepare files for Shafafiya submission. It also specifies batching files at 5 MB or less in its readiness checklist.

Before production submission:

• Validate the XML structure
• Confirm mandatory elements
• Check identifiers
• Review file size
• Check schema compliance
• Run available validation processes
• Correct identified errors
• Regenerate the file where necessary

Do not assume that successfully generating an XML file means the underlying data is correct.

Technical validity and costing accuracy are two separate controls.

10. Review Shafafiya Errors and Resubmit Corrected Records

Shafafiya is the platform used for healthcare costing data submission and validation under the current DoH framework.

After submission, review the resulting validation feedback carefully.

DoH's Quick Start Guide directs providers to correct errors and resubmit as part of the submission process.

Instead of fixing errors individually without analysis, maintain an error register.

For example:

This turns submission errors into improvements for the next reporting cycle.

Clinical Costing Data Validation Checklist 2026

Before final DoH submission, healthcare providers should be able to confirm:

Finance

• General Ledger extracted
• Relevant expenses classified
• Cost centres mapped
• Direct and overhead costs reviewed
• Allocation bases documented
• Financial reconciliation completed

Clinical & Patient Data

• Patient encounters extracted
• Required identifiers available
• Missing records reviewed
• Duplicate records checked
• Clinical activity mappings validated

Technical

• Current DoH specifications used
• Mandatory fields completed
• Codes validated
• XML schema checked
• File-size requirements checked
• Internal validation completed
• Shafafiya access confirmed

Governance

• Clinical Costing contact registered
• Finance involved
• IT involved
• Clinical Operations involved
• Medical Records involved where appropriate
• Errors documented and corrected
• Final reconciliation reviewed
• CFO/Director of Finance sign-off obtained

DoH's own 2026 readiness checklist calls for a multidisciplinary internal team including Finance, IT, Clinical Operations and Medical Records, with the CFO engaged in the sign-off process.

Why Clinical Costing Validation Should Not Be Left to IT Alone

Clinical costing is not simply an IT submission project.

IT can validate file structure, system interfaces and technical requirements.

But IT cannot independently determine whether:

• A GL account has been classified correctly
• An overhead allocation is economically appropriate
• A cost centre belongs in the correct category
• A reconciliation difference is acceptable
• A patient-level cost makes financial sense

Likewise, Finance cannot independently solve every XML, system-integration or data-extraction problem.

An effective validation process therefore requires collaboration between:

Finance + Costing + IT + Clinical Operations + Medical Records + Management

This multidisciplinary approach is also reflected in DoH's 2026 readiness guidance.

Build a Clinical Costing Audit Trail

Healthcare providers should maintain evidence showing how the final submitted numbers were produced.

A structured working file can include:

• Original GL extraction
• Cost-centre master
• GL mapping
• Cost classifications
• Allocation rules
• Allocation statistics
• Patient encounter extraction
• Mapping tables
• Reconciliation reports
• Validation reports
• Error logs
• Corrected files
• Final submission version
• Management review/sign-off

This provides greater traceability when differences or questions need to be investigated.

How Young & Right Can Support Clinical Costing Data Validation

Preparing reliable clinical costing information requires coordination between accounting, healthcare operations, data management and regulatory submission requirements.

Young & Right supports healthcare providers in Abu Dhabi with clinical costing implementation and data-preparation activities.

Support can include areas such as:

• Clinical costing readiness assessment
• General Ledger mapping
• Cost-centre mapping
• Cost classification
• Allocation methodology review
• Patient-level costing
• Financial reconciliation
• Clinical costing data validation
• Submission-file preparation support
• Error identification and correction support
• Management reporting and documentation

Our approach focuses on creating a structured, traceable process from the General Ledger through to patient-level costing and final submission preparation.

Healthcare providers should always apply the latest DoH standards, guidelines and technical specifications applicable to their reporting cycle.

Final Thoughts

Preparing error-free clinical costing data is not simply about fixing an XML file immediately before submission.

The quality of the final submission depends on the entire process:

Accurate GL → Correct Mapping → Appropriate Allocation → Complete Patient Data → Patient-Level Costing → Reconciliation → Validation → XML → Shafafiya → Review & Sign-Off

The strongest healthcare providers will build validation into each stage rather than waiting for Shafafiya to identify problems at the end.

For 2026, this is particularly important because DoH has introduced Clinical Costing Standard V2, Guideline V2, updated technical documentation and expanded implementation guidance as part of its latest Clinical Costing Road Map.

Need Support With DoH Clinical Costing Data Validation?

If your healthcare facility is preparing clinical costing data for DoH submission, Young & Right can support your team with data preparation, GL and cost-centre mapping, allocation, reconciliation, validation and submission-readiness activities.

Speak with Young & Right about preparing your clinical costing data for the 2026 DoH requirements.