ACCOUNTING DATABASE FUNDAMENTALS

This title is printed to order. This book may have been self-published. If so, we cannot guarantee the quality of the content. In the main most books will have gone through the editing process however some may not. We therefore suggest that you be aware of this before ordering this book. If in doubt check either the author or publisher’s details as we are unable to accept any returns unless they are faulty. Please contact us if you have any questions.

Accounting Database Fundamentals presents the mechanics of accounting in the common language understood by SQL Developers, Business Analysts, Data Analysts, and Data Architects - data modelling.

The book presents accounting principles and how they are applied in an accounting database. Every chapter is easily digestible, has practical takeaways, and has answers to your how-to questions, including:

-Incremental construction of a data model based on the accounting equation

-Modelling of double-entry accounting principles

-Demonstration of the ingestion of transactional data from multiple modules into accounting

-Accounting data verification

-Components and data sources of the Income Statement, Balance Sheet, and Cash Flow Statement.

-SQL information-retrieval code for each financial statement

-Month-end and year-end data processing

-Basic table structures to support budgeting and cash flow forecasting