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.
Why the amounts differ
Section titled “Why the amounts differ”During invoicing, STACKIT rounds the costs as follows:
- STACKIT sums up the costs of all resources per project and SKU.
- 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.
Calculate project costs in a spreadsheet
Section titled “Calculate project costs in a spreadsheet”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.
Prerequisites
Section titled “Prerequisites”- 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.
-
Create a second worksheet.
-
Copy the columns
x_CustomerAccountId,SubAccountId, andSkuIdfrom the first worksheet to columns A, B, and C of the second worksheet. -
Sort the second worksheet in ascending order by
x_CustomerAccountId, then bySubAccountId, then bySkuId. -
Remove the duplicate rows. Each row now represents one SKU in one project.
-
In column D of the second worksheet, sum up the
BilledCostvalues from the first worksheet with aSUMIFSfunction. Use the following criteria:x_CustomerAccountIdmatches column A.SubAccountIdmatches column B.SkuIdmatches column C.
Column D now contains the unrounded cost per project and SKU.
-
In column E, round the values of column D to two decimal places with the
ROUNDfunction. Column E now contains the cost per project and SKU as it appears on the invoice. -
To get the cost per project, sum up the values of column E for each
SubAccountId. -
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.