The OnSIP Reports tab provides summary CDR information broken down by User for outbound calls and by the Billable User for inbound calls.  Only one Billable User can be configured per phone number for inbound calls.  The reports found here do not provide a breakdown of how the call made it to a specific User or feature.  For that type of reporting one would want an Enhanced Queue or use an API.

Reading the Account Summary Report

1. Navigate to the "Reports" page and select the time period you would like to review in the report. Then, click on "Generate Report."

   

2. The summary for the time period chosen above will be displayed in the body of the page. The summary totals for inbound minutes, outbound minutes, and cost are at the top of the page. Each of the previous metrics is then broken down by the user in a table under the totals. 
3. Downloading Detailed Call Reports:  OnSIP provides a link to download the current time period's call detail records (CDRs) as a CSV file from the Reports page. Simply click the "Download as CSV" link near the top of the page to retrieve an in-depth breakdown of all calls in the specified time period. Call duration in the CSV is in seconds.

Reading User's Summary Report

1. Click on a username then "Show CDRs" in the lower right of the box to open that user's detailed report (see below, lower right arrow).
2. The report is broken down by call type, i.e. inbound, outbound, toll-free, and on network calls. The second column of each row displays the number of minutes used, the third column displays the number of calls, and the fourth column displays the total cost of the current call type. The cost of all of this user's calls for the given time range is the value listed in the user's summary row, under Total User Cost.

 

 

Reading the Downloaded .CSV file

Once you download your .csv file into whatever program you plan on using, here is what each of the fields mean:

CDR ID: More for OnSIP's use, you could pare this out of your sort

User ID: More for OnSIP's use, you could pare this out of your sort

DateTime(UTC):

• If this says "UTC" you may want to go back to your Reports tab >change the timezone > generate a report > download .csv file again
• When call was first dialed/start of call

Caller ID: self-explanatory

Source: Number that was Called or Number User Called

Destination: Reverse of Source (number the Caller dialed or number User is calling)

Disposition:

• Answered = call was answered
• Unanswered = no one answered the call and caller/callee hung up
• Failed = Unable to complete the call (inbound or outbound) / never connects

Length: call duration reported in seconds

Price: total cost of call

Cost: placeholder / not used

Answer Date: typical the same as DateTime

End Date Time (UTC): 

• If this says "UTC" you may want to go back to your Reports tab >change the timezone > generate a report > download .csv file again
• When call was ended

Routing: 

• Termination - Outbound call placed by User
• Origination - Inbound call

Name: for OnSIP use, you could pare this out of your sort

Auth User Name: for OnSIP use, you could pare this out of your sort

 

Please Note: SIP to SIP (this includes extension to extension calling) will not appear on the reports. The reports only reflect charged calls.

 

Updated October 2018

 

Learn more about OnSIP's built-in reporting tools