Welcome
Sheets
Workflows
| Task | Owner | Status | Priority | % Complete | Due Date | Current Step | Next Action | Actions |
|---|
Dashboards
Tiles
Build a tile once, drop it onto any dashboard. Custom Tile supports multi-scenario, multi-year, and calculated P&L lines (Net Income, EBITDA, etc.).
Calculations
Saved Calculations
Edit Calculation
MDX-lite Cheat Sheet
[COA].[Revenue]— reference a member[Scenario].[Actual] - [Scenario].[Budget]— cross-dimIF(cond, a, b)/ABS(x)/ROUND(x,n)YTD([COA].[Revenue])— year-to-dateQTD([COA].[Revenue])— quarter-to-datePRIOR([COA].[Revenue])— previous periodROLLING([COA].[Revenue], 3)— 3-period rolling avgPARALLELPERIOD(-12, [COA].[Revenue])— 12 periods back<>for not-equal (MDX style)
Dimensions
Scenarios
Reports
Stored Reports
Workforce
Edit per-cube rates and wage bases. Changes apply on the next Generate.
Set the number of pay periods that fall inside each calendar month. Biweekly schedules produce 2 pays in most months and 3 in two "magic" months — enter those here so Generate spreads annual salary correctly.
Map each workforce cost item to a leaf account. Items without an account are skipped during Generate.
Fixed Assets
SaaS Customers
Sub-Ledger
Data Sources
Forecast
Generate a forecast
Run-rate × seasonality: each (account, dept, location, driver) slice gets its own 12-month forecast built from history. The engine extracts a seasonal curve from all history years, takes the last N months of the most recent year as the run-rate, deseasonalizes it, and projects forward.
Point-in-time snapshots (M+N)
Freeze "Actuals-through-month-M + Forecast-for-the-rest" as an immutable scenario. Ideal for month-end 3+9 / 6+6 / 9+3 cuts you'll compare later to see how the forecast shifted.
Rolling 12-month forecast
Always looks n..n+11 months forward from the pivot. Backed by the live Rolling Forecast scenario — snapshot it from Settings → Scenarios when you want to freeze a version.
Driver Based Planning
Driver Inputs
Pick a row above to enter driver values for that slice.
Cost Allocations
Allocation rules
Distribute shared costs (rent, IT, G&A) from one department across many. Each rule reads a source slice — an account paid by one dept — and spreads it to a list of target depts using either a dynamic driver (a value in the cube, e.g. headcount) or a rigid driver (manual percents that sum to 100). The engine writes target-positive rows plus a single contra-negative at the source, so totals balance and the raw entry stays intact for audit.
Cash Flow
Indirect-method cash flow derived from the current scenario + year filter. Operating activities start from Net Income, add back non-cash expenses, and adjust for working-capital movement. Investing covers CapEx. Financing covers debt / equity / dividends. Need a balance sheet to start — run Settings → Integrations → Seed balance sheet demo data if your cube doesn't have one yet.
Variance alerts
Rules
Each rule watches one account across two scenarios. When the variance crosses its threshold, recipients get a bell notification. Run checks on demand (scheduled auto-checks are on the roadmap).
Comparisons
Pin any two scenarios side-by-side to see variance ($ and %). Flip the row dimension to compare by account, department, location, or driver.
Settings
General
Organization-wide defaults. Changes here affect all users of this cube.
Company logo
Uploads a PNG, JPG, SVG, or WebP (max 1 MB) that renders in the header next to the Forecastle wordmark. Visible to every user of this cube.
Preferences
These settings are saved in your browser only — they don't affect other users.
Integrations
Connect Forecastle to the tools your team already uses.
Excel Add-In
Install the Forecastle FP&A add-in in Excel to load and edit cube data directly from spreadsheets.
Xero
One-way sync from Xero into Forecastle. Populates your Chart of Accounts and monthly P&L actuals from the connected Xero organisation. Re-running a sync is safe: only rows tagged as Xero-sourced are replaced.
QuickBooks Online
One-way sync from QuickBooks Online into Forecastle. Populates your Chart of Accounts, classes, and departments — plus monthly P&L actuals and balance-sheet snapshots — from the connected QBO company. Requires QBO Plus or Advanced for class / department tracking.
Quick Mapping — P&L categories
Assign your chart of accounts to the six standard P&L leaves so Cash Flow, Full P&L, and future forecasting tools work regardless of how your accounts are named. Gross Profit / EBITDA / EBIT / Net Income are derived automatically.
Currency & FX
Define the cube's reporting currency and enter exchange rates for every source currency you need to translate. Rates are entered as source → reporting multipliers (e.g. 1 EUR = 1.07 USD ⇒ enter 1.07 on the EUR row when reporting = USD).
Exchange rates
Phase 1 (shipped): rate admin. Phase 2 (coming): pivot/dashboard values auto-translate to the reporting currency using these rates.
Database Connection
Only edit this if your database host or credentials change. You'll need to re-test before saving.
Tenants
Every customer gets their own Postgres schema. Provision a new tenant, rename, or impersonate a tenant for troubleshooting. Only superusers can see this tab.
Users
Accounts that can sign in to this cube. Edit permissions, reset passwords, or deactivate accounts.
Audit log
Append-only history of every cell change. Filter by account or user to narrow down.
Guided tour
Pick the tools you want Percival to walk you through. Three-click tour per feature — we'll land you on the right tab and explain what you're looking at.
You can run this as many times as you like — when you want a refresher or when a new teammate needs onboarding.
Ops Console
Platform-wide view. Only visible to superusers. Suspending or deleting a tenant will kick every active user of that tenant immediately.