Businesses that use spreadsheets to collate and manage expense data can struggle with spend transparency and often risk non-compliance with company policies and tax legislation.
Spreadsheets are largely ineffective for managing processes like employee expenses. There are many steps in the end-to-end expense process.
When you rely on spreadsheets, data can become disjointed as it tends to sit on individual computers.
Real-time, cross-team collaboration is virtually impossible and it can be difficult to track the status of an expense claim if you rely on people to keep the process moving.
It is also challenging to ensure employee and ATO compliance because spreadsheets can be prone to errors.
I regularly see these four hidden costs in businesses using manual systems for employee expense management:
1. Employee frustration and wasted time
Staff can spend large portions of time gathering and submitting their expenses. Many dread the process of attaching paper receipts and filling in lengthy forms.
In addition, waiting for expenses to be reimbursed in the next pay cycle can force employees to stretch their budget prior to payday.
Many employees resort to completing admin-related tasks like expenses outside of working hours. They may even delay their expense claims until the end of the month, which then adds increased pressure for finance teams. This can also reduce the level of employee compliance with expense protocols.
2. Laborious administration for finance teams
Finance teams can waste massive amounts of time re-entering data into spreadsheets, chasing employees for further information, chasing managerial approval, and cross-checking each claim against ATO guidelines and company policies.
The lengthy process of manual expense management can often result in a bottleneck of claims waiting to be actioned. If there are too many claims, it is more likely that finance will rubber-stamp claims for approval without meticulously reviewing the content. This can mean companies spend more than necessary on travel and expenses.
By automating the expense administration process, the finance team’s time can also be better spent on value-added tasks like helping to budget and forecast, and claiming back the business’ taxes.
3. Lack of compliance and control
Despite most businesses’ best efforts, out-of-policy claims and expenses that breach ATO regulations can occur. It is a delicate balance of checking every single claim and receipt against current mandates, while keeping the finance process ticking over swiftly.
Many managers do not question employee claims, which means finance teams must be extra-vigilant.
Automating the expense management process can make the approval process almost immediate, and requires managers to be directly involved in claim approval. This reduces the demand on finance teams to closely review every application and chase claim approval.
4. Lack of spend transparency
Businesses that rely on a manual process involving spreadsheets cannot easily connect and track the data with other finance tools, like payroll and invoicing. Nor can they easily combine it with sales, marketing, HR, and other company data to deliver a truly holistic view of company spend.
This makes it difficult to budget, take corrective action, and ensure a steady cash flow.
Poor visibility into spending and compliance creates one of the greatest travel and expense (T&E) business pressures.
While spreadsheets will continue to have a place for certain calculations, automating T&E management can greatly help businesses with expense submission rates, deliver faster approval processes and provide transparency into the entire T&E process for compliance purposes.
Matt Goss is the Australian and New Zealand managing director for Concur, an international travel management business.