CFO Review
Northstar Creative Studio
Full review checklist, notes, and action plan.
Demo mode is read-only. BookSmrt clients can save notes or action items with their own company data.
Get an Agency Financial CheckupLoading period selector…
Review summary
Northstar Creative Studio is profitable, but the review should focus on cash pressure
Northstar Creative Studio is producing a strong operating result, yet operating cash remains thin. That combination usually points to timing issues — inventory, receivables, vendor payments, or upcoming obligations may be absorbing cash. Before making decisions, review the aging reports, upcoming payables, and the largest expense movements.
- Cash is tight — about 7.2 days of runway at current spending.
- Revenue moved compared with the prior period and should be reviewed.
- Expenses jumped compared with the prior period — review the largest categories.
- Revenue declined 34.5% vs May 26
- Cash runway is roughly 7 days
Monthly review summary
Client-facing summary for Northstar Creative Studio · Year to date (Jan 1 – Jun 30, 2026). Prepared from synthetic demo snapshot data modeled after QuickBooks-style financials; interpretation validated by the advisor.
What changed this period
- Total cash held steady at $44,438.
- Revenue increased by $1,607,493 to $2,048,956 (was $441,463).
- Expenses increased by $860,890 to $1,064,244 (was $203,354).
- Net result increased by $746,603 to $984,712 (was $238,109).
What looks good
- Gross margin trend: Gross margin is approximately 55.2% based on mapped revenue and cost-of-goods categories.
- Net income / surplus trend: The period shows a surplus of $984,712 based on mapped income and expenses.
- Cash balance: Total cash is $44,438 as of the latest refresh.
- Budget vs actual: Actuals are tracking within the 10% review threshold against "Demo budget".
- Missing account mappings: All required account mappings are configured.
What needs attention
- Revenue declined 34.5% vs May 26 — Mapped revenue moved from $441,463 to $289,263. This may be timing, seasonality, or a real trend — it needs review.
- Cash runway is roughly 7 days — Operating cash covers about 7 days at the trailing spend rate, below the 30-day review threshold.
- 38.8% of receivables are 90+ days old — $51,071 of $131,725 open receivables sit in the oldest aging bucket. Collectability may need review.
- Payroll as % of revenue increased from 12.5% to 111.8% — Review whether this was planned hiring, payroll timing, or a revenue dip. The software cannot tell which — the advisor should confirm.
- Payroll increased while revenue decreased — Payroll rose from $55,078 to $323,276 while revenue declined. This combination may be planned — it should be reviewed.
- 33.6% of payables are 90+ days old — $43,484 of $129,392 open bills sit in the oldest aging bucket. Vendor relationships or data accuracy may need review.
Data & mapping items
- Suggested KPI "Average Hourly Rate" requires data outside QuickBooks
- Suggested KPI "Backlog" requires data outside QuickBooks
Recommended action items
- Review whether the decline is timing-related, seasonal, or a trend worth acting on.
- Review upcoming cash commitments and collection timing with the client.
- Review the oldest open receivables and follow up with the largest overdue customers/donors.
- Confirm with the client whether the payroll change was planned (hiring, seasonal staffing) or needs attention.
- Discuss whether the payroll increase was planned hiring or needs adjustment given the revenue dip.
These are recommended review points, not final business decisions. Please review with your advisor.
What needs review
Items from your demo snapshot that may deserve a closer look. Your advisor decides what each one means.
Critical — needs reviewRevenue declined 34.5% vs May 26Revenue
Mapped revenue moved from $441,463 to $289,263. This may be timing, seasonality, or a real trend — it needs review.
Suggested next step: Review whether the decline is timing-related, seasonal, or a trend worth acting on.
Critical — needs reviewCash runway is roughly 7 daysCash
Operating cash covers about 7 days at the trailing spend rate, below the 30-day review threshold.
Suggested next step: Review upcoming cash commitments and collection timing with the client.
Needs review38.8% of receivables are 90+ days oldReceivables
$51,071 of $131,725 open receivables sit in the oldest aging bucket. Collectability may need review.
Suggested next step: Review the oldest open receivables and follow up with the largest overdue customers/donors.
Needs reviewPayroll as % of revenue increased from 12.5% to 111.8%Expenses
Review whether this was planned hiring, payroll timing, or a revenue dip. The software cannot tell which — the advisor should confirm.
Suggested next step: Confirm with the client whether the payroll change was planned (hiring, seasonal staffing) or needs attention.
Needs reviewPayroll increased while revenue decreasedExpenses
Payroll rose from $55,078 to $323,276 while revenue declined. This combination may be planned — it should be reviewed.
Suggested next step: Discuss whether the payroll increase was planned hiring or needs adjustment given the revenue dip.
Needs review33.6% of payables are 90+ days oldPayables
$43,484 of $129,392 open bills sit in the oldest aging bucket. Vendor relationships or data accuracy may need review.
Suggested next step: Review the oldest open bills — confirm they are real obligations and plan payment or cleanup.
Possible issueA single expense is 550.2% of period expensesExpenses
"Product Cost of Goods Sold" ($917,968) is unusually large relative to total expenses for year to date. It may be a one-time item or a misclassification.
Suggested next step: Confirm this transaction is classified correctly and expected.
Possible issueSuggested KPI "Average Hourly Rate" requires data outside QuickBooksData quality
Average Hourly Rate is relevant for this type of business but needs an external data source or integration.
Suggested next step: Decide with the client whether this KPI is worth tracking manually or via a future integration.
Possible issueSuggested KPI "Backlog" requires data outside QuickBooksData quality
Backlog is relevant for this type of business but needs an external data source or integration.
Suggested next step: Decide with the client whether this KPI is worth tracking manually or via a future integration.
Financial review checklist
A structured monthly review built from registry-backed KPIs and the synthetic demo snapshot. Statuses suggest where to look first — final interpretation should be validated by the advisor.
Revenue
- Needs reviewRevenue trend
Revenue declined versus the comparison period beyond the review threshold.
- Looks goodGross margin trend
Gross margin is approximately 55.2% based on mapped revenue and cost-of-goods categories.
Profitability
- Looks goodNet income / surplus trend
The period shows a surplus of $984,712 based on mapped income and expenses.
- Needs reviewPayroll as % of revenue
Payroll of $323,276 is 15.8% of mapped revenue for the period.
- Needs reviewTop expense changes
Largest category change vs the prior snapshot: Product Cost of Goods Sold up $720,923.
- Needs reviewUnusual transactions / large items
"Product Cost of Goods Sold" ($917,968) is 86.3% of period expenses.
Cash
- Looks goodCash balance
Total cash is $44,438 as of the latest refresh.
- Needs reviewCash runway
Runway is roughly 7 days — below the 30-day critical threshold.
Receivables & Payables
- Needs reviewAR aging
A meaningful share of receivables is 90+ days old.
- Needs reviewAP aging
A meaningful share of open bills is 90+ days old.
- UnavailableVendor / customer concentration
Customer- and vendor-level concentration requires entity-level transaction data not yet loaded into snapshots.
Budget
- Looks goodBudget vs actual
Actuals are tracking within the 10% review threshold against "Demo budget".
Data quality
- Looks goodMissing account mappings
All required account mappings are configured.
KPI coverage
- WatchSuggested KPIs for this business
8 suggested KPIs are blocked by missing mappings or external data.
Data quality notes
Review numbers are only as trustworthy as the setup behind them.
3 of 3 required mapping categories are complete.
All required categories are mapped.
KPIs blocked by missing mappings
- Fixed vs Variable Cost Mix cannot be calculated until the related accounts are mapped.
- AP Aging cannot be calculated until the related accounts are mapped.
- AR Aging cannot be calculated until the related accounts are mapped.
- AR Over 90 Days % cannot be calculated until the related accounts are mapped.
- Accounts Payable Balance cannot be calculated until the related accounts are mapped.
- Accounts Receivable Balance cannot be calculated until the related accounts are mapped.
- Days Sales Outstanding cannot be calculated until the related accounts are mapped.
- Expense Growth % cannot be calculated until the related accounts are mapped.
Recommended KPIs for this business
Suggested metrics for a service business profile — validated by your advisor before adding to the dashboard.
Suggested KPIs to add
- Suggested KPI Advertising Expense
- Suggested KPI Advertising Expense Variance
- Suggested KPI Advertising as % of Revenue
- Suggested KPI Bank Fees Expense
- Suggested KPI Bank Fees Expense Variance
- Suggested KPI Bank Fees as % of Revenue
- Suggested KPI Dues and Subscriptions Expense
- Suggested KPI Dues and Subscriptions Expense Variance
Use these KPIs as review points. Final interpretation should be validated by the advisor.
Advisor notes
The software surfaces the issue; the advisor explains what it means.
Notes need a database connection to persist. Configure DATABASE_URL to enable advisor notes.
No advisor notes for this review period yet.
Action plan
Concrete follow-ups from this review period, with owners and due dates.
Action items need a database connection to persist. Configure DATABASE_URL to enable the action plan.
No action items for this review period yet.