New: Boardroom MCP Engine!

ROI, cash forecasts, and invoice review โ€” Worksheets

Usable worksheets and fictional practice material for roi, cash forecasts, and invoice review.

Updated

On this page

Download the complete part-07 practice pack (ZIP). Extract it and preserve its folders. All organizations, records, and results in this teaching pack are fictional.

Use these templates to organize a review, with your actual entity, records, and approvals. The accompanying figures are fictional. Blank fields represent missing evidence, not zero values or completed decisions.

One-page AI investment case

FieldEntry to complete
Decision and workflowProposed change and present alternative
Business ownerPerson accountable for the decision
Comparison periodStart, end, and timing of payments
Volume and eligibilityTasks included and excluded; evidence for forecast usage
Baseline effort and qualityComplete current workflow, including errors and rework
Assisted effort and qualityComplete proposed workflow, including review and exceptions
Setup cashConfiguration, integration, migration, and other initial payments
Setup internal timeTraining and implementation hours with explicit value basis
Recurring cashSoftware, usage, external support, and other incremental payments
Recurring internal timeMaintenance and oversight not already counted per task
Capacity benefitReleased hours, intended use, and how use will be verified
Cash benefitSpecific payment avoided or incremental cash collected; supporting evidence
SensitivityUsage, effort, costs, delays, and quality assumptions that change the result
Decision and review datePending until an authorized decision is recorded

Calculate the capacity and cash views separately. State benefit, cost, net benefit, period, and denominator for every ROI percentage. If the same work supports a contractor reduction, do not also claim its full internal-capacity benefit without separate evidence. Preserve the original case for later comparison with actual results.

Cash forecast input record

Use one row per event or clearly defined non-overlapping group:

Event ID:
Entity and currency:
Receipt or payment:
Amount and source document:
Contractual date, if established:
Expected cash date and basis:
Committed, assumed, or proposed:
Included elsewhere? Reference and duplicate check:
Owner and next review date:
Unresolved evidence:

Reconcile opening cash to the chosen account scope. Identify restricted amounts and outstanding items. Do not include the same outstanding payment in both the adjusted opening position and future payments.

For each week, calculate opening cash plus receipts minus payments. Roll closing cash into the following week. Examine the minimum balance, first breach of the business's proposed or approved floor, and daily timing where weekly totals could hide a problem.

Cash decision memo

Forecast version and preparation date:
Available opening cash and evidence:
First projected floor breach:
Lowest projected cash and date:
Main source events driving the shortfall:
Effect of delayed collections:
Proposed action, decision owner, and deadline:
Evidence or agreement required before updating the committed view:
Obligations that remain unchanged:
Next scheduled review:

Keep a management proposal separate from an approved change. A deferred purchase only improves the forecast when the assumption is explicit; it does not remove an existing contractual obligation by itself.

Invoice and expense exception register

ColumnRequired meaning
Record ID and entityStable identity and correct business
Source referencesInvoice, order, receipt, credit, expense evidence, or payment record
Currency and amountSupported figures; missing values remain missing
ExceptionSpecific discrepancy or evidence gap
Draft findingWhat the supplied records establish
Resolution neededDocument, confirmation, or decision still required
Reviewer rolePerson responsible for obtaining or assessing the evidence
Approval scope and referenceActual recorded decision; blank while pending
Posting and payment referencesActual completed system steps, when available
Status and review dateCurrent state and next review

A duplicate-looking document, missing receipt, or changed payment request does not share one generic resolution. Preserve the relationship between documents and the evidence needed for each case. Do not turn a proposed category into a tax conclusion.

Practice files and sequence

  1. Read practice/Finance-Sources.md. It defines the fictional entities, scenarios, simplified dates, and source boundaries.
  2. Review practice/roi-assumptions.json and practice/roi-scenarios.csv. Explain why the capacity case has a positive resource ROI while its cash view uses cash. Compare the separate contractor case without combining overlapping benefits.
  3. Trace the sixty source events in practice/cash-events.csv into the three forecast CSVs. Find the base floor breach, the earlier breach in the delayed case, and the separate equipment proposal's effect. Use cash-week-one-variance.csv to practice variance signs.
  4. Read practice/mesa-source-packet/ and practice/finance-review-records.json. Complete a draft exception register for the six cases in practice/review-cases.csv.
  5. If you actually evaluate a model in an approved environment, record its output, reviewer, and result. Until then, leave observed fields in the case register and practice/observations.csv blank.

Run python3 practice/verify_examples.py from the Part 7 directory to reproduce the derived CSVs and Example-Verification.json. The script uses Python's standard library and checks arithmetic, weekly dates, source relationships, and fixture consistency. It does not run an AI model, import files into accounting software, validate tax treatment, verify a bank balance, or execute financial actions.

The source-event CSV uses simplified Monday scheduling dates. The forecast presents week-end balances; neither file is proof of daily liquidity. The simulated actuals are a separate exercise and do not overwrite the baseline forecast. Review all omitted categories and source assumptions before adapting the structure to real records.