Free accounting textbook · Publication information
Early release availableAccounting Analytics
An Integrated Approach
A free, open textbook connecting accounting questions with the preparation, querying, analysis, and communication of data. Excel, SQL, and Power BI support financial accounting, managerial accounting, and auditing applications in the shared Charles River business environment.
Free digital editions. Official First Edition release scheduled for .
Free digital access
Read online.
Download your preferred format.
The complete digital textbook is free. Choose the web edition for online reading, PDF for a fixed page layout, EPUB for an e-reader, or DOCX for an editable document.
These files are First Edition, revision 2027.1. The official book downloads page (opens in a new tab) maintains current editions. Print format identifiers appear in the publication record; print availability and pricing remain unconfirmed.
Inside the book
Explore the book.
Book synopsis
Accounting Analytics: An Integrated Approach is free to read online, with free PDF, EPUB, and DOCX downloads. It connects accounting knowledge with Excel, SQL, and Power BI so that learners can move from an accounting question to data preparation, analysis, and an explanation supported by evidence. Financial accounting, managerial accounting, and auditing applications give the analytical work its purpose.
The Charles River Accounting Dataset provides the book's shared business environment. Learners can follow operational transactions and source evidence through subledgers and the general ledger, then relate their analytical results to the processes that produced the records. This process-to-ledger approach keeps accounting meaning visible as the tools change.
Five parts progress from accounting analytics foundations to spreadsheet preparation and analysis, SQL queries, Power BI models and reports, and integrated capstone cases. Comprehensive cases connect the parts; appendices support reference, report publishing, browser-based Power BI, and professional competencies. The complete chapters, tutorials, exercises, cases, and instructional files remain on the textbook website.
Intended audience
Undergraduate and graduate accounting and business students, instructors adopting an open textbook, researchers exploring applied accounting analytics, and independent learners. No prior analytics or programming experience is assumed.
Subjects and technologies
- Accounting analytics
- Data quality and preparation
- Financial accounting
- Managerial accounting
- Auditing
- Excel
- SQL
- Power BI
Table of contents
5 parts and 19 chapters. Each chapter opens in the complete web textbook.
Foundations of Accounting Analytics
Accounting Analytics with Excel
- Excel Essentials for Accounting Analytics ↗ (opens in a new tab)
- Data Preparation and Cleaning in Excel ↗ (opens in a new tab)
- Descriptive and Diagnostic Analytics in Excel ↗ (opens in a new tab)
- Forecasting, Budgeting, and What-If Analysis in Excel ↗ (opens in a new tab)
- Audit Analytics in Excel ↗ (opens in a new tab)
Accounting Analytics with SQL
Data Visualization and Power BI
Capstone Cases
Comprehensive cases
Appendices
Publication details & formats
Reference this publication
Suggested citation
Codesso, M. (2027). Accounting analytics: An integrated approach. Accounting Analytics Hub. https://doi.org/10.5281/zenodo.23425591 (opens in a new tab)
A shared educational environment
Connect the book with Charles River.
Follow accounting questions through the same fictional company, from source records to analytical evidence. Public cases, process guides, and practice materials remain on their dedicated websites.