Forecast & Accruals (FASBA)¶
Overview¶
The Forecast & Accruals capability provides WIP period management, accrual forecasting, and rolling forecast analysis using Tecto 365's FASBA (Igangværende Arbejder) extension. It extends existing project and GL models with WIP period context and adds dedicated accrual forecast tracking.
This capability powers the forecast and accrual report pages — enabling period-over-period analysis of project forecasts.
Semantic Model Tables¶
Dimensions¶
| Table | Description |
|---|---|
| WIP Period | Tecto WIP Period definitions — period code, description, and date range. The core time dimension for FASBA reporting. Includes "current" and "actual" flags for filtering |
Facts¶
| Dim Table | Fact Table | Description |
|---|---|---|
| Accrual Forecast | Accrual Forecasts | Accrual forecast entries — cost, sales, profit in TR and CS views. Links to sell-to and bill-to customers (resolved from project task with project-level fallback). Includes remaining amounts, benchmark amounts, and rolling forecasts |
Power BI–Only Tables¶
These tables exist in the semantic model for report filtering but have no corresponding data pipeline:
| Table | Description |
|---|---|
| WIP Benchmark | Benchmark configuration for WIP analysis — provides benchmark comparison context |
| WIP Period Perspective | WIP period perspective slicer — enables switching between different period views |
Module Overrides¶
The Forecast & Accruals capability adds FASBA-specific fields to several base models:
| Override | Change |
|---|---|
| Project, Project Task | Adds FASBA-specific attributes for WIP-aware project analysis |
| General Ledger, Budget | Adds WIP period and project linkage from FASBA extension fields |
| Financial Report Row | Adds WIP period context for financial statement rendering |
Key Measures¶
WIP Period (2)¶
Selected WIP Period Code, Last WIP Period Code
Accrual Forecasts (30)¶
| Category | Measures |
|---|---|
| TR | Cost TR, Sales TR, Profit TR, Amount TR |
| CS | Cost CS, Sales CS, Profit CS, Amount CS |
| Remaining | Cost Remaining CS, Sales Remaining CS, Profit Remaining CS, Amount Remaining CS, Amount Remaining CS AP |
| Future WIP Periods | Future Amount CS, Future Sales CS, Future Cost CS, Future Profit CS |
| Benchmark | Benchmark Amount CS, Benchmark Cost CS, Future Benchmark Amount CS |
| Rolling Forecast | Amount RCS, Sales RCS, Cost RCS, Profit RCS, Margin RCS, Amount RCS AGG |
| Benchmark Rolling | Benchmark Amount RCS, Benchmark Amount RCS AGG |
| Period-over-Period | Rolling Forecast Amount Benchmark Margin PoP, Benchmark PoP |
Use Cases¶
- WIP reporting — Track work-in-progress amounts by WIP period for accurate financial reporting
- Accrual forecasting — Analyze forecast cost, sales, and profit with remaining amount visibility
- Rolling forecasts — Monitor how forecasts evolve across WIP periods with rolling aggregate views
- Benchmark comparison — Compare actual and forecast amounts against benchmarks
- Period-over-period analysis — Track forecast changes between consecutive WIP periods
- Customer-level accrual analysis — Break down accrual forecasts by sell-to and bill-to customer for project profitability insights