Insurance is the expense that looks tidy until you try to report on it. The general liability premium arrived as an emailed PDF. The professional policy invoice is a paper page you photographed on the kitchen table. The auto policy leaves your account every month under a descriptor nobody would recognize. A cyber charge appears on the card statement and nowhere else.
A spreadsheet can hold all of that, if each payment becomes the same kind of row.
What is an insurance expense template?
An insurance expense template is a sheet with one row per premium, renewal, or refund, and the same columns every time. The column that does the real work is the coverage period, because it ties a payment to the stretch of time it covers.
Which columns does it need?
Seven are enough: date paid, carrier, policy type, coverage period, amount, source, category. Date paid is when the money moved. Coverage period is the start and end of the cover, which is often different. Source says where the proof is: email PDF, phone photo, autopay confirmation, or a card statement line.
The rule is plain: one payment is one row. A renewal, a monthly draft, and a refund each get their own line. Nothing is folded into a neighboring row to keep the sheet short.
What does a worked September look like?
Here is one invented month for a small studio with four policies:
| date paid | carrier | policy type | coverage period | amount | source | category |
|---|---|---|---|---|---|---|
| 2026-09-02 | Marlowe Mutual | General liability | 2026-09-01 to 2027-08-31 | $1,284.00 | email PDF | Insurance / liability |
| 2026-09-10 | Bellwether Indemnity | Professional liability | 2026-09-10 to 2027-09-09 | $640.00 | phone photo | Insurance / professional |
| 2026-09-15 | TERN CMRCL PMT 4471 | Commercial auto | 2026-09-01 to 2026-09-30 | $142.50 | autopay confirmation | Insurance / auto |
| 2026-09-18 | Marlowe Mutual | General liability (endorsement credit) | 2026-09-18 to 2027-08-31 | -$96.00 | email PDF | Insurance / liability |
| 2026-09-24 | Cedarline Cyber | Cyber | not shown | $58.00 | card statement line | Insurance / cyber |
| September | 5 lines | $2,028.50 |
Each row answers the same questions. The liability premium covers a full year, so its coverage period runs twelve months from the first of September. The commercial auto draft covers one month, and the descriptor TERN CMRCL PMT 4471 is what the bank showed, so the carrier cell keeps that string until you know better. The endorsement credit is negative, and it carries its own dates.
The month nets to $2,028.50: $2,124.50 in payments and -$96.00 in credits. Filter the category for Insurance / liability and the premium and the credit sit together, netting to $1,188.00. The cyber row says not shown for its coverage period, which is the honest entry until the carrier's invoice turns up.
How do annual and monthly premiums differ on the sheet?
An annual premium is a single row with a long coverage period. A monthly auto-pay is twelve rows, each with its own month. Same columns, same rule.
How an annual premium is treated in your books, in one period or spread across the months it covers, is your accountant's decision. Your job is to have the date paid and the coverage period on the row so they don't have to hunt for either.
What about policies that are partly personal?
Some coverage is mixed: a vehicle used for both work and errands, or a home office under a household policy. Split and allocation decisions belong to your accountant. Add a notes cell to the row saying so, and keep the full amount on the line, so whatever percentage they choose is applied to the real number. This page is a ledger, not tax advice.
Why isn't the bank line enough?
A bank or card line proves money left. It usually doesn't carry the policy type or the coverage dates, and the merchant name can be a string of codes. That's the gap a receipt row fills, and the reason the cyber line above has a gap in it. The longer argument is in a card statement is not a receipt.
This page is about premiums and renewals. If you're collecting receipts for an actual claim, that's a different job, and the claim receipt workflow covers it.
Slipsheet is the export path. Photograph the paper invoice, upload the PDF, or forward the confirmation to receipts@slipsheet.app. OCR reads the page; you review each row and set the carrier, coverage period, and category yourself. Then export a CSV or send the rows to Google Sheets. The file is yours.
A few straight answers
What should an insurance expense template include?
One row per payment, with the date paid, carrier, policy type, coverage period, amount, source, and category. Add a policy number or a note for mixed-use coverage if you need them. Start with the seven columns above and add more only when you find yourself looking something up.
How should I record an annual premium?
As one row on the date you paid, with the full coverage period in its own column. Whether the cost is treated as a single-period expense or spread across the months it covers is a question for your accountant. The row gives them both the date and the period to work from.
Do I need a receipt for an auto-pay insurance payment?
Yes, keep something. A bank line shows an amount and a cryptic name, but not the policy type or the coverage dates. A payment confirmation or the carrier's invoice carries them, and the source column records where it lives.
Where do refunds and endorsement credits go?
On their own row with a negative amount, dated when the credit was issued, and tied to the same carrier and policy type as the premium it adjusts. That keeps the total honest and the original premium row untouched.