How to export Azure cost data, and which export to choose
To export Azure cost data, create an export in Cost Management and pick the dataset by the question you need answered. Cost and usage details (actual) reconciles with your monthly bill, cost and usage details (amortized) prorates reservation and savings plan purchases onto the usage that consumed them, and cost and usage details (FOCUS) combines actual and amortized costs in one dataset on EA and MCA scopes only (Microsoft Learn, exports tutorial and reservation usage guide, checked 2026-11-13).
Pick the wrong one and the numbers still look plausible. Export actual cost and your reservations show up as one Purchase line while the usage they cover shows an EffectivePrice of zero, so your per-team chargeback is wrong before anyone opens the file.
Why does my reservation usage look wrong in Cost Analysis?
Azure cost analysis defaults to Actual cost, which shows reservation purchases as a line with ChargeType = "Purchase" and the usage those reservations cover with EffectivePrice = 0. That makes team chargebacks misleading: VMs fully covered by reservations show no cost, even though you paid for them through the reservation. The actual cost export doesn’t show how much of a reservation was used or wasted.
To see how reservations are being consumed, use the amortized export. Amortized cost puts the per-hour prorated reservation cost on the usage that used it, adds the hours nobody used as ChargeType = "UnusedReservation", and has no purchase records. Filter on UnusedReservation and sum the cost: that is reservation money you paid for and didn’t use. Actual cost can’t show you that.
How do I set up an Azure cost export?
In the Azure portal, open Cost Management, select your billing scope (an EA enrollment, an MCA billing account or a pay-as-you-go subscription), and select Exports in the left menu. Pick the dataset: cost and usage details (actual), cost and usage details (amortized), or cost and usage details (FOCUS). Send it to a container in an Azure Storage account you control.
Choose CSV (None or Gzip compression) or Parquet (None or Snappy). Parquet with Snappy is the better default if you query the files; pick CSV only if people open them in Excel.
Partitioning is always on: each uncompressed file stays under 1 GB, and every file is listed in a manifest.json. Load from the manifest instead of assuming one file per run, or you will silently drop rows.
Schedule the export as one-time, daily month-to-date, monthly last month, or monthly last billing month. History is 13 months in the portal, one month at a time, or up to 7 years by REST API.
An export can take up to 24 hours to run; once a run starts, data should arrive within 4 hours. Separately, cost data latency is typically 8–24 hours on EA and MCA and up to 72 hours on pay-as-you-go, and a billing period typically closes up to 72 hours after it ends. Daily exports run twice a day for the first five days of a month to catch charges invoiced up to 72 hours after month end.
So don’t close a month’s numbers from a daily month-to-date file. Wait for the billing period to close, then reconcile from a monthly last billing month export or a fresh one-time export.
How do I check which cost column to read?
The column name depends on your export type and billing agreement:
| Schema | Cost column |
|---|---|
| EA cost details (actual or amortized) | CostInBillingCurrency |
| EA cost details, version 2019-10-01 | PreTaxCost (no currency column) |
| MCA cost details (actual or amortized) | costInBillingCurrency |
| Pay-as-you-go cost details, 2019-11-01 (actual or amortized) | PreTaxCost, with Currency |
| FOCUS (EA and MCA only) | BilledCost (invoice basis), EffectiveCost (amortized) |
Pay-as-you-go accounts can’t use FOCUS. Microsoft says “Azure MOSP billing scopes and subscriptions don’t support FOCUS datasets,” and FOCUS exports don’t support the management group scope either. On pay-as-you-go, export actual or amortized cost details and read PreTaxCost, “Cost of the charge before credits or taxes,” with its Currency column.
Pay-as-you-go cost data has usage with commitment discounts applied but no Marketplace or commitment purchases. Don’t look for Purchase rows there; they won’t exist.
EA cost details version 2019-10-01 has no currency column, so the amounts carry no unit. Take the currency from your EA invoice before you compare them with anything else; the Revelations bill checker shows those amounts without a currency.
Check your own bill in 2 minutes: https://revelations.consulting/checker?utm_source=blog&utm_medium=organic&utm_content=blog-azure-cost-export-actual-amortized-focus
How do I fix my cost visibility without re-architecting anything?
Start by setting up all three exports if you’re on EA or MCA. Keep the Actual Cost export to reconcile with your invoice. Add the amortized export to find unused reservations. If you’re using FOCUS, verify that your scope is supported: it won’t work on pay-as-you-go, MOSP subscriptions, or management groups.
Backfill the last three months with one-time exports, one month at a time, then check:
- Purchase rows (ChargeType = "Purchase") in actual cost: every reservation purchase you paid for in the period.
- Usage rows with EffectivePrice = 0 in actual cost: usage a reservation covered, which a chargeback built on actual cost bills to nobody.
- UnusedReservation rows in amortized cost: reservation hours you paid for and didn’t use.
- The gap between BilledCost and EffectiveCost in FOCUS: where upfront purchases are being amortized.
Cost analysis defaults to Actual cost, so the portal view your teams look at hides reservation waste. Switch the view from Actual cost to Amortized cost before you review utilization.
One safety rule: never sum actual and amortized rows, or BilledCost and EffectiveCost, into one total. Each already counts your reservations once, so the sum double-counts them. Reconcile to the invoice only from actual cost or FOCUS BilledCost.
What it usually looks like
In actual cost, a reservation shows up as a Purchase row and the usage it covers shows an EffectivePrice of zero. In amortized cost, that usage carries its prorated share of the reservation, and the hours nobody used sit in UnusedReservation rows. In FOCUS, BilledCost and EffectiveCost sit side by side on the same rows.
You can check all three in your own files: filter for ChargeType = "Purchase" in actual, ChargeType = "UnusedReservation" in amortized, and compare BilledCost to EffectiveCost in FOCUS.
If you want a second pair of eyes on which export your reports should read, book a free 30-minute consult. We’ll look at your bill with you, no obligation and no sales pitch.
The rule: actual to match the invoice, amortized to find unused reservations, FOCUS to get both on EA and MCA.
Run your own numbers: bill checker. Its unused-commitment check needs the amortized export and reports "can't tell" on actual.
Frequently asked questions
What’s the difference between Actual Cost and amortized cost in Azure?
Azure actual cost reconciles with your monthly bill: reservation purchases appear as ChargeType = "Purchase" rows and the usage they cover shows an EffectivePrice of zero. Azure amortized cost puts the per-hour prorated reservation cost on the usage that used it, lists unused hours as ChargeType = "UnusedReservation", and has no purchase records.
Can I use FOCUS on a pay-as-you-go account?
No. Azure FOCUS exports support Enterprise Agreement (EA) and Microsoft Customer Agreement (MCA) scopes only; Azure MOSP (pay-as-you-go) billing scopes and subscriptions don’t support FOCUS datasets. Pay-as-you-go accounts use actual or amortized cost details, where the cost column is PreTaxCost.
Why does my Azure EA cost export have no currency column?
Azure EA cost details schema version 2019-10-01 has no currency column, so the amounts in that export carry no unit. Take the currency from your EA invoice before comparing the numbers. The Revelations bill checker shows those amounts without a currency.
How long does it take for Azure cost data to appear after an export runs?
An Azure cost export can take up to 24 hours to run, and once a run starts the data should arrive within 4 hours. Separately, Azure cost data latency is typically 8–24 hours on EA and MCA and up to 72 hours on pay-as-you-go, and a billing period typically closes up to 72 hours after it ends.
Which Azure cost export shows unused reservations?
The Azure amortized cost export shows unused reservation hours as rows with ChargeType = "UnusedReservation"; the actual cost export doesn’t include them. On EA and MCA, the FOCUS export also carries amortized cost in its EffectiveCost column.
Run the numbers on your own bill: Cloud Bill Gotchas Checker. Free, in your browser.
Want this kind of thing weekly? Get Cloud Bill Weekly. Want us to find it in your bill? We're taking three founding clients for a free Cost Assessment.