Different Total Cost in Cost Explorer vs API

Question

Hi,

I'm having an issue related to a discrepancy between what is shown in the Cost Explorer and Billing pages in the AWS console vs what is returned over the API.

Previous to March 2023, both views (console and API) would show the same total cost. March 2023 was the first month we implemented a Savings Plan so we changed from using the Unblended data set to using Amortized (this change was applied to both our console settings and API usage) - I believe the Savings Plan is the source of this issue somehow, since it just showed up this month.

Viewing our cost for March 2023 in Cost Explorer shows the total cost as $17,409 as seen here:

![Cost in console](/media/postImages/original/IM17dA8dJxS4-XHVD_gh1BWg)

However, when attempting to pull the same data over the API, it shows $16,843 as the total cost for the month. The code used to query the API is the following in Python:

```python
    client = boto3.client("ce")
    total_cost = client.get_cost_and_usage(
        TimePeriod={"Start": '2023-03-01', "End": '2023-03-31'},
        Granularity="MONTHLY",
        Metrics=["AmortizedCost"],
    )["ResultsByTime"]
    print(total_cost)
# -> [{'TimePeriod': {'Start': '2023-03-01', 'End': '2023-03-31'}, 'Total': {'AmortizedCost': {'Amount': '16843.7283177265', 'Unit': 'USD'}}, 'Groups': [], 'Estimated': False}]
```

This discrepancy exists no matter which data set I use (unblended or amortized) and also only exists for March 2023.

Does anyone have insight on how I might rectify? We rely on the API for running some cost analysis that can't be done through the console but if it's giving inaccurate costs we can't use it.

Thanks!

NightCrawler · Accepted Answer

Hello mburger,

You're finding different values because CE API deals with End (in TimePeriod) as *exclusive*. 
The [boto3 documentation](https://boto3.amazonaws.com/v1/documentation/api/1.9.42/reference/services/ce.html#CostExplorer.Client.get_cost_and_usage) says:
> *The end of the time period that you want the usage and costs for. The end date is exclusive. For example, if end is 2017-05-01 , AWS retrieves cost and usage data from the start date up to, but not including, 2017-05-01.*

With that in place, promote the following changes in your code to find the same you saw at the screenshot:
```
    client = boto3.client("ce")
    total_cost = client.get_cost_and_usage(
        TimePeriod={"Start": '2023-03-01', "End": '2023-04-01'},
        Granularity="MONTHLY",
        Metrics=["AmortizedCost"],
    )["ResultsByTime"]
    print(total_cost)
```

After test it, share your findings!

krishna · Answer

Hi I'm having the same issue.

Even when I try to fetch the details as below does not include` "TimePeriod": {"Start": "2024-11-17", "End": "2024-11-18"}` in the response.

As per the [documentation](https://boto3.amazonaws.com/v1/documentation/api/1.9.42/reference/services/ce.html#CostExplorer.Client.get_cost_and_usage) it says whereas when `timeperiod `is from 1`1th - 18th` it does not include `17th` date

> TimePeriod (dict) --
Sets the start and end dates for retrieving AWS costs. The start date is inclusive, but the end date is exclusive. For example, if start is 2017-01-01 and end is 2017-05-01 , then the cost and usage data is retrieved from 2017-01-01 up to and including 2017-04-30 but not including 2017-05-01 .

```
client = boto3.client("ce")
total_cost = client.get_cost_and_usage(
    TimePeriod={"Start": '2024-11-11', "End": '2024-11-18'},
    Granularity="DAILY",
    Metrics=["UnblendedCost"],
    GroupBy=[
        {'Type': 'DIMENSION', 'Key': 'USAGE_TYPE'}
    ]
)["ResultsByTime"]
date = []
for result in total_cost:    
    date.append(result['TimePeriod'])

print(date)
#[{'Start': '2024-11-11', 'End': '2024-11-12'}, {'Start': '2024-11-12', 'End': '2024-11-13'}, {'Start': '2024-11-13', 'End': '2024-11-14'}, {'Start': '2024-11-14', 'End': '2024-11-15'}, {'Start': '2024-11-15', 'End': '2024-11-16'}, {'Start': '2024-11-16', 'End': '2024-11-17'}]
```

NightCrawler · Answer

Hello, check if Cost Explorer you're seeing it Aggregating costs by 'Amortized' (in Advanced options section). It seems that the screenshot was get with Unblended (the default).

Different Total Cost in Cost Explorer vs API

Add your answer

Relevant content