Richard Day and Alannah Comerford explain how Chartered Accountants can enhance their organisations’ data transformation capabilities using Alteryx. With the recent changes to the FAE syllabus, which now includes Tableau, Alteryx and UIPath, the new crop of qualified Chartered Accountants will bring these skills into the workplace. In this article, we will discuss the advantages of using a data processing tool such as Alteryx. The Institute has recognised the value that Alteryx provides, and the onus is now on all of us to leverage the skills and knowledge our bright new crop of young accountants will bring to the workplace. Reflect on the tasks we are required to complete regularly as part of our role as a modern-day Chartered Accountant. Many of us would find that, despite not considering ourselves to be data experts, we cleanse, filter, summarise, append and cross-reference datasets – even if we don’t think of our actions in these terms. We often turn to spreadsheets to do these data-heavy tasks. Many of us have picked up a spreadsheet which has multiple tabs, complex formulae, thousands of rows of data and found it challenging to figure out what is happening. Also, these complex transformations and calculations often have undocumented steps, can be slow to update, require manual effort to repeat, and generally could be better controlled. Alteryx is a data processing tool that facilitates data transformations and calculations in a controlled and repeatable manner and can revolutionise how we process and analyse data.  Given the user-centric design and functionality, all accountants should be able to pick up Alteryx and get started. In Alteryx, steps in a process are represented graphically in a format called a “workflow”. It should, therefore, be far easier for a colleague to view such a workflow and figure out what is happening than if they were to pick up a spreadsheet, as described above.  Repeatable data transformation Take the simple scenario where we need to carry out a task that requires information from two or more systems. We typically export information from each system into separate files and then transfer these files to tabs in a single spreadsheet to carry out the task by summarising information from one tab and looking it up in the other. In an ideal world, with fully integrated systems perfectly tailored to all of our needs, this would be possible to do automatically on the systems themselves. However, this level of integration is not a reality for most of us and as a result, we regularly spend our time on these data transformation tasks. In many cases, data manipulation often represents a significant proportion of the time taken and does not leave much time for the accountant to review and consider the results. Alteryx can help with the data transformation and processing elements of such tasks. It provides the accountant with a way to build a workflow to complete each of the required steps each time such analysis is performed. It would then be a matter of refreshing the input files as needed and running the workflow, eliminating almost all of the time associated with the transformation of the data (see Figure 1). Similarly, Alteryx offers excellent value to an accountant by cleansing the data. In a world with imperfect and unintegrated systems, there may be data quality issues as well as inconsistent data across different systems. We have become used to removing leading zeros in an account or reference number, correcting misspelt names, or translating names of customers or products, so they match across systems. Alteryx allows us to build these data cleansing routines into a workflow to ensure that they are automatically performed the same way any time a file of this type is processed, unlocking real efficiencies. Where we need to perform tasks such as sorting, manipulating or joining files of any reasonable scale, Alteryx comes into its own. Standard steps that are performed regularly are prime targets for Alteryx. This affords excellent opportunities for Chartered Accountants to begin using this tool, as they should have an exceptional understanding of the activity required and the associated inputs and outputs. Robust data processing While many of the functions discussed above would be possible with other tools, Alteryx also has the added advantage of allowing the user to make the data transformation process more robust. While at first, it may be slightly more challenging to use Alteryx rather than filtering, sorting and using copy and paste in a spreadsheet, a Chartered Accountant will quickly become familiar with the tool given its graphical nature. Also, the rigour that is brought to a process by a user deliberately building specific steps into a workflow lends itself to robust processing. In Alteryx, it is also possible and recommended to build in controls to provide comfort over the completeness and accuracy of the information being manipulated at critical stages of the process, assuring that all required data is included and that the result is accurate. The processing is a little more opaque since it generally sits in data files rather than yet another tab on a spreadsheet. You should, therefore, build in the ability to browse the interim data at various stages of your process so you can troubleshoot or review how it looks and check that the different steps are performing as expected. When performing calculations or analysis in a spreadsheet, a small change can cause an error in a set of calculations, and it can be challenging to identify where the error is occurring. There may be hundreds or even thousands of iterations of a formula. As a result, we often see data anomalies fixed with hard-coded values. This is much better in Alteryx as good design will allow errors to be identified and a user cannot revert to hard-coding values, which may not be appropriate for future iterations of a calculation. It is also easier with Alteryx to ensure that inputs are used as provided. It provides a mechanism to revert to the source data when required, which also contributes to the robustness of a process.  Processing at scale In Alteryx, tasks can also be carried out using large volumes of data that would only have been attempted by the bravest of spreadsheet proponents, making tasks that were previously tricky (or in some cases, impossible) more feasible. Some spreadsheets have an outer limit of up to one million lines, but in many cases, the practical limit is much lower since adding formulae to files with only thousands of records can cause them to slow down drastically. Alteryx can handle the bigger datasets we now encounter. In addition, making changes to calculations in spreadsheets can be time-consuming and many have encountered spreadsheet files crashing. Alteryx generally allows changes to be made and re-run quickly. Many workflows will run in seconds while processing simple transformations for millions of records should only take a few minutes. This is a huge advantage when building a workflow, as it enables the user to experiment efficiently and add additional functionality with ease. Documentation The ability to review a workflow and the controls built into it affords management excellent oversight of calculations that may drive critical outputs. Detailed documentation of processes is something that is not always present, especially for data-heavy tasks that began as an ad hoc exercise but are now embedded in everyday activities. Performing data transformation in a tool such as Alteryx and adding annotations to workflows has the added benefit of encouraging the user to define and document what is happening in a process. Outputs The outputs from Alteryx workflows can be produced in a range of formats. It may be that the most convenient output from your Alteryx workflow is a spreadsheet, such as debtors who are over their credit limit. It is also possible for visualisations, such as those covered in previous articles, to be refreshed automatically with data files produced from Alteryx. This can help Chartered Accountants provide significant value to their businesses. Significant value Alteryx may not be required when you are working with easy-to-manipulate data on a once-off basis. In an increasingly regulated and controlled business environment, however, the benefits associated with repeatable, efficient and documented data transformations are of significant value. As we are supported by our soon to be qualified Chartered Accountants on our data analytics journey, we encourage you to share your experiences within your teams. Knowledge-sharing and an open attitude to the improvements technology can bring will breed success.   Richard Day FCA is Partner, Data Analytics & Assurance, at PwC Ireland. Alannah Comerford ACA is Senior Manager, Data Analytics & Assurance, at PwC Ireland.

