Link Search Menu Expand Document

Could not find the answer to your question? You can always contact support via our customer portal or send us an email


Reconciliation

What is reconciliation?

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.

How do I reconcile Microsoft CSP usage?

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/

If you require assistance with Reconciliation, reach us using this link or sending us an email.

How do I download my Reconciliation files from Azure?

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

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

Figure FAQ Reconciliation 2: Downloading Reconciliation via Overview

How do I perform AWS reconciliation?

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

How do I download a Cost and Usage report (CUR) from AWS?

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 3: Accessing the report description

Figure FAQ Reconciliation 4: Identifying CUR location in the bucket

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

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

Figure FAQ Reconciliation 6: Downloading CUR Guide


Back to top

Copyright Ⓒ 2023 CloudBilling (Inter8-NL B.V.)