Skip to content
14-day free trial, no card9 languages176 business types · 50 apps
EN· USD
Try a live demoStart free trial

Internet & cable reports: how it works

Active subscribers by area and package, new and churned lines per month, ARPU, billed vs collected per area this month and collections per collector, overdue aging of open bills and installations still waiting.

Lesson 8 of 12 · How it works

  • about 2 min
  • Internet & cable → Reports

How it works

  1. «Lines by area» and «Active lines by package» count the lines today; suspended lines are shown per area.

  2. «New and churned lines» counts activations and disconnections per month for the last six months, with what was billed and the ARPU What was billed in a month divided by the lines active in that month. More words in the glossary (billed in the month ÷ lines active in it).

  3. «Billed vs collected» compares this month's bills with what was paid on them, per area; below it the door collections per collector.

  4. «Overdue aging» groups open bills by days past due (not due, 1–30, 31–60, 61–90, over 90); «Installations waiting» lists open installation visits with their waiting days.

Where to find it

Checklist

Before you move on, check that you can:

  • Open Internet & cable → Reports
  • Lines by area and Active lines by package count the lines today; suspended lines are shown per area.
  • New and churned lines counts activations and disconnections per month for the last six months, with what was…
  • Billed vs collected compares this month's bills with what was paid on them, per area; below it the door…
  • Overdue aging groups open bills by days past due (not due, 1–30, 31–60, 61–90, over 90); Installations…

Tips and common mistakes

  • All figures come from the real invoices and payments, so a voided bill drops out of them.
  • Give every line an area — lines without one are counted under «No area» in the area tables.