Kim Doyle considers the best course of action for businesses that are strained financially as a result of the impact of COVID-19. COVID-19, a term that was not part of most members’ vocabulary a mere two months ago, is now the unwanted commandeer of conversations. Self-isolation, social distancing, WFH (working from home) and CC (conference call) have become part of our basic business language. But we must not forget to keep talking about the old reliable, tax. Continue to talk to Revenue, as early as possible, if you are now experiencing timely tax payment difficulties. This is one of their key messages. The other is to get tax returns in on time. At the time of writing, Revenue’s message to businesses strained financially as a result of the impact of COVID-19 is that they will work to resolve tax payment difficulties. Viable businesses that experience cash flow difficulties have long been encouraged by Revenue to engage with them as early as possible. Often, entering a phased payment arrangement is the appropriate practical step to deal with outstanding tax payments. In fact, at the end of 2019, over 6,300 business had such arrangements in place covering €73 million in tax debt, according to Revenue. Revenue will only agree to a phased payment arrangement provided the relevant tax returns are filed with them, the tax due is fully calculated, the business is viable and there is early and honest engagement. Applications for such an arrangement can be made via the Revenue Online Service (ROS). Supporting documents will be required; the volume of documentation depends on the level of outstanding tax payments. A down-payment must be made, which can range from 25-40% of the total tax payment, which may include interest. Agents can apply on behalf of their clients via ROS. Applications are typically responded to within two weeks; in many cases, arrangements are up and running in a matter of days. Responding to the difficulties arising from the impacts of COVID-19, Revenue has implemented specific measures for small- and medium-sized enterprises (SMEs) experiencing trading difficulties. Perhaps the most important being that interest will not be applied to late tax payments of VAT for the January/February period (due by 23 March) or employer PAYE liabilities for the months of February and March. Any future similar suspension will be considered at the relevant time, Revenue say. For other businesses experiencing temporary cash flow or trading difficulties, the advice from Revenue is to contact the Collector-General’s office directly or the appropriate Revenue division. Revenue has also suspended all debt enforcement activity, for now. Current tax clearance status is expected to remain in place for all businesses over the coming months.  And in an effort to ease the burden on households, Revenue also announced the deferral of certain local tax payments (annual Debit Instruction/Single Debit Authority) to 21 May from 21 March. As of now, there is no statement from Revenue on dealing with other taxes such as corporation tax. In this unprecedented turbulent environment, protecting the tax receipts must be one of the priorities for Government. It is hoped that any dip in tax receipts will be confined to 2020. However, as long as we continue to talk about COVID-19 and suffer the impacts, we must also continue to talk to Revenue. Kim Doyle FCA, AITI-CTA, is Tax Manager at Chartered Accountants Ireland.

