Spreadsheets vs Carbon Accounting Software: The Real Cost Breakdown
When your carbon spreadsheet stops being enough, costed in AUD. Around 300 hours a year of transcription at a loaded $110 to $120 an hour, extra assurance hours reconstructing the evidence chain, and an $18,000 rebuild when the builder leaves. Plus the cases where Excel is still fine.
Somewhere in Australia right now, a sustainability analyst is staring at a scanned electricity bill, trying to figure out whether the consumption figure is 14,230 kWh or 14,320 kWh. The font is small. The PDF is slightly crooked. She types one of them into row 247 of a spreadsheet that was built by someone who left the company eighteen months ago.
That spreadsheet is the entire emissions reporting system for a company with 35 sites and an NGER obligation.
This is common. And here's the thing - there was nothing wrong with starting in Excel. Every carbon accounting journey begins with a spreadsheet. Ours did. The problem isn't the spreadsheet. It's the moment when the spreadsheet should have been retired and wasn't.
So this isn't a "spreadsheets bad, software good" argument. It's a cost argument. And costs include things that don't show up in anyone's budget: the hours burned on data entry, the errors that compound silently, the audit remediation nobody planned for, and the morning your best analyst hands in their notice and takes the only working knowledge of your reporting system with them.
The hourly cost of copying numbers from PDFs
Advertised salaries for a sustainability analyst in Australia sit between $80,000 and $105,000 per year, depending on experience and city. Call it $90,000 base. Add super, leave, and overheads, and you're looking at a loaded cost of roughly $110 to $120 per hour.
Now think about what that person actually does during reporting season. A mid-market company with 25 to 40 sites generates around 150 to 250 utility documents per quarter - electricity bills, gas invoices, water statements, waste manifests. Each document needs to be opened, read, interpreted, and transcribed into a spreadsheet. The consumption figure. The billing period dates. The meter number. The unit of measurement. Repeat.
Run that at 600 to 1,000 documents a year and you are into the region of 300 hours annually on transcription alone. At a $110 to $120 loaded rate, that is $33,000 to $36,000 a year. These are illustrative figures built from the rates above, not a measured result. Not analysis. Not reduction strategy. Not stakeholder reporting. Typing numbers from PDFs into cells.
Compare that to what AI document processing does with the same stack. Carbonly's pipeline handles eight file formats - PDF, CSV, multi-sheet Excel workbooks, Word, PowerPoint, RTF, images (including photos of meter readings) and scanned documents - with five-tier material matching. Low-confidence results go to a reviewer, and when a reviewer corrects a match, the line text is saved as an alias for your organisation. The work shifts from manual transcription to review-and-confirm, because the documents have already been read and the figures pre-populated. How much time that actually saves depends on your document mix, which is why we would rather run your own bills through it than quote you a number.
And that's before the correction cycles. Because with manual entry, the numbers won't all be right.
1-4% doesn't sound bad. It is.
Manual transcription error rates sit between 1% and 4% under normal conditions, according to research published in the Journal of the American Medical Informatics Association. A study of 6,930 manual entries found 3.7% contained discrepancies from the interfaced (correct) values. That's in a clinical setting with trained staff entering relatively simple numerical values.
Carbon reporting isn't simpler. You're dealing with kWh versus MWh versus GJ. Estimated reads mixed with actuals. Billing periods that overlap quarters. Supply charges buried between consumption tables and demand charges. The real error rate in utility bill transcription is probably at the higher end of that range - and possibly beyond it.
For a company reporting 50,000 tonnes of CO2-e under NGER, a 2% error in the underlying consumption data could shift your reported emissions by 1,000 tonnes. That's not a rounding issue. Under the NGER Act, the Clean Energy Regulator can issue infringement notices for incorrect reports, and penalties are calculated per contravention in penalty units. The Commonwealth penalty unit is $364 for offences committed on or after 1 July 2026. In July 2025 the Regulator accepted an enforceable undertaking from Beach Energy after the company inadvertently misstated components of its NGER reports. The Regulator said the errors suggested potential weaknesses in the internal control systems supporting accurate NGER reporting, and the undertaking commits the company to external reasonable assurance audits of its NGER reports for the next three reporting periods.
And here's the part that should worry CFOs specifically: Scope 1 and Scope 2 emissions reported under ASRS carry full liability from day one. No modified liability protection. No safe harbour. If your numbers are wrong because someone misread a gas bill, that's your problem. In its performance audit of the scheme's administration, the ANAO found that 72% of 545 NGER reports contained errors, with 17% having significant errors. Those are reports filed by organisations with dedicated compliance teams.
A carbon accounting spreadsheet vs software debate isn't really about technology preference. It's about whether your error detection system is a human squinting at a screen, or an automated anomaly detection layer that flags outliers without anyone asking it to. At Carbonly, anomaly checks are deterministic rules rather than generative AI, and they run daily at 6am and after each document batch, so a data entry error or a genuinely unusual consumption spike can be flagged before it reaches a report. In a spreadsheet, anomaly detection is someone scrolling through rows and hoping something "looks wrong."
The audit trail problem assurance providers won't shut up about
Spreadsheets don't have audit trails. They have version histories - which is not the same thing.
When an assurance provider audits your emissions under ASRS, they need to trace every reported figure back through a chain: reported number, to calculation, to emission factor applied, to extracted consumption value, to original source document. They need to see who entered the data and when. They need to verify which edition of the NGA Factors was used. They need to confirm that NSW electricity used the NSW grid emission factor, not a national average.
In Excel, that chain exists in someone's head. Maybe it's documented in a methodology note saved on a SharePoint site that hasn't been updated since 2024. Maybe it's in a tab called "Notes" that references cell ranges that have since shifted because someone inserted a column.
Limited assurance, the minimum ASRS requires from year one, costs mid-market companies somewhere between $30,000 and $80,000 on indicative market pricing. But that price assumes the auditor receives clean, traceable data. When they can't trace a figure, they have to do the tracing themselves. At indicative assurance rates of $300 to $500 per hour, an auditor spending an extra 40 hours reconstructing your evidence chain adds $12,000 to $20,000 to your bill. Every year.
That is where assurance budgets get blown. Not on the audit itself, but on the auditor spending half the engagement asking "where did this number come from?" and nobody being able to answer quickly.
Software doesn't magically fix bad data. But it does create a click-through trail from reported figure to source document. Carbonly records typed audit events on ledger writes, and a restatement needs a recorded reason, so the evidence chain is assembled before the auditor asks for it. That's what audit-ready actually means - not "we have all the files," but "we can show you the link between any number and its origin in under a minute." In a spreadsheet, the audit trail is cell-level chaos: overwritten values, broken formulas, and a version history that tells you a cell changed but not why.
When spreadsheets are genuinely fine
We're not going to pretend every company needs software. That would be dishonest, and the ACCC has been active on environmental claims: in 2025 the Federal Court ordered Clorox Australia to pay $8.25 million in penalties over misleading "ocean plastic" representations on GLAD bags.
Spreadsheets work when:
- You have fewer than 10 sites generating utility bills
- You're doing voluntary reporting - a carbon footprint for your website, a response to a customer's supply chain survey, an internal baseline
- You're only tracking Scope 1 and Scope 2 with straightforward fuel and electricity inputs
- You have one or two people who own the process and aren't going anywhere
- Nobody is going to assure the numbers
Under those conditions, a well-built spreadsheet with the right NGA emission factors hardcoded is perfectly adequate. Honestly, spending $20,000 a year on software to track emissions from three offices and a warehouse would be overkill.
But those conditions describe fewer Australian companies every year. ASRS Group 2 reporting kicks in for financial years beginning 1 July 2026 - that's any company meeting two of three thresholds ($200M revenue, $500M gross assets, 250 employees). Group 3 follows from 1 July 2027, dropping to $50M revenue and 100 employees. And NGER reporters that lodge financial reports under Chapter 2M are pulled into Group 2 if they are not already in Group 1.
The pool of companies where spreadsheets are "fine" is shrinking fast.
When spreadsheets break
They break at a specific point, and it's usually a combination of three things happening at once: your site count crosses double digits, your reporting becomes mandatory, and someone external needs to trust the numbers.
At 15+ sites, a spreadsheet becomes a data management problem. You need consistent naming conventions. You need to handle sites that change energy retailers mid-year. You need to deal with the gas bill that arrives three months late and requires backfilling. You need to separate estimated from actual reads. Every one of these is solvable in Excel - we're not saying it isn't. But each solution adds complexity, and complexity in spreadsheets creates fragility. In Carbonly, each site or project gets its own document ingestion through a per-project email address and OneDrive or SharePoint sync, so documents flow in without someone manually downloading attachments and saving them to the right folder. In a spreadsheet, that's another tab, another naming convention, another thing that breaks when someone forgets a step.
At mandatory reporting, the cost of errors changes. A wrong number in a voluntary footprint is embarrassing. A wrong number in an NGER report is a compliance breach. A wrong number in an ASRS disclosure that faces assurance is a liability event. Civil penalties for false or misleading climate statements run up to $15 million or 10% of annual turnover for the entity, and directors carry personal exposure through their existing Corporations Act duties of care and diligence.
And at the point where assurance is required, your spreadsheet becomes the auditor's problem. They will charge you accordingly.
There's one more failure mode, and it's the one nobody budgets for.
The cost that isn't in anyone's risk register
Your emissions spreadsheet was probably built by one person. Maybe two. They chose the structure. They wrote the formulas. They know why column J uses a VLOOKUP that references a hidden tab called "EF_2024_backup." They know that rows 340 to 360 need to be excluded because those meters were decommissioned but the data hasn't been removed. They know that the Scope 1 gas calculation uses energy content factors from Table 2 of the NGA Factors workbook, not Table 1.
When that person leaves - and people do leave - you inherit a spreadsheet that functions like a black box. The formulas work until they don't, and when they don't, nobody knows why. It's a familiar pattern: bringing in an external consultant to reverse-engineer your own emissions spreadsheet after a staff departure. On indicative Australian consulting rates of $150 to $250 per hour, a three-week reconstruction engagement lands somewhere around $18,000. That is an illustrative range rather than a quote, and a good consultant earns it. The point is what you are paying for.
Roughly $18,000 to understand your own data. Not to improve it. Not to report it. Just to figure out what it's doing.
Key person risk is a known concept in finance. But in sustainability reporting, it's rarely on anyone's risk register because the spreadsheet "works." It works until the person who built it takes a job at a competitor, or goes on parental leave, or - let's be blunt - gets sick. Then it doesn't work and you're six weeks from your NGER deadline with a spreadsheet nobody can interpret.
Software doesn't eliminate key person risk entirely. You still need someone who understands carbon accounting. But the methodology is encoded in the platform, not in one person's head. The emission factors are documented. The calculation logic is visible. A new hire can see what's happening without needing a three-hour walkthrough from the person who set it up.
The three-year cost comparison
Here's where the numbers actually land. We're modelling a mid-market Australian company with 30 sites, mandatory NGER reporting, and ASRS Group 2 obligations starting FY2026-27. This isn't a real company and these are not measured results from a Carbonly deployment. It is an illustrative model built from the published market rates and document volumes described above.
| Cost component | Spreadsheet approach (3-year total) | Software approach (3-year total) |
|---|---|---|
| Sustainability analyst time on data entry (300 hrs/yr at $115/hr loaded) | $103,500 | $20,700 (80% reduction) |
| Error correction and rework (estimated 60 hrs/yr) | $20,700 | $6,900 |
| Audit preparation - manual evidence assembly (80 hrs/yr) | $27,600 | $6,900 |
| Assurance provider fees (inflated by poor traceability) | $195,000 ($65K/yr) | $135,000 ($45K/yr) |
| Software licensing | $0 | $90,000 ($30K/yr) |
| Onboarding and change management | $0 | $8,000 (year 1 only) |
| Consultant cost to rebuild after staff turnover (assume once in 3 years) | $18,000 | $0 |
| Total | $364,800 | $267,500 |
On this illustrative model, that is roughly $97,000 over three years, about $32,000 a year. It is a modelled figure, not an outcome any customer has reported.
Some caveats, because we're not going to pretend these numbers are precise. The assurance cost difference is our estimate - it depends entirely on your auditor and how clean your data is. The 80% reduction in data entry time is an assumption drawn from published benchmarks for AI document processing on standard utility bills, not a measured Carbonly result; your mileage will vary with non-standard documents. And the $30,000 per year software cost is mid-range for the Australian mid-market tier - you could pay more or less depending on the platform and your site count.
But the direction is clear even if you argue with individual line items. The spreadsheet approach has labour costs that compound every year. The software approach has licensing costs that stay relatively flat while labour costs drop. And the spreadsheet approach carries a tail risk - the audit remediation, the staff departure, the compliance breach - that doesn't show up until it does.
The migration nobody talks about
Here's our honest admission: switching from spreadsheets to software is not painless. Anyone who tells you it's a seamless transition is selling something.
You need to get historical data into the new system. That means either manual upload of past consumption figures (which, ironically, means someone has to check the spreadsheet numbers one more time) or accepting that your software-based record starts from a specific date and prior years remain in the old format.
You need to change people's habits. The sustainability analyst who's been doing this in Excel for three years has muscle memory. The new workflow will feel slower for the first month. Budget for that. Budget for grumbling.
And you need to pick the right moment. Don't switch tools two months before your NGER deadline. Start at the beginning of a reporting period so you have a clean dataset from day one.
We're still working out the best way to handle the historical data migration for companies with complex multi-year spreadsheet histories. It's a harder problem than it sounds, because every spreadsheet is structured differently. There's no "import from Excel" button that works universally - and anyone who claims there is hasn't seen enough spreadsheets.
What to do this week
If you're sitting on a carbon accounting spreadsheet right now, do one thing. Open it and ask: "If the person who built this left tomorrow, could someone else run the next reporting cycle without calling them?" If the answer is no - and it usually is - that's your signal. Not to buy software today, but to start costing the risk honestly.
And if you're already past 10 sites with a mandatory reporting obligation, you probably already know the spreadsheet isn't scaling. The question is whether you migrate before or after the auditor tells you to.
FAQ
Our sustainability team spends weeks keying supplier invoices into a spreadsheet, how do we stop? Move the reading to software and keep the team for review. Carbonly reads supplier invoices, dockets and utility bills in eight file formats and matches each line to an emission factor. Low-confidence results go to a reviewer. Run a handful of your own bills through any tool before you commit, because the time involved depends on your document mix.
When is a spreadsheet no longer enough for emissions reporting? Usually when three things happen together: the site count passes double digits, reporting becomes mandatory, and someone external must rely on the numbers. Past that point, late bills, retailer changes and estimated reads make the workbook fragile. A useful test is whether someone else could run the next reporting cycle if the person who built the spreadsheet left tomorrow.
What are the alternatives to spreadsheets for emissions reporting in Australia? The main alternatives are carbon accounting software, a consultant-run process, or a mix of the two. Software reads or imports the source data, applies Australian emission factors and keeps each figure linked to its document. A consultant can set up the method and review the numbers. The two fit together: the consultant provides judgement, and the software holds the data entry and record keeping.
Is a spreadsheet still fine for a small company's carbon footprint? Yes, in the right conditions. A well-built spreadsheet works when you have fewer than 10 sites, the reporting is voluntary and nobody will assure the numbers. It also helps if the inputs are simple fuel and electricity, and one or two people own the process. Keep the NGA factor edition noted in the workbook so the figures can be checked later.
What does it cost to keep emissions reporting in a spreadsheet? The main costs are staff time, rework and extra assurance effort, and none of them appears as a budget line. Staff time goes on copying figures from bills and correcting errors. An assurance provider who cannot trace a figure spends billable time tracing it. Rebuilding the workbook after its builder leaves is a further cost. This post works through an illustrative model in Australian dollars.
When is the right time to move from a spreadsheet to carbon accounting software? At the start of a reporting period, so the new record begins with a clean dataset. Avoid switching in the two months before an NGER deadline. Expect the new process to feel slower for the first month while habits change. Decide early whether past years are loaded into the software or stay in the old workbook, because every spreadsheet is structured differently.
Related reading:
- What a Carbon Accounting Consultant Costs vs Software
- Why Most Carbon Calculators Give You a False Sense of Accuracy
- How Carbonly Approaches Carbon Accounting in Australia
- How the Document AI Reads Fuel Dockets and Utility Bills
If you're evaluating whether to move beyond spreadsheets, the quickest test is your own bills. Email a handful to hello@carbonly.ai and we will run them through and show you the difference, no commitment required. Carbonly.ai is Australian carbon accounting software that reads supplier invoices, dockets and utility bills in eight file formats, matches them to Australian emission factors with five-tier material matching, runs deterministic anomaly checks, and keeps every figure traceable to its source document for NGER and ASRS reporting. Built in Australia, for Australian emission factors and regulatory requirements.