Solar Installer Chart of Accounts: Free CSV Template

Solar installer books fail because the customer is often not the one who pays you. A cash customer pays you directly. A loan-financed customer's lender pays you in milestones, minus a dealer fee. A lease or PPA customer never pays you at all: a third-party owner buys the system from you. The default small-business chart of accounts has one receivable and one revenue line. Feed all three kinds of sale through it and your P&L can't tell you which ones make money, and your balance sheet can't tell you who owes you what.

This is a working chart of accounts for a residential solar installer, account by account, with the reason each one exists.

Free download: Solar installer chart of accounts template (CSV), the structure in this guide as 68 numbered accounts with types, subtypes, and a one-line note on why each exists. Imports into QuickBooks Online, Xero, and most accounting software. No email required.

Why the default template fails solar installers

Five things are true of solar that are not true of a generic service business.

The cash comes from three places on three schedules. Cash customers, financing partners, and lease or PPA funds each pay on their own terms. A financing partner may pay one milestone at install and hold the last one until the utility grants permission to operate, which can take weeks.

The fee comes out before the money lands. A loan-financed sale arrives net of a dealer fee that can be a fifth or more of the contract price. If you book what landed as revenue, the fee never shows up anywhere.

The warehouse holds real money. Panels, inverters, and batteries sit on the shelf between purchase and install. Expense them when you buy them and every month's margin depends on your purchasing schedule.

Commissions have their own balance sheet. Reps are paid advances, earn commissions at install, and owe clawbacks when a deal cancels. All three are money moving between you and the rep, and none of them fits in a single commission expense line.

The warranty outlives the job. A workmanship warranty measured in decades is a cost of every system you sell today. If you book nothing until a claim arrives, the P&L of the year you sold the system looks better than it was.

The mix is also moving. The federal credit homeowners claimed on systems they bought ended for systems paid for after 2025, so more residential work is now sold as leases and PPAs. Splitting sales by who pays you is how you see that shift in your own numbers rather than guess at it.

Income accounts

The split by who pays you is the one that matters. The three channels carry different prices, different fees, and different collection timing, and the margin on each is the most useful number an installer can have when deciding which deals to chase. Removal and reinstall work is worth its own line too: roofers send it to you, it carries no equipment cost, and it is usually your best-margin work.

Cost of goods sold

Two of these decide whether your margins are real.

Dealer fees. Say you sell a $40,000 system on a loan with a 25% dealer fee. The lender funds $30,000. Book $40,000 of revenue and $10,000 of dealer fees, not $30,000 of revenue. The net version makes the fee disappear, understates your top line, and makes a financed job look identical to a cash job that sold for $30,000. The gross version shows you exactly what financing costs you per deal. The same mechanics apply to HVAC financing, covered in dealer financing and job margin.

Sales commissions. Many installers book commissions as a general selling expense. On a solar job they are often the largest cost after equipment and they exist because that specific deal exists, so they belong in COGS, tagged to the job. Put them below the line and every job's gross margin looks better than the business actually is.

Balance sheet accounts installers are missing

Recognize revenue at install, not at the last milestone. When the system is installed and the work is done, you have earned the sale. If the lender holds back a portion until permission to operate, that portion is earned but not yet collectible, so it moves to milestone holdback receivable. The balance in that account tells you how much cash is stuck waiting on utilities and inspectors. If it climbs month over month, you have a process problem, not a sales problem.

Commission advances are an asset until they are earned. If you pay a rep $2,000 in advances and the rep's deals earn $1,500 at install, $500 is still owed back to you. Booked straight to expense, that $500 disappears. Held in commission advances, it stays visible until it is earned or clawed back.

The warranty reserve is a percentage, set from your own history. Each month, book warranty expense as a percentage of system revenue and credit the reserve. When a warranty call comes in, charge its labor and parts against the reserve, not against this month's jobs. Once a year, compare what you actually spent with what you reserved and adjust the percentage. Your CPA will have views on the tax side; this is about books that tell you what the work cost.

Operating expenses

Standard, with three splits worth making. Keep lead purchases and canvassing apart from general marketing, so cost per signed deal is a number and not an estimate. Keep cancelled project costs on their own line: the survey, design, and permit costs on deals that cancel before install are the price of your cancellation rate, and most installers have never seen that number. And keep inventory shrink and damage apart from COGS, so a broken pallet of panels shows up as a warehouse problem rather than quietly lowering one job's margin.

Setting it up without breaking your history

1. Change at a period boundary, the start of a quarter or year.
2. Rename before you create. If "Sales" becomes "System sales, cash," renaming keeps the history. Creating a new account splits it.
3. Merge rather than delete. Deleting an account with transactions either fails or orphans data.
4. Map old to new in writing before you touch anything, so you can restate the prior year.
5. Count the warehouse on the cutover date. Opening inventory is the number everything after it depends on.

And if you use bank rules to keep the new accounts filled, write them narrowly and check quarterly what they actually caught. A rule that files every deposit from a lender to one revenue account will file the milestone holdback there too. What that costs is a post of its own.

What good looks like

Once the structure is right, your books answer these without a spreadsheet:

• What is gross margin on cash, financed, and lease or PPA sales, each on its own?
• How much did dealer fees cost us last quarter?
• How much is earned but still held back waiting on permission to operate?
• How much have we advanced to reps that they have not earned yet?
• What do cancelled deals cost us before they cancel?

If your books can't answer those, the chart of accounts is the problem, not the bookkeeper.

The solar installer chart of accounts template (CSV) has all 68 accounts numbered and ready to import. For related trades, see the electrical, roofing, and general contractor versions.

*Written by Austin Semple, a former controller: three years in audit, seven running the books for small businesses, and the founder of Poof. Poof holds deposits as a liability and releases them on completion, tracks profit per job from the bills and invoices tagged to it, and closes the books within five business days or the next month is free. Start a 30-day trial, no card required.*