It is now time to consider the UK tax relief available on building projects, writes Eugene Moore. To stimulate international investment in the UK, the then-Chancellor, Phillip Hammond, presented his 2018 Autumn Budget to the House of Commons. In it, he announced the introduction of capital allowances for capital expenditure incurred on the construction, renovation or conversion of most UK and overseas buildings and structures. The Structures and Building Allowance (SBA) applies to contracts entered into on or after 29 October 2018. Construction projects that may qualify for the SBA are now starting to be completed, with the structures and buildings coming into use. It is now, therefore, time for the current owners and their advisors to consider the significant tax relief available on such capital projects and how best to mitigate the risks of making an invalid claim. The relief Relief is available for UK and overseas structures and buildings where the claiming business is within the charge to UK tax. The SBA was introduced at a rate of 2% straight-line basis on qualifying expenditure over 50 years. The rate was increased to 3% in the Budget and the change will take effect from 1 April 2020 for UK corporation tax and 6 April 2020 for UK income tax. The relief commences with the later of: The day the building or structure is first brought into non-residential use; or The day the qualifying expenditure is incurred. Once qualifying expenditure is incurred, the first use of the structure or building must be non-residential. Subsequent events, such as change of use to residential or the demolition of the structure or building, will impact the availability of the SBA. A period of non-use immediately after a period of non-residential use is deemed as non-residential use, and the SBA continues to be available. Qualifying activities The structure or building must be for a qualifying activity carried out by the person who holds the relevant interest. Qualifying activities include: trade; an ordinary UK property business; an ordinary overseas property business; a profession or vocation; the carrying on of a concern listed in ITTOIA05/S12(4) or CTA09/S39(4) (mines, quarries and other concerns); or managing the investments of a company with investment business. Qualifying expenditure Capital expenditure incurred on the construction or purchase of a structure or building (including professional fees and site preparation costs) is qualifying expenditure. Excluded expenditure covers: the cost of the land or rights over the land; the cost of obtaining planning permission; financing costs; or the cost of land remediation, drainage and reclamation. Abortive costs, such as architect’s fees associated with a structure or building that is not completed, do not qualify for the SBA. Commencement date As the SBA was introduced to stimulate investment from 29 October 2018, allowances are not available on structures or buildings where the contract for the physical construction work was entered into before 29 October 2018. For projects under a construction contract, the commencement date for the SBA will be the date of that contract. HMRC is of the opinion that contracts can take different forms; it gives the example of email exchanges, which confirm that works will take place. Where no contract is in place, the date of the commencement of physical works represents the commencement date for the SBA. This is also the case where physical works commence, and a contract is subsequently put in place. Site preparation According to HMRC, the cost incurred in preparing land as a site is treated as expenditure on the construction of the structure or building that is then built upon that site. This includes cutting, tunnelling or levelling land. On the plus side, these costs are not excluded as expenditure for the SBA. On the downside, the timing of these costs could drag the entire construction project into an invalid claim position for the SBA if they are incurred before 29 October 2018. HMRC states that the following does not impact the commencement date: separate preparation and construction contracts; replacement of preparation contracts; preparation works ceased then recommenced; and preparation work redone. Demolition or enabling works incurred before 29 October 2018 do not in themselves make the entire claim invalid for the SBA unless explicitly linked to the actual structure or building. Practical issues Before an SBA claim can be made on a UK income tax or UK corporation tax return, the current owner of the relevant interest in a structure or building must create and maintain an allowance statement. Where the current owner incurred the qualifying expenditure in relation to the structure or building, the current owner creates the allowance statement. Where the current owner acquired the relevant interest in the structure or building from another person, they must obtain the allowance statement from the previous owner. An allowance statement means a written statement, which must include the following information: information to identify the building to which it relates; the date of the earliest written contract for the construction of the building; the amount of qualifying expenditure incurred on its construction or purchase; and the date the building is first brought into non-residential use. CPSE.1 (Ver. 3.8) General Pre-Contacts Enquiries for all Commercial Property Transactions now contains questions concerning the SBA and requests explicitly the allowance statement. In summary The SBA may result in significant tax relief for UK businesses that construct or purchase non-residential structures and buildings where previously, there was none on such expenditure. Careful consideration should be given to the commencement date of the project, and detailed evidence must be created and maintained by way of an allowance statement to avoid invalid claims.   Eugene Moore ACA is Corporate Tax Manager at BDO Northern Ireland.

