Enhancing Source Data for Financial Management

The knowledge in this book is valuable and can repay the outlay many times over in a short period. Digital Skills for Finance Professionals There are times when working with data can strengthen accounting and create efficiencies. Times when accounting applications don't support the tasks in hand. Such as when making a quick forecast, supporting line managers, analysing inventory discrepancies, managing fixed assets, validating balance sheet...
More Description

The knowledge in this book is valuable and can repay the outlay many times over in a short period.

Digital Skills for Finance Professionals
There are times when working with data can strengthen accounting and create efficiencies. Times when accounting applications don't support the tasks in hand. Such as when making a quick forecast, supporting line managers, analysing inventory discrepancies, managing fixed assets, validating balance sheet amounts, looking for data in a closed period, responding to auditors' requests. Times when ledger data are poorly labelled, or there is no audit trail to outside-of-the-ledger data.

As digital applications advance, the amount of non-accounting data available for financial management grows larger. For the finance professional, working with data starts with accounting data and expands to other sources.

To work with data requires knowledge and skill. This book is by way of sharing technical knowledge gained working with data in a variety of enterprises. It explains how data is related to other data, how it is stored, how it can be accessed, downloaded, enhanced, and used in accounting and financial management.

It describes maintaining data offline to create efficiencies. It explains query features in MS Access, and useful functions in Excel. It suggests how technical knowledge can be used to add depth and value to accounting records and embrace outside-of-the-ledger data.

The book is in eight sections with over eighty subjects
- About data - Accounting Applications - Suite Software - User Data - MS Access - MS Excel - Accounting Tasks - Other Solutions.

It looks at accounting data. How it is stored, what it looks like, and methods used to enhance it.
It explains using Access and Excel to create useful data sources for queries and pivot tables.
It suggests data-based solutions for a variety of accounting and financial management tasks.
It shows with illustrations, efficiencies that can save time and effort spent on accounting tasks.
It has a strong emphasis on balance sheet validation and using outside-of-the-ledger data.
It contains must-have knowledge for anyone working in accounting or financial management. Or for data engineers developing accounting-based solutions.