A residential solar job is sold in an evening and delivered over three months. The price is set per watt, the cost lands as equipment, crew days and a commission cheque, and everything in between is a queue at a city desk or a utility. The jobs that go wrong rarely go wrong on the roof. They go wrong in a discount the commission never came down to meet, or in a permission to operate nobody chased.

Priced per watt, recorded per watt

Each proposal carries system size and price per watt, and the system price derives from them, with adders kept separate.

A job takes its size, rate and contract price from the proposal that sold it, so the number the crew builds to is the number the closer sold.

Every milestone has a clock

Building permits, HOA reviews, interconnection applications and permission to operate each record when they were submitted and when they came back.

Anything unapproved reads Waiting with the days it has been sitting, which is the list worth reading on a Monday.

Cost that belongs to the job

Equipment lines cost themselves from the item's unit cost, and crew days cost themselves from that crew's day rate.

Permit fees land on the job too, so a jurisdiction that charges eight hundred dollars is visible rather than absorbed.

Commission against the price it was earned on

Every commission is tied to the contract it came from, so the rate is read against the price per watt that was actually signed.

A discounted job carrying a full rate is the most common way a solar company sells itself into a loss, and it only shows when both sit on the same row.

Review exceptions every week

Resolve duplicate IDs, missing links, overdue balances, negative amounts, and open operational items in CHECKS before using the dashboard for decisions.

SolarDesk US Google Sheets Edition is designed for use with a Google account and current desktop Google Sheets.

It does not calculate federal or state tax credits, file incentive or rebate paperwork, or design systems. No shading analysis, production modelling or layout drawing, no permit portal submission, no proposal PDF or e-signature, and no payroll or commission tax handling.