Quota Share Treaty Cession Reconciliation Worksheet

Monthly or quarterly worksheet to reconcile ceded premium and losses under a proportional quota share treaty using bordereaux and supporting accounting records.

Reconciliation Overview

• Reporting Period Type
  Select the period covered by this reconciliation.
• Period Start Date
  First day of the reporting period.
• Period End Date
  Last day of the reporting period.
• Treaty Name
  Enter the quota share treaty name or identifier.
• Ceding Company
  Name of the ceding entity for this reconciliation.
• Prepared By
  Name or team preparing the worksheet.
• Submission Notes
  Optional context for unusual timing items, late bordereaux, or known adjustments.

Treaty Terms and Basis

• Ceded Percentage
  Quota share percentage ceded under the treaty.
• Currency
  Reporting currency used for the reconciliation.
• Accounting Basis
  Select the basis used for the bordereaux and ledger comparison.
• Bordereaux Received
  Confirm whether the source bordereaux were received for the period.
• Bordereaux Source
  Select the bordereaux types used in this reconciliation.
• Late or Missing Bordereaux
  Indicate whether any bordereaux were late, incomplete, or missing.
• Late or Missing Bordereaux Details
  Describe the missing items, expected receipt date, and any interim estimate used.

Ceded Premium Reconciliation

• Gross Written Premium
  Total gross written premium for the period.
• Ceded Premium per Bordereaux
  Ceded premium amount reported on the bordereaux.
• Ceded Premium per Ledger
  Ceded premium amount recorded in the accounting ledger.
• Premium Variance
  Calculated difference between bordereaux and ledger amounts.
• Premium Variance Reason
  Explain timing differences, rate changes, corrections, or other causes of variance.
• Premium Adjustment Required
  Indicate whether a journal entry or correction is needed.

Ceded Loss Reconciliation

• Gross Losses
  Total gross losses or incurred losses for the period.
• Ceded Losses per Bordereaux
  Ceded loss amount reported on the bordereaux.
• Ceded Losses per Ledger
  Ceded loss amount recorded in the accounting ledger.
• Loss Variance
  Calculated difference between bordereaux and ledger amounts.
• Loss Variance Reason
  Explain case reserves, paid losses, recoveries, timing differences, or other causes of variance.
• Loss Adjustment Required
  Indicate whether a journal entry or correction is needed.

Variance Analysis and Audit Trail

• Supporting Documents
  Upload bordereaux extracts, ledger reports, or reconciliation support files.
• Material Variance Present
  Indicate whether any variance exceeds the review threshold used by your team.
• Material Variance Explanation
  Provide the root cause, expected resolution date, and any escalation details.
• Review Status
  Select the current reconciliation status.
• Reviewer Comments
  Optional review notes for the audit trail.
• Attestation
  Required acknowledgment for submission.