Accounting database Fundamentals

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