SQLite accounting database
Download a ready-to-query SQLite database with 73 tables for SQL practice, source-to-ledger tracing, and accounting analytics labs.
Synthetic accounting analytics dataset
Teach the business before the joins.
Charles River is a synthetic ERP-style accounting analytics environment that helps students trace business activity from source documents to GLEntry using SQL, Excel, and guided teaching materials.
Source documents to GLEntrySQL and Excel readyClassroom-ready teaching materials
Why Charles River
Connect business activity to ledger impact.
Students often see tables before they understand the business process and accounting logic behind them. Charles River exists to solve that teaching problem by connecting business events, source documents, process flows, and posted ledger activity in one integrated model.
What's Included
One accounting database, multiple classroom-ready formats.
Excel workbook and CSV export
Work from the same synthetic accounting dataset in an Excel workbook or a CSV package when the class needs pivots, charts, or external tooling.
Financial, managerial, and audit paths
Use one dataset across financial reporting, managerial analysis, audit procedures, working-capital review, payroll, and manufacturing cases.
Teaching materials with the data
Pair downloads with process flows, schema guidance, SQL walkthroughs, analytics pages, and instructor adoption support instead of starting from bare tables.
What Makes It Different
One teaching model, three proof points.
Process-to-ledger traceability
Follow business events from source documents through process flow and into GLEntry with clear traceability.
SQL and Excel ready
Use one integrated environment for query work, workbook analysis, and guided interpretation without rebuilding the dataset first.
Teaching materials included
Pair process guides, schema and posting references, analytics pages, and cases so students learn the business before the joins.
What You Can Do With It
Use one environment across multiple accounting teaching paths.
AIS and business process courses
Teach why each document exists, how process cycles connect, and which events actually reach the ledger.
SQL and accounting analytics
Support structured query work with one company model that already connects process logic, documents, and accounting outcomes.
Excel analytics and interpretation
Use the same environment for pivots, workbook-based analysis, and classroom discussion without losing business context.
Auditing, controls, and managerial analysis
Trace approvals, exceptions, labor, variance, portfolio behavior, and control logic inside one integrated teaching dataset.
Why Instructors Adopt It
One company, one dataset, multiple course and assignment styles.
Charles River is designed for reuse across AIS, business process, SQL, Excel, audit, and managerial accounting work. Instructors can keep one integrated environment and vary the emphasis by course, module, or assignment type.
- One company and one dataset can support multiple accounting courses.
- The same environment works for demos, guided labs, process tracing, SQL, Excel, and open-ended assignments.
- Students can start with business context and then move into analysis without switching models or file structures.
Choose Your Next Step
Start with the route that matches what you need next.
Start HereOpen the main student entry page for the recommended reading order, downloads, and core references.DownloadOpen the published file package when you want the SQLite database, Excel workbook, and CSV export for class use.Adopt in a CourseUse the instructor guide when you want teaching sequence, setup notes, and course-ready adoption support.
Common Questions
What people usually want to know before they download the dataset.
Is this a synthetic accounting analytics dataset?
Yes. Charles River is a synthetic accounting analytics dataset built for teaching, open reuse, and broad classroom distribution without exposing real company transactions.
What files are included?
The published package includes a SQLite database, an Excel workbook, and a CSV export so users can move between SQL practice, workbook analysis, and table-by-table tooling without switching datasets.
Can students use it for SQL practice and audit work?
Yes. The dataset is designed for SQL practice, source-to-ledger tracing, audit exception review, financial analysis, managerial accounting, and business-process teaching in one connected model.
Who is it for?
It is built for AIS, accounting analytics, audit, financial, managerial, and business-process courses where students need a realistic accounting database plus guided teaching materials.
Open Educational Resource
Charles River Accounting Dataset is an openly licensed open educational resource designed for reuse, adaptation, and course adoption.