Understanding the Service Report from FTP

Admin
The platform also offers a report of all the Service Charges incurred by your Account for the billing month. The report is available for download from our FTP server at the end of the billing month, which is usually available on the second day of the new month.
To find out how to access our FTP server to download this report as well as your CDR, you can read this article here.
This report covers all charges incurred by your Account/s that is not call related such as number rental, porting charges, service plan charges, etc.

Version 1 (service-mm-yyyy.csv)

⚠️
This version does not take into account Customer information like Customer ID and Customer name and was introduced before services like Mobile and NBN was introduced. Moving forward, we will continue to offer this version to existing customers until 1st June 2023, in which time, this version will then no longer be generated moving forward.
The information that is available for this report are:-
No - The line item of the CDR charge
Account Id - The Account ID that the charge is associated to
Account Company - The Account Name that the charge is associated to
SIP Account - The Service Account that the charge is associated to
Type - The charge type*
Did - The DID number of the line item revolves around a phone number
Did Type - The DID type associated to the DID number*
Did Block - The block size of the DID number
Payment Time - the date and time, as per your timezone, on when the charge occurred
Desc - The description of the charge
Payment Amount - The total cost of the charge

Version 2 (service-mm-yyyy-v2.csv)

⚠️
Version 2 of the file addresses Customer information that you tie to service and is relevant for services like Mobile and NBN. This version will be the version that will prevail, moving forward.
No - The line item of the CDR charge
Sub Customer Id - The Customer ID that the charge is associated to
Sub Customer Company - The Customer’s Company Name that the charge is associated to
Account Id - The Account ID that the charge is associated to
Account Company - The Account Name that the charge is associated to
SIP Account - The Service Account that the charge is associated to
Type - The charge type*
Did - The DID number of the line item revolves around a phone number
Did Type - The DID type associated to the DID number*
Did Block - The block size of the DID number
Payment Time - the date and time, as per your timezone, on when the charge occurred
Desc - The description of the charge
Payment Amount - The total cost of the charge
*Type - the charge type groups expected are Misc Charges, Rental Number Charges, Setup Number Charges, Service Plan Charges, Receive SMS Charges & the expected type’s can be obtained via Atomic under Products
Service Plan Charges - the types expected can be obtained from Products > Service Plan > then navigate between Voice/Mobile/SMS/NBN. The service plan name will be the expected type and will be represented as Service Plan Charges - [Service Plan Name]
Setup & Rental Number Charges - the types expected can be obtained from Products > DID Rates > the Type column will be what is expected in the DID Type* column of the Service file.
Was this article helpful?
Ask AVA about this