Plan Structure Overview
A plan is a table that consists of measures and dimensions that stores financial data and enables you to use calculations in order to create budgets.
For example, your plan might look like the following tables.
Year | 2025 | |||||||
---|---|---|---|---|---|---|---|---|
Quarter | Q1 | Q2 | ||||||
Period | 001 | 002 | 003 | 004 | ||||
GLA | Home | Dual | Home | Dual | Home | Dual | Home | Dual |
1100 - Accounts Receivable | 5,500.00 | 5,891.34 | 7,750.00 | 8,301.43 | 13,000.00 | 13,924.98 | 5,000.00 | 5,355.76 |
2000 - Accounts Payable | -1,500.00 | -1,606.73 | -2,500.00 | -2,677.88 | -5,000.00 | -5,355.76 | -1,250.00 | -1,338.94 |
Year | 2025 | ||||||||
---|---|---|---|---|---|---|---|---|---|
Quarter | Q1 | Q2 | |||||||
Period | 001 | 002 | 003 | 004 | |||||
Project | Role | Billing | Cost | Billing | Cost | Billing | Cost | Billing | Cost |
Fortis Technology - Phase 1 Implementation | Project Manager | 8,400 | 7,000 | 7,200 | 6,000 | 6,000 | 5,000 | 6,000 | 5,000 |
Fortis Technology - Phase 1 Implementation | Business Analyst | 4,000 | 3,800 | 5,000 | 4,750 | 6,000 | 5,700 | 7,000 | 6,650 |
You can create plans in several ways:
- Blank plan - Create a plan by manually entering your data
- Data source - Create a plan by importing your data from an Analytics dataset
Each plan can have up to six measures and up to 12 dimensions. Dimensions are displayed as columns or rows and contain categorical data, such as company names, years, or quarters. Measures are displayed as either columns or rows and contain quantitative data, such as currency or time.