{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Cloudmore Data Input ","Data Check - Important!","Customer Billing File","Customer Detail Billing File","Customer Margin Summary","Data Analysis","Sheet4"],"not_rendered":{"defined_names":1,"pivot_tables":6},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"Instructions"]
[1,"Go to the Azure Billing Reports page"]
[2,"Run the One Time Billing Report"]
[3,"Download the data export by selecting the 3 horizontal bars in the top right of the support screen"]
[4,"Copy all the data from \"Sheet 1\" to the Cloudmore Data Input sheet in this spreadsheet"]
[5,"Go to the 'Cloudmore Billing File' tab and right-click pivot table and select \"refresh data\" (You may need to do this for each of the pivot tables) "]
[]
["Note ","The Invoice Data Report shows a summary breakdown of your Microsoft Invoice data. If you have not linked all tenants, the report will not reconcile with your Microsoft invoice"]

{"sheet":"Cloudmore Data Input ","index":1,"n_rows":1,"n_cols":40,"rows_kept":1}
["ORGANIZATIONID","INVOICENUMBER","ORGANIZATIONNAME","MICROSOFTCUSTOMERID","CUSTOMERNR","PRODUCTNAME","SKUNAME","PRODUCTID","SKU","CUSTOMERCOUNTRY","SUBSCRIPTIONID","SUBSCRIPTIONDESCRIPTION","CHARGESTARTDATE","CHARGEENDDATE","TERMANDBILLINGCYCLE","BILLINGFREQUENCY","QUANTITY","BILLABLEQUANTITY","UNITCOSTPRICE","UNITSALESPRICE","UNITDISCOUNTPROC","SALESPRICE","TOTALCOST","TOTALSALE","PROFIT","INVOICECURRENCY","PRICINGCURRENCY","PCTOBCEXCHANGERATE","PCTOBCUNITCOSTPRICE","PCTOBCUNITSALESPRICE","PCTOBCSALESPRICE","BILLINGPROVIDER","RECORDTYPE","PUBLISHERNAME","MSPRICEADJUSTMENTDESCRIPTION","METERDESCRIPTION","ORDERDATE","CHARGETYPE","PRICEADJUSTMENT","PRICEMANAGED"]

{"sheet":"Data Check - Important!","index":2,"n_rows":12,"n_cols":12,"rows_kept":12,"hidden":true,"merged":[[1,0,1,3],[3,0,3,3],[4,0,4,3]]}
[]
["If you have not linked all tenants, this report will not reconcile with your Microsoft invoice."]
[]
["Data Check"]
["Use the filters to show any Zero margin items, that need sale price management (See Instructions TAB).   Adjust the total Margin filter to show only items that have 0 margin or show all items and check margin is set correctly in columns K amd L"]
[]
["TotalCost","(blank)"]
["TotalMargin","(blank)"]
[]
["OrganizationName","Customer Number","RecordType","ProductName","SkuName","ProductId","Sku","Country","Total Cost ","Total Sale","Total Margin","Margin%"]
["(blank)","(blank)","(blank)","(blank)","(blank)","(blank)","(blank)","(blank)",{"$nulls":3},{"$error":"#DIV/0!"}]
["Grand Total",{"$nulls":10},{"$error":"#DIV/0!"}]

{"sheet":"Customer Billing File","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[1,0,1,3],[3,0,3,3],[4,0,4,3]]}
[]
["If you have not linked all tenants, this report will not reconcile with your Microsoft invoice."]
[]
["Customer Billing File"]
["Use this data to create a summary bill for your customer"]
["TOTALSALE","(All)"]
[]
["ORGANIZATIONNAME","Customer Number","Total Cost ","Total Sales","Sum of Profit","TOTAL Margin CBF"]
["(blank)","(blank)",{"$nulls":3},{"$error":"#DIV/0!"}]
["Grand Total",{"$nulls":4},{"$error":"#DIV/0!"}]

{"sheet":"Customer Detail Billing File","index":4,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[1,0,1,4],[3,0,3,4],[4,0,4,4]]}
[]
["If you have not linked all tenants, this report will not reconcile with your Microsoft invoice."]
[]
["Customer Billing File split by Azure Consumption, Reserved Instances, Microsoft Subscriptions and Marketplace Services"]
["Use this data to check your margin is correct for each service type.   See Instructions TAB for details on how to change sales prices. "]
["TOTALSALE","(All)"]
[]
["ORGANIZATIONNAME","Customer Number","RECORDTYPE","Total Cost ","Total Sales","Sum of Margin CBF"]
["(blank)","(blank)","(blank)",null,null,{"$error":"#DIV/0!"}]
["Grand Total",{"$nulls":4},{"$error":"#DIV/0!"}]

{"sheet":"Customer Margin Summary","index":5,"n_rows":11,"n_cols":11,"rows_kept":11,"merged":[[1,0,1,3],[3,0,3,3],[4,0,4,3]]}
[]
["If you have not linked all tenants, this report will not reconcile with your Microsoft invoice."]
[]
["Billing Detail Report that shows "]
["Use this data, to do a detailed check, per line item, to confirm sales price and margin is correct"]
[]
["TOTALSALE","(All)"]
[]
["ORGANIZATIONNAME","Customer Number","RECORDTYPE","PRODUCTNAME","SKUNAME","PRODUCTID","SKU","Country","Total Cost ","Total Sale","Sum of Margin CBF"]
["(blank)","(blank)","(blank)","(blank)","(blank)","(blank)","(blank)","(blank)",null,null,{"$error":"#DIV/0!"}]
["Grand Total",{"$nulls":9},{"$error":"#DIV/0!"}]

{"sheet":"Data Analysis","index":6,"n_rows":11,"n_cols":10,"rows_kept":11,"merged":[[1,0,1,3],[3,0,3,3],[4,0,4,3]]}
[]
["If you have not linked all tenants, this report will not reconcile with your Microsoft invoice."]
[]
["Billing Detail Report that shows "]
["Use this data, to do a detailed check, per line item, to confirm sales price and margin is correct"]
[]
["TOTALSALE","(All)"]
[]
["ORGANIZATIONNAME","Customer Number","RECORDTYPE","PRODUCTNAME","PRICEADJUSTMENT","PRICEMANAGED","MSPRICEADJUSTMENTDESCRIPTION","Total Cost ","Total Sale","Sum of Margin CBF"]
["(blank)","(blank)","(blank)","(blank)","(blank)","(blank)","(blank)",null,null,{"$error":"#DIV/0!"}]
["Grand Total",{"$nulls":8},{"$error":"#DIV/0!"}]

{"sheet":"Sheet4","index":7,"n_rows":6,"n_cols":4,"rows_kept":6,"hidden":true,"merged":[[1,0,1,3]]}
[]
["If you have not linked all tenants, the report will not reconcile with your Microsoft invoice."]
[]
["OrganizationName","Customer Number","Total Cost","Total Sales"]
["(blank)","(blank)"]
["Grand Total"]