Overview
This document covers manual billing line items in Cloudmore 5.0. Manual Billing Lines enable a broker to input billing records from external sources into Cloudmore.
These billing lines are non-recurring and are intended for manual adjustments. They can be used for one-time extra charges or one-time discounts related to specific subscriptions.
Import Billing Lines
Navigation and permissions
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
Billing lines are imported from an Excel file on the View tab of the Billing Report. You import them at subscription level, so first drill down to the billing lines of the subscription.
-
Navigate to Reports > Billing Report. The View tab opens.
-
Set the filters and click Apply filters.
-
Drill down by clicking the rows: billing date, organization, service and subscription. The breadcrumb shows Viewing: Billing Lines when you reach the subscription's billing lines.
-
Click Import billing lines. If you click it before reaching a subscription's billing lines, Cloudmore asks you to drill down first.
-
Click Download template to get the Excel template (billing-lines-template.xlsx, 5 columns).
-
Fill in one billing line per row and save the file.
-
Drag the file into the dialog, or browse to it. The file must be Excel (.xlsx) and up to 2 MB. Each row is validated before anything is imported.
-
Click Import billing lines.
[SCREENSHOT] The Import billing lines dialog with the Download template and upload steps.
Manual Billing Lines API
Organization Manual Billing Lines (MBL) can be created through the following POST endpoint exposed by the Cloudmore API:
POST /api/resellers/{resellerId}/organizations/{organizationId}/manualbilling
Request Body
{
"billingDate": <datetime>,
"serviceId": <string>,
"productId": <string>, // Optional
"subscriptionId": <string>,
"itemCode": <string>, // Optional
"quantity": <decimal>,
"costPrice": <decimal>,
"salesPrice": <decimal>,
"currencyCode": <string>, // Optional
"note": <string> // Optional
}
Special Handling of itemCode and productId
Both itemCode and productId are optional fields. The API applies the following logic:
-
If provided - The given values are stored as-is and used directly in the created MBL.
-
If not provided - The API retrieves the associated subscription using the provided
subscriptionIdandserviceId, then extracts and applies theitemCodeandproductIdfrom the subscription.
Viewing Manual Billing Lines
Imported billing lines appear in the Billing Report. Navigate to Reports > Billing Report, select a date range that includes the billing date and the service, and click Apply filters. See Billing Report (5.0).