Surety monthly report worksheet.

Surety reports require pulling data from multiple sources — bond registers, payment records, forfeiture logs. This worksheet provides a single staging area to compile the numbers before submission.

Who this is for

Agency owners and bookkeepers who prepare monthly production and liability reports for their surety companies.

Template preview

Report month	Surety	Bonds written	Total face value	Premiums collected	Premiums outstanding	Active bonds	Open liability	Forfeitures this month	Forfeiture exposure	Bonds discharged	Notes
2026-09	Pacific Surety	4	120000	12000	8500	22	580000	0	0	2	—
2026-09	Western Bail	2	75000	7500	5000	11	340000	1	50000	0	Torres forfeiture pending
2026-08	Pacific Surety	3	85000	8500	6000	20	495000	0	0	1	—

All names, case numbers, and amounts are fictional.

Column reference

Report month: Month and year this report covers.
Surety: Surety company this report is for.
Bonds written: Number of new bonds written this month for this surety.
Total face value: Sum of face amounts for bonds written this month.
Premiums collected: Total premiums received this month.
Premiums outstanding: Total premiums still owed across all active bonds.
Active bonds: Total bonds currently active with this surety.
Open liability: Sum of face amounts on all active bonds.
Forfeitures this month: Number of bonds forfeited this month.
Forfeiture exposure: Sum of face amounts on unresolved forfeited bonds.
Bonds discharged: Number of bonds discharged or exonerated this month.
Notes: Adjustments, discrepancies, or items needing surety clarification.

How to use this template

Complete one row per surety per month. Pull bond counts from your register, payments from your payment tracker, and forfeitures from your forfeiture log.
Reconcile Active bonds and Open liability against your bond register before submitting.
Compare Premiums collected against your payment records to catch discrepancies.
Check Forfeiture exposure against your forfeiture log to make sure nothing was missed.
Save each month’s completed worksheet so you can trend production and liability over time.
Submit to each surety in their required format — this worksheet is your staging area, not the final submission.

Limitations

A CSV does not compute totals, averages, or month-over-month changes automatically.
This worksheet does not match any specific surety’s reporting format. You will need to map columns to their template.
Numbers here are agency-side figures. The surety’s records may differ — reconcile before assuming agreement.
This is a preparation tool. It does not replace your surety’s official reporting requirements.

Frequently asked questions

When should I prepare the monthly report?

Most sureties expect reports by the 10th to 15th of the following month. Build the worksheet as you go and finalize at month-end.

What if my numbers do not match the surety’s?

Note the discrepancy, investigate the source (timing differences, pending payments, unreported discharges), and resolve it with the surety before the next report.

Should I keep historical worksheets?

Absolutely. Historical reports help you spot trends, prepare for audits, and resolve disputes about past periods.

Replace the spreadsheet.

See how ClickBail handles this workflow automatically.

See surety reports in the Agency OS demo