← Back to Statement Engine

Calculation Methodology and Forecast Logic

Last updated: 2026-06-28

1) Forecast input layers

Statement Engine separates input into opening balance sheet data and future transaction rules. Trial balance CSV import is used to create opening BS data. Revenue, expense, payroll, capex, loan, debt repayment, tax, and journal rows are future assumptions.

2) Journal-driven calculation flow

  1. Normalize opening BS accounts and balances.
  2. Expand transaction rules across the forecast horizon.
  3. Generate projected journal rows from each transaction rule.
  4. Aggregate projected trial balance movement by period and account.
  5. Map account balances into PL, BS, and CF outputs.
  6. Run checks for balance consistency and cash tie review.

3) What the Checks tab means

Checks are designed as review signals, not audit opinions. They help users identify sign, mapping, timing, and cash-tie issues before using the forecast externally or exporting Excel.

4) Excel output boundary

The web model is the free preview and review layer. Formula-linked Excel output is the paid deliverable layer when enabled. Users should review assumptions and checks before treating any exported workbook as an external planning artifact.

5) 日本語要約

Statement Engineは、開始BSと将来取引を分けて扱います。取引ルールから予測仕訳を作成し、勘定科目別に集計してPL・BS・CFへ連動します。 Checksタブは監査意見ではなく、符号、マッピング、期間、現金整合を確認するためのレビューシグナルです。

計算方法 3表予測

計算方法 3表予測という観点では、開始BS、取引ルール、予測仕訳、勘定科目別集計、PL・BS・CFマッピング、Checksの順で確認します。

Related pages