Navigating workforce data challenges with the smart application of smart technology

Key highlights

  • In the fifth article of our Connected Tax Compliance thought leadership series, we take a deep-dive into the technology use case for managing increasingly complex and voluminous workforce tax data, particularly in relation to Fringe Benefits Tax (FBT). 
  • Workforce tax data typically resides across multiple systems, with several data parameters and organisational touchpoints, making it difficult to process and manage.
  • However, the intersection of (often) subjective, technical ‘rules’, and the associated information breadth across multiple data sources and business processes, adds an additional layer of complexity to managing FBT data.  
  • Read on to find out how technology - including data analytics software, purpose-built data flows and tailored visualisation tools - can help you mitigate risks and increase efficiency.

Across all industries and sectors, technology is undeniably shaping the way we work. As seen most recently with the advent of readily available OpenAI software, the ever-increasing pace and intelligence of new technologies mean organisations need to remain agile and regularly transform to ensure long-term sustainability.

With respect to technology governance, Excel has historically formed the analytical bedrock of most tax functions, but the pace of advancement signals that this software will soon become a relic, including the reliance on V-Lookups, Index Matches and convoluted Pivot Tables. Emerging data analytics software, purpose-built data flows and tailored visualisation tools now allow complex data analysis to be performed for a fraction of the effort required to use and maintain Excel spreadsheets. 

Regulators are also progressively expecting organisations to embed technology within their broader governance processes. For example, the Australian Taxation Office (ATO)’s Tax Risk Management and Governance Review Guide lists expected technology controls across numerous risks, including intra and inter system data flows (managerial control 6), and complete and accurate tax disclosures (managerial control 8). Relevantly, the regulators are also embedding new technology for their own analytical purposes, primarily to monitor compliance and shape investigative activities.

Making sense of complex, voluminous data is a key function of any organisation’s tax team; this challenge is undoubtedly exacerbated for workforce tax data, which typically resides across multiple systems, with several data parameters and organisational touchpoints. For example, superannuation compliance will be dependent on systems like time & attendance, payroll and finance; flow across numerous reporting regimes, such as payslips, Single Touch Payroll, SuperStream; and cross-over business processes from HR to payroll to tax to finance. 

So, how does workforce tax data fit in the technology evolution, and how can organisations utilise technology effectively and implement the necessary controls to ensure risk mitigation?

The challenge of FBT – An illustrative workforce example

Coming towards the close of the 2024 FBT year, many of you will have that familiar sense of impending dread. Whilst data challenges exist across all tax compliance obligations, FBT unequivocally takes it up several notches. Well-resourced tax functions will often consign themselves to losing two to three personnel for a couple of months, with their focus on working through the data maelstrom.

The latest taxation statistics reveal that the time required to complete FBT returns is more than double that of corporate income tax returns. However, despite this time-spend discrepancy, FBT represents just 0.7% of the total tax liabilities collected, compared to the company income tax portion of 22.6%.

Almost every organisation’s tax function will immediately resonate with the observation that managing FBT is resource-heavy, time-consuming and revenue-disproportionate.

But what makes FBT so challenging? The answer lies in the intersection of (often) subjective, technical ‘rules’ and the associated information breadth across multiple data sources and business processes. With this challenge in mind, this article workshops the technology use case for FBT data, particularly for those notoriously complex food and drink transactions.

‘Entertainment’ deep dive

Assessing whether food or drink transactions constitute ‘entertainment’ is a key FBT challenge, determined by why, what (type of), when, and where the food or drink is being provided. To answer these questions, several data sources are required to create a complete dataset for accurate analysis. This presents two key challenges:

  • Firstly, collating data - the information relevant to these transactions comes from multiple sources (General Ledger, Expense Management, etc.), as well as from across various business processes.  
  • Secondly, organising the collated data to enable accurate tax disclosure. Due to transaction volume, this can be a challenge for resource-constrained tax functions. 

With respect to the latter challenge, it’s also relevant to note that accurate tax analysis can be compromised when multiple resources are utilised. For example, if a tax function has five members, there are likely to be natural variances in FBT classification as a product of human bias/background and the subjectivity of tax ‘rules’. 

Further compounding this is the overlay of competing demands, coupled with the tight tax deadline; even with the tax agent extension, three months to prepare and lodge an FBT return is simply not enough. 

For the best part of a decade, taxpayers, tax professionals and their representative professional bodies have lobbied the ATO and Federal Government to delay the FBT lodgment deadline to no avail. However, the increased flexibility and capability of technology offers hope that there may be a silver bullet.

