Statement of Values Completeness Checker.

How to use the result.

Copy a working version of the schedule and keep the source file unchanged. Use one row per location reference in this checker. If the account has several buildings at one premises, choose distinct references for the rows and document how they roll up to the location. A repeated reference is a review prompt; it may be intentional, but should not be silently double-counted.

Use the columns location, address, building, contents and business_income. Values may be ordinary numbers or dollar amounts with commas. In CSV, put a value containing a comma inside double quotes. Enter zero explicitly when appropriate. A blank field is treated as missing rather than assumed to mean zero. Use a consistent currency throughout the schedule.

Compare the result with the original spreadsheet. The displayed total is only the sum of valid numeric cells in those three value columns. A missing or invalid amount makes the total incomplete. Resolve each flagged row, rerun the check and reconcile the completed total to the application and the intended coverage request.

A clean result answers only a limited completeness question. Next review how the values were established, the valuation date, whether acquisitions or renovations changed exposures, and whether the periods used for business income make sense for the account. Construction, occupancy, protection, exposure and catastrophe facts still need their own review.

A practical example.

A schedule lists a warehouse twice under location 2, leaves contents blank on one row and includes an unformatted note in the building value column. The checker flags the repeated reference and two numeric problems. It cannot tell whether the second row represents a separate building or a duplicate. Resolve the structure of the source schedule first, then reconcile values instead of deleting the second row simply to make the warning disappear.

Illustrative preparation example, not an account outcome.

What this check does not establish

This tool does not appraise property, verify replacement cost, calculate a coinsurance penalty, assess catastrophe exposure or determine policy adequacy. It does not geocode an address or confirm that a street address exists. Business income values may require a separate worksheet and professional judgment. A total here is not a quote, a coverage limit or evidence that a market will accept the schedule.

Keep the working file under your control.

The checker runs locally in the browser. It does not upload the schedule or send its values to Hedge. Closing or refreshing the page clears the unsaved inputs. Avoid pasting information unrelated to the check, and keep the original application and policy documents as the authoritative source.

Optional usage measurement records the tool action, not the rows, names, addresses, values or results. The check is a preparation aid. It does not create an account, release documents or notify an insurer. When you are ready for an account review, use Hedge’s existing submission process and provide the documents appropriate to that account.

Record your corrections in the source file so the improvement survives outside this page. If a warning cannot be resolved, explain it in the submission narrative. A transparent outstanding question is more useful than an apparently complete schedule based on assumptions. Keep the supporting evidence and the latest version together for subsequent renewals or endorsements.