When it comes to performing accounting or any other duties where data processing takes a long time or where you regularly need to perform some repetitive or similar activities and processes, it’s great to keep easy-to-use tools handy. As we are putting together courses at PwC’s Digital Academy, we would like to tell you about a tool that will make your daily tasks much easier to do. Power Query is a data preparation and transformation tool available in Microsoft Power BI and, starting from the 2016 version, in Microsoft Excel and other programs. This tool allows users to obtain data from a variety of external data sources and from files stored on computer. It allows you to group and transform data and perform other activities. This article offers a few practical examples to raise awareness of how this functionality can be used and what benefits it offers.
Section 18.2(1) of the Anti Money Laundering and Counter Terrorism and Proliferation Financing Act requires a company to notify the Enterprise Registry of its ultimate beneficial owner (UBO) and how UBO control is exercised.
As company balance sheets become increasingly saturated with liabilities and future cash flows less certain, the scope for obtaining bank finance on balanced terms is limited. Yet companies need fresh capital to continue investing and to make their business more resilient to energy shocks and lack of raw materials, and to cope with rising costs, which often cannot be offset by an increased price of the end product.
Ever-changing legislation puts additional pressure on businesses and individuals. To make sure you haven’t missed any important changes and to spot potential risks early, the best solution is to keep up with the changes and know your way around the relevant resources.
The global entertainment & media (E&M) industry’s revenue strongly outpaced overall global economic growth last year. Following a pandemic-related 2.3% decline in 2020, E&M revenue rose a strong 10.4% in 2021, from US$2.12trn to 2.34trn. With the industry becoming more digital, more mobile and more youth-oriented, virtual reality (VR), gaming and digital advertising are the main growth drivers. These are findings from PwC’s Global Entertainment & Media Outlook 2022–2026, the 23rd annual analysis and forecast of E&M spending by consumers and advertisers across 52 countries and territories.
Russia’s military aggression has significantly affected some of the businesses importing metal products from Russia and Belarus, as well as industries such as metalworking, defence, construction, mechanical engineering, and information & communication technologies. To promote market stability, the Ministry of Economics intends to implement aid measures as an immediate solution in the form of financial instruments to ensure traders’ future business.
Our Flash News edition of 12 July 2022 informed MindLink subscribers about a new aid programme based on rules recently adopted by the Cabinet of Ministers. In that article we looked at eligible entities, qualifying activities and excluded industries. This article explores the aid instrument and the programme’s status.
The Latvian Labour Code is amended on a regular basis and sometimes even more than once a year, but recent years have not seen so sweeping amendments as those coming into force on 1 August 2022. This article will help you navigate the new provisions of labour law.
On 1 December 2021 the European Parliament published the approved directive on the preparation of a public country-by-country report (“PCbCR Directive”). It states that any multinational group with consolidated revenue exceeding EUR 750 million for each of the last two financial years has to publish certain information (including revenue, headcount, and taxes paid) on their operations in each EU member state and certain third countries. This information has to be posted on the group’s website by December 2026 relating to subjects governed by the Directive if the financial year ends on 31 December 2025.
Amendments to section 9 of the Corporate Income Tax Act came into force on 21 April 2022. The Act’s transition rules now have paragraphs 47 and 48, and there is a different CIT treatment of debts appearing on the balance sheet at 31 December 2017 and ones incurred after this date for which provisions were made before 2022 and later. This article offers an updated summary of the CIT treatment of bad debts in different situations.
The Cabinet of Ministers Rule governing a new aid programme for improving energy efficiency in manufacturers and exporters came into force on 18 June 2022. Businesses can apply for aid to cover their overheads, i.e. for a loan (or a parallel loan) of up to EUR 5 million from the Altum Development Finance Institution. Up to 30% of the loan principal can be cancelled as a capital allowance. The aid can be used on costs associated with improving energy efficiency or introducing renewable energy resources for personal consumption by businesses in non-residential buildings and warehouses. This article explores some aspects of the new aid programme described in the publicly available wording of the Cabinet Rule.
In March 2022, PwC conducted the “Global Workforce Hopes and Fears” survey of 52,195 individuals who are in work or active in the labour market. That was one of the largest ever surveys of the global workforce, covering a range of industries, demographic characteristics and working patterns in 44 countries and territories.
As Russia continues the war in Ukraine, the US and the European Union (EU) together with other countries keep increasing the size of sanctions imposed on Russia.
At the EU summit held on 30–31 May 2022, the European Council agreed on the sixth package of sanctions against Russia that will mainly apply to crude oil and petroleum products supplied to EU member states. Yet the Council of Europe has agreed a temporary exception for crude oil supplied through pipelines. Ursula von der Leyen, President of the European Commission, has said that the restrictions included in the package will in fact stop around 90% of EU oil imports from Russia by the end of this year.
As the size of the sanctions grows, confused companies are having more and more questions about how to cope with the increasing sanctions burden, whether a company is supervised by particular regulatory bodies, and whether the current sanctions rules and guidelines provide for setting up an internal control system to manage sanctions risk.
