by Chris Chinaire (Author)
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