David Duffy discusses recent Irish, EU and UK VAT developments. Irish VAT updates VAT compensation scheme for charities eBrief 21/20 contains updated guidance in respect of the VAT compensation scheme for charities. This scheme is now open in respect of VAT incurred by charities in 2019. The deadline for submitting such claims is 30 June 2020. Charities must satisfy various conditions to make a valid claim and there is a formula for calculating the claim. The total fund available for all claims is capped at €5 million and, if exceeded, this amount will be allocated between valid claims on a pro rata basis. There have been no changes to the scheme, but the guidance provides further details on the terms “total income” and “qualifying income”, which are relevant to the calculation of claims under the scheme. VAT on telecom services On 31 January 2020, the Tax Appeals Commission (TAC) published a determination in a case (16TACD2020) involving a mobile telephone operator (the appellant). The case considered the VAT treatment of the appellant’s cancellation charges, unused data, and non-EU roaming on bill-pay mobile phone services, as well as the time limit for making VAT reclaims. The appellant was unsuccessful in arguing for a VAT refund on three counts but did succeed in a claim for a VAT refund on non-EU roaming services. The key points of TAC’s determination were as follows: The appellant was liable for VAT on cancellation charges to bill-pay customers for early termination of their contracts. This followed a similar decision by the Court of Justice of the EU (CJEU) in MEO (C-295/17). The appellant was also liable for VAT in respect of customers’ unused data included in the price of their bundle. The appellant’s argument that VAT refunds should extend back further than four years was also rejected. The appellant had sought to argue that it should be equivalent to the five-year refund period available for other taxes, but this was rejected. The appellant was successful in arguing for a VAT refund to the extent that its bill-pay customers used its telecom services outside the EU. Revenue had sought to argue that refunds for non-EU roaming should only be available for pre-pay customers, but this was rejected by the TAC. While the case is principally relevant to the telecoms sector, some of the principles regarding cancellation charges and equal treatment could have wider application. The determination (which is available on the TAC’s website) is, therefore, a useful read. Time limits The question of time limits for VAT refunds was also the subject of a TAC determination (03TACD2020). The taxpayer was engaged in a VAT-exempt business but was entitled to partial VAT recovery on its dual-use input costs to the extent that its services were to non-EU recipients. However, during 2009, the taxpayer had not been aware of its entitlement to partial VAT recovery and therefore had not taken any VAT recovery on its costs. Upon becoming aware of this entitlement, the taxpayer submitted a claim on 31 December 2013, which included VAT incurred before 1 November 2009, which would ordinarily be outside the four-year time limit. The taxpayer sought to argue that this VAT was still within the four-year time limit because, in the taxpayer’s view, it was an adjustment of its partial exemption VAT recovery rate review for 2009 (which fell due after 31 December 2009). However, the TAC disagreed as the taxpayer had not applied any VAT recovery rate to dual-use inputs during 2009. The TAC concluded that only VAT incurred from 1 November 2009 onwards was correctly included in the claim submitted on 31 December 2013. While the facts of the case are quite specific, it emphasises the importance of following the appropriate procedures and paying close attention to time limits when submitting a claim for any historic VAT. EU VAT updates VAT treatment of boat moorings Segler (C-715/18) was a German non-profit-making association whose objective was to promote sailing and motorised water sports. It maintained boat moorings, some of which were used by members of the association and others were used by guests. Segler applied the reduced rate of German VAT as it believed the letting of the moorings fell within the meaning of “accommodation provided in hotels and similar establishments, including the provision of holiday accommodation and the letting of places on camping or caravan sites”. The German tax authorities argued that the standard rate of VAT should instead apply. The CJEU concluded that the reduced rate could not apply, as the letting of the boat mooring was not intrinsically linked to the concept of “accommodation”. UK VAT updates Budget 2020 The UK’s Chancellor of the Exchequer announced several VAT measures in Budget 2020, which was presented to the UK parliament on 11 March 2020. The key updates are summarised below: The 0% rate of VAT will apply to e-books and online newspapers, magazines and journals with effect from 1 December 2020, bringing them in line with the rate applying in the UK to physical books and publications. The standard 20% rate has applied heretofore. Interestingly, however, the UK Upper Tribunal had already held that the 0% rate correctly applied to such publications in the Newscorp decision, but HMRC has indicated an intention to appeal that decision. Consequently, the position applying before 1 December 2020 remains to be clarified. As a cash flow-relieving measure following the implementation of Brexit, postponed accounting for import VAT will be introduced for all goods imported into the UK with effect from 1 January 2021. Postponed VAT accounting will enable UK VAT-registered businesses to self-account for import VAT under the reverse charge mechanism. From January 2021, 0% VAT will apply to women’s sanitary products. David Duffy FCA, AITI Chartered Tax Advisor, is Indirect Tax Partner at KPMG.

