Reconciliation Summaries

In addition to viewing gauges in the Producer Portal, FlexNet Usage Management provides a way to download simple usage reports that can be uploaded to a billing system. A reconciliation summary is a file containing records of usage and overage data for a given account ID, product name, and feature name, for the desired billing period.

While logged in to the Producer Portal, you can download a reconciliation summary file by opening this URL, where <siteID> is your account’s site ID and yyyy-mm-dd is the billing period end date (for information about the site ID, see FlexNet Operations Environments):

https://<siteID>-fno.flexnetoperations.com/flexnet/service/ReconSummary?StmtCloseDate=yyyy-mm-dd

For a UAT environment, include -uat in the URL:

https://<siteID>-fno-uat.flexnetoperations.com/flexnet/service/ReconSummary?StmtCloseDate=yyyy-mm-dd

If you are not logged in, the URL must include username and password values in the query string.

Instead of using a browser, you can automate download of the reconciliation summary data with a utility such as cURL, using a command similar to the following:

curl --url 'https://<siteID>-fno.flexnetoperations.com/flexnet/service/ReconSummary?
username=user@domain.com&password=pwd&StmtCloseDate=yyyy-mm-dd'

The reconciliation summary file is a comma-separated text file (CSV file) containing the summary usage data for the specified billing period. The file contains a header row followed by records of usage data.

enterpriseName, accountID, productName, productID, featureName, friendlyName, startDate,
endDate, usageUnitName, usageFromStatement, entitled, overageFromReset, overageFromStatement

"DEMO1","DEMO1","Storage","55555","Connections","Number of Connections",2014-07-01,
2014-08-01,,0,5000,0,0

"DEMO1","DEMO1","Storage","55555","Storage","Storage (GB)",2014-07-01,2014-08-01,,0,2000,0,0

You can then transform the data into the required format before uploading it to your billing system for processing.