Electrical Cash Flow Template

Start with the Weekly Cash Flow sheet. Download the file and open it in Excel or Google Sheets — no macros or plugins required. Enter your current bank balance in the starting cash cell, then fill in expected inflows for the next 13 weeks: progress billing draws you expect to submit and collect, service call revenue based on your current call volume, panel upgrade and installation payments, and any new construction draw schedule receipts. Use your active job list and accounts receivable aging report as your source. Most electrical contractors can complete the initial setup in 20–30 minutes the first time through.

Set up the Job Cash Flow sheet for every active and booked commercial or project job. Enter the contract value, mobilization deposit received, total material cost estimate, your expected labor hours and cost, and the draw schedule milestones. For commercial work on AIA billing cycles, enter each draw request amount and the typical net days to payment from your GC — usually net 30, sometimes net 45–60 on larger projects. The sheet shows you, job by job, how much cash each project requires before the next draw arrives, and the aggregate view across all active jobs tells you the total cash requirement at any point in the schedule.

Update the Service Call Tracker weekly by logging each completed call with its invoice amount, labor hours, and material cost. Residential service work — troubleshooting calls, panel upgrades, EV charger installations, outlet and switch jobs — tends to pay quickly (same day to net 7) and provides the cash flow backbone that keeps the business solvent between commercial project draws. Tracking service calls separately from project work gives you a clearer picture of whether your residential volume is covering fixed costs, which matters most during slow commercial construction seasons.

Electrical contractors face a cash flow structure that can look profitable on paper while creating real short-term pressure in the bank account. Commercial and new construction work pays on billing cycles — AIA applications for payment submitted monthly, with GC payment typically arriving 30–45 days later — but wire, conduit, panels, and labor costs run continuously from the day work starts. A $200,000 commercial project requires $60,000–$90,000 in materials and labor before the first draw request is even submitted, and 60–90 days before those first draw funds actually arrive. For a contractor running three commercial jobs simultaneously, that's a $180,000–$270,000 cash commitment against payments that are still weeks away.

The specific cash flow metrics that matter for electrical contractors are driven by job type mix. Revenue per man-hour is the core efficiency metric — residential service calls typically run $150–$250 per man-hour billed, while commercial work runs $80–$140 depending on the prevailing wage requirements and scope. Material markup percentage matters because materials are a large share of electrical revenue (often 30–45% of contract value) and the spread between your material cost and your billing rate is a direct contributor to gross margin. And days outstanding on commercial AR — the gap between when you submit a draw request and when the check arrives — is the single number most likely to create a cash crunch if it drifts from net 30 to net 60.

The right way to use this template is as a weekly planning tool that feeds a monthly review. Every Monday, update the 13-week rolling view: roll it forward one week, enter service call payments received last week, log any progress billing draws collected from commercial jobs, and check whether any draw requests you submitted are approaching their expected payment date. Then look at the job cash flow sheet to see what material orders are coming up in the next two weeks and whether current cash balances cover them. Electrical contractors who run this weekly process consistently say it makes line of credit decisions straightforward — instead of drawing reactively when the account gets low, they can plan a draw two weeks in advance because the model shows exactly when the cash gap will occur.