PBilling
Import Data
| Import Type | Current Records | Action |
|---|---|---|
| UC Users | Loading... | |
| E911 | Loading... | |
| UC Phone Numbers | Loading... | |
| UC Telco | Loading... | |
| PP DIDs | Loading... | |
| PP CDR | Loading... | |
| Iristel CDR | Loading... | |
| PP Clients | Loading... |
Accepts Excel (.xlsx, .xls) or CSV files.
The file should contain columns: Domain (first column), PBX Users, Call Centre, Call Recording, SIP Trunks, Meeting Rooms, Voicemail, Telephone Numbers, MS Teams, Video Conferencing. First 2 rows will be skipped.
CSV file format: Domain, Phone Number, Name, Street Number, Street Name, Location, City, State, Country, Zip Code, Language. First row will be skipped.
CSV file format: Tab-separated values. First row will be skipped.
CSV file format: Comma-separated values. Only columns matching table field names will be imported.
CSV file format: year,month,client_id,provider_id,calldate,src,dst,billsec,onnet,ratecenter,price,totalprice
Month and year will be read from the file. Platform will be automatically set to 'pp'. First row will be skipped.
CSV file format: field[1]=date, field[2]=calling, field[3]=called, field[6]=billed_min
Year and month will be extracted from the date field. Platform will be set to 'iris', provider_id to 'irisdirect'. First row will be skipped.
CSV file format: shortname, name, enabled (true/false)
Month and year will be read from the variables table. First row will be skipped.
CSV columns: Date/Time, (skip), Called Number, Calling Number, (skip), (skip), (skip), Duration (minutes)
First row will be skipped. Imports into ppircdr table with platform=reseller.
Admin Panel
Manage Variables
Map Domains
| Domain | Client ID | Group |
|---|
Build Billing Table
This will update the pp_clients table with minute usage data from mins_client_onnet view for the current month/year from variables.
Build UC Billing Table
This will update the uc_users table with minute usage and billing data from uc_inbound_mins and mins_client_onnet views for the current month/year from variables.
Validate Data
Validates data consistency across tables for the current month/year from variables.
User Management
| Username | Role | Reseller Access | Created | Last Login | Actions |
|---|
Reports
Filters
PPIRCDR Report
PP Clients Report
UC Phone Numbers Report
UC Users Report
UC 911 Report
Trend Reports
Shows monthly trends from June 2025 to current month/year from variables.
Filters
Client Billing Report
Showing active clients for the current month/year from variables.
| Client Info | DIDs Local/TF | DIDs 911/QC | Orig Mins | Term Mins | Billable | Unified Communications | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Client ID | Name | En | Limit | Local | TF | 911 | QC | Orig | TF | OnNet | OffNet | Bill | Price | Users | CallCtr | Record | Trans | SIP | Phone | 911 |
Client ID Billing Reports
Generating Reports...
Processing...
UC Domains Billing Reports
Generating Reports...
Processing...
UC Billing Report
| Domain | Services | Minutes | Billing | Totals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Domain | PBX | CallCtr | Record | SIP | Trans | Numbers | 911 | Inbound | TF | OnNet | OffNet | Int | Price | Total | Avg |
User Management
| Username | Role | Reseller Access | Created | Last Login | Actions |
|---|