Battery quotes sized from what the house really uses
Size the battery in your sheet from exports and evening use, offer the sizes as one choice, and let the total feed your payback estimate.
- 5/5 on G2
- 4.2 on Capterra
- Building QuoteCloud since 2013
With QuoteCloud a battery installer sizes the battery in a Spreadsheet block from the household's exports and evening use, connects the result to the battery line's description and unit price, offers sizes as a single choice the household makes, and brings the total back into the sheet for a payback estimate. They sign and pay a deposit.
Battery modules stacking on a garage wall under an existing 5 kW solar system, from a fictional business, Tallowwood Solar & Storage. In the installer's sheet, cell B4 holds the household's evening use and B6, =ROUNDUP(B4/(5*B5),0), works out the modules: 6.5 kWh a day gives 2 modules (10 kWh), Ruth Abernethy's 11.5 kWh gives 3 modules (15 kWh) and 16 kWh gives 4 (20 kWh). The battery line's description and unit price follow the sheet: for Ruth, Quolla battery, 3 × 5 kWh modules, $11,280, a total of $11,583.00 inc tax and an estimated payback of 9.7 years.
A battery for a system that's already on the roof
Ruth's 2016 system sends most of what it makes to the grid while she buys power back at night. Nate types last year's exports and her evening use into the Battery tab; ROUNDUP works out three modules, and the battery line's description and unit price come straight from the sheet.
The incentive she may be eligible for is a figure Nate types into its own cell, connected to its own line. Tick the pool pump circuit and watch the total land in Payback!B2.
- Battery!B11 → description, D11 → unit price
- Incentive: your figure, typed, if eligible
- Total → Payback!B2, payback estimate follows
Spreadsheet block and price tables: Essentials and up
How the sheet prices the linesYour sizing sheet
=ROUNDUP(B4/(5*B5),0)
Battery
| Row | A | B | C | D |
|---|---|---|---|---|
| 1 | What | Value | Unit | Basis |
| 2 | Existing system | 5.0 | kW | Installed 2016 |
| 3 | Exported last year | 4,120 | kWh | Typed from the bills |
| 4 | Evening & night use | 11.5 | kWh / day | Typed from the bills |
| 5 | Usable share per module | 90% | Installer's assumption | |
| 6 | Battery modules | 3 | × 5 kWh | Rounded up |
| 7 | Battery size | 15 | kWh | |
| 8 | Stored, used at night | 4,120 | kWh / yr | Estimate |
| 9 | Saving a year | $1,195 | a year | Estimate |
| 10 | Price line | Description → price line | Unit price → | |
| 11 | Battery | Quolla battery, 3 × 5 kWh modules (15 kWh) | $11,280 | |
| 12 | Incentive line | Installer's figure, typed if eligible | −$3,600 | |
Payback
| Row | A | B | C |
|---|---|---|---|
| 1 | What | Value | Basis |
| 2 | Price table total | Price table$11,583.00 | Inc tax · linked from the price table |
| 3 | Saving a year | $1,195 | Estimate |
| 4 | Simple payback | 9.7 years | Estimate |
- Typed in
- Installer's assumption
- Estimate
- Connected to the price table
Your battery, priced
Battery system
Options · tick to addTick to add
- Subtotal
- $10,530.00
- Tax (10%)
- $1,053.00
- Total
- $11,583.00
- Deposit on signing (15%)
- $1,737.45
Accept, sign and pay
Ruth Abernethy · Homeowner
Signed online · Thu 22 Oct 2026
Deposit on signing (15%)
$1,737.45
Paid via PayPalPay with card or PayPal
Certificate of authenticity and audit trail attached
Two, three or four modules, side by side
The same proposal at three sizes, every figure from the installer's Battery tab. Move the evening use and see which size the sheet picks, and what each one is estimated to save.
B6=ROUNDUP(B4/(5*B5),0)→ the sheet's size: 3 modules
-
10 kWh2 modules The sheet's size
Quolla battery, 2 × 5 kWh modules (10 kWh) Battery!B11 · Battery!D11 $8,130- Proposal total, inc tax
- $8,118.00
- Stored, used at night estimate
- 3,285 kWh a year
- Saving a year estimate
- $953
- Simple payback estimate
- 8.5 years
78% of evening use covered (estimate)
-
15 kWh3 modules The sheet's size
Quolla battery, 3 × 5 kWh modules (15 kWh) Battery!B11 · Battery!D11 $11,280- Proposal total, inc tax
- $11,583.00
- Stored, used at night estimate
- 4,120 kWh a year
- Saving a year estimate
- $1,195
- Simple payback estimate
- 9.7 years
98% of evening use covered (estimate)
-
20 kWh4 modules The sheet's size
Quolla battery, 4 × 5 kWh modules (20 kWh) Battery!B11 · Battery!D11 $14,430- Proposal total, inc tax
- $15,048.00
- Stored, used at night estimate
- 4,120 kWh a year
- Saving a year estimate
- $1,195
- Simple payback estimate
- 12.6 years
98% of evening use covered (estimate)
A worked example of the installer's own sheet with fictional figures: QuoteCloud runs the formulas you build and calculates nothing on its own. Stored energy, savings and payback are estimates from last year's exports, the evening use and the rates on the bill; they aren't guarantees. In the proposal you'd offer the sizes as one battery choice in the price table.
What goes in a battery system, line by line
Each part as a price line with a drawn product image and a note, so the household knows what they're paying for.
Battery modules
The size your sheet works out, as the line's description and unit price.
Battery inverter
AC-coupled beside an existing inverter, or a hybrid for a new system.
Backup gateway & circuits
Which circuits run in an outage, written in the note.
Monitoring
Battery level and use on their phone, as its own line.
Incentive, if eligible
A line you enter, tagged as your figure.
Options to tick
An extra backup circuit or a bigger battery, ticked by the household.
Datasheets & warranty
The module datasheet and your warranty as PDF blocks.
Deposit on signing
A percentage or fixed amount, paid through Stripe or PayPal.
Quote your next battery from two bills
Free for 14 days, no credit card required. Send us your battery sizing spreadsheet and we'll convert one template during the trial.
With a new system, the battery is one choice
For the Penhaligons the battery sits in the solar proposal as a single choice: no battery for now, the size the sheet works out, or one module more. Both sized lines read their description and unit price from the sheet.
What's in the battery system opens beneath the choice, and whichever they pick, the total comes back into the sheet for the payback estimate.
- None / sized / one more module
- Components open beneath the choice
- Inverter battery-ready if they wait
Your system, priced
Solar system
Battery · choose oneChoose one
What's in the battery system
- a×2Quolla QB-5 battery modules5 kWh each, stacked on the garage wall
- bQuolla backup gatewaySwitches your essential circuits to the battery in an outage
- cPellam PH-5 hybrid inverterAlready in your solar system: runs the panels and the battery
- dMonitoringBattery level and use, on your phone
EV charger · tick to addTick to add
- Subtotal
- $13,250.00
- Tax (10%)
- $1,325.00
- Total
- $14,575.00
- Deposit on signing (15%)
- $2,186.25
Quote a battery retrofit in five steps
From the household's bills to a signed battery proposal with the deposit paid.
Type in two figures
Last year's exports and the evening use, from the bills, into the Battery tab.
The sheet sizes it
ROUNDUP works out the modules; the battery line takes its description and price.
Add your incentive line
If they may be eligible, type your figure; it's connected to its own line.
They choose
Sizes and options in the price table; the payback estimate follows the total.
Sign and pay
They sign and pay the deposit through Stripe or PayPal.
Battery quote questions
How do I quote a battery for a household that already has solar?
Start from a battery template with a Spreadsheet block. Type last year's exports and the evening use from the bills; your formulas work out the modules, and that cell sets the battery line's description and unit price. Add the battery inverter, backup circuits and monitoring as lines, send, and they sign and pay a deposit.
Can the household compare battery sizes?
Yes. Offer the sizes as a single-choice group in the price table. Each sized line can take its description and unit price from your sheet, and the total comes back into the sheet so your payback estimate matches the size they choose.
How do I show a battery incentive?
As a line you enter, worded your way and tagged as your figure, for example 'Battery incentive discount, if eligible'. You can type the figure into a cell connected to the line's unit price. QuoteCloud doesn't calculate or claim incentives and doesn't check eligibility.
Does QuoteCloud promise how long the battery will last in an outage?
No. QuoteCloud sends your proposal; backup circuits, run times and savings are your own wording and estimates. Label anything you calculate in the sheet as an estimate, and describe the backup circuits in the line notes.
Can the household pay a deposit when they sign?
Yes, from the Essentials plan. Set a deposit as a percentage or a fixed amount, paid through Stripe or PayPal as they sign. The balance is your own invoice: QuoteCloud doesn't offer finance, instalments or payment reminders.
Everything a solar business sends
From the sizing sheet to the signed install, for every kind of solar job.
-
Sizing calculators that price the proposalYour sizing spreadsheet as a block in the proposal: cells set price lines' descriptions and unit prices, and the total comes back for payback.Explore
-
EV charger quotesA charger as an option in the solar proposal or its own quick quote, paid in full or with a deposit on signing.Explore
-
Solar, battery & EV packagesSolar only, solar + battery, or the lot: packages the homeowner chooses inside the proposal, with the price following.Explore
- Residential solar proposalsBills, sizing, roof photos, panels, inverter and datasheets in one proposal the household reads, signs and pays a deposit on.
- Site assessments & roof photosRoof, switchboard, meter and existing system captured in a Forms block, with marked-up photos, inside the proposal.
- Rebate & incentive linesAny rebate or incentive as a line you enter, worded your way and tagged as your figure: never calculated by QuoteCloud.
- Commercial solar proposalsLarger systems sized from interval data, approvals on big totals, two directors signing and an install programme.
- In-home sales & tablet signingSize it at the kitchen table, change the battery as you talk, and both homeowners sign on your tablet.
- Deposits & installation programmesA deposit on signing through Stripe or PayPal, and the steps to switch-on as a programme in the proposal.
- From website enquiry to proposalYour website calculator or enquiry form creates a proposal from your template through the API, Zapier or Make.
- CRM, accounting & job integrationsHubSpot, Pipedrive, Xero, QuickBooks, simPRO and ServiceM8, connected the way each one really connects.
- Solar templatesReal QuoteCloud solar proposal and quote templates, ready for your sizing sheet and price book.
- QuoteCloud implementation for solar retailersYour sizing spreadsheet rebuilt as a block, your price book loaded, payments connected and consultants trained.
- FAQAnswers to the questions solar retailers, battery installers and EV charger installers ask most.
Your next battery quote, sized by your sheet
Free for 14 days. No credit card required.