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개 답변
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
전문가
답변함 6달 전
-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
전문가
답변함 6달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인