What people complain about in Excel
290 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
- 290
- Avg severity
- 3.2/5
- Would pay to fix
- 13
- 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 ASC 606 revenue recognition software that can handle usage components and scale with contract volume, replacing manual Excel workbooks and inadequate QBO capabilities.
- Automated COI expiration tracking with reminders
- Bulk vendor import from existing spreadsheet
- 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
- Automated reconciliation software that detects duplicate offsets and missing entries without manual review
- Purpose-built tool that converts comparison into summation to avoid false matches
- Excel add-in or standalone app that implements Vertical Netting framework natively
- 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 AISaaS 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 ProManaging vendor certificates of insurance manually in spreadsheets leads to lapses and risk exposure.
4HighGeneral Business ServicesCompliance ManagementCOITracker 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 AIStandard 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 ManagementMatchZeroResidential plumber using paper loses track of customer history, bills, and receivables, losing money.
4HighField ServiceClient Management & BookingPipeFlow CRMController 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 ProUnable to reconcile advance payments to purchase orders when clearing companies don't provide invoices and shipments cover multiple POs, leading to risk of duplicate payments and inaccurate cost allocation.
4HighGeneral Business ServicesAccounting & Financial ManagementAdvancePay MatcherBank reconciliation for a small church is extremely difficult and error-prone when using Excel, with multiple payment sources causing persistent discrepancies.
4HighGeneral Business ServicesAccounting & Financial ManagementChurchRecon ProA junior employee spends excessive time manually correcting basic calculation errors in paper-based accounting systems and faces blame for mistakes made by a computer-averse financial manager.
4HighAccounting & BookkeepingAccounting & Financial ManagementLedgerLock ProMonth-end financial close takes 8 days due to manual reporting in Excel, causing frustration and inefficiency.
4HighAccounting & BookkeepingReporting & AnalyticsCloseDash: Automated Month-End ReportingA small business owner cannot translate detailed market research and financial projections into actual sales and market share growth, feeling blocked from scaling beyond a small eBay operation despite thorough planning.
4HighGeneral Business ServicesBusiness DevelopmentMarketPulse PredictSmall accounting firm with 300+ clients manually entering bank statement data from PDFs into Excel, wasting significant time.
4HighAccounting & BookkeepingData ManagementStatementSnatchLaw firms and service businesses rely on complex, fragile Excel spreadsheets with VBA for attorney compensation calculations, which break when historical data changes.
4HighProfessional ServicesCompensation ManagementCompensateProProperty manager lacks a reliable system to track and verify contractor insurance certificates, risking uninsured vendors on site.
4HighProperty ManagementCompliance ManagementCoverCheck
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