Monthly Report
The Monthly Report provides a month-by-month financial summary of your ISP's billing and collection activity. It is the primary report for monthly financial closing, management review, and submission to your accountant or finance team.
Accessing the Monthly Report
Navigate to Accounts > Monthly Report in the left sidebar.
What the Report Shows
Each row in the Monthly Report represents one calendar month:
| Column | Description |
|---|---|
| Month / Year | The billing month and year for the row. |
| Total Billed | Total value of all invoices generated to customers during the month. |
| Total Collected | Total payments received from customers during the month (cash + online). |
| Cash Collected | Subset of payments received in cash by operators. |
| Online Collected | Subset of payments received via payment gateways. |
| Outstanding | Total billed amount not yet collected (Total Billed − Total Collected). |
| New Customers | Number of new customers added during the month. |
| Churned Customers | Number of customers who were deleted or deactivated during the month. |
| Operator | When filtered by operator, the reseller or manager for the displayed data. |
Filtering the Report
| Filter | Description |
|---|---|
| Year | Select a year to view all 12 months for that year. |
| Month Range | Select specific months within a year. |
| Operator | Filter to a specific reseller, sub-reseller, or manager. Admins see all operators by default. |
Click Apply Filters to update the displayed data.
Exporting the Report
To export the Monthly Report:
- Apply any desired filters.
- Click Export to Excel or Export to CSV.
- The downloaded file can be opened directly in Microsoft Excel, Google Sheets, or imported into accounting software such as QuickBooks or Tally.
Use Cases
Monthly Financial Closing
At the end of each month, the admin or finance manager can:
- Open the Monthly Report for the closing month.
- Verify total billed vs. total collected.
- Identify outstanding amounts and follow up with operators or customers.
- Export the report and hand it to the accountant for ledger entries.
Management Reporting
The Monthly Report is suitable for presenting a financial overview to business owners or investors. The month-by-month trend in billed amounts, collections, and customer growth gives a clear picture of business performance.
Operator Performance Review
Filter the Monthly Report by individual operators to review each reseller's monthly billing and collection performance. This helps identify resellers who are consistently underperforming on collections.
Year-End Review
Set the filter to the full year to see all 12 months side by side, providing an annual financial summary for tax or regulatory reporting.
Relationship to Other Reports
| Report | Difference |
|---|---|
| Monthly Report | Month-level summary; best for financial closing and management. |
| Daily Report | Day-level detail; best for short-term reconciliation. |
| Customer Payments | Transaction-level log; use when individual payment details are needed. |