Advanced Allocation Planner

Map your general ledger expenses to clinical cost types, cost buckets, and cost centers in minutes, aligned with the Abu Dhabi Clinical Costing Standard.

Advanced Allocation Planner

Import source files, classify ledger lines, and prepare an export-ready costing dataset aligned with the DOH Clinical Costing Standard.

Abu Dhabi Clinical Costing General Ledger Mapping Export Workflow

Source Files

Load the general ledger and cost center source files before starting automated classification.

Inputs
Expense Data
Excel or CSV ledger lines with account code, title, amount, and date fields.
Primary
Clinical Cost Centers
Reference file for mapping organizational cost center names and identifiers.
Reference
Clinical Data
Excel or CSV clinical claim data using the standard Clinical Data Validator headers (claimId, encounterId, procedureCode, ICDCode, amount, department, and more).
Clinical
Cost Master
Excel or CSV with 'code' and 'cost' columns. Used to populate cost in the Final Products export. If not uploaded, cost defaults to 0.
Optional

Workflow Actions

Search the working set, launch assisted classification, and publish the mapped export from one command area.

Controls
i Showing sample data. Upload your production files to replace the current working set.
Search Working Set

Use auto-classify to prefill costing fields, then review the editable grid before exporting the final mapped workbook.

Expense Nature Cost Bucket Cost Type Export Ready
Overview
Total Records
Dataset
0

Rows currently loaded into the allocation workspace.

Financials
Total Amount
AED
AED 0

Running value of all expense lines available for mapping.

Coverage
Mapped
Ready
0

Rows already classified with expense nature, category, and cost type.

Attention
Unmapped
Review
0

Rows still missing at least one required classification field.

Clinical
Products in Clinical Data
Codes
—

Unique procedure codes found in uploaded clinical claim data.

Quality
Non-Standard Codes
Review
—

Procedure codes in clinical data not found in the master lookup. May need mapping.

Coverage
Expenses with Products
Config
—

Expense lines that have clinical products generated and configured.

Export
Cost Buckets
Mapped
—

Unique cost bucket and cost type combinations from mapped expense lines.

Insight
Expense → Category Breakdown
Interactive

Select an expense to see which product categories are mapped and how many products per category.

Momentum
Completion
No data
0%

A quick read on how much of the uploaded ledger is allocation-ready.

Inputs
Clinical Data Cols
Drivers

Track which supporting clinical driver columns are present before exporting mapped data.

DrugsSuppliesMiscellaneous

Supported allocation drivers.

Mapped Expense Table
Review classification outputs, edit allocation fields, and freeze columns by clicking any header.
Amber dot = needs mapping
# Account Code Expense Title Amount (AED) Date Expense Nature Expense Category Cost Bucket Cost Type Cost Center Status Confidence Allocation Driver Clinical Cost Centers Encounter Type Notes Hints Products
Why Cyscode Advanced Allocation Planner

Built for enterprise-grade clinical costing workflows.

Designed for Abu Dhabi providers who need faster ledger classification, cleaner allocation logic, and export-ready costing output without spreadsheet rework.

Built for Abu Dhabi Healthcare Providers

Designed for hospitals, clinics, and healthcare providers submitting clinical costing data under the Abu Dhabi DOH Clinical Costing Standard (ADCCDC). Covers all cost types: SWNurs, SWDoc, SWAllied, Laboratory, Imaging, Pharmacy, Prostheses, MS, Hotel, Depreciation, and Overhead.

Intelligent Auto-Classification Engine

Upload your general ledger and the planner automatically detects expense nature and cost bucket from line item descriptions, covering nursing roles, physician specialties, allied health, medical and surgical supplies, and overhead cost centers, with built-in confidence scoring.

Multi-Dimensional Cost Allocation

Assign allocation drivers (Encounter, Product, Recipe, Time, Driver based - Area, Driver based - FTE, Driver based - Code, Driver based - Domain Area, Driver based - Domain FTE, Driver based - Drugs, Driver based - Miscellaneous, Driver based - Supplies), clinical cost centers per the ADCCDC appendix, and encounter types (Inpatient, Outpatient, Emergency, Day Case, Telemedicine, Home Healthcare), all mapped in a single workflow.

Department ID Mapping & Round-Trip Integration

Upload your cost center reference file with Department IDs and names. The planner auto-matches Department IDs when cost center names align, with manual entry for custom cost centers. Exports include Department ID columns, enabling seamless re-import to your costing system and creating a linked data flow.

Export-Ready Costing Output

Download a fully mapped Excel workbook with all columns required for clinical costing submission: expense nature, category, cost bucket, cost type, cost center, department ID, cost center status, allocation driver, clinical cost centers, and encounter type. Structured for direct use in your costing system.

Workflow

How the mapping workflow runs end to end.

Move from raw ledger lines to a validated costing output in a short review cycle, with guided automation and manual control where it matters.

1

Download the Sample Template

Get the pre-filled Excel template with 100+ sample expense lines covering every DOH expense nature.

2

Upload Your General Ledger & Cost Centers

Drop your facility's expense data (Excel or CSV) and your cost center reference file with Department IDs and names. The tool reads Account Code, Expense Title, Amount, Date, and maps Department IDs automatically.

3

Auto-Classify & Refine

Click Auto-Classify to detect expense natures and cost buckets. Review and adjust any row manually using the dropdowns. Configure cost centers with auto-matched or manually entered Department IDs.

4

Export Mapped Data

Download the complete Excel output with all allocation fields and Department IDs filled in, ready for re-import to your clinical costing system with linked cost center references.

Advisory Support

Turn the planner into a full costing delivery workflow.

When you need more than self-service mapping, Cyscode can help operationalize the full DOH clinical costing model across classification, allocation design, data preparation, and submission readiness.

ImplementationConfigure the mapping model around your ledger structure and costing approach.
ValidationReview allocation logic, costing fields, and output quality before submission.
DeliveryMove from planning to production workflows with a cleaner operational rollout.
Full Costing Suite

Explore the full Clinicost engine for end-to-end clinical costing workflows, or reach out to discuss implementation support with our team.

Explore Full Suite Contact Us

Clinical Product Builder

1
Cost Center
›
2
Select Clinical Dimensions
›
3
Configure Filter Values
›

Select at least one dimension above to configure filters.

4
Select Category
›
5
Assign Professional Roles
›
ⓘ The duration shown is a clinical reference derived from consultations with medical professionals and multiple clinical references. Actual duration may vary by clinical setting and practice. Please consult your clinical team to determine the appropriate duration.

Configure filters above to see available codes.