Skip to content

Reconcile FOCUS costs with your invoice

Last updated on

The FOCUS report shows all your resources and their costs in detail. The BilledCost column contains values with up to 11 decimal places. If you sum up these values, the result can differ from the amount on your invoice in the cent range.

During invoicing, STACKIT rounds the costs as follows:

  1. STACKIT sums up the costs of all resources per project and SKU.
  2. STACKIT rounds each sum to two decimal places using commercial rounding.

If you apply the same calculation to the FOCUS report, you get the same amounts as on your invoice.

The following example uses a spreadsheet application, such as Microsoft Excel or Google Sheets. The example uses manual steps, so that you can follow each calculation. You can automate the same logic in your FinOps tool or with SQL.

  • You have downloaded the FOCUS report for the month of the invoice.
  • STACKIT has issued the invoice for that month, and the report contains the corresponding InvoiceId. For details, see Invoice information.
  • You have opened the report in the first worksheet of your spreadsheet.
  1. Create a second worksheet.

  2. Copy the columns x_CustomerAccountId, SubAccountId, and SkuId from the first worksheet to columns A, B, and C of the second worksheet.

  3. Sort the second worksheet in ascending order by x_CustomerAccountId, then by SubAccountId, then by SkuId.

  4. Remove the duplicate rows. Each row now represents one SKU in one project.

  5. In column D of the second worksheet, sum up the BilledCost values from the first worksheet with a SUMIFS function. Use the following criteria:

    • x_CustomerAccountId matches column A.
    • SubAccountId matches column B.
    • SkuId matches column C.

    Column D now contains the unrounded cost per project and SKU.

  6. In column E, round the values of column D to two decimal places with the ROUND function. Column E now contains the cost per project and SKU as it appears on the invoice.

  7. To get the cost per project, sum up the values of column E for each SubAccountId.

  8. To compare the total with the invoice, sum up all values of column E and compare the result with the net amount of the invoice. The FOCUS report doesn’t contain taxes.