What people complain about in Excel
312 reported problems name Excel as what the person is currently using. Below is what they said was missing, and what they resorted to instead.
- Complaints
- 312
- Avg severity
- 3.2/5
- Would pay to fix
- 14
- Industries
- 5
What they wish it did
Capabilities people described needing that Excel does not give them, taken from the highest-scoring problems first. These are individual accounts written in each person’s own terms, so two entries may describe the same underlying gap in different words.
- 2 peopleAutomated WIP report generation integrated with QuickBooks Online
- Automated payables management with accrual accounting capability
- Integrated purchase order and inventory system that ties to job costing
- Automated receivables tracking from project management inputs
- Document management that automatically captures and categorizes emails and receipts
- Automated time tracking system that syncs with payroll and provides real-time compliance dashboards
- Automated commission calculation software that handles complex tiered and MRR-based plans with Salesforce integration and paid-account tracking
- Automated data aggregation from multiple source systems into a single WIP report
- Built-in percentage complete calculation engine that replaces manual formula maintenance
- Real-time WIP reporting that updates as new data enters connected systems
- Automated normalization of invoice numbers and vendor names to catch variant duplicates
- Automated detection of same-amount-different-reference invoices within a date window
- Automated matching of credit notes to paid invoices with alert for orphans
- Automated QuickBooks data ingestion and normalization tool
- Pre-built financial red-flag detection algorithms for acquisition screening
- Deal triage dashboard that replaces manual spreadsheet re-categorization
- Automated COI expiration tracking with reminders
- Bulk vendor import from existing spreadsheet
- Automated ASC 606 revenue recognition software that can handle usage components and scale with contract volume, replacing manual Excel workbooks and inadequate QBO capabilities.
- Automated intercompany consolidation tool replacing Excel workarounds
- Reliable bank feed integration with error auto-resolution
- Automated data extraction from accounting software
- Automated data cleaning and standardization
- Direct report generation into slide format
- Mobile customer history database accessible from phone
What they do instead
The manual processes people built around the gap. A long workaround list is the strongest evidence a problem is real: someone is already paying for it in time. Where several people described the same workaround, it is marked.
- 4 peoplejournal entries on papers
- 4 peoplesubledger accounts in literal books
- 2 peoplewrites bills on a notepad
- 2 peoplecreated excel sheet that mimics simple ERP system
- 2 peopleediting local copies of the same Excel file
- 2 peopleuses Excel to track leads
- 2 peoplemanually types every receipt from photos into Excel
- Manual Excel for payables and no accrual experience
- Manual Excel and release sheets for purchase orders and inventory
- Project manager does monthly receivables manually
- VA saves emails to pdf manually
- uses Excel to track employee time
- spends a full day per week reconciling time records
- manually corrects payroll with batches of up to 14 employees
- manual Excel calculations for commissions
- builds WIP schedules in Excel every month end
- pulling from multiple systems manually
- calculating percent complete by hand
- fixing formulas in Excel
- Uses Excel SUBSTITUTE to normalize invoice numbers before running COUNTIFS
Industries
The problems themselves
Highest opportunity score first.
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.
5CriticalConstructionAccounting & Financial ManagementBuildFin ProAt a 160-employee manufacturing company, using Excel for time tracking caused data inconsistencies, audit vulnerability, and a full day per week spent on reconciliation.
4HighManufacturingTime TrackingTimeForge ProManual 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.
4HighGeneral Business ServicesCompensation ManagementCommissionFlow ProAccountants 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.
4HighAccounting & BookkeepingReporting & AnalyticsWIP FlowAccounts 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.
4HighAccounting & BookkeepingAccounts Receivable / CollectionsDuplicateDetect AIScreening 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.
4HighFinancial ServicesDue Diligence & Risk AssessmentDealSifter TriageManaging vendor certificates of insurance manually in spreadsheets leads to lapses and risk exposure.
4HighGeneral Business ServicesCompliance ManagementCOITracker ProSaaS 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.
4HighSoftware and TechnologyAccounting & Financial ManagementRevRecFlow ProFinancial 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.
4HighAccounting & BookkeepingAccounting & Financial ManagementConsolidateFlowQuarterly financial reporting to board and investors is slow and manual, requiring pulling data from accounting software, cleaning in Excel, and reformatting into slides.
4HighGeneral Business ServicesFinancial ManagementBoardReport AIResidential plumber using paper loses track of customer history, bills, and receivables, losing money.
4HighField ServiceClient Management & BookingPipeFlow CRMStandard Excel reconciliation methods (VLOOKUP, MATCH-INDEX, pivot table 'Difference From') can falsely show MATCHED when duplicates offset missing entries, hiding critical accounting errors.
4HighAccounting & BookkeepingFinancial ManagementMatchZeroController needs a financial accounting system with project accounting capabilities for a joint venture, frustrated by QuickBooks' design changes, price hikes, and loss of value.
3MediumGeneral Business ServicesAccounting & Financial ManagementJV Ledger ProA 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.
4HighGeneral Business ServicesFinancial ManagementFinanceSync ProA small paving company's payroll manager manually re-enters payroll data into different GC-specific templates, tracks apprentice rate progressions, and ensures prevailing-wage compliance, consuming 5–6 hours weekly and risking costly errors.
4HighConstructionCompliance ManagementCertiPay Compliance BuilderIntercompany 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.
4HighAccounting & BookkeepingIntercompany Accounting & ReconciliationInterCo ReconcileUser experiences extremely long wait times (up to 4 hours) when running commands on large datasets in Excel due to slow computer performance.
4HighGeneral Business ServicesSoftware PerformanceCloudCrunch for Big DataA junior employee spends excessive time correcting basic calculation errors and manual journal entries made by a computer-averse financial manager who refuses to adopt even simple automated solutions.
4HighAccounting & BookkeepingAccounting & Financial ManagementLedgerLock ProBosses reject system-generated P&L format, forcing manual entry of 30 subsidiary P&Ls into Excel with hardcoded values and varying line descriptions, preventing automation.
4HighAccounting & BookkeepingFinancial ManagementFlexiP&L AutomatorFinance team spends excessive time manually copying and pasting data between systems, rebuilding variance reports from scratch in Excel each month.
4HighAccounting & BookkeepingFinancial ManagementReportSync Pro
Read this fairly
These are complaints, and only complaints — nobody posts to say their software worked. A high count mostly reflects how many people use Excel at all, so this page is not a quality judgement and should not be read as one. What it is good for is the shape of the gaps: the specific jobs people could not get done, which are the same whether the tool is popular or not.
Folded from: Excel, Excel sheet, Excel sheets, Excel spreadsheet, Excel spreadsheets, MS Excel, Microsoft Excel, excel, excel sheet, excel sheets, excel spreadsheet