Spreadsheets are where most Australian companies start their carbon accounting. They are familiar, they sit on every finance team's desktop already, and for an initial estimate they do the job. As mandatory reporting under the Australian Sustainability Reporting Standards (ASRS) and AASB S2 rolls out across Group 1, 2 and 3 companies, that same spreadsheet gets asked to do a lot more than it was built for.
Here are the signs your business has outgrown spreadsheet carbon tracking, and what a mature process looks like instead.
Pulling the numbers together takes weeks
A small footprint fits in a single tab. A real footprint spans dozens of cost centres, hundreds of suppliers and several business units, each with data sitting in a different system. Once someone has to manually export, reformat and consolidate all of that before a single emissions figure appears, the process has outgrown the tool. The time cost compounds every reporting cycle, and it usually falls on one or two people who already have a full-time job outside carbon reporting.
Supplier data is chased by email
Scope 3 usually depends on data from suppliers, and in a spreadsheet-based process that means emails, follow-ups and manually entering whatever comes back. It is slow, it is inconsistent, and it puts the reporting timeline at the mercy of everyone else's inbox. A handful of non-responsive suppliers can hold up an entire disclosure, and there is rarely a fallback in place when that happens.
Nobody can explain how a number was produced
Ask where a specific emissions figure came from and the honest answer is often "a formula in that cell, built two years ago by someone who has since left." That is a governance risk, and it will not survive external assurance. Auditors expect a clear line from raw data to final figure, and a spreadsheet with no change history or documented methodology cannot show that line.
Errors surface after the numbers have already gone out
A broken formula, a misaligned row or a copy-paste mistake can sit undetected in a spreadsheet for months. In a disclosure document, that same error becomes a restatement, and a restatement invites scrutiny from auditors, investors and the board. The larger the dataset, the harder these errors are to catch through manual review alone.
Scope 3 is mostly assumptions
Spend-based estimates are a legitimate part of Scope 3 accounting, useful where activity data is not available. The issue is when spend-based estimates are the whole approach, applied because nobody has the time to source better data. That leaves the largest part of most companies' footprint resting on the least precise method available, which is a hard position to defend under scrutiny.
Every reporting cycle starts from a blank file
If last year's spreadsheet cannot simply be updated and instead gets rebuilt from scratch, the process is not repeatable. That means more hours each cycle, more room for inconsistency between years, and no reliable trend line for the board to review. A process that cannot be repeated reliably is also difficult to hand over to someone new.
One person owns the file, and there is no backup
A single spreadsheet, maintained by one person, with no audit trail and no access control, is a single point of failure. If that person is on leave during reporting season, or leaves the business altogether, the knowledge often leaves with them. There is no shared record of decisions made, assumptions used or changes applied along the way.
Leadership is asking where emissions are heading next
A spreadsheet is built to report the past. Boards and finance leaders increasingly want to know what next year looks like under different scenarios, and whether current targets are realistic. Modelling that in a spreadsheet is possible but slow and hard to trust, and it rarely gets updated often enough to stay useful for planning.
Making the shift
None of this means a spreadsheet was the wrong place to start. It means the requirements have moved past what a manual file can reliably support. Under ASRS, disclosures need to be accurate, auditable and consistent with financial reporting, and that is a higher bar than most spreadsheets were ever designed to clear. Closing that gap generally means automating data collection, applying a consistent methodology, and keeping a permanent record of every input and calculation.
Summary
- Pulling the numbers together takes weeks: manual consolidation across systems signals a footprint that has outgrown a spreadsheet. Avarni automates data import from 1,000+ business systems.
- Supplier data is chased by email: manual supplier follow-up slows Scope 3 reporting and depends on response times outside your control. Avarni's supplier engagement tools collect this data directly.
- Nobody can explain how a number was produced: untraceable formulas are a governance risk under external assurance. Avarni logs every calculation and change for full traceability.
- Errors surface after the numbers have already gone out: manual formulas invite mistakes that can lead to costly restatements. Avarni applies 65,000+ emission factors consistently across every source.
- Scope 3 is mostly assumptions: relying only on spend-based estimates leaves your largest emissions category the least precise. Avarni combines activity-based and spend-based data for better accuracy.
- Every reporting cycle starts from a blank file: rebuilding each year adds hours and breaks year-on-year comparability. Avarni's reporting is reusable and framework-aligned.
- One person owns the file, and there is no backup: a single owner with no access control is a single point of failure. Avarni is a shared platform with permanent audit records.
- Leadership is asking where emissions are heading next: boards want forecasts and scenario modelling alongside historical totals. Avarni's forecasting tools model targets and scenarios.
Ready to move off spreadsheets? Talk to a specialist about what a shift to dedicated carbon accounting software looks like for your business.
