---
title: "How to Download and Archive Carrier Commission Statements — Lapidar"
url: https://getlapidar.com/guides/how-to-download-and-archive-commission-statements/
description: "A monthly routine for collecting carrier commission statements: portal downloads vs emailed PDFs, a naming convention, CSV/XLSX vs PDF, and how long to keep them."
last_modified: "2026-10-12"
source: getlapidar.com (HTML converted to Markdown at the edge)
---

Guide · 6 min read

# How to download and archive carrier commission statements

**Short answer.** Collect every carrier statement once a month into one place, in the same folder structure, with the same file name pattern. Where a carrier portal offers a spreadsheet or CSV export, keep it next to the PDF: the PDF is the record of what the carrier said, the spreadsheet is what you can actually check. Don’t rely on the portal as your archive, because access and history can disappear. How long to keep statements depends on your tax situation, your state and your agreements; agree a period with your accountant.

[Open an account — founding pilot](https://app.getlapidar.com/signup) [See a sample report](https://getlapidar.com/sample-report/)

Most reconciliation problems start a step earlier: the statement nobody can find.

By Lapidar, the team building it · October 12, 2026

## TL;DR

- One collection day a month, one checklist of carriers and producer codes, one folder per month.
- Download from portals; save emailed PDFs out of the inbox. Both go into the same folder.
- Name files `YYYY-MM_carrier_code_type` so they sort and can be found without opening them.
- Keep the PDF _and_ any CSV or XLSX export. Don’t edit the originals.
- Retention: the IRS’s general guidance starts at three years from filing the return for federal tax records, with longer periods in some cases; state rules and your agreements may ask for more. Ask your accountant.

This guide is about the step before reconciliation: getting every carrier statement into one place, in a form you can find and check later. It covers property and casualty agencies with several carriers. It doesn’t describe any particular carrier’s portal, because those differ and change; adapt the routine to what each of yours offers. Lapidar is a tool that checks commission statements line by line; it is in its founding pilot. This is general information, not legal, tax or accounting advice.

## Why keep your own archive of commission statements?

Because the questions arrive late. A chargeback can refer to a policy written more than a year earlier, a premium audit settles after the term ends, and a discrepancy is only worth raising if you can show the line you were paid on. If the statement is still in someone’s inbox, or only on a portal, answering takes much longer. The case where this matters most is when an appointment ends: portal access can be switched off, which is why [commissions after a carrier appointment is terminated](https://getlapidar.com/guides/commissions-after-carrier-appointment-termination/) says to download statements before that happens.

## Where do statements come from: portals or email?

Usually a mix:

- **Carrier or agency portals.** You log in and download. Some offer only a PDF, some also a spreadsheet or CSV export, some a choice of date ranges. History may be limited, so download each month rather than relying on going back later.
- **Emailed PDFs.** Convenient, but they scatter across inboxes and leave with the person who received them. Save the attachment to the archive on the day it arrives, and set up a shared mailbox for statements if several people receive them.
- **Downloads into your agency management system.** Where a carrier sends statement data electronically into your AMS, you may not need to save a file by hand, but it is still worth knowing where the original lives. [What is an AL3 file?](https://getlapidar.com/guides/what-is-an-al3-file/) explains how those downloads work.

Whatever the route, the archive should look the same afterwards: one file per statement, in the month it covers.

## Should you keep the PDF or the CSV/XLSX?

Keep both when you can. They do different jobs:

**What each format is good for. Not every carrier offers both.**

| Format | Good for | Weak at |
| --- | --- | --- |
| PDF | Showing what the carrier issued, as issued; attaching to a dispute | Sorting, totalling, matching to your records |
| CSV or XLSX | Checking line by line, filtering by policy, totalling | Proving what was issued, since a spreadsheet is easy to change |

Two habits help. First, never edit the downloaded file; make a working copy if you need to annotate it. Second, check that the spreadsheet total matches the PDF total once when you save them, so you know the two describe the same statement.

## What naming convention works?

One that sorts by date and tells you what the file is without opening it. For example:

`2026-09_ExampleMutual_A1234_direct-bill.pdf` `2026-09_ExampleMutual_A1234_direct-bill.xlsx`

That is: statement period (year and month, so files sort), carrier, [agency or producer code](https://getlapidar.com/glossary/agency-code/), statement type, and the format as the extension. The carrier name and code in the example are invented. Add a suffix such as `_corrected` when a carrier reissues a statement, and keep the original. If a carrier sends more than one statement a month, add the statement date or number.

## How should the folders be organised?

A simple structure is one folder per year, one per month, files named as above inside. Per-carrier folders work too, but by month makes it easier to see whether everything for a month has arrived. Whatever you choose:

- keep it on shared, backed-up storage the agency controls, not on one person’s laptop;
- limit who can delete files; statements contain commission figures and policy details;
- keep a short list of carriers and codes you expect statements from, so a missing one is visible.

## How long should you keep commission statements?

It depends on your situation, and we won’t give a single number. For federal tax, the IRS’s general guidance is to keep records for three years from when you file the return they support, and longer in some cases, for example six years if you don’t report income you should have and it is more than 25% of the gross income shown on your return ([IRS](https://www.irs.gov/businesses/small-businesses-self-employed/how-long-should-i-keep-records)). That is a tax rule, not an insurance one. Your state insurance department may have its own record-keeping requirements for producers, and your carrier agreements may set their own. Ask your accountant to set one period that covers all of them.

## What does a monthly routine look like?

1. **Pick a collection day** after most of your carriers have issued, and put it in the calendar.
2. **Work through the list** of carriers and codes: log in, download PDF and spreadsheet, or save the emailed PDF.
3. **Name and file** each one in that month’s folder.
4. **Tick off the list.** For anything missing, note it and set a date to chase the carrier.
5. **Check totals** between PDF and spreadsheet where you have both.
6. **Then reconcile.** The [monthly commission reconciliation checklist](https://getlapidar.com/guides/commission-reconciliation-checklist/) and [how to reconcile carrier commission statements](https://getlapidar.com/guides/how-to-reconcile-carrier-commission-statements/) pick up from here.

## Where Lapidar fits

Lapidar is built to take the statements you have collected and check each line against your book, flagging missing, underpaid and paid-twice commissions. Collecting the statements, and deciding how long to keep them, stay with you. It is in its founding pilot, it has no customers yet, and we’ll say so until that changes.

## Frequently asked questions

### How long should an insurance agency keep commission statements?

There is no single answer. For federal tax records the IRS’s general guidance is three years from filing the return, with longer periods in some situations, and your state, your carrier agreements and your accountant may set longer ones. Agree a period with your accountant and apply it to every carrier.

### Should I keep the PDF or the spreadsheet version of a statement?

Both, where the carrier offers both. The PDF shows what the carrier issued; the CSV or XLSX is the version you can sort, total and match. Save them side by side with the same file name and leave the originals unedited.

### Is the carrier portal enough as an archive?

It’s safer not to rely on it. Portals may only show a limited history, and access can end when a login changes or an appointment is terminated. Download each statement when it is issued and keep your own copy.

## Sources

1. Internal Revenue Service, [How long should I keep records?](https://www.irs.gov/businesses/small-businesses-self-employed/how-long-should-i-keep-records), last updated June 30, 2026. Retrieved October 12, 2026.

Lapidar is [commission reconciliation software for independent insurance agencies](https://getlapidar.com/), in its founding pilot. Related: [monthly commission reconciliation checklist](https://getlapidar.com/guides/commission-reconciliation-checklist/) · [how to read a carrier commission statement](https://getlapidar.com/guides/how-to-read-a-carrier-commission-statement/).

In this guide

1. [Why archive at all](https://getlapidar.com/guides/how-to-download-and-archive-commission-statements/#why)
2. [Portals vs emailed PDFs](https://getlapidar.com/guides/how-to-download-and-archive-commission-statements/#sources-of-statements)
3. [PDF vs CSV or XLSX](https://getlapidar.com/guides/how-to-download-and-archive-commission-statements/#formats)
4. [A naming convention](https://getlapidar.com/guides/how-to-download-and-archive-commission-statements/#naming)
5. [Folders and access](https://getlapidar.com/guides/how-to-download-and-archive-commission-statements/#folders)
6. [How long to keep them](https://getlapidar.com/guides/how-to-download-and-archive-commission-statements/#retention)
7. [A monthly routine](https://getlapidar.com/guides/how-to-download-and-archive-commission-statements/#routine)
8. [Where Lapidar fits](https://getlapidar.com/guides/how-to-download-and-archive-commission-statements/#where-lapidar-fits)
9. [Frequently asked questions](https://getlapidar.com/guides/how-to-download-and-archive-commission-statements/#faq)
10. [Sources](https://getlapidar.com/guides/how-to-download-and-archive-commission-statements/#sources)

See what a statement looks like once it has been checked line by line.

[See a sample report](https://getlapidar.com/sample-report/)

## Checking statements takes hours every month.

Every carrier formats its statements differently, and the lines rarely match your records on the first pass. Lapidar checks each statement line by line against your book and flags missing, underpaid and paid-twice commissions. See what a statement looks like once it has been checked line by line. [See a sample report](https://getlapidar.com/sample-report/), or read [how the founding pilot works](https://getlapidar.com/pilot/).

[Open an account — founding pilot](https://app.getlapidar.com/signup)

[See a sample report](https://getlapidar.com/sample-report/)