From IT Dependence to Ad Hoc Reporting: Why and How
Summary
It’s an all-too-familiar scenario: You’re deep into the month-end closing process, and a recent change in the enterprise resource planning (ERP) system necessitates the modification of some of the key reports you rely on every month. Designing an ad hoc report often involves navigating arcane features and delving into the details of ERP database tables. The results of these limitations are usually fairly predictable: finance and accounting staff end up exporting data from their ERP system, importing it into a spreadsheet, and then doing their reporting and analysis from there. Tools that allow members of the finance team to directly connect to live ERP data through Excel make ad hoc analysis much simpler, faster, and more flexible. That allows finance and accounting (F&A) professionals to perform ad hoc analysis, inserting formulas and benefiting from familiar spreadsheet features and functionalities.