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