Start Here

Charles River Accounting Dataset teaches accounting analytics through one company and a connected set of business cycles. Sales demand becomes shipment, service delivery, invoicing, and cash collection. Purchasing supports inventory and operating needs. Manufacturing turns materials and labor into finished goods. Payroll supports wages, liabilities, and cash settlement. Finance closes the whole picture in the ledger.

Students should not start by browsing every table or every query. The easiest path is: download the files, learn the company, read one process, then choose a first working mode such as SQL, Excel, reports, or a foundation case. The published files give students the working dataset. The company story and process pages give those files a clear purpose.

What Comes With the Teaching Package

Students and instructors receive one integrated package:

• SQLite database download for source-to-ledger SQL work, document tracing, and audit-style review
• Excel workbook download for pivots, charts, filters, and instructor-led walkthroughs
• CSV package download for table-by-table exports, external tools, and import workflows
• process pages, guides, reports, and cases that keep the business story connected to the data

Where It Fits in Coursework

Charles River Accounting Dataset supports a strong entry point for:

• AIS and business-process courses
• accounting analytics and SQL labs
• audit and control walkthroughs
• financial statement, working-capital, and close-cycle analysis
• managerial, payroll, manufacturing, and service-margin interpretation

Start With the Company and the Cycles

Read the first pages as one sequence before opening a large query set:

1. Downloads to get the published teaching package
2. Company Story to understand the business model
3. Process Flows to see how the major cycles connect
4. One process page such as O2C, Design Services, P2P, Manufacturing, or Payroll
5. One first analysis path from Analyze the Data: SQL Guide, Excel Guide, Reports Hub, or a foundation case in Cases

This sequence keeps the business logic in front of the data. By the time students open a table or query, they already know what the company is doing and where the accounting evidence comes from.

How the Business Reaches Analysis

Business cycle	What it changes in the company	Best analytical follow-through
O2C	Customer orders, shipment activity, goods invoicing, receivables, collections, returns, and customer corrections	Commercial and Working Capital, Financial Reports, O2C Trace Case
Design Services	Service engagements, staffing, approved hours, monthly billing, service revenue, and labor-margin interpretation	Commercial and Working Capital, Managerial Reports, SQL Guide
P2P	Supplier commitments, receipts, AP timing, and accrual settlement	Commercial and Working Capital, Financial Reports, P2P Accrual Case
Manufacturing	Planning pressure, component usage, labor support, completion, and close	Operations and Risk, Managerial Reports, Manufacturing Labor Case
Payroll	People cost, approved time, payroll liabilities, cash settlement, and control review	Payroll and Workforce, Financial Reports, Workforce Cost and Org-Control Case
Manual Journals and Close	Accruals, reclasses, retained earnings, and final statement presentation	Executive Overview, Financial Reports, Financial Statement Bridge Case

How to Start if SQL Comes First

Students who begin with SQL can move quickly without losing the business context:

1. Download the files from Downloads.
2. Read Company Story and Process Flows.
3. Keep Dataset Guide and Schema Reference open while you query.
4. Use SQL Guide for the starter workflow and query-running sequence.
5. Move into Query Library after you know the first business question. It is a repository, not the easiest first reading page.

The Published Teaching Files

The downloaded files present the same business in different formats:

• CharlesRiver.sqlite supports source-to-ledger SQL analysis.
• CharlesRiver.xlsx supports workbook-based review, pivots, charts, and filters.
• CharlesRiver_csv.zip supports table-by-table exports for external tools and import workflows.

Next Steps

1. Get the files from Downloads.
2. Read Company Story and Process Flows.
3. Open one process page that matches the business question you want to follow first.
4. Then use Analyze the Data to choose SQL Guide, Excel Guide, Reports Hub, or Cases.
5. Use Instructor Adoption Guide only when you are planning course rollout, labs, or assignments.