Identify sources of billed cost

FOCUS Versions

v1.3 v1.4

Context

Reconcile billing data from Service Providers, Host Providers, and Invoice Issuers to pinpoint true spend and eliminate duplicate charges.

FOCUS SQL Query

SELECT 
    ServiceProviderName,
    HostProviderName,
    InvoiceIssuerName,
    InvoiceId,
    SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
GROUP BY
    ServiceProviderName,
    HostProviderName,
    InvoiceIssuerName,
    InvoiceId

FOCUS Datasets

Contract Commitment Cost and Usage Billing Period Invoice Detail

FOCUS Columns

Service Provider Name Host Provider Name Invoice Issuer Name Invoice ID Billed Cost Charge Period Start Charge Period End

Previous Identify resources with shared cost allocation Next Report corrections by subaccount for a previously invoiced billing period