Separate receipt from review
A file can arrive successfully and still be the wrong period, the wrong property, or too difficult to read. Define the status in terms of a completed action, not an optimistic assumption. Use the same words across the office so “received” never quietly means “ready to quote.”
| Status | What has happened | What remains |
|---|---|---|
| Requested | The specific request was sent | Homeowner or other authorized party responds |
| Received | The file arrived in the approved system | Assigned person reviews it |
| Needs correction | A reviewer identified a specific problem | Correction is requested and returned |
| Reviewed | Assigned review is complete for this task | Producer confirms any subsequent quoting step |
| No longer needed | Responsible person withdrew the request | Record why and stop reminders |
Scroll across to read every column.
“Reviewed” should not be a claim that coverage is approved or that the whole application is complete.
Give each item a small, useful record
Start with opportunity ID, requested item, purpose, request date, status, received date, reviewer, next action, next-action date, and approved file reference. Add a correction reason only when one is needed. The purpose column helps prevent repeated requests for documents that no longer serve the current quoting task.
Keep application details and sensitive document contents in their approved location. A status sheet can say “current policy document received; producer review due Tuesday” without reproducing policy numbers, account details, or the document itself. Access and retention should follow your agency’s existing process. The downloadable CSV is a starting structure, not a security system. Before using it, decide where it belongs, who can edit it, and who owns keeping it current.
Make the document request easy to act on
Ask for the specific item your team needs and identify the approved submission method. If the homeowner has already sent something similar, check that file before asking again. A repeated request should explain the missing piece, rather than making the person guess whether the first upload or email failed.
Illustrative request: “Thank you—we received the file you sent. The page showing the current policy period is not readable, so our producer cannot finish that part of the review. Please resubmit a clear copy through the same approved link. You do not need to resend the other items we have already confirmed.”
Replace “approved link” with your agency’s real method. Do not invent an upload portal or ask the homeowner to post sensitive documents into an open worksheet. Keep the request connected to the original conversation.
Do a receipt check before handing the file to a reviewer
The person logging receipt can check that the file opens, is attached to the correct opportunity, and appears to be the requested item. That is a handling check, not an interpretation of coverage. Have the appropriate producer or authorized reviewer address questions that require professional judgment.
- Record where the file was received and its approved reference.
- Confirm the relevant homeowner and property match the request.
- Flag visibly missing pages or unreadable content.
- Assign a reviewer and a next-action date.
- Tell the homeowner about a specific correction only after it is identified.
If the file belongs to another person or property, follow the agency’s handling procedure instead of forwarding it around to solve the mystery. Keep sensitive information out of casual internal notes.
Keep corrections attached to the original request
When a replacement arrives, keep the same item row and record a new file reference or revision according to the agency’s normal process. Preserve enough history to understand what was corrected. Do not count the second upload as a new lead or start a parallel document request that sends another reminder.
Illustrative sequence: Monday: requested current declarations document. Tuesday: received, assigned to Morgan. Wednesday: Morgan identified an unreadable page and requested a clearer copy. Thursday: replacement received; review pending. Friday: review complete; producer owns the next quoting step.
The dates demonstrate statuses, not a recommended turnaround. If another request depends on this review, say so in the next-action field. When the need disappears, mark the item accordingly and stop the relevant reminders instead of leaving it permanently overdue.
Review the queue by responsibility, not just age
Look separately at items waiting on the homeowner, files waiting on your team, and corrections waiting for a clear explanation. Otherwise, “waiting on documents” can conceal files that have been in the agency for days without a reviewer. Give each open item a named owner who can move it forward.
Before the next homeowner message, check the latest status and send one consolidated update if several items are outstanding. Avoid multiple teammates asking for the same file. When the quoting task ends, reconcile the worksheet with the approved opportunity and document records, following your agency’s retention process.
Homefield keeps the email conversation available to your team and copies the agent. Use that context alongside your agency’s document process. For the larger opportunity record, see how to track insurance leads; this worksheet is specifically for the items needed to move a quote forward.