Summary of Reddit Comments on "FP&A Tools"

Common Issues with FP&A Tools

• Spreadsheets: Massively flexible but not scalable, especially for distributed processes.
• BI/Data Analytics Tools: Great for consolidation/versioning but not designed for data entry/writeback.
• Conventional EPM Tools: Solve problems but require specialist IT support and are inflexible.
• Many tools try to adDRess these issues without complete success.
• The complexity of EPM tools can hinder self-service by finance teams.

FP&A Tool Options

• PivotXL, DR, Vena: Built on top of Excel, making them familiar for users.
• Planful: Attempts to move users away from Excel.
• Prophix, Datarails: Recommended for medium-sized companies.
• Anaplan, Adaptive Insights: Suggested for larger companies.
• Needs vary based on cloud vs. on-premise, Excel replacement vs. built on Excel.

Automation and Data Transformation

• Suggestions include using Power Query, VBA, SQL, and tools like Coefficient, Coupler, PowerQuery, or Alteryx for data automation.
• Prioritize tasks, automate where possible, utilize enterprise data warehouse and Business Intelligence Team.

EPM Tools Recommendations

• IBM Planning Analytics, Anaplan, Adaptive Insights, Planful, Prophix: Require building but offer flexibility.
• Modeloptic: More rigid, with potential customizations.
• Oracle Hyperion Planning: Recommended for Netsuite users.

General FP&A Tips

• The biggest pain point is often attributed to bad bosses.
• Excel remains valuable for ad hoc analysis but may not be ideal for routine processes like forecasting and budgeting in larger companies.

Not Relevant to "FP&A Tools" Query

Since the query was about "FP&A Tools," comments related to Canon's challenge to ASML in semiconductor technology and suggestions for angry breakup songs were not included in the summary as they did not pertain to FP&A tools.