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.
When external conditions are especially challenging, smooth internal processes and readily available information may prove to be a key aspect of improving your competitive edge. Today’s finance function is challenged by changes in the business environment and economy and by disruptive technology, so a CFO equipped with financial knowledge alone is no longer enough. In its annual CFO survey, PwC finds out what problems are facing companies in areas that CFOs keep on their radar as a top priority in order to grow their company and improve the performance of its finance function. This article summarises findings of the CFO survey conducted by PwC CEE and opportunities we see for supporting CFOs.
The preparation of annual accounts is relevant to each company, and this process often involves making multiple changes that have a direct effect on the numerical information presented in the company’s financial statements. Accounting software mostly ensures automatic preparation of the balance sheet and the profit and loss account, yet companies, depending on their size, may have to produce a number of notes that tend to take a long time to prepare. In this article we share recommendations for accelerating the technical preparation of financial statements.
The summer is rolling on and has all companies thinking about vacations and staff replacements. Accounting is one of the departments expected to promptly handle various enquiries and confirmations to ensure business continuity. Everyone who works in the accounting field is aware of situations where an accountant cannot take a vacation during the monthly closing, when filing reports, and during the payroll calculation. When is the accountant supposed to go on vacation? This article explores possible solutions.
Growing companies tend to see an increase in the amount of documentation and financial accounting data they generate. While the concept of paperless accounting is improved by developers of technology solutions and by digital start-ups, it is implemented by each company individually to make its accounting more straightforward and efficient, allowing its stakeholders to handle its financial accounting data with ease.