Technology as a risk mitigant

Circling back to the ‘entertainment’ example above, the first challenge is data wrangling. In this regard, while Excel leads at spreadsheet augmentation, data wrangling generally involves building workflow processes, which better-honed software is capable of automating. 

Further, where systems and upstream data outputs remain broadly consistent year upon year, the workflow is capable of ongoing/annual leverage via automation, crystallising an enduring benefit. 

Similarly, technology can be a game-changer in developing accurate tax analysis for ‘entertainment’. Akin to data-wrangling, a purpose-built workflow can not only automate assessment (alleviating resource-constraints), but also ensure consistency (i.e. harmonious analytical process). 

To elaborate, ‘entertainment’ analysis is, generally, highly dependent on data parameters. By way of example, the word ‘restaurant’ in the ‘description’ field of an expense claim may typically signify ‘entertainment’ (why: social occasion, what: elaborate meal, when: provided outside of work time, where: consumed off-premises). However, other data parameters may alter this assessment (e.g., the ‘restaurant’ transaction may be coded to a ledger account reserved for travel claims, amending the why).

A purpose-built workflow could sequence this assessment by isolating all ‘restaurant’ transactions as ‘entertainment’ but re-categorise it when coded to ledger account ‘x’ and the spend is less than, say, $60 per person. 

The power of such automated analytics is strengthened when paired with visualisation, which provides curated insights and potential areas of focus for supplementary manual reviews. This visualisation allows for streamlined reviews using tangible data insights, rather than manual line-by-line reviews. 

Workforce tax data - The technology use case

As the ‘entertainment’ illustration demonstrates, the appropriate application of technology can enable efficiency, productivity and data insights, whilst ensuring a complete and accurate analysis of complex and high-volume workforce tax data. 

At a high-level, the ‘entertainment’ example demonstrates just some of the innumerable benefits that investment in technology can deliver, including:

  • Annuity leverage: Once configured, whether for data-wrangling or tax assessment, workflows can be leveraged to facilitate future compliance (mitigating the risk of differing approaches year-to-year).
  • Consistency: Automated transactional analysis and assessment (mitigating the risk of multiple resources or subjectivity creating inconsistency or inaccuracy)
  • Audit trail management: Modern technology can provide a workflow snapshot which, when coupled with plain english logic framing the automation, enables stronger governance.
  • Review ease: Visualisations provide clear insights and transparency, allowing for robust and timely secondary reviews and sign-off. 

Human-led, technology-enabled approaches that underlie an organisation’s governance structures also ensure conformity with regulator expectations. For instance, the ATO’s managerial controls 6 and 8 are exemplified through an automated workflow, which builds a complete dataset (data wrangling), and has a uniform assessment methodology for accurate tax outcomes. 

Ultimately, whilst the technology journey (particularly for workforce data) is likely to be bespoke for each organisation, it is evident that the historical challenge of multiple systems and voluminous data can be overcome with the capabilities of modern technology. The next step, then, is to find the right technology that suits your organisation’s unique challenges. Our extensive experience in working with clients across a broad spectrum of sizes, industries  and resourcing models have allowed us to gain critical insights into the different challenges and opportunities organisations face. 

Using these insights, we’ve developed Workforce Automate - a first-of-its-kind modular technology, providing broad coverage across workforce compliance and risk analysis - including FBT, pay-as-you-go withholding, superannuation guarantee, employee share scheme reporting, payroll tax, workers’ compensation, and vendor/contractor review - all within the one platform. Connect with us to find out more about Workforce Automate and request a demonstration! 

You can also read other articles in our Connected Tax Compliance thought leadership series to discover more insights. 

Greg Kent

Partner, Employment Taxes, PwC Australia

+61 412 957 101

Email

Shane Pinto

Director, Employment Taxes, PwC Australia

+61 423 679 958

Email

Adrian James

Director, Employment Taxes Technology, PwC Australia

+61 401 360 607

Email

{{filterContent.facetedTitle}}

{{contentList.loadingText}}

Contact us

Greg Kent

Greg Kent

Partner, PwC Australia

Tel: +61 412 957 101

Shane Pinto

Shane Pinto

Director, Employment Taxes, PwC Australia

Tel: +61 423 679 958

Adrian James

Adrian James

Director, Employment Taxes Technology, PwC Australia

Tel: +61 401 360 607