Templates › Forms › SEO page

Run: Quota Share Treaty Cession Reconciliation Worksheet

Reconcile ceded premium and losses under a quota share treaty using bordereaux and ledger records. This worksheet helps you spot variances, document adjustme...

Fill this out, get a PDF emailed to you. No account required. Want to run it with your team and track results? Sign up free →

Reconciliation Overview

Reporting Period Type (required)

Select the period covered by this reconciliation.

Period Start Date (required)

First day of the reporting period.

Period End Date (required)

Last day of the reporting period.

Treaty Name (required)

Enter the quota share treaty name or identifier.

Ceding Company (required)

Name of the ceding entity for this reconciliation.

Prepared By (required)

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 (required)

Quota share percentage ceded under the treaty.

Currency (required)

Reporting currency used for the reconciliation.

Accounting Basis (required)

Select the basis used for the bordereaux and ledger comparison.

Bordereaux Received (required)

Confirm whether the source bordereaux were received for the period.

Bordereaux Source

Select the bordereaux types used in this reconciliation.

Late or Missing Bordereaux (required)

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 (required)

Total gross written premium for the period.

Ceded Premium per Bordereaux (required)

Ceded premium amount reported on the bordereaux.

Ceded Premium per Ledger (required)

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 (required)

Indicate whether a journal entry or correction is needed.

Ceded Loss Reconciliation

Gross Losses (required)

Total gross losses or incurred losses for the period.

Ceded Losses per Bordereaux (required)

Ceded loss amount reported on the bordereaux.

Ceded Losses per Ledger (required)

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 (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 (required)

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 (required)

Select the current reconciliation status.

Reviewer Comments

Optional review notes for the audit trail.

Attestation (required)

Required acknowledgment for submission.

Yes No N/A

Get your results

Enter your email — we'll send you a PDF of your filled-out template, plus the occasional MangoScoop newsletter (templates, workflow tips, product updates). Unsubscribe anytime — link is in every email.

Email (required)

Your name (optional)

Generated with MangoApps Templates — browse 250+ free