Overview
This document covers the seller-level Billing Report in Cloudmore 5.0. It brings together the billing of the seller's child brokers: every Limited and Linked broker where this seller is set as the parent. Seller users use it to review, export and import the billing of these brokers, one broker at a time.
The seller report has the same functionality as the broker-level report described in Billing Report (5.0), with an added Broker selection. The differences are listed below.
The Billing Report page
Navigation and permissions
Seller level: Reports > Billing Report
-
Full access: Seller Global Admin, Seller Billing Admin
-
Read only: Seller View Only Admin
Seller Service Admin has no access to the Billing Report.
The page has two tabs.
|
Tab |
What it shows |
|---|---|
|
View |
Billing of the selected broker per billing date, with total cost, total sales, margin and totals per currency. Filter by billing date range, Broker, Services and Currency. |
|
Export |
Export options for an Excel file sent by email, and the list of previously exported files. |
[SCREENSHOT] The seller Billing Report page with the View tab selected and the Broker filter open.
Which brokers are included
The report includes every broker where this seller is marked as the parent:
-
Limited brokers
-
Linked brokers
These brokers are listed in the Broker filter. Independent brokers can appear in the seller's Brokers list, but their billing is not part of the seller report.
You can view the billing of one broker at a time. When the View tab opens, the first broker in the list is selected in the filter and its billing is loaded automatically. Select another broker to switch. The selected broker stays visible in the results path, so it is always clear whose billing you are looking at. The same one-broker selection applies on the Export tab.
Costs shown in the report
The report shows the selected broker's cost and the broker's sales, with the margin between them. This applies to both the View and Export tabs.
The seller's own cost is not shown anywhere in the Billing Report. The upside is that all billing in the report is pre-generated and comes from the same data source as the broker-level report, so the seller sees exactly the same figures as the broker.
All billing data for the selected broker is available, including the Microsoft details.
Differences from the broker report
-
The results start one level higher. The drill-down goes from billing date to Broker, then to the broker's organizations and on from there.
-
There is a Broker filter instead of an Organizations filter. Only one broker can be selected at a time.
-
Cost and margin are the broker's, not the seller's.
-
There are no Schedule or Charts tabs.
-
An export covers the broker selected under Broker on the Export tab.
-
The export offers all four additional data options: Organization details, Pricing details, Microsoft details and Cost centers.
-
Billing lines can be imported at seller level with Import billing lines.
Viewing billing
-
Navigate to Reports > Billing Report. The View tab opens.
-
Select the billing date range, the Broker and, optionally, the Services and Currency.
-
Click Apply filters. Click a billing date to see the brokers, then click a broker to see its organizations.
Exporting the billing report
-
Open the Export tab.
-
Select the Broker, and set the Billing date range and the Services.
-
Optionally, select Convert to other currency, and any of the additional data options.
-
Add the recipients under Send to emails and click Send billing report.
Recipients receive an email with a link to download the Excel file. The file also appears in the list of exported files on the tab.
Importing billing lines
Click Import billing lines on the View tab to add billing lines from a file. The file format and steps are described in Manual Billing Lines (5.0).