All 24 canonical pain buckets, ordered by frequency, each with a short definition and up to three verbatim exemplars in the customer's own words.
-
Excel / spreadsheets can't scale
61 opps · 53% · Dominant (>25%)
Spreadsheet-based budgeting/forecasting is manual, fragile, error-prone, hits size limits, breaks formulas, and cannot support the org's complexity.
- "Current budgeting and forecasting are managed in Excel and Castaway, creating inefficiencies" — Soberlink, Healthcare, Lost
- "negative feedback from senior leadership regarding current Excel-based FP&A tool's usability" — Apprenti, Non-profit Organizations, Lost
- "Manual, spreadsheet-based budgeting is inefficient and time-consuming with 60 locations" — JC Licht, Retail & E-commerce, Lost
-
Data integration and uploads are manual
42 opps · 37% · Dominant (>25%)
Pulling data from ERP/HRIS/payroll/BI/warehouse is manual, brittle, requires IT, and lacks two-way sync or API access.
- "Need executive dashboards integrating financial data with operational metrics from Qualia" — Kriss Law Atlantic, Unknown, Lost
- "Struggle to tie operational metrics to financial outcomes and analyze variance drivers" — Clarion Home Services Group, Utilities, Won
- "Manual process, risk of errors, security concerns, and difficulty in creating different scenarios" — INSART, Technology & IT Services, Lost
-
Complex revenue and driver modeling
35 opps · 30% · Dominant (>25%)
Diverse or driver-based revenue (SKU, per-lease, project, grant, membership, rental, commission, PVM) is hard to model.
- "concern about forecasting, budgeting, pro forma financials with historical acquisition data" — HCR Group, Construction, Lost
- "complex expense allocations with varying percentage splits between commercial/residential" — Choice New York Companies, Business & Consumer Services, Open
- "Lumpy sales cycle, perpetual licensing, and manufacture own units adds COGS complexity" — ISS, IT Services and IT Consulting, Lost
-
Reporting lacks drill-down and granularity
34 opps · 30% · Dominant (>25%)
Cannot drill from summary to transactions, dimensions, sub-ledger, vendor, project, or component level — variance and root-cause analysis blocked.
- "most cumbersome aspect is spreadsheet systems for assessing profitability among groups" — French and Parrello Associates, Unknown, Lost
- "limited financial reporting for salary/benefits across grants/programs/departments" — Kohl's Children Museum, Nonprofit & Human Services, Open
- "Need to drill down from actuals to transaction-level detail and link to invoices" — California Primary Care Association, Unknown, Lost
-
Reporting is manual and inflexible
30 opps · 26% · Dominant (>25%)
Standard, ad-hoc, board, and management reporting is slow to produce, static, hard to slice, and lacks dashboarding or drill-down.
- "Need high-level summaries for executives and highly detailed reports for budget managers" — California Primary Care Association, Unknown, Lost
- "Desire for a stoplight report or dashboard view for the board — red, yellow, green indicators" — Life Unlimited, Nonprofit & Human Services, Lost
- "need ad-hoc reporting, diverse roll-ups, transactional drill-down for non-finance users" — Terribles, Unknown, Open
-
Current tool is slow, clunky, or unreliable
29 opps · 25% · Dominant (>25%)
The incumbent FP&A/BI/ERP tool has poor UX, latency, bugs, high maintenance burden, requires consultants, or is being sunset.
- "Current solution has similar security features but UI is not as clean or easy to navigate" — National WW2 Museum, Nonprofit & Human Services, Open
- "Current budgeting software, PowerPlan, is sunsetting, and we are seeking an alternative" — YMCA of the Roses, Nonprofit & Human Services, Lost
- "QuickBooks is a limited tool for data categorization — garbage in garbage out" — ELSA, E-Learning Providers, Lost
-
Consolidation is slow and manual
26 opps · 23% · Common (10-25%)
Rolling up P&Ls, closing books, and month-end reporting is time-consuming, macro-driven, and delays finance cycles.
- "uses Quavinci and Coefficient, finding it inefficient with limitations on consolidated P&L" — Roam, Real Estate, Lost
- "consolidation effort involving Excel sheets and information sharing across global locations" — Act Commodities, Unknown, Lost
- "Manual consolidation across Sage, Intacct, Service Titan, and Power BI with 415 branches" — Clarion Home Services Group, Utilities, Won
-
Implementation and buying friction
26 opps · 23% · Common (10-25%)
Vendor selection stress, prior failed implementations, IT/legal/security approvals, tight timelines, contract-expiring pressure, budget constraints on the deal.
- "concern about committing to paid POC without certainty product meets highly complex needs" — Valley Presbyterian Hospital, Healthcare, Lost
- "past experience with Anaplan and consultants, need clear implementation process" — Act Commodities, Unknown, Lost
- "Cube's pricing was high and integration with messy QuickBooks data challenging" — ISS, IT Services and IT Consulting, Lost
-
No single source of truth / data silos
23 opps · 20% · Common (10-25%)
Data lives in disconnected systems, spreadsheets, and ERPs with no central, trusted source for financial and operational data.
- "Data from NetSuite, Avid, and other sources — challenge of managing over 100 locations" — CRH Healthcare, Healthcare, Lost
- "No centralized system for consolidation or visibility, actuals, variance reports, P&L" — Bluebonnet Trails Community Services, Nonprofit & Human Services, Won
- "three separate PDI instances leading to inconsistent and manual financial reporting" — Terribles, Unknown, Open
-
No scenario planning / what-if
22 opps · 19% · Common (10-25%)
Cannot model scenarios, flex assumptions, run what-ifs, or do rolling forecasts and variance analysis in a repeatable way.
- "Want to marry versions — three months actuals with nine months of a different version" — Neocal, Unknown, Lost
- "Effort required to update drivers and assumptions on a monthly or quarterly basis is too cumbersome" — Raven Capital, Financial Services, Lost
- "Struggling with spreadsheet-based budgeting that becomes fragile with multiple scenarios and stakeholders" — Clarus Medical, Manufacturing, Lost
-
Small / lean team overwhelmed
22 opps · 19% · Common (10-25%)
Finance team is too small, stretched, doing manual work on nights/weekends, and cannot free capacity for strategic work.
- "heavily involved with Datarails due to staff turnover, limiting Sara's involvement" — Mary T Inc, Healthcare, Lost
- "small finance team: one for FP&A, two in accounting, external team, director" — Daiichi Sankyo Columbia, Manufacturing, Open
- "early-stage planning maturity, need simple ownership and controls in FP&A" — Merchants Bonding, Insurance, Lost
-
Multi-entity / intercompany is painful
19 opps · 17% · Common (10-25%)
Multi-entity structures, intercompany eliminations, and cross-entity rollups are difficult with current tooling.
- "Need consolidated balance sheet, cash flow, and P&L when data doesn't reside in QuickBooks" — ISS, IT Services and IT Consulting, Lost
- "need to view China entity P&L, balance sheet, cash flow independently as well as US entity" — Faradyne Motors, Manufacturing, Won
- "biggest pain point is month-end process for each entity separately, doing same tasks five times" — Wendover Art Group, Unknown, Lost
-
Team collaboration is broken
18 opps · 16% · Common (10-25%)
Budget owners, departments, and finance cannot collaborate effectively; hand-offs happen via email/spreadsheets and coordination breaks down.
- "Excel collaboration issues, broken formulas, version control problems, ghost formulas" — SubjectWell, Technology & IT Services, Lost
- "Need agile, scalable, secure, and collaborative tool for budgeting and forecasting" — Upside, Financial Services, Lost
- "Need clear communication mechanism for budget approvals/denials within the system" — California Primary Care Association, Unknown, Lost
-
Growth outpacing current process
18 opps · 16% · Common (10-25%)
Company growth, expansion, acquisitions, or new complexity is outrunning the current planning stack and process maturity.
- "Hyper-growth phase, growing from 25 to 90 employees, with target of $20 million in revenue" — LerroSarbey, Financial Services, Lost
- "Establishing a consistent FP&A process; fixing infrastructure; consolidating broken data" — Neocal, Unknown, Lost
- "Class structure becomes limiting as business grows, need to break payments down further" — Certify Health -, Technology & IT Services, Lost
-
GL / chart of accounts is non-standard
15 opps · 13% · Common (10-25%)
Chart of accounts, GL strings, project codes, and account structures are inconsistent, poorly configured, or block clean reporting.
- "multiple Acumatica tenants with six-segment subaccount structure varying across tenants" — Cesar Chavez Foundation, Nonprofit & Human Services, Won
- "Unique chart of accounts structure, with project IDs as the primary driver for departments and cost centers" — Nonprofit Finance Fund, Nonprofit & Human Services, Lost
- "need to report on endowment earnings, spend down, and capital planning" — Eagle Hill School, Primary and Secondary Education, Lost
-
Workforce / personnel planning is manual
15 opps · 13% · Common (10-25%)
Headcount, salary, fringe, benefits, overtime, and FTE planning are manual, crude, or lack granularity and HR integration.
- "intricate labor budgeting, calculating productive and non-productive hours for 100+ employees" — Valley Presbyterian Hospital, Healthcare, Lost
- "Complex workforce planning by home group, project, and funder with time allocations" — Point Blue Conservation Science, Nonprofit & Human Services, Won
- "Need to manage annual increases like COLA, merit, promotion in a single spreadsheet" — Point Blue Conservation Science, Nonprofit & Human Services, Won
-
Budget owners hard to coordinate
15 opps · 13% · Common (10-25%)
Distributing budget input to non-finance managers is hard: low adoption, inconsistent formats, no workflow, no accountability.
- "Need to involve 13-15 budget owners across the organization in budgeting and forecasting" — Nonprofit Finance Fund, Nonprofit & Human Services, Lost
- "budgetary requirements coming up next quarter, different department heads need to input information" — Phoenix Art Museum, Nonprofit & Human Services, Won
- "inconsistent process of receiving budget changes from managers in various formats (Word, Excel, email)" — Family Insurance Solutions, Unknown, Lost
-
No version control or audit trail
14 opps · 12% · Common (10-25%)
Cannot see who changed what, cannot compare versions, no history of edits, no formal audit trail on budgets/forecasts.
- "Version control issues, lack of integration, difficulty with variance analysis and forecasting" — Life Unlimited, Nonprofit & Human Services, Lost
- "customize input columns for adjustments (beginning budget, adjustment, final budget)" — UPMC Children's Hospital Foundation, Nonprofit & Human Services, Lost
- "disconnected spreadsheets, version control, limited visibility, manual processes" — Association of Legal Administrators, Nonprofit & Human Services, Lost
-
Enterprise FP&A tools too expensive or heavy
14 opps · 12% · Common (10-25%)
Competitor/enterprise tools (Anaplan, Adaptive, NSPB, etc.) are too complex, too costly, or require coding — mid-market can't justify them.
- "owner is not wholly convinced about paying for anything due to a tight market" — M9 Solutions, Consulting & Professional Services, Lost
- "Budget constraints — need nonprofit discount and flexible payment options" — Cesar Chavez Foundation, Nonprofit & Human Services, Lost
- "alternative is staying with Aleph or doing tasks manually to save money" — M9 Solutions, Consulting & Professional Services, Lost
-
Non-finance users can't use current tool
14 opps · 12% · Common (10-25%)
Department heads, operational users, and managers can't self-serve — UI is too technical, too dated, or requires finance to intervene.
- "wide range of user technical proficiency, some less familiar with computer systems" — Cesar Chavez Foundation, Nonprofit & Human Services, Won
- "Newly implemented budgeting tool (Budget) not usable, reverted to Excel" — Bluebonnet Trails Community Services, Nonprofit & Human Services, Won
- "Challenge of operational users modifying complex drivers by department" — DAP Health, Healthcare, Lost
-
No cash flow visibility
11 opps · 10% · Recurring (5-10%)
Cash flow forecasting, weekly cash view, direct-cash-method, and forward cash visibility are weak, manual, or inaccurate.
- "inaccurate cash-based forecasting due to high compliance requirements" — California Banker's Association, Financial Services, Open
- "Need detailed personnel planning and automated cash flow statements" — National WW2 Museum, Nonprofit & Human Services, Open
- "improve cashflow planning, forecast cash flow to inform decisions" — Superior Walls, Construction, Won
-
No role-based access or security
10 opps · 9% · Recurring (5-10%)
Cannot grant granular permissions, role-based access, data-security controls, or manage sensitive data (payroll, IP) safely.
- "wants supervisor-level access to flow directly from payroll system without manual maintenance" — YMCA LA, Nonprofit & Human Services, Lost
- "concerns about complexity of setting up and maintaining security protocols" — YMCA LA, Nonprofit & Human Services, Lost
- "granting department heads access to only their specific budgets" — WRM, Transportation & Logistics, Lost
-
Other
9 opps · 8% · Recurring (5-10%)
One-off pains that don't cluster into a canonical bucket (compliance, data sovereignty, key-person risk, etc.).
- "board wants zero-based budgeting; currently using blend of actuals and projections" — Eagle Hill School, Primary and Secondary Education, Lost
- "Disappointed Centage's AI is experimental vs competitors' more advanced AI" — ISS, IT Services and IT Consulting, Lost
- "Wants automated insights and narrative generation like Datarails" — LerroSarbey, Financial Services, Lost
-
Multi-currency / geo complexity
6 opps · 5% · Recurring (5-10%)
FX modeling, multi-currency consolidation, cross-country/geo rollups, and tax allocations across geographies are complex.
- "Multi-entity consolidation across 7 entities in 3 countries with different connection points" — Grupo Mayoreo, Unknown, Open
- "Multi-currency complexities with USD revenue and foreign currency expenses" — ISS, IT Services and IT Consulting, Lost
- "need multi-entity, multi-currency planning with intercompany eliminations" — Faradyne Motors, Manufacturing, Won