Electrician Business Spreadsheet

Every call priced from memory: your usual rate, materials marked up by feel, the big job quoted before anyone costed the hours. Then tax season asks what the business made, and the notebook cannot answer. This workbook runs the money side of an electrical business in one Google Sheets file, 7 tabs: a Dashboard showing a month's calls, revenue, costs, profit and what is still owed, a Service Calls log where hours, rate, materials and markup bill themselves, and a Job Costing tab that costs a big job against your real cost per labor hour.

Around them sit a Materials & Prices tab — van stock with cost, markup percent and sell price figured for you — a flat-rate Price Book so quotes stay consistent, and an Expenses tab for fuel, van, insurance, permits and tools. The fictional sample month: 20 service calls, $11,284.30 billed, $5,237.30 gross profit, net profit +$3,926.15, every figure recomputed against the workbook's own formulas.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

What you receive is the finished file, delivered instantly at checkout as a PDF containing your Google Sheets copy link. Open it, choose "Make a copy," and the file is yours. It runs in Google Sheets on a free Google account — nothing to install — and sample data is included so you can see the formulas work. If a file ever breaks, you receive a corrected copy of the file free. This is a digital product — no physical item will be shipped.