Financial Reports
Use these reports when you want a student-first output for monthly close, statements, revenue review, payroll cost and liability analysis, and receivables/payables aging.
Preview a sample directly in the site, then download the Excel or CSV artifact generated from the current SQLite build.
Monthly Close and Statements
Monthly Income Statement
Review revenue, cost of goods sold, operating expenses, and net income by fiscal period.
Monthly Balance Sheet
Analyze monthly ending balances for assets, liabilities, equity, and current year earnings.
Monthly Indirect Cash Flow
Reconcile net income to cash movement and review monthly operating, investing, and financing activity.
Pro Forma Monthly Income Statement
Review the driver-based monthly income statement budget built from forecast volume, planned pricing, standard cost, payroll, and recurring expense drivers.
Pro Forma Monthly Balance Sheet
Review the driver-based monthly balance-sheet roll-forward for receivables, inventory, payables, accruals, fixed assets, equity, and cash.
Pro Forma Monthly Indirect Cash Flow
Reconcile the pro forma budget from net income to operating, investing, financing, and ending-cash movement.
Budget vs Actual Statement Bridge by Month
Compare key income statement, balance sheet, and cash lines between the pro forma budget and posted actual results.
Revenue and Working Capital
Monthly Revenue and Gross Margin
Compare invoiced revenue, gross margin, discounts, and returns across fiscal periods.
Design Service Revenue and Billed Hours
Review billed design-service hours and posted service revenue by customer and invoice month.
Receivables and Payables Aging
AR Aging
Review open customer invoices by aging bucket and identify collection pressure.
AP Aging
Review open supplier invoices by aging bucket and identify upcoming cash commitments.
Monthly AR Aging Detail
Track open customer invoices at each month-end with due-day aging based on the last day of the month.
Monthly AR Aging Summary
Summarize month-end receivables exposure by customer, region, and segment.
Monthly AP Aging Detail
Track open supplier invoices at each month-end with due-day aging based on the last day of the month.
Monthly AP Aging Summary
Summarize month-end payables exposure by supplier, category, and risk rating.
Working Capital and Cash Conversion
Working Capital Bridge by Month
Compare the month-end balances of the main working-capital buckets and track net working capital over time.
Budget vs Actual Working Capital and Cash Bridge
Compare budgeted and actual balances for the main working-capital buckets plus ending cash across the planning horizon.
Sales Commission Payable Rollforward
Reconcile commission payable from invoice-line accruals through credit-memo clawbacks and sales-rep payments.
Customer Deposits and Unapplied Cash Aging
Review customer receipts, open unapplied balances, and how long cash remained unapplied before first use.
Cash Conversion Timing Review
Compare invoice-to-settlement and receipt-to-payment timing across sales, purchasing, and goods receipts.
Customer Pricing and Settlement
Customer Credit and Refunds
Review customer credits created by credit memos and whether those balances have been refunded or remain open.
Price Realization vs List by Customer and Portfolio
Compare realized billed pricing to base list price by customer, segment, region, collection, and style family.
Payroll Cost and Mix
Payroll Expense Mix by Cost Center and Pay Class
Review payroll register totals by pay month, cost center, and pay class before moving into ledger-only expense analysis.
Payroll and People Cost Mix by Cost Center Job Family and Level
Compare payroll concentration to current workforce structure by cost center, job family, job level, and pay class.
Gross to Net Payroll Review
Trace payroll registers from gross pay to withholdings, employer burden, and net pay by employee and pay period.
Hourly Payroll Hours to Paid Earnings Bridge
Bridge approved hourly time, labor support, paid earnings hours, and payment timing by employee and pay period.
Payroll Cash and Liabilities
Payroll Cash Payments and Remittances
Compare employee net-pay cash outflows to payroll-liability remittances by month.
Payroll Liability Rollforward
Track payroll-liability account movement and ending balances by fiscal period.