Cost usage monthly report per instance

Cost and Usage Reports (CUR) and Cost Explorer are different tools. Cost Explorer may show cost by resource/InstanceID for the last two weeks or so: https://aws.amazon.com/blogs/aws-cloud-financial-management/extended-history-and-more-granular-data-available-within-aws-cost-explorer/

CUR might be a better solution for extended timelines. This is an example athena query -

SELECT line_item_resource_id as "Instance ID",
    SUM(line_item_unblended_cost) AS Cost
FROM cost_and_usage_report
WHERE line_item_product_code = 'AmazonEC2'
    -- AND Month = 04
    -- AND Year = 2023
    AND line_item_resource_id = '${instance_id}'

Hi Arjun, using the Cost Explorer, you can find the resource level cost for past 14 days only, provided resource-level data is enabled from the Billing & Cost Management Preferences for Cost Explorer. Once you enable it, apply the below filters on Cost Explorer to get the cost of an instance. Resource = EC2-Instances EC2-Instances = <select or type in the instance ID that you are looking for>

Better alternative is to get the compete cost and usage data from CUR using the Athena query. you can learn about CUR query using Athena from AWS Well Architected Labs. You can find the query from this repost.