Pre-Billing Report

The pre-billing report highlights potential issues before invoices are produced. It runs automatically when the billing run is marked Ready or Approved, and is emailed to billing users. You can also request it manually from the billing run.

You must confirm the pre-billing report has been checked before requesting bill production. Expert mode bypasses this requirement.

Understanding the Report

Colour Coding

The report uses colour to show the status of each value:

• Green: Normal. The value is within expected range.
• Light red: Possible anomaly. The data differ from recent months and are worth checking.
• Dark red: Likely error or loss. The data suggest missing information, a pricing problem, or a financial loss.
• Blue with ??? or ????: Missing data. The platform could not find a value it expected, such as a wholesale cost or retail rate.
• Grey: Not relevant to the current billing period. This applies to unbilled call data for the most recent month, where the calls are about to be billed in the current run.

Anomaly Detection

The platform compares each month’s figures against a rolling average of recent months. When values differ from the average by more than 15%, the report highlights them in light red. This helps you spot unexpected changes in call volumes, charges, or costs without checking every number manually.

Conditional Sections

Each section only appears when there are data to show. If no calls are unallocated, for example, the Unallocated Calls section is omitted entirely. Some sections (such as Carrier Fixed Fees and Wholesale Call Cost Discrepancies) only appear when specific wholesale modules are active on your platform.

Report Sections

Carrier Call Report

Shows CDRs received from each carrier, broken down by file type and month. Use this to confirm all expected data have arrived and volumes look sensible.

What to look for: Check that every expected carrier has data for the current billing period. Watch for sudden drops in call legs or minutes compared to previous months, and confirm that profit margins are consistent.

Each carrier and file type gets its own table. The actual report shows six months, with the most recent on the left.

Carrier Alpha [calls]

The following rows appear only when relevant:

• Nonbilling Calls: Shown when some calls are flagged as non-billing. Highlighted in red if they exceed 1% of total call legs.
• Wholesale Discrepancy: Shown when the wholesale calls module is active. Compares CDR-reported wholesale costs against the platform’s calculated costs.
• Unbilled Calls / Unbilled Call Value: Shown when calls from previous periods remain unbilled. Current-period values appear in grey since those calls are about to be billed.

Carrier No CDR Report

Lists carriers expected to provide CDRs that have not sent any recently. This is one of the first things to check. If a carrier is missing, their customers’ calls will not appear on invoices.

What to look for: Every carrier listed here needs investigating. Either files are late and you should chase the carrier, or the carrier is no longer in use and can be removed from the expected list.

Unallocated Calls

Shows calls that have not been matched to a number or customer. These calls will not appear on any invoice until they are allocated.

What to look for: High wholesale costs in this section mean you are paying for calls nobody is being charged for. Numbers appearing here often indicate new numbers not yet added to the platform, or ported numbers with formatting differences.

Rows are sorted by chargeable cost (highest first). When wholesale cost data are missing, the Wholesale Cost column shows ??? and the Wholesale Chargeable Cost shows >= to indicate the true cost may be higher.

Unrated Calls

Shows calls matched to a customer but without a retail rate. These calls will not be billed unless a rate or markup is added.

What to look for: Check whether the missing rates are for new call types that need tariff setup, or existing call types where rates have expired. The wholesale cost tells you how much you are paying for calls you currently cannot charge for.

When a call type has a tariff band, it appears in brackets after the call type name.

Fallback Rated Calls

Shows calls that will be billed using a percentage markup over wholesale cost, rather than a specific retail rate. This includes calls rated using per-class markup during rating, and calls rated using fallback markup at billing time. The platform checks for a fallback percentage on the tariff first, then the number, then the customer.

What to look for: Review the markup percentages to check they produce acceptable retail prices. If you need more precise pricing, set up specific retail rates for these call types instead.

The Fallback column shows the percentage markups. “Suggested Retail” applies to the suggested retail rate. “Wholesale” applies to the wholesale cost. When both are set, they appear together.

Unbillable Calls

Shows calls allocated to numbers or customers that are not set up for billing. These calls have been matched but will not be charged because the customer, number, or feature is marked as non-billable.

What to look for: Check whether these customers or numbers should actually be billable. A high wholesale cost here means you are paying to carry calls that nobody will be invoiced for.

The Customer column shows the account number and company name. Rows are sorted by chargeable cost (highest first).

Carrier Fixed Fees

Shows fixed fee files received from each carrier, broken down by file type and month. This is the fixed-fee equivalent of the Carrier Call Report.

What to look for: Confirm all expected fixed fee files have arrived. Watch for months with zero files, sudden changes in the number of charges, and any unallocated fees that need matching to customers.

This section only appears when the wholesale fixed fee modules are active. The actual report shows six months, with the most recent on the left.

Carrier Alpha [fixed fees]

