Get-CSPBilling

Get-CSPBilling.ps1

Import-Module PartnerCenterModule
Import-Module PSExcel
$Destination = 'C:\Billing'
$BillingFilename = '{0}-{1}-{2}Billing.xlsx'
$clientSecret = 'Your super secret string'
$CSPAppID = 'Your App GUID'
$CSPDomain = 'Your CSP Domain'
$clientSecretSecure = $clientSecret | ConvertTo-SecureString -AsPlainText -Force
Add-PCAuthentication -cspAppID $CSPAppID -cspDomain $CSPDomain -cspClientSecret $clientSecretSecure
$Latest = Get-PCInvoice -all | Select-Object -First 1
'Azure','Office' | ForEach-Object {
    $Params = @{
        invoiceid = $Latest.id
        billingprovider = $_
        invoicelineitemtype = "BillingLineItems"
    }
    $FilePath = Join-Path $Destination $($BillingFilename -f $(Get-Date $Latest.invoiceDate -uformat "%Y-%m-%d"),$Latest.id,$_)
    Get-PCInvoiceLineItems @Params | Export-xlsx $FilePath
}