Tool Gap Index

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

Problem types

The problems themselves

Highest opportunity score first.

Search the full corpus for Excel

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

Join the beta — full access for the first 1,000 builders

Join Beta