Mathproven

Surplus lines tax on a policy list

Open the period's policy list (.csv or .xlsx) with the insured's home state and the premium on each row; a return is a negative premium. Each policy gets the surplus lines tax and any second charge from the state surplus lines tax rates table on this site, worked exactly as that page's calculator works one premium, and the policies are totaled by home state. A further fee the table does not carry, such as a stamping fee, can be typed as a percent for any state, and is labeled as typed everywhere it appears.

The file is read in your browser and stays on this device. Nothing is uploaded. The rates are the table's rows, read from the cited statutes and state agency pages on October 19 and 20, 2026; rules change, and the figures are arithmetic on those rows, not tax advice.

Surplus lines tax by home stateOregonTexasNew YorkMichiganReturnTaxReturn premiumState totals tie to the list
A period's policy list, its tax added up by home state.

The file is read in this browser and is not uploaded.

Each figure is premium × rate, rounded half up to the cent on the premium without its sign; a return premium gets the same figure with a minus sign. Rates only: the page shows the arithmetic on the rates table's rows and on any rate typed. It does not say what to charge, collect, or file. Mathproven is not affiliated with any state agency whose rules are cited in the table.

What gets checked

Your numbersThe mathThe checksVerifiedNot verified
A result that fails a check is marked not verified. It is never shown as correct.

How it works

  1. Open the policy list. Drop a spreadsheet (.csv or .xlsx) with one row per policy or endorsement for the period. It is read in the browser. A return premium is written as a negative amount or in brackets.
  2. Check the column mapping. The policy number, insured, home state, and premium columns are matched from the header words and can be changed. The home state can be a two-letter code or the state's name. For a list from one state with no state column, type the state once.
  3. Type what the table does not carry. Each home state on the list gets a row showing the table's tax rate and second charge. A further fee, such as a stamping fee, can be typed there as a percent of premium. A state the table has no row for needs its tax rate typed before the list is worked. Typed rates are marked as typed on screen, in the export, and in the certificate.
  4. Review and export. The page shows the totals by home state, the tax on each policy, and the certificate. Download Excel or CSV, or print.

Worked example

A made-up October list of six surplus lines policies for four home states, one of them a return premium of -$1,200.00 on a Texas policy. The list's own total row says $30,358.82. No fee is typed, so every rate comes from the table: Oregon 2% plus the 0.3% State Fire Marshal tax, Texas 4.85%, New York 3.6%, and Michigan 2% plus the 0.5% regulatory fee.

Home statePoliciesReturnsPremiumTax rateTaxSecond chargeTotal
Michigan (MI)10$3,333.332%$66.67$16.67$83.34
New York (NY)10$5,375.503.6%$193.52$0.00$193.52
Oregon (OR)20$10,449.992%$209.00$31.35$240.35
Texas (TX)21$11,200.004.85%$543.20$0.00$543.20
All states61$30,358.82$1,012.39$48.02$1,060.41

The Texas return of -$1,200.00 gives a tax of -$58.20 (4.85% of $1,200.00 with the minus sign), so Texas is $601.40 - $58.20 = $543.20. Oregon's two policies are $165.00 + $44.00 of tax and $24.75 + $6.60 of State Fire Marshal tax. Michigan's $3,333.33 gives 2% = $66.6666, rounded to $66.67, and 0.5% = $16.66665, rounded up to $16.67. In all, $1,012.39 of tax and $48.02 of second charges make $1,060.41 on $30,358.82 of premium, which equals the list's total row. The first policy, $8,250.00 in Oregon, gives the same $189.75 as the calculator on the rates page, and so does every other policy, so the certificate passes with no warnings.

The example uses made-up names and numbers.

Questions

Where do the rates come from?

From the surplus lines tax rates by state table on this site: each state's tax rate, and a second charge where the state's own source sets one as a percent of premium. The list tool reads the same rows the table shows and adds no rate of its own. Each state's row on the results names its source and the day it was read.

How are return premiums handled?

A negative premium, or one in brackets, is a return. Its tax is worked on the amount without the minus sign, rounded the same way, and then given the minus sign, so a $1,200.00 return in a 4.85% state takes $58.20 off that state's total. A policy and its full return always come to exactly zero.

How does the rounding work?

Each policy's figure is premium times rate, rounded half up to the cent on the premium without its sign, the same rule as the one-premium calculator on the rates page. A state's total is the sum of its policies' rounded figures, so it ties to the list line by line. That sum can differ by a few cents from the rate applied once to the state's total premium.

What about stamping fees and states the table does not have?

The table carries only charges a state's own statute or agency page sets as a percent of premium. Any other fee can be typed as a percent for a home state, and a state with no row in the table needs its tax rate typed. Typed rates are labeled as typed on the screen, in the export, and in the certificate, which also carries a warning. Where the site's surplus lines stamping fees table has a percent fee for a home state that is figured to the cent, it is offered beside the box for a policy effective date you pick, and is labeled as that table's with the date; a state takes one or the other, never both.

Does it say what to file or remit?

No. It works out the arithmetic on the table's rates and any rates typed. It makes no statement about what a state requires on a filing, what is taxable, or which home state applies to a policy.

This tool calculates and checks numbers. It is not legal, tax, or medical advice.

Template updates by email

At most four emails a year, when the free templates and rate tables for insurance agency commissions are updated for a new quarter. Each has a one-click unsubscribe link.

Only the address typed here is sent, never anything from a file opened on this page. Nothing is added until the link in the confirm email is opened. Mathproven is a product of OpenSlot LLC, PO Box 96, Paintsville, KY 41240, USA. Privacy.