Editorial responsibility: JusticeFinder. Source research checked September 30, 2026.
Open the tracker and make a private copy
An insurance claim tracker should help you answer four questions: Which claim is this? Who has the next action? What document is missing? When should you check again?
Keep original emails, letters, estimates, and receipts alongside your workbook. The Texas Office of Public Insurance Counsel recommends retaining claim records, including estimates, correspondence, receipts, and medical bills. OPIC first-party claims guidance
Never enter personal, medical, financial, or claim information into the public master spreadsheet or embedded preview. Other visitors may be able to view or change the master. Make your own copy and check its sharing settings before adding any private information.
Before you start:
- Use the copy link above or, in Google Sheets, choose File → Make a copy. Give your copy a neutral name, such as “Accident claim records.” Google's copying instructions
- Open Share in your copy. Check that General access is Restricted, then review the people and groups with access. Also check the destination folder's sharing. “Restricted” does not mean you are the only person with access. Google's file-sharing instructions and folder-sharing instructions
- Review and replace prefilled entries in your private copy. Do not adopt existing names, dates, amounts, or claim numbers as your own facts.
- Check calculations against your records. If you use an Excel download, inspect the downloaded file before relying on its formatting or formulas.
If copying or downloading is unavailable, do not use the master as a substitute. Start a private sheet using the fields below.
Separate the accident from the individual claims
One accident can generate several insurance files. A claim under your own policy and a claim involving another driver's liability insurer should be identifiable separately. Their coverage questions and handling requirements can differ. California's insurance glossary identifies the policyholder as the first party and distinguishes a third party who may seek compensation under the policy after a loss. California automobile insurance terms
Give the accident one internal label, such as “Incident A.” Under it, keep separate rows for each insurer and claim number. Within a claim, you may need separate rows for vehicle repairs, rental reimbursement, or injury-related requests.
For this guide, a subclaim means a separately tracked part of a claim. It is an organizational label, not a promise that the insurer uses that term or has assigned another claim number. Record the insurer's actual identifiers exactly as provided.
For example, use “Incident A / Insurer 1 / Claim 123 / Vehicle repairs” and “Incident A / Insurer 1 / Claim 123 / Rental.” A paid repair invoice should not hide an unresolved rental request. Leave coverage as “unconfirmed” until you have a reliable source for its status.
Build a claim overview that shows the next action
Start in Claim Overview. Adapt your private copy if a suggested field is missing. The useful minimum is:
“Pending” alone is rarely useful. “Awaiting revised estimate from repair shop; requested September 4; check September 8” tells you what to do.
Keep the overview brief. Use the timeline for history so that updating the current status does not erase the earlier sequence.
Turn every conversation into a usable record
After a call, add a dated entry to the Adjuster Contact Log or Claim Timeline. Include the time and time zone when relevant, who you spoke with, the correct claim number, what was requested, and what each person agreed to do next.
Separate these three kinds of information:
- Documented fact: “Portal receipt saved for upload on September 4.”
- Reported statement: “Adjuster said the estimate is awaiting review.”
- Your question: “Does review include the repair shop's supplement?”
Avoid changing “I think they approved it” into “approved.” Ask for clarification and retain the answer. When useful, send a short written recap: “Following our call, I understand the revised estimate is under review. Please confirm whether you need anything further from me.” Log that message and any response.
If a new adjuster takes over, retain the former contact and dates of involvement. Add the replacement instead of silently overwriting the history. For a conversation-heavy file, use the insurance adjuster communication log alongside this tracker.
Track requests separately from documents
A document can exist without having reached the right person. A request can remain open even after you send something.
In Document Tracker, give each item a short identifier. Record its description, who requested it, the request date, who will obtain it, where the original is stored, when it was sent, and any receipt confirmation. One row per item makes partial responses visible.
For example, a request for “repair estimate and photos” should not be marked complete merely because you uploaded the estimate. Either use two rows or explicitly list the missing photos.
Useful document statuses include:
- Needed
- Requested from source
- Received by you
- Sent to insurer
- Receipt confirmed
- Further information requested
Reserve “request resolved” for a documented resolution of that request. Receipt confirmation does not establish coverage, acceptance of the amount, or payment approval. Preserve upload receipts and the exact version sent, particularly when estimates are revised.
If medical records are the bottleneck, the medical records tracker can help organize outstanding provider records. Avoid duplicating sensitive clinical details across several spreadsheets.
Keep deadlines separate from follow-up reminders
Use distinct date types in the Deadline Tracker:
- Your follow-up reminder: A date you choose to ask for an update or confirm receipt.
- A stated commitment or requested date: For example, an adjuster's promised callback or a date in a document request. Record who supplied it and link the message.
- A potentially controlling deadline: A policy notice requirement, applicable claim-handling deadline, or deadline for legal action. Record the source, relevant jurisdiction, triggering event, and whether its application has been confirmed.
Do not let a spreadsheet calculate a legal date from the accident date without checking the actual rule. Even within one state, requirements may depend on whose insurer is handling the claim and what information has been received. Texas, for example, distinguishes its prompt-payment requirements for claims under your own policy from claims paid by another driver's insurer. Texas auto insurance guide
If a deadline is unclear, enter “needs confirmation” and seek qualified advice promptly. A blank date or an expired reminder should never silently become a conclusion that you have more time.
Keep legal-deadline review active during complaints. Arizona's regulator expressly warns that filing a consumer complaint does not extend time limits in policies, statutes, or regulations. Check the rules relevant to your situation rather than assuming a complaint protects a deadline. Arizona DIFI complaint guidance
Two examples of a tracker in everyday use
The following examples are illustrative workflows created for this guide. They do not describe or verify any prefilled records in the workbook.
A repair estimate is sent but the request stays open
On September 4, the adjuster asks for an estimate and photographs. You create request R-01 with two linked document entries. You upload the estimate that afternoon, save the confirmation, and mark only that item “Sent to insurer.” The photographs remain “Needed.”
On September 5, you send the photographs. On September 8, the adjuster confirms receipt of both items but asks for a clearer image of one damaged area. Keep the earlier submissions in the timeline. Add the new request and owner rather than deleting the original history.
Your overview now reads: “Awaiting clearer photo; owner: me; follow-up: September 9.” Those dates are organizational examples, not prescribed response periods.
The repair payment arrives while rental remains unresolved
You receive a payment identified as vehicle repairs. Record the amount, payee, date, and supporting payment notice against the repair row. The rental row still shows a question about the rental period and an outstanding invoice.
Do not mark the whole incident “Closed” just because one payment arrived. Record the repair payment status and rental status separately. If a letter says the insurer closed its file, preserve that statement while showing any issue you still dispute.
Before signing a release, understand its scope and get legal advice if needed. A release can affect further claims; Texas's insurance guide specifically warns about releases in injury settlements. Texas auto insurance guide
Keep offers and payments from inflating your totals
Use separate entries for an estimate, a submitted expense, an offer, and an actual payment. Otherwise, the same loss may be counted several times.
For every payment, record the payer, payee, amount, date, covered item, and supporting notice. If an amount went directly to a repair shop, label that clearly rather than treating it as money received by you. Keep disputed or unexplained differences visible.
An offer is not cash received, and a spreadsheet total is not a determination of what an insurer owes. For detailed loss documentation, use the expense and damages tracker. Keep this tracker focused on status and next actions.
Review the file before each follow-up
After important activity, and during a regular weekly review:
- Check open items with follow-up dates that have arrived
- Confirm each item has an action owner
- Look for documents marked sent without receipt confirmation
- Reconcile new letters, revised estimates, and payments
- Review unresolved coverage questions and deadline assumptions
- Add a dated summary of the current position
Prepare your next message around the outstanding item: “Were both attachments received?” or “Who is reviewing the revised estimate?” A specific question is easier to answer than a general request for progress.
Use the tracker to prepare an insurance complaint
If a handling problem remains unresolved, your records can support a complaint to the appropriate state insurance department. The NAIC recommends first trying to resolve the issue with the insurer, then assembling the relevant policy information, communication history, supporting records, and requested outcome. Its insurance department directory links to state resources. NAIC complaint guidance
Prepare a concise chronology from the tracker. Identify the company and claim, explain the specific problem, list the important dates, attach relevant supporting copies, and state what response or correction you are requesting. Follow the department's current submission instructions. Keep the complaint confirmation and reference number in your tracker.
A complaint does not guarantee payment or a particular settlement. Regulatory authority varies. For example, Texas says it cannot decide who caused an accident or determine damage amounts. Texas auto insurance guide
If there is a looming deadline, a release to evaluate, or a substantial dispute over your rights, seek qualified legal help rather than waiting for a routine tracker review.
Protect the file when someone else needs to help
Before sharing your private copy, decide what the recipient actually needs. An attorney may need a broader record than a repair shop asking about one estimate. Review every included tab, note, and linked file.
Keep passwords, Social Security numbers, payment-card details, and unnecessary medical detail out of the tracker. Use neutral document descriptions and store originals separately with appropriate access controls. Check access to linked folders as well as the spreadsheet itself.
Keep your complete record intact. If you prepare a limited extract for someone else, label its date and scope so it is not mistaken for the entire history. Ask your attorney how to handle sensitive or privileged material when you have counsel.