You turn to Accordion.
We partner with your accounting, finance and IT teams to:
- Create a data cube for historical pro forma financial P&Ls, inclusive of adjustments (QoE, run-rate, and pro forma) with separate data dimensions for all acquired entities—leveraging Power Query and Power Pivot.
- Enhance hospital-level profitability by leveraging Power Pivot to optimize pricing and cost across all hospitals.
- Build interim reporting tools in Excel and Power BI giving management previously unavailable visibility into one of their largest expense categories: payroll costs.
- Shift from manual to automated process for payroll reporting including automating payroll data feed into Snowflake data warehouse for business reporting purposes and creating completed-payroll-related journal entry templates ready for upload into Sage Intacct.
Your value is enhanced.
You now have a consolidated data set of accrual basis financials for performance tracking across different periods. On top of that:
- The pricing optimization increases your profitability by bringing prices at hospitals up to the level consistent with the wider group.
- The cost optimization analysis allows you to negotiate better terms for cost of goods (your largest expense category) with two main vendors.
- The interim reporting and automation tools for payroll create visibility into payroll costs for the first time, helping you manage and forecast expenses better on a weekly basis.
- The automation tool also drastically reduces the burden on the accounting team for payroll related entries.