Guides
Practical Forecast Guides
Searchable guides for free web forecasting, paid Excel output, trial balance import, cash timing, and niche accounting forecast entries.
66
English guide topics.
66
Japanese guide topics.
354
Journal templates referenced by coverage.
Start
Setup, Pricing, and Validation
How to create a free 3-statement forecastStart from opening balances and run a browser forecast.
How to import a trial balance CSVCSV headers, mapping, and opening BS setup.
Trial balance CSV formatAccount code, account name, balance columns, and sign review.
Account mapping for 3-statement forecastsMap account codes to PL, BS, and cash flow behavior.
Web forecast vs paid Excel outputFree browser review and paid workbook boundary.
Formula-linked Excel outputWorkbook contents, export timing, and pre-export review.
Validate forecast before exportChecks tab, signs, timing, and workbook readiness.
Why a balance sheet does not balanceTroubleshoot cash tie, signs, timing, and journal direction.
Journal-driven forecast vs Excel templateWhen a web model, Excel output, or static template fits.
Symptom
Forecast Troubleshooting Guides
Trial balance import balance sheet does not balanceCheck TB import signs, account mapping, retained earnings, opening BS, and Checks.
Excel output before bank submission checklistReview opening balances, debt repayment, DSCR, assumptions, Checks, and workbook readiness.
Account sign mapping cash flow mistakeFind AR, AP, debt, tax, equity, revenue, and expense sign issues before export.
Opening balance sheet reset for forecast reviewReinitialize the starting point when the imported TB, month, mapping, or scenario is wrong.
Negative cash balance forecast causesSeparate real low-cash months from timing, mapping, and sign mistakes.
Loan repayment not reflected in cash flow forecastCheck principal, interest, debt balance, financing cash flow, payment timing, and signs.
Depreciation expense is not a cash outflowSeparate depreciation expense from capex payment and fixed asset movement.
Accounts receivable collection lag cash flow forecastModel AR days, cash receipts, delayed collections, and low-cash months.
Inventory purchase cash flow forecast and stock increaseReview purchase timing, AP timing, COGS, inventory balance, and cash risk.
Free web forecast and paid Excel output for bank submissionUse the free browser forecast first, then export Excel when a formal workbook is needed.
Trial balance debit and credit reversed forecastDetect reversed TB columns before opening balances distort PL, BS, CF, and Excel output.
Retained earnings opening balance mismatch forecastSeparate imported retained earnings from forecast profit movement before blaming cash.
Accounts payable payment lag cash flow forecastCheck supplier payment timing when profit looks fine but cash drops later.
Tax payment month cash flow forecastReview tax payment month timing when cash falls after profit has already been recognized.
Forecast Checks tab balance sheet mismatchUse the Checks tab to find balance sheet mismatch before exporting Excel.
Problem
Industry Problem Guides
Restaurant cash shortfall forecastFind low-cash months caused by food purchases, payroll, rent, tax, debt, and settlement lag.
Construction bank submission cash flow forecastPrepare progress billing, retention, subcontractors, project loans, and DSCR for lender review.
Ecommerce no-Excel inventory cash flow forecastReview inventory purchases, marketplace settlement, returns, fees, and tax before creating Excel.
Clinic equipment loan bank forecastPlan equipment capex, loan draw, repayment, interest, depreciation, and lender-facing Excel output.
Manufacturing inventory cash shortfall forecastIdentify low-cash months caused by raw materials, WIP, supplier payments, collections, and capex.
Beginner
Beginner and Adoption Guides
Free financial forecast without ExcelStart with free browser forecasting and export Excel only when needed.
Small business monthly cash flow forecastMonthly sales, expenses, AR, AP, tax, payroll, debt, and ending cash.
Financial forecast for non-accountantsUse opening balances, templates, cash timing, and checks without building from scratch.
Industry
Industry-Specific Cash Flow Guides
Restaurant cash flow forecastSales, food cost, payroll, rent, tax, deposits, and cash timing.
Ecommerce inventory cash flow forecastInventory purchases, marketplace fees, returns, settlement lag, and cash balance.
Construction project cash flow forecastProgress billing, subcontractor payments, retention, materials, and working capital loans.
Dental clinic cash flow forecastPatient revenue, insurance collections, payroll, equipment loans, tax, and cash timing.
Beauty salon cash flow forecastAppointment revenue, retail inventory, card settlement, staff cost, rent, and tax.
Real estate rental cash flow forecastRent, vacancy, deposits, repairs, property tax, debt, capex, and depreciation.
Manufacturing inventory cash flow forecastRaw materials, WIP, finished goods, AP timing, labor, capex, and cash.
Consulting project AR cash flow forecastRetainers, milestone billing, accounts receivable, subcontractors, payroll, and tax.
Cash
Cash Flow and Operating Planning
Trial balance to 3-statement forecastUse starting TB data as the forecast base.
Cash flow forecast with collection and payment lagAR, AP, working capital, and ending cash timing.
COGS, inventory, and working capital forecastGross margin, inventory purchase, AP timing, and cash flow.
Startup cash runway forecastBurn rate, hiring, collection timing, and runway.
SaaS deferred revenue and MRR forecastAnnual prepayment, deferred revenue, MRR, ARR, and cash receipts.
Payroll withholding cash flow forecastSalary payment, withholding liability, and social insurance timing.
Finance
Debt, Equity, Tax, and Investment Entries
3-statement forecast for DCF assumptionsOperating assumptions for DCF planning.
Loan draw and debt repayment forecastBorrowing, repayment, interest, debt balance, and cash.
Bank loan covenant and DSCR forecastDebt service, covenant headroom, and repayment capacity.
Bank submission forecast checklistPrepare lender-facing assumptions, DSCR, repayment, and Excel output.
Bond issuance and redemption forecastBond issuance, interest accrual, redemption, and conversion.
Equity financing and share issuance forecastCapital stock, capital surplus, warrants, options, and runway.
Deferred tax and temporary difference forecastDTA, DTL, reversal timing, and cash tax review.
Niche
Specialized Accounting Forecasts
Capex and depreciation forecastFixed asset additions, useful life, depreciation, and cash outflow.
Lease liability and right-of-use asset forecastLease payment, interest split, depreciation, and cash flow.
Asset retirement obligation forecastARO recognition, accretion, settlement, depreciation, and cash.
Acquisition goodwill and PPA forecastGoodwill, PPA assets, deferred tax, amortization, and acquisition debt.
Securities and derivatives forecastValuation, settlement, hedge entries, and cash impact.
Warranty and restructuring provision forecastProvision accrual, reversal, payment timing, and cash flow.
Retirement benefit obligation forecastBenefit expense, liability movement, payment timing, and cash.
Bad debt allowance forecastAllowance movement, receivable write-off, reversal, and recovery.
Foreign currency and FX revaluation forecastFX gain/loss, revaluation, settlement, and forward valuation.
Intercompany elimination and consolidation forecastIntercompany AR/AP, loans, sales, dividends, goodwill, and NCI.
VAT and sales tax cash flow forecastTax payable, refunds, settlement timing, and cash impact.
Grant and subsidy cash flow forecastReceivables, receipts, deferred release, and runway.
日本語
日本語ガイド
無料で3表予測を作る手順
開始TB CSV取込を正しくやる方法
開始TB CSVフォーマット
3表予測の勘定科目マッピング
Web予測とExcel出力の違い
数式付きExcel出力
Excelなしで無料の財務予測を始める
中小企業の月次資金繰り予測
会計に詳しくない人向けの財務予測
試算表から3表予測を始める方法
入金サイト・支払サイトの資金繰り予測
DCF用の3表予測
借入・返済を含む3表予測
設備投資・減価償却の3表予測
スタートアップの資金繰り・ランウェイ予測
売上原価・在庫・運転資金の3表予測
融資・返済余力・DSCRの3表予測
銀行提出用の3表予測チェックリスト
飲食店の資金繰り予測
EC在庫と資金繰りの3表予測
建設業の工事別資金繰り予測
クリニック・歯科医院の資金繰り予測
美容室・サロンの資金繰り予測
不動産賃貸の資金繰り予測
製造業の在庫・資金繰り予測
受託・コンサルの売掛金資金繰り予測
飲食店の資金ショート予測
建設業の銀行提出用資金繰り予測
ECのExcelなし在庫資金繰り予測
クリニックの設備借入・銀行提出予測
製造業の在庫資金ショート予測
開始TB取込後にBSが合わないとき
銀行提出前のExcel出力チェックリスト
勘定科目の符号ミスと資金繰り予測
開始BSを初期化して予測を見直すとき
予測キャッシュ残高がマイナスになる原因
借入返済がキャッシュフロー予測に反映されないとき
減価償却費でキャッシュは直接減らない予測の見方
売掛金の回収サイトで資金繰り予測がずれるとき
在庫仕入でキャッシュが減る資金繰り予測
無料Web予測と銀行提出向けExcel出力の使い分け
試算表の借方・貸方が逆の予測ミス
利益剰余金で開始BSが合わないとき
買掛金の支払サイトで資金繰りがずれるとき
税金支払月で資金繰りが苦しくなるとき
ChecksタブでBS不一致を確認する方法
消費税納付・還付の資金繰り予測
SaaS前受収益・MRR・ARRの3表予測
給与・源泉所得税・社会保険料の資金繰り予測
補助金・助成金の入金と資金繰り予測
リース負債・使用権資産の3表予測
買収・のれん・PPAの3表予測
増資・新株発行・ストックオプションの3表予測
税効果・一時差異・繰延税金の3表予測
資産除去債務・利息費用・履行支払の3表予測
社債発行・社債利息・償還の3表予測
有価証券・デリバティブ・繰延ヘッジの3表予測
製品保証引当金・事業再編引当金の3表予測
退職給付債務・退職給付費用の3表予測
貸倒引当金・貸倒損失の3表予測
外貨建取引・為替差損益の3表予測
連結消去・親子間取引の3表予測
Trust