Colm Davitt, CEO at Dental Care Ireland, discusses life at the helm of the five-year-old dental business he founded with his brother. What do you most enjoy about your current role? My role involves acquiring dental practices and helping them achieve their full potential. It combines my background in business and accountancy with a passion for the healthcare sector. I love seeing the practices grow and evolve as we invest in facilities, services and management support structures. Our 15 practices are located all over the country, which means a fair amount of travel, but I enjoy getting out of the office every week to meet with current and potential practice teams. What has been your career highlight thus far? Two career milestones stand out. First, I passed my final admitting exams to become a Chartered Accountant at age 21. My qualification has been the foundation and bedrock of my career achievements to date. Second, a major highlight was the opening of our first branded Dental Care Ireland practice. I first came up with the Dental Care Ireland concept in 2014 with my brother, Dr Kieran Davitt. Our vision was to create a group of established, high-quality dental practices nationwide. It has been a hugely rewarding experience to see that idea become a reality in just five short years. How do you stay productive day in, day out? I am a firm believer in setting goals. We have ambitious growth plans for Dental Care Ireland, so I review our objectives and targets at least every six months. I am also fortunate to have built a highly motivated team around me. Our head office is located beside the sea and close to home, so I can walk to and from work. When I’m not on the road, it gives me some guaranteed fresh air and headspace. I try to balance work with plenty of family time too. I dedicate my weekends to watching my kids in action on the sports field or catching up on GAA.  What changes do you anticipate in your profession in the next five to ten years? I expect to see the large-scale automation of routine accounting and data processing over the next ten years. It will be essential for Chartered Accountants to remain commercial and value-focused. In general, I think the need for flexibility in the workplace will continue to grow, and employers will have to adapt accordingly. In the dental sector, we may see fewer dentists willing to run their own businesses due to increased compliance and administration requirements. What is the best advice you’ve ever received? Stay true to what you really believe in. Being a CEO can be a lonely place, and there are many ups and downs along the way. If you believe in what you are doing, you will gain respect and trust from those around you. Over the years, I have had the privilege of working with several great mentors and CEOs. They all had the ability to create a small but very loyal team, which is probably the most important lesson I have learned. Working with a talented and supportive team makes the days much more enjoyable and fulfilling.