The following row appears only when relevant:

• Unallocated Fixed Fees: Shown when some fees from this carrier could not be matched to a customer. Highlighted in red.

No Fixed Fee Files

Lists carriers expected to provide fixed fee files that have not sent any recently. This is the fixed-fee equivalent of the Carrier No CDR Report.

What to look for: Every carrier listed here needs investigating. Either files are late, or the carrier’s fixed fee setup needs updating.

This section only appears when the wholesale fixed fee modules are active.

Unallocated Fixed Fees

Shows fixed fees from carriers that have not been matched to a customer’s feature. These data represent costs you are paying but not passing on to anyone.

What to look for: Check whether the listed numbers or references match customers on your platform. Unallocated fees often indicate new services not yet set up, or number formatting differences between the carrier file and the platform.

This section only appears when the wholesale fixed fee modules are active.

Each carrier gets its own table:

Carrier Alpha

When a customer or number is recognised by the platform, it appears in green in the actual report. Unrecognised references show the raw carrier data instead.

Fixed Fee Discrepancies

Shows mismatches between the wholesale rates on the platform and the rates in the carrier’s fixed fee files. A discrepancy means the carrier is charging a different amount than the platform expects.

What to look for: Negative discrepancies (shown in red) mean the carrier is charging more than expected. Positive discrepancies mean they are charging less. Blue ???? markers indicate months where data are missing from one side or the other.

This section only appears when the wholesale fixed fee calculation module is active. The actual report shows six months, with the most recent on the left.

Each carrier gets its own table, with customers listed beneath:

Carrier Alpha

The current billing month often shows ???? because the platform is still processing that month’s transactions. Only customers with at least one non-zero discrepancy are shown.

Ended Recurring Charges

Shows active features with recurring charges where the end date has already passed. These features are still active on the customer’s account, but the charge period has expired.

What to look for: Decide whether each feature should be cancelled (if the service has genuinely ended) or the charge end date extended (if the service is continuing). Instalment-based charges do not appear in this section.

Features linked to a number show the number. Customer-level features leave the number column blank.

Unchargeable Features

Shows features with a service charge or connection charge that the platform cannot bill because required fields are missing. Common missing fields include the billing interval, feature type, or start date.

What to look for: Each feature listed here represents lost revenue until the missing information is added. Check the Sold Date to understand how long the feature has been unchargeable.

A blank Service Charge means the charge exists on the standard feature template but is missing on the customer’s feature record. A blank Sold Date means the feature has no start date set.

Fixed Charges

Shows fixed charges (recurring fees, one-off charges) for each customer compared across a six-month window. Only customers with values that differ significantly from their rolling average appear in this section.

What to look for: Sudden increases may indicate duplicate charges or incorrectly applied fees. Sudden drops could mean a feature was accidentally removed. Blue ???? markers on profit indicate missing wholesale costs.

The actual report shows six months, with the most recent on the left.

The Profit row only appears when the wholesale fixed fee calculation module is active. Negative profit values (where wholesale costs exceed retail charges) are highlighted in red.

Call Charges

Shows call charges for each customer compared across a six-month window. Like the Fixed Charges section, only customers with values that differ significantly from their rolling average appear here.

What to look for: Watch for customers with a sudden drop in call legs or minutes, which could indicate a porting issue or service disruption. Red loss-making leg values mean the customer’s calls are being sold below cost.

The actual report shows six months, with the most recent on the left.

The following row appears only when relevant:

• Loss-Making Legs: Shown when the platform detects calls being sold below wholesale cost. Values where wholesale or retail data are missing show >= to indicate the true loss may be higher.

Loss-Making Calls

Shows individual call types where retail charges are below wholesale cost (before any discounts). Each tariff group gets its own table, with call types broken down by time of day.

What to look for: Focus on call types with high loss values or large call volumes. These may need retail rate increases. The Numbers column helps you identify which customers are affected.

Standard Tariff

When more than 10 numbers are affected, the report shows the first few followed by “+ X others”. Call Time values are Day, Eve, or W/E (weekend).

When calls have both A-leg and B-leg components (such as calls involving two carriers), the Loss column splits into separate A Leg Loss and B Leg Loss columns.

Wholesale Call Cost Discrepancies

Shows calls where the wholesale cost in the CDR file differs from the platform’s calculated wholesale cost, or where one of these values is missing. Each carrier and tariff combination gets its own table.

What to look for: Consistent discrepancies across a call type suggest the carrier has changed their rates. Missing values (shown as ???) mean either the CDR had no cost data, or the platform has no wholesale tariff set up for that call type and carrier.

This section only appears when the wholesale calls module is active.

Carrier Alpha [Standard Tariff]

When calls have both A-leg and B-leg components, the Discrepancy column splits into separate A Leg Discrepancy and B Leg Discrepancy columns.