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.

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.

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

Unearned Premium Report

Gives earned and unearned premium on a per-policy basis, as well as day-over-day changes. This version of the report shows unearned premium on accounts receivable, as opposed to paid premium.

  • Input is the as-of time of the report

  • Each row represents a billing period for a policy

  • Only invoiced periods for which the premium is not fully earned are displayed

  • Earned/unearned premium is calculated for the as-of time, using the state of the policy at that time

  • Earned premium for a given billing period is calculated on a straight-line, actual-day basis. (Not 30/360)