Knowledge Base

Billing Report (5.0)

Overview

This document covers the broker-level Billing Report in Cloudmore 5.0. The report gives a complete view of billing across your organizations. You can filter and review billing, export the dataset by email, schedule recurring deliveries, and explore sales trends in charts. The report is pre-generated using the most up-to-date billing and product pricing data.

For the organization-level report, see Billing Report for Organizations (5.0). To add one-off charges or discounts, see Manual Billing Lines (5.0).

The Billing Report page

👥

Broker level: Reports > Billing Report

  • Full access: Super Admin, Global Admin, Global View Only Admin, Global Billing Admin

  • Full access (assigned organizations): Key Account Manager, Key Account View Only Manager, Limited Key Account Manager, Sales Agent

The page has four tabs.

Tab

What it shows

View

Billing results with total cost, total sales and margin, which you can drill down from billing date to individual billing lines. Also holds Import billing lines.

Export

Export options for an Excel file sent by email, and the list of previously exported files with their filters, date range, status and recipients.

Schedule

Scheduled reports. Columns: schedule name, frequency, filters, recipients, next run, last sent, status, and an Actions menu.

Charts

Total sales trends for the last 12 months, with total costs and total margins.

[SCREENSHOT] The broker Billing Report page with the View tab selected.

Role-based scope

The role decides which organizations are included in the report, the export and the charts.

  • Super Admin, Global Admin, Global View Only Admin, Global Billing Admin: all organizations.

  • Key Account Manager, Key Account View Only Manager, Limited Key Account Manager, Sales Agent: assigned organizations only.

Viewing billing

  1. Navigate to Reports > Billing Report. The View tab opens.

  2. Select the billing date range. By default, a rolling one month of billing is selected. The range sets the bounds by billing date, not by when the subscriptions were provisioned.

  3. Optionally, select Organizations and Services, and choose the grouping: Organizations > Services or Services > Organizations.

  4. Click Apply filters.

The results show total cost, total sales and margin per billing date, with totals per currency. Click a row to drill down. With the Organizations > Services grouping, the levels are: Billing date > Organization > Service > Subscription > Billing lines. The breadcrumb above the table shows where you are, and the arrow buttons expand or collapse all rows.

Exporting the billing report

  1. Open the Export tab.

  2. Set the export options (see below).

  3. Under Send to emails, add the recipients. Your own email is filled in by default.

  4. Click Send billing report.

Recipients receive an email with a link to download the Excel file. The file also appears in the list under the export options, with its status. The email is sent from noreply@cloudmore.com by default. To use your own sender address, see Branded Email (5.0).

Export options

  • Billing date range: restricts the export to billing within a date interval.

  • Organizations: pick organization groups and individual organizations, or keep all.

  • Services: all services by default. Microsoft 365 NCE and Legacy, and the Azure models, can be selected separately. All services is mutually exclusive with the individual options.

  • Currency: select Convert to other currency to show all amounts in a currency other than your default currency. Today's exchange rate is used for any date range.

  • Additional data: Organization details, Pricing details, Microsoft details and Cost centers add extra columns to the file.

Export fields

Field

Included

Billing Date, Service Name, Organization Name, Customer Number

Always

Product ID, Product Name, Item Code

Always

Quantity, Unit Cost Price, Unit Sales Price

Always

Total Cost, Total Sales, Margin Amount, Margin Percentage

Always

Currency Code, Payment Frequency, Purchase Order Number

Always

Subscription ID, Subscription Name, Billing Line Details

Always

Organization Currency Code, Organization Groups

Always

Company Registration Number, Primary Domain, Custom Properties

When Organization details is selected

Price Level, Price Rule Type, Unit Recommended Price, Total Recommended Price, Total Difference From Recommended

When Pricing details is selected

Charge Type, Charge Start/End Date, Tenant ID, Invoice ID, Invoice Date, Vendor Pricing Tags

When Microsoft details is selected

Cost Center

When Cost centers is selected

Pricing details fields

  • Price Level: The level on which the subscription's price was committed, for example Subscription, Organization, Broker or Seller level.

  • Price Rule Type: The rule type associated with the price, for example Fixed sales price, Fixed margin, Discount on MSRP or Price adjustment.

  • Unit Recommended Price: The recommended unit sales price at the beginning of the commitment term. For NCE promotion items, this is based on the standard Microsoft list price rather than the discounted promotional price.

  • Total Recommended Price: Unit Recommended Price x Quantity.

  • Total Difference From Recommended: Total Sales Price minus Total Recommended Price. This shows how much discount is given per billing line.

Scheduling the billing report

Global View Only Admin and Key Account View Only Manager can see schedules but cannot create or change them.

  1. Open the Schedule tab and click Create schedule.

  2. Enter a Report name, and select the Organizations, Service, currency and additional data, as for an export.

  3. Choose the Frequency (Daily, Weekly or Monthly), the day, and the Send at time. Weekly reports show the billing lines for the previous 7 days.

  4. Add the recipients under Send to emails and click Save schedule.

To change or remove a schedule, click Actions > Edit or Actions > Delete on its row.

[SCREENSHOT] The New scheduled report dialog.

Charts

The Charts tab shows the Total sales trends chart for the last 12 months, with total sales, total costs and total margins per month.

  1. Open the Charts tab.

  2. Select Services, Organizations and the currency, and click Apply filters.

  3. Click the table icon to see the numbers behind the chart, or the download icon to save the chart.