What people complain about in Excel

An Excel formula error in a gas company's budget tracking led to a $1.5 billion mistake due to incorrect formula application across natural gas figures.

A solo accountant in a rapidly growing construction company is overwhelmed by manual processes, uncooperative project managers, and lack of systems, while being blamed by the owner despite working 60-70 hours a week.

At a 160-employee manufacturing company, using Excel for time tracking caused data inconsistencies, audit vulnerability, and a full day per week spent on reconciliation.

Manual commission calculations in Excel are becoming unmanageable and the addition of paid-account tracking will require more time than available, risking the need for a dedicated commissions specialist.

Accountants spend up to 8 hours manually building Work in Progress (WIP) reports in Excel each month for construction clients, pulling from multiple systems and recalculating percentage complete by hand.

A controller at a mid-size distribution company struggles to manage 120 leases under ASC 842 in Excel, leading to quarterly scrambles during modifications and auditor concerns, and seeks dedicated lease accounting software.

Screening 5-10 messy proprietary small business acquisition deals per month using QuickBooks exports is too slow and costly when manual Excel re-bucketing is required just to disqualify a deal.

Accounts payable teams lose 0.1–0.5% of total spend to duplicate payments that evade standard system checks due to subtle variations in invoice numbers, supplier names, and other data quirks.

Managing vendor certificates of insurance manually in spreadsheets leads to lapses and risk exposure.

Financial advisory firm struggles with multi-entity consolidation, intercompany journaling, and unreliable bank feeds in QBO Advanced, and faces stalled onboarding for Intuit Enterprise Suite amid layoffs.

SaaS company's revenue recognition is not ASC 606 compliant due to incorrect straight-lining of contracts with usage components, and the current tools (QBO, Excel) cannot scale with future growth.

Quarterly financial reporting to board and investors is slow and manual, requiring pulling data from accounting software, cleaning in Excel, and reformatting into slides.

Standard Excel reconciliation methods (VLOOKUP, MATCH-INDEX, pivot table 'Difference From') can falsely show MATCHED when duplicates offset missing entries, hiding critical accounting errors.

Residential plumber using paper loses track of customer history, bills, and receivables, losing money.

Controller needs a financial accounting system with project accounting capabilities for a joint venture, frustrated by QuickBooks' design changes, price hikes, and loss of value.

Finance manager discovers the company is recognizing revenue at production completion instead of shipment, leading to material misstatements in financial reporting, but faces resistance when raising the issue.

Intercompany expense splitting between US parent and UK subsidiary requires two days of manual reconciliation each month, with expenses miscoded to wrong entity and currency, and there is no automated solution to prevent or resolve it.

A worker struggles to use a constantly changing, broken Excel file for financial reporting, unable to ask their VP for help due to fear of appearing incompetent.

User experiences extremely long wait times (up to 4 hours) when running commands on large datasets in Excel due to slow computer performance.

AIA billing for commercial HVAC jobs takes 2 hours per job in Excel and is prone to errors with change orders, wasting a full day every billing cycle.