Guides
Practical Forecast Guides
Searchable guides for free web forecasting, paid Excel output, trial balance import, cash timing, and niche accounting forecast entries.
46
English guide topics.
46
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.
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表予測
建設業の工事別資金繰り予測
クリニック・歯科医院の資金繰り予測
美容室・サロンの資金繰り予測
不動産賃貸の資金繰り予測
製造業の在庫・資金繰り予測
受託・コンサルの売掛金資金繰り予測
消費税納付・還付の資金繰り予測
SaaS前受収益・MRR・ARRの3表予測
給与・源泉所得税・社会保険料の資金繰り予測
補助金・助成金の入金と資金繰り予測
リース負債・使用権資産の3表予測
買収・のれん・PPAの3表予測
増資・新株発行・ストックオプションの3表予測
税効果・一時差異・繰延税金の3表予測
資産除去債務・利息費用・履行支払の3表予測
社債発行・社債利息・償還の3表予測
有価証券・デリバティブ・繰延ヘッジの3表予測
製品保証引当金・事業再編引当金の3表予測
退職給付債務・退職給付費用の3表予測
貸倒引当金・貸倒損失の3表予測
外貨建取引・為替差損益の3表予測
連結消去・親子間取引の3表予測
Trust