Reporting
Reports are available through both the UI and the API. All reports are defined out-of-the-box. No configuration is required. Historical reports will produce the same results every time they are run.
See the Reporting API topic for information about retrieving reports from the API.
Note
All dates are treated as midnight (00:00:00) in your instance’s time zone.
Financial Transactions Report
Shows all invoice line items posted between the requested times. Use this report to book journal entries on an accrual basis in a General Ledger system, or to get a comprehensive view of the financials for a given line or policy.
Input is a range of transaction posting times
All posted transactions are shown, even for unissued invoices and policies
Each row represents an invoice line item, though the invoices in question may not be issued yet
For policies on an installment payment schedule, financial transactions will be split, one per billing period.
Paid Financial Transactions Report
Shows only financial transactions from paid invoices. Otherwise, this report is the same as the Financial Transactions Report.
On-Risk Report
Gives a granular view of risk assumed by the insurer, for all policies that had active coverage at the given coverage timestamp. Use this report as the basis for building custom reports or for actuarial analysis.
Input parameter is the as-of time for the report.
Only issued policies with active coverage are included.
Each row represents a period of coverage against a given peril with a given set of policy and exposure details.
Any change to coverage, exposure, or policy details (i.e. via an endorsement) will result in the old row falling off the report and being replaced by two or more new rows.
The report shows the state of policies that had active coverage at the given as-of time for the report.
All Policies Report
Gives a granular view of all policies that had active coverage during the specified coverage period.
Input parameters are the start and the end dates of the coverage period for the report.
Each row represents a period of coverage against a given peril with a given set of policy and exposure details.
Any change to coverage, exposure, or policy details (i.e. via an endorsement) will result in the old row falling off the report and being replaced by two or more new rows.
The report shows the state of policies with active coverages at the given coverage time stamp.
Since this report takes a datetime range and returns all unreplaced coverages with at least some coverage in that range, you can obtain an “as of” report by setting a small time window. For example, if you would like to see all active coverages in effect for a specific time, such as midnight on the first of the month, you can set a 1-millisecond time window as the date range for your request.
Payable Commissions Report
Returns commissions for premiums paid between the requested times. Socotra tracks which premium generated a given commission.
Input is a range of invoice payment times
Only commissions for paid premiums are shown
Each row represents the total commission payable to a single recipient for a single peril.
Claims Report
Shows all claim files and their status.
Input is the as-of time of the report
Each row represents a claim
All claims in the system at the as-of time are included, with their then-current status
Total loss and expense reserves for the case are included
Claim Reserves Report
Shows the current reserves across all claims in the instance.
Input is the as-of time of the report
Each row represents a subclaim
Loss and expense reserves are shown separately
Claims Payables Report
Shows all claims payables, along with the associated claim and subclaim IDs, and other context relating to the claim payable, for example, Policy ID.
Input is the range within which the payable was created
Each row represents a payable
Reversal information is provided for payables that have been reversed