Revenue reporting and profit & loss

    Most billing systems tell you what you collected. Rather fewer tell you what you kept.

    ✓ Revenue by package and site✓ Costs recorded alongside✓ Profit and loss✓ Reconciles to M-Pesa

    Collections, reconciled

    Every payment is recorded against the subscriber who made it, with the M-Pesa receipt alongside. That matters at month end, because the test of a revenue report is whether it agrees with your M-Pesa statement — and if the two disagree, one of them is wrong and you need to know which.

    Costs, which is the unusual part

    Bandwidth, rent, power, salaries, hardware — recorded in the same place as the revenue they produced. Plenty of ISP billing systems stop at collections and leave the other side of the ledger to a spreadsheet that quietly stops being updated around March.

    • Recurring costs that repeat each month without being re-entered.
    • One-off costs against the month they fell in, so a router purchase does not distort a year.
    • Profit and loss over the period you choose, rather than a revenue figure you have to mentally discount.

    Per-site, because averages hide the problem

    An ISP running three locations usually has one carrying the others. A single revenue number hides that; revenue and cost per site is what tells you whether the third site is worth keeping.

    Common questions

    Is this proper accounting?
    No, and it is better to be clear about that. This is operational profit and loss — what the network earned, what it cost to run, and the difference. It is not double-entry bookkeeping and it does not file your taxes. If you need a general ledger, you want accounting software alongside, and these figures feed it.
    Can I see revenue per package?
    Yes, and per site. Package-level reporting is usually the one that changes a decision, because it exposes the plans nobody buys and the price point that is too low.
    Does hotspot revenue show separately from PPPoE?
    Yes. They behave differently — hotspot is high-volume and variable, PPPoE is steady and monthly — so a combined figure tends to hide what each is doing.

    See it on your own network

    Seven days free, on the MikroTik routers you already run, with your own customers.