These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Financial Planning & Analysis
- Data model
The tables behind Financial Planning & Analysis
Financial Planning & Analysis ships with 15 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 15
- Features
- 8, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Planning
Plans own plan lines for cost center budgets and forecasts.
Forecasting
Forecast versions reference forecast drivers, business partners, Organizations and team members.
Financial records
Accounting periods group accounting documents; document lines and cash receipts connect detail and cash to documents.
Evidence
Review decisions, record attachments and operation receipts hold decisions, files and action results.
Reference data
Organizations, business partners and team members provide ownership and counterparties.
Every table, by feature
- Plans and cost centers4
- Budget versus actual2
- Forecast drivers3
- Forecast versions5
- Plan review5
- Accounting periods5
- Documents and cash5
- Review evidence4
- Shared and settings1
- Plans
Budget and forecast plan headers with period, owner, version and approval status.
Linked to Organizations, Team members - Plan lines
Cost center budget and forecast lines with quantity, unit rate and amount.
Linked to Plans - Organizations
Business units and legal entities that own plans, revenue and billing activity.
- Team members
Planners, billing operations and revenue staff who own plans, runs and reviews.
Linked to Organizations
- Plans
Budget and forecast plan headers with period, owner, version and approval status.
Linked to Organizations, Team members - Plan lines
Cost center budget and forecast lines with quantity, unit rate and amount.
Linked to Plans
- Forecast drivers
Driver catalogue used to build driver-based forecasts: driver name, unit, rate, driver type, default forecast basis and category.
- Forecast versions
Versioned forecast records phased across a planning term, linked to a business partner and a forecast driver, carrying forecast amount, actual-to-date, unforecast balance and percent actual.
Linked to Business partners, Forecast drivers, Organizations, Team members - Document lines
Line-level detail behind each accounting document, linked to a forecast driver and forecast version.
Linked to Accounting documents, Forecast drivers, Forecast versions
- Forecast versions
Versioned forecast records phased across a planning term, linked to a business partner and a forecast driver, carrying forecast amount, actual-to-date, unforecast balance and percent actual.
Linked to Business partners, Forecast drivers, Organizations, Team members - Forecast drivers
Driver catalogue used to build driver-based forecasts: driver name, unit, rate, driver type, default forecast basis and category.
- Business partners
External business partner directory with contact email, payment terms, partner status, country, credit limit and industry.
Linked to Team members - Organizations
Business units and legal entities that own plans, revenue and billing activity.
- Team members
Planners, billing operations and revenue staff who own plans, runs and reviews.
Linked to Organizations
- Plans
Budget and forecast plan headers with period, owner, version and approval status.
Linked to Organizations, Team members - Plan lines
Cost center budget and forecast lines with quantity, unit rate and amount.
Linked to Plans - Review decisions
Approval decisions on plans, billing runs, invoices and revenue schedules.
Linked to Team members, Plans, Accounting periods, Accounting documents - Operation receipts
Executed-operation evidence with operation type, actor, result and document URL.
Linked to Team members - Record attachments
Files attached to any parent record with kind, uploader and timestamp.
Linked to Team members
- Accounting periods
Planning and close cycles for a period: which accounting documents are ready, blocked or need review, with period document value and linked document count.
Linked to Organizations, Team members - Accounting documents
Documented financial records with document date, status lifecycle, counterparty, gross value, cash applied, balance due and aging state.
Linked to Business partners, Accounting periods, Organizations, Team members - Operation receipts
Executed-operation evidence with operation type, actor, result and document URL.
Linked to Team members - Organizations
Business units and legal entities that own plans, revenue and billing activity.
- Team members
Planners, billing operations and revenue staff who own plans, runs and reviews.
Linked to Organizations
- Accounting documents
Documented financial records with document date, status lifecycle, counterparty, gross value, cash applied, balance due and aging state.
Linked to Business partners, Accounting periods, Organizations, Team members - Document lines
Line-level detail behind each accounting document, linked to a forecast driver and forecast version.
Linked to Accounting documents, Forecast drivers, Forecast versions - Cash receipts
Recorded cash receipts against a business partner and accounting document, with method, status and bank reference.
Linked to Business partners, Accounting documents, Team members - Business partners
External business partner directory with contact email, payment terms, partner status, country, credit limit and industry.
Linked to Team members - Accounting periods
Planning and close cycles for a period: which accounting documents are ready, blocked or need review, with period document value and linked document count.
Linked to Organizations, Team members
- Review decisions
Approval decisions on plans, billing runs, invoices and revenue schedules.
Linked to Team members, Plans, Accounting periods, Accounting documents - Record attachments
Files attached to any parent record with kind, uploader and timestamp.
Linked to Team members - Operation receipts
Executed-operation evidence with operation type, actor, result and document URL.
Linked to Team members - Team members
Planners, billing operations and revenue staff who own plans, runs and reviews.
Linked to Organizations
Keys and references
Preserve the plan number, forecast reference, period number and document number during migration. Match plan lines to the intended plan and cash receipts to the intended accounting document. Keep the organization and team member references consistent across a working cycle. Record attachments identify a parent table and parent record; check both before accepting a file as review evidence.
Migration order
- Reference data. Load Organizations, team members, business partners and forecast drivers.
- Planning. Load Plans, then plan lines and forecast versions with their references.
- Period records. Load accounting periods before accounting documents, document lines and cash receipts.
- Evidence. Load review decisions, record attachments and operation receipts after their parent records can be resolved.
Set up Financial Planning & Analysis your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.