Discrepancy In Amortized Cost Results: Athena Query using Cost and Usage Reports (CUR) VS Cost Explorer

0

I've been using AWS Athena along with Cost and Usage Reports (CUR) to check amortized costs for the past six months. When I compare the results with Cost Explorer with the amortized cost filter applied, Everything lines up perfectly for the last five months. However, there's a difference in the current month.

Enter image description here

Is this because the amortization hasn't applied yet for the current month? If so, how can I get the correct amortized results?

I used this source as reference and Here's the Athena query I'm using:

SELECT
    YEAR(line_item_usage_start_date) AS year,
    MONTH(line_item_usage_start_date) AS month,
    DAY(line_item_usage_start_date) AS day,
    ROUND(SUM(
        CASE
            WHEN (line_item_line_item_type = 'SavingsPlanCoveredUsage') THEN COALESCE(savings_plan_savings_plan_effective_cost, 0)
            WHEN (line_item_line_item_type = 'SavingsPlanRecurringFee') THEN COALESCE(savings_plan_total_commitment_to_date - savings_plan_used_commitment, 0)
            WHEN (line_item_line_item_type = 'SavingsPlanNegation') THEN 0
            WHEN (line_item_line_item_type = 'SavingsPlanUpfrontFee') THEN 0
            WHEN (line_item_line_item_type = 'DiscountedUsage') THEN COALESCE(reservation_effective_cost, 0)
            WHEN (line_item_line_item_type = 'RIFee') THEN COALESCE(reservation_unused_amortized_upfront_fee_for_billing_period + reservation_unused_recurring_fee, 0) 
            WHEN (line_item_line_item_type = 'Fee') THEN 0
            ELSE COALESCE(line_item_unblended_cost, 0)
        END
    ), 2) AS amortized_cost
FROM "my_cur_report"
WHERE 
    line_item_line_item_type NOT IN ('Credit') AND
    DATE(line_item_usage_start_date) >= DATE('2023-10-01')
    AND DATE(line_item_usage_start_date) <= DATE('2023-10-01')
    AND line_item_usage_account_id = 'my_acc_id'
GROUP BY 1, 2, 3
ORDER BY 1,2, 3;

Any thoughts on addressing this current month difference would be appreciated. Thanks!

2 Answers
0

Cost Explorer and CUR reports have different refresh rates. If you're looking at the bill of the past months and it's matching - that's because the bills for the past months have been already finalized. The bill for the current month is not yet finalized, and you will see certain discrepancies throughout the month.

Normally, your bill is finalized around 3rd of the following month (e.g. the bill for Nov is finalized around 3rd of Dev). But if you have some additional support charges, like for example Enterprise Support fees, this may take a few more days.

The delay for Cost Explorer data refresh is generally approximately 24 hours. And CUR may be refreshed a few times a day, so generally, there might be some discrepancies throughout the current month.

As November is over, and I suspect that the bill should have been finalized, do you see the correct amount now? Does it match?

profile pictureAWS
EXPERT
answered 5 months ago
-1

Hello,

If you'd like, feel free to ask our Support team for billing insight: http://go.aws/support-center. They'll have the tools and visibility to provide assistance.

Thank you,

— Lex D.

AWS
EXPERT
answered 5 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions