Will the native pivot function change the way accountants use Excel?
NetSuite’s recent announcement of a native pivot function, allowing users to pivot data from within their software instead of exporting it to a spreadsheet, poses some interesting questions about how accountants will use Excel in the future.
Here on AccountingWEB we’ve read so many articles on the death of Excel we were thinking about setting up a spreadsheet for them.
While no one with any common sense is predicting yet that accountants will suddenly ditch Excel, the dawn of the native pivot function could mark a new relationship between accountants and Excel and a change in the way the humble spreadsheet is used by finance teams.
PivotTables are one of the most popular features in Excel – still the most-used accounting tool in the world. PivotTables have been on the scene since Excel 98, and compared to traditional formula-based tables they allow users to effortlessly manipulate large volumes of data into different views without slowing the spreadsheet down.
However, they do have their drawbacks. For each query you need to export the data from your accounting package and set up a bespoke table. And as accountant Nick Brown recently pointed out PivotTables do not automatically update themselves, so if you change anything within your source data, you need to refresh your table.
NetSuite co-founder Evan Goldberg told the Suite World audience in Las Vegas that the Suite Analytics tool would soon include queries, pivots and charts.
“Customers in beta with us have provided feedback over the last few months, and we got raving reviews so far,” said Goldberg.
In a demonstration during the same session, Joav Bally, NetSuite’s VP of product management and engineering, used dummy company figures to pivot sales data to show year-on-year sales per quarter, then drilled down into the data to look sales periods for a specific region (full video demo below).
Speaking to AccountingWEB after the event Bally confirmed NetSuite had built the tool from the ground up, and that the native pivot function will be made available to Suite Analytics users later this year.
Will this make accountants pivot from Excel?
Despite all the fireworks and razzmatazz in Las Vegas, the pivot function was the one thing accountants wanted to talk about on the show floor. So why all the fuss? After all, a lot of enterprise accounting systems already analyse data internally, and there is a semantic debate around where you draw the line between producing general analysis and replicating what a PivotTable does.
The main advantage of NetSuite’s native pivot function is that it addresses the set-up time and lack of live data within Excel PivotTables. Being able to manipulate real-time data with pivot-like tools is akin to using Excel’s secret weapon against it, and the ability to stay within the accounting system could save users hours of time.
Moving the point of intelligence
According to Hugh Johnson, an AccountingWEB contributor and vice president of financial data analysis platform Suntico, NetSuite aims to embed intelligence right down into the lower level transactional software makes a lot of sense.
Industry insightsView more
“If you move the point of intelligence as far back up the chain as you can and get it closer to the raw transactions, it could be a game-changer in terms of delivering better analysis from a company’s transactional data,” Johnson told AccountingWEB.
However, he continued, we are still a long way from the native pivot replacing Excel: “I don’t think it’ll cut Excel out of the loop. People love Excel, they’re familiar with it and you don’t need a NetSuite licence to consume an Excel report.
“So often with technology, a new tool comes out and everyone thinks ‘this is going replace Excel’, and actually what usually happens is you end up with an ‘and’ situation. What I suspect will happen is that you’ve got people who are so used to using Excel that they’ll always fall back onto the familiar – so 10 minutes before a board meeting a finance director will still use a pivot table in Excel to pull together a last-minute report and email it round. This is obviously fraught with danger, but it’s just so easy.
“Where I think it could be a nice facility is that it will make it easier to pull the data into Excel in the form that you want it in the first place. In that way it might encourage greater use of Excel!”
Taking the friction out
AccountsIQ CEO Darren Cran is well-qualified to discuss this topic, as his firm has recently released a pivot dashboard that allows users to select the dimensions they wish to report on - for example to see data by country or region - and take away the bits that are not relevant at point in time.
For Cran, these functions save finance team time. “Rather than have to run a report or get one built for you, this allows you to drill down into what you’re looking for immediately,” Cran told AccountingWEB. “We see it as taking the friction out.”
While he agreed with Hugh Johnson’s verdict that the native pivot was unlikely to kill off Excel any time soon, Cran said increasing use of such tools may signal a shift in the way it is used over time.
“I can’t see Excel dying,” said Cran. “It gives you freedom and flexibility. Excel allows for a lot of ad hoc data analysis. It allows you to maintain curiosity around data – if you just stick to the software you miss the freedom to be curious with data. That will never go away.
“However,” he continued, “it will morph over time. Pivot functionality allows you to strip out a lot of repetition.
Cran is also hopeful that Excel will become a lot less relevant to financial reporting.
“Business will really see the benefits of not relying on Excel for reporting – it takes the time and error out. When reporting relies on Excel it fails over time.
“Excel is brilliant for ad hoc data analysis – this is where its long-term future lies, as a freestyle data analysis tool.”
How worried is Microsoft?
Specialist financial analytics developers have a habit of overlooking one of the key players in the market – Microsoft. Although the Windows and Office giant has a patchy track-record when it comes to catering for finance professionals, it has already anticipated the native analysis challenge with its own PivotTable extension: Power BI.
Initially released alongside Excel 2010 and refined into a powerful data extraction and analysis suite, Power BI connects all kinds of live data into a spreadsheet-based reporting environment. Once the system has been plugged into your source data, it too can generate dynamic analyses.
Configuring Power BI is a challenge and the specialist skills needed to make effective use of the system are still in short supply, which opens the door to native analysis tool, or hybrids like Hugh Johnson’s Suntico that sit on top of Microsoft’s analytical engine.
AccountingWEB’s software surveys show users prefer to use tools they don’t have to tinker with or pay extra for to get the results they want, which should work in favour of NetSuite and AccountsIQ.
The suspicion remains that native pivot tools won’t lure away “power users” like the 11th hour pivot FD earlier – these Excel addicts are likely sustain Excel use within accountancy for many years to come.
Do you see your analysis techniques changing in the near future? Are you tempted by native analysis tools that let you interrogate transactional data within the accounts system, or are you an Excel diehard who has no truck with these lazy fripperies?
Tom is editor at AccountingWEB, responsible for all editorial content on the site. If you have a story that might interest us or wish to comment on the site's coverage get in touch via the site's private message function or Twitter DM (@AWebTom)