Nsites · City of Indianapolis Charter School Intelligence Platform

OEI Financial Validation Lab

Nsites CQ2 calculation, source traceability & replication validation

Reviewer: Allan Bell - Nsites
Run sealed 04 Sep 2026 · 18:16 UTC
Report studio

Upload financials → parse the source → generate the CQ2 report

Load a school's audited statements and workbooks for a new period. The platform reads the statement lines, proposes the Core Question 2 inputs with a page or cell reference for each, and drafts the full evaluation report — results, ratings and narrative — using only the uploaded documents.

Nothing published by OEI or held in Salesforce/CAP is used here. Every figure and every rating in the generated report is derived from the documents uploaded on this page. Where a required value is absent, the sub-indicator is written up as “unable to validate” rather than estimated.
Documents uploaded
0
Parsed in this session
Statement lines read
0
Label + value + source reference
Inputs mapped
0 / 20
Confirm or correct each below
Sub-indicators calculable
0 / 9
Draft overall: Unable to Validate
Step 1 · Report header
Step 2 · Upload the source documents

Drop audited statements, supplemental schedules or workbooks here

PDF and Excel (.xlsx) · files are read in your browser and never leave this session

Step 2b · Upload last year’s report to use as the template

Load the prior period’s completed Core Question 2 report. The platform reads its sub-indicator sections, keeps the wording, and holds every figure printed in it as a replaceable slot. The prior report supplies wording only — its numbers and its ratings are never used in this year’s calculation.

Step 3 · Confirm the mapped inputs

Each proposed value carries the file and the page or cell it came from. Correct anything the parser mis-read; leave a field blank where the document was not provided.

CQ2 inputValueSource filePage / cellMatch confidence & note
Board-approved budgeted enrollment
Board-approved budget / supplemental schedule
Enrollment in the budget in force at the October count.
Analyst entry
Fall ADM (October count)
ADM count schedule
Average daily membership certified at the fall count date.
Analyst entry
Spring ADM (February count)
ADM count schedule
Average daily membership certified at the spring count date.
Analyst entry
Total current assets
Statement of financial position
School-level column where separately presented.
Analyst entry
Total current liabilities
Statement of financial position
Includes current maturities of long-term debt.
Analyst entry
Unrestricted cash and equivalents
Statement of financial position / liquidity note
Exclude donor-restricted, escrow, trustee-held and board-designated cash.
Analyst entry
Total expenses
Statement of activities
Total functional expenses for the fiscal year.
Analyst entry
Depreciation and amortization
Statement of activities / cash flow statement
Removed from expenses in the days-cash denominator.
Analyst entry
Total assets
Statement of financial position
Analyst entry
Total liabilities
Statement of financial position
Analyst entry
Net income — current year
Statement of activities
Change in net assets for the reporting year.
Analyst entry
Net income — prior year 1
Prior-year audited statement of activities
Required for the three-year aggregate. Leave blank if the audit is not held.
Analyst entry
Net income — prior year 2
Prior-year audited statement of activities
Required for the three-year aggregate. Leave blank if the audit is not held.
Analyst entry
Change in net assets (unrestricted)
Statement of activities
Used in the debt-service coverage numerator.
Analyst entry
Interest expense
Statement of activities / debt note
Analyst entry
Principal payments on long-term debt
Statement of cash flows / debt maturity schedule
Analyst entry
Debt default or covenant violation in the year?
Debt note / covenant compliance note
Yes if an event of default or unwaived covenant violation occurred.
Analyst entry
Going-concern uncertainty disclosed?
Nsites auditor's report
Analyst entry
Material weakness reported?
Report on internal control (Government Auditing Standards)
Analyst entry
All required financial reports submitted on time?
OEI submission log
Answer No if any required submission was late or is unknown.
Analyst entry