Could not find the answer to your question? You can always contact support via our customer portal or send us an email
- What is reconciliation?
- How do I reconcile Microsoft CSP usage?
- How do I download my Reconciliation files from Azure?
- How do I perform AWS reconciliation?
- How do I download Cost and Usage report (CUR) from AWS?
Reconciliation refers to the process of ensuring that two sets of records correspond accurately. In the case of CloudBilling, it means the checks between the information billed to the partner by Public Cloud Vendor and the information on the invoices in CloudBilling
In CloudBilling, CSP (Cloud Service Provider) connectors retrieve consumption data from Public Cloud Providers, including Microsoft Azure or AWS.
The primary objective of the reconciliation process is to compare the costs of Public Cloud services generated in CloudBilling with the costs reported by the Public Cloud Provider itself (such as Microsoft or AWS).
The ultimate goal is to analyze and resolve any discrepancies that may exist between the two sets of records.
In order to perform reconciliation for Microsoft CSP, you need to download the right reconciliation files from the Partner Center, depending on the product category that you are reconciling./br/
The usage and costs in these files can be checked against the usage and costs under the invoice of the customer you have mapped to the specific tenant in CloudBilling. Columns such as billable quantities, unit prices, and subtotals in these files can be compared with the invoice results in CloudBilling./br/
Keep in mind that for each product or product category, you might need different reconciliation files and may need to account for proration, mutations, cancellations, promos, etc. in order to properly reconcile the product category./br/
Make sure that you know which reconciliation file you need to download and whether it is a billed or unbilled version of it.
You can download reconciliation file in the Partner Center. On your [partner center] (https://partner.microsoft.com) home screen, go to ‘Billing’.
For the BilledOneTimeInvoiceLineItems, you can download it by pressing the Download-Reconciliation button.
For the UnbilledOneTimeInvoiceLineItemsDailyUsage, pay attention to the “Estimates” section. By pressing download current or previous month, you can select which file is required to be downloaded.
For the UnBilledOneTimeInvoiceLineItems, look under the “Estimates” section as well. Press current month and select the file you are required to download.
Figure FAQ Reconciliation 1: Downloading Azure Reconciliation files
In case you are required to download files for months before, you can go to the ‘Billing Overview’ section on the left side of the menu. Find the month you are required to download and click the clue download button on the left side of the invoice name. A menu on the right will pop up and you can select the right reconciliation file to download
Figure FAQ Reconciliation 2: Downloading Reconciliation via Overview
To successfully reconcile your AWS account, it’s essential to download the Cost and Usage report from the designated bucket in your AWS cloud. Once you have this report, you can easily compare your usage and costs against those listed on the invoice of your CloudBilling customer.
By comparing multiple columns in these files with the invoice results in CloudBilling, you can ensure that everything aligns properly. However, it’s important to note that different item types may require you to consider various columns in the cost and usage report. This is especially crucial when dealing with credits, discounts, refunds, proration, mutations, cancellations, promos, and other factors that can impact the product category./br/
Recon files for AWS specifically are extremely large files, so much so that they are split up into multiple files. That means that unlike other cloud providers, it is not always possible to reconcile AWS using excel. You might need to run a script or a query on the data before you can use it to reconcile your invoice. Please, contact support at cb if you require assistance or would like us to do the reconciliation for AWS.
If you require assistance with Reconciliation, reach us via support channel or give us a call
Make sure that the report is being generated in your Amazon S3 bucket. In case you want to create a new report, see our AWS connector guide on how to do that.
- Go to the “S3” section (e.g. by searching “S3” in the top search bar).
- Select the S3 bucket where the reports are being generated
- Search for folder named ‘usage’. This folder location is specified in your cost and usage reports. See images below on how to find your CUR in the bucket.
Figure FAQ Reconciliation 3: Accessing the report description
Figure FAQ Reconciliation 4: Identifying CUR location in the bucket
- Look for the date of the report that you require to download.
- Select the .zip file of a report you require to download by clicking the checkbox.
- Click ‘Download’ button above.
Figure FAQ Reconciliation 5: Downloading CUR
Below, you can see a step-by-step guide on downloading the report
Figure FAQ Reconciliation 6: Downloading CUR Guide