Story image

Expense management: Microsoft Excel isn't going to cut it

15 Nov 16

Growing businesses need to look further when it comes to how they track their expenses, according to Concur, who says spreadsheet software like Microsoft Excel isn’t going to cut it.

“Many businesses begin their expense tracking with spreadsheet software like Microsoft Excel. However, as an organisation grows or expands operations, the limitations of spreadsheets quickly become apparent,” the organisation says.

According to Matt Goss, Concur ANZ managing director, it has become essential to consider software that is purpose-built to manage business and staff expenses.   

There are a number of expense management pain points that businesses can overcome by moving to purpose-built expense software, he says.

“It’s common for businesses to be hesitant about changing their expense management process,” says Goss.

“They have invested considerable time in their spreadsheets and may lack the time, money or business case to move away from that model,” he explains. 

When it comes to tracking expenses over time, Goss says there’s a lot your spreadsheet can’t tell you that an automated solution can.

“This includes trends tracking, the organisation’s most profitable clients or products, or where the business’s money is being spent,” he says.

According to Goss, automated expense management software makes the expense process faster.

“Data can be entered automatically, letting finance teams export a variety of reports, and roll up data into a dashboard for easy visibility into daily operations,” he explains.

“The software can also be set up to notify the appropriate person within a business if someone violates the expense policy,” he adds.

Concur has developed eight areas that organisations should consider when justifying a move away from spreadsheets to an automated expense solution: 

1. Labour costs: How long does it take the finance team to consolidate information, correct expense data and tweak spreadsheet formulas every month? 

2. Data integrity: Can the organisation be sure that the data is accurate? Is there one true source of centralised data and can the data be viewed historically to highlight trends? Is the business basing important decisions on data that could be impacted by human error, like formulas? 

3. Reports: Does it take a considerable amount of time to develop reliable reports from existing spreadsheets or can they be developed at the push of a button? Is the right combination of data included in the report? 

4. Visibility: What is the organisation spending money on? How quickly can trends and problems be spotted and can they be viewed on a consolidated dashboard? 

5. Opportunity costs: If the finance point of contact was away from the office and a business opportunity arose that relied on the right data being served up quickly, would this be possible? 

6. Mobility: Can staff access data from their smartphones or capture receipts and record expense data away from the office? With a growing mobile workforce it’s key for businesses to embrace this. 

7. Policy violations: How does the organisation currently spot violations of expense policies? If the spreadsheet format cannot automatically alert the finance team about potential violations, an automated solution can alleviate this issue. 

8. Integration: Can the spreadsheet be integrated with other applications that are used within the organisation, i.e. travel management or time sheets? 

“Automated expense management software delivers greater flexibility, scalability, and data accuracy,” says Goss.

“As organisations collect and process more data in an effort to improve business efficiencies and daily operations, shifting from spreadsheets to an automated solution will eliminate the pain points associated with expense management,” he explains.

“This will free up staff in turn to focus on value-added tasks that drive business outcomes.” 

GirlBoss wins 2018 YES Emerging Alumni of the Year Award
The people have spoken – GirlBoss CEO and founder Alexia Hilbertidou has been crowned this year’s Young Enterprise Scheme (YES) Emerging Alumni of the Year.
SingleSource scores R&D grant to explore digital identity over blockchain
Callaghan Innovation has awarded a $318,000 R&D grant to Auckland-based firm SingleSource, a company that applies risk scoring to digital identity.
IDC: Standalone VR headset shipments grow 428.6% in 3Q18
The VR headset market returned to growth in 3Q18 after four consecutive quarters of decline and now makes up 97% of the combined market.
Spark Lab launches free cybersecurity tool for SMBs
Spark Lab has launched a new tool that it hopes will help New Zealand’s small businesses understand their cybersecurity risks.
Preparing for the future of work – growing big ideas from small spaces
We’ve all seen it: our offices are changing from the traditional four walls - to no walls. A need to reduce real estate costs is a key driver, as is enabling a more diverse and agile workforce.
Bluetooth-enabled traps could spell the end for NZ's pests
A Wellington conservation tech company has come up with a way of using Bluetooth to help capture pests like rats and stoats.
CERT NZ highlights rise of unauthorised access incidents
“In one case, the attacker gained access and tracked the business’s emails for at least six months. They gathered extensive knowledge of the business’s billing cycles."
Report finds GCSB in compliance with NZ rights
The Inspector-General has given the GCSB its compliance tick of approval for the fourth year in a row.