Answers
Short answers for users who search by symptom instead of product name. Each answer links to a deeper guide for opening balances, trial balance import, Checks tab review, and Excel output readiness.
The usual causes are debit and credit sign direction, equity sign convention, retained earnings treatment, unmapped accounts, or importing a trial balance for a different starting month. Start with the opening BS, then inspect the Checks tab before paid Excel output.
Look for assets, cash, or receivables showing as negative while liabilities or equity move in the opposite direction. If many normal debit accounts appear negative at import, the debit and credit columns may have been reversed.
Retained earnings can be duplicated, reversed, or mixed with current-period profit. Separate opening retained earnings from forecast profit movement, then confirm whether dividends or prior-period adjustments are included.
Accounts payable terms shift cash outflow away from the purchase or expense month. Profit can look stable while cash drops later, especially when supplier payments, payroll, tax, or debt service overlap.
Tax expense and tax payment often happen in different periods. Cash can fall when corporate tax, VAT, sales tax, or estimated tax is paid after the profit has already been recognized.
A Checks tab mismatch means the linked forecast should be reviewed before the workbook is used externally. Common causes include opening balance issues, account sign mistakes, timing mismatches, retained earnings problems, or an unbalanced journal.
よくある原因は、借方・貸方の符号、純資産の符号、利益剰余金の扱い、未マッピング勘定、開始月のズレです。 Excel出力前に開始BSとChecksタブを確認します。
現預金、売掛金、固定資産など通常借方に出る科目が大きくマイナスになり、借入金や純資産が逆方向に動いている場合、 借方列・貸方列または符号ルールを見直します。
利益剰余金に当期純利益が重複している、符号が逆、配当や前期修正が混ざっている、といった原因が考えられます。 開始残高と予測期間の利益を分けて確認します。
買掛金の支払条件は、仕入月や費用発生月から現金支出月をずらします。利益は出ていても、支払月に税金、給与、 借入返済が重なると資金繰りが急に悪化します。
税金費用を認識する月と、法人税・消費税・予定納税を実際に支払う月は一致しないことがあります。利益が出ている月ではなく、 支払月の現金残高を確認します。
Checksタブの不一致は、外部共有やExcel出力の前に3表のつながりを見直す必要がある状態です。開始BS、符号、 利益剰余金、取引タイミング、仕訳の貸借一致を確認します。
Web forecast review is free. Formula-linked Excel output is a paid output or reward-unlocked output when configured. Use the free web Checks review first, then export Excel only when the forecast is ready for sharing or bank submission.
Webでの予測確認は無料です。数式付きExcel成果物は、有料または設定されたリワード解放の対象です。 まずWeb上でChecksを確認し、銀行提出や外部共有が必要な場合だけExcel出力を使います。