While support for diversity and inclusion is welcome, it is now time for business leaders to instigate meaningful change, writes Rachel Hussey. In the past ten years, diversity of all kinds – but gender diversity in particular – has become an area of focus for almost all business leaders. In what can be interpreted in many ways as progress, the 30% Club, which I currently chair, has been asked more frequently if 30% is a sufficiently ambitious goal. 30% Club Ireland is a group of Chairs and CEOs of 260 Irish organisations who agree with our goal to ensure that 30% of board members and senior management in Irish businesses are women. The Club was founded in the UK in 2010 by Helena Morrissey, and the Irish chapter was established in 2015. The 30% title was adopted because 30% is the critical mass that a minority must reach in a group to have an effective voice. And 30% is very much a floor and not a ceiling in terms of our goals and ambitions. I am a lawyer, but law firms and advisory and accounting firms face the same challenges around inclusion and diversity. In this rapidly changing world, with new careers emerging all the time, professional services firms have to find ways to stay attractive to graduates (both men and women) and to retain them once they have been trained. In other words, diversity may be a moral imperative, but it is also a necessity for business. Today’s graduates expect to find diversity where they work. That wasn’t the case in the 1990s when I started in practice. There was no discussion about diversity in business back then. There was a concept of ‘equality’, which was confined mainly to pay and conditions. The feminist movement was a social one, focused on issues like contraception. The Women’s Political Association was advocating for more women in politics, but the business world was separate to all of that. And I think many of the women who were in that business world either didn’t focus on the lack of diversity or were too isolated to speak up in any meaningful way. I was, of course, aware of the social movements while I was in college, but I assumed that the world was mostly a fair place and that if you were good enough, you could do whatever you wanted to do. Women were very well represented in the top of my class in Trinity. I didn’t even notice when I was doing a master’s degree at Harvard Law School that only a quarter of my class were women. After I qualified, however, a few incidents surprised me. When I attended an event with my then-boss, and we met his sister, she asked me how long I had been my boss’ secretary. When I was pregnant with my first child and was the primary breadwinner, I realised that I was going to have to rely on social welfare payments to survive. And then I had to make – and saw other women having to make – career decisions that weren’t decisions, as there was no choice. Spurred on by all of this, my women partners and I came together in 2008 and came up with plans to empower the women in our firm. And when I saw Helena Morrissey speak in Dublin in 2013, I knew the 30% Club was a real game-changer because it had clear goals, was business-led and – most importantly of all – included men, without whom no real change will ever be possible. There has been some progress, but perhaps we in professional services firms need to take some bolder steps now – for our men and women. We need to recognise the needs of a more modern workforce and find ways to integrate family life and absences into a career path rather than separate to, or an exit from, a career path. That includes better career planning built around family absence and greater recognition and accommodation of the needs of men in their desire to play an equal part in family life.  We need to recognise the potential for 24-hour demands in a digital age and become more agile in how we work and how we rest – as individuals, as parents, as carers and as human beings – and we need to demonstrate and practise this, starting from the top. We all state our commitment to diversity and equality of opportunity. It’s now time to prove our commitment. Rachel Hussey is Chair of 30% Club Ireland and a Partner at Arthur Cox.