Lumen Spend Reports with CSV and Scheduled Email

Spend Reports is a library of ready-made reports built from your invoices and inventory. The list on the left is every report available to you. Click one, and it runs right away on the right. The first report, Spend trend, charts your monthly spend with the figures underneath.

Hover over a month to see how it breaks down, and the line above the chart shows the date the report starts from. Most reports have a few options next to the title. For Spend trend you can change the period, from the last month up to two years, and group the spend by billing account, product family, product, or cost center. The next group looks at where your money goes: month-over-month variance shows what went up or down and by how much.

Top services, sites, and billing accounts ranks your biggest costs. Spend mix, tax by jurisdiction, cost per site, and unit cost per megabit help you compare charge types, locations, and products. Further down are billing health and audit reports: past due balances and late fees, missing or late invoices, spend that isn't matched to inventory, on-demand usage checks, and findings like ghost services, billing after disconnect, duplicate billing, and rates above contract. For month-end, there's the chargeback statement by cost center, the MSP rebill statement, budget versus actual and forecast, the monthly accrual for charges not yet billed, and GL and AP export files for your accounting system.

The last group covers contract expiry and out-of-term services, commitments, dispute aging, savings, SLA credits, optimization opportunities, and a benchmark of what you're billed against list price. Every report can be downloaded with the CSV button, using the options you've set. Email schedules the same report to be sent daily, weekly, or monthly, just like the executive summary. That's the Spend Reports library: pick a report, set its options, and download or schedule it.

Next, we'll see how the Audit tab finds billing problems.