Overview: Plan Tables.

Utilize Plan Tables to enter all the essential information for your various planning scenarios.

Plan Tables serve as the central location for entering all the essential information for various planning scenarios such as a budget or forecast. These tables offer the flexibility to input values directly or use drivers to automate the planning process and establish interdependencies within the plan.

Navigate to the various Plan tables from the left menu in the Plan area. 

  • The Income Statement (Revenue, COGS, OpEx, Other) and Balance Sheet (Assets, Liabilities,  Equity) tables are automatically generated from the accounting system. The structure can optionally be modified from Setup ⚙️ >  Chart of Accounts. 
  • The Staffing table contains the list of current staff members imported from the Workforce import, as well as any future planned hires.
  • The Custom Tables contain all the personalized lines that have been specifically defined for your Jirav account within Custom Tables. This includes things like a Marketing Funnel, data imported from the CRM system, or custom key performance indicators. 

Income Statement Table Plan Table Overview

  • Utilize the department filter to slice data by department. Data rolls up to the company level automatically.
  • Select a specific department to input manual amounts and sub-items. Manual input is not available when the department filter is set to "All."
  • Utilize plan drivers to forecast future planning periods with mathematical expressions. Optionally create variables within the driver as an assumption.  For example, if benefits are planned as a $1,000 per employee, the driver would be Headcount * $1,000 and the $1,000 would be an assumption.
  • Plan drivers, sub-items, and manual inputs can be combined for any account and will sum to the total. 
  • Review and manage plan drivers and assumptions by clicking on the fx and gear head icons from the right menu.

Balance Sheet Table Plan Table Overview

  • The prior month's balance of all balance sheet accounts will automatically roll forward.
  • Plan for the increase or decrease to the previous month's balance to forecast future planning periods. For example, for Accounts Receivable the increase would be new billings and the decrease would be collections. 
  • The increase or decrease to the previous month's balance can either be manually input or calculated with plan drivers and assumptions. For example, a series A round of funding is expected in July, it is likely best to input the one-time increase to equity manually in July. Whereas if bonuses are accrued monthly and paid quarterly, it would be best to use drivers for the accrual (increase) and payout (decrease). 

Staffing Plan Table Overview

  • Headcount | Salaries
    • Displays a summary of Headcount and Salaries by Department, Position, and employee in the first table. This table is reflective of any changes to headcount per the Manage Staff and Driver Based Hires tables. 
  • Manage Staff
    • Contains a list of all actual employees imported from the payroll system (white rows) and named planned hires(blue rows). 
    • Update any blue field for planned changes.
  • Driver Based Hires
    • Utilize plan drivers to forecast future hiring needs with a mathematical expression. Optionally create variables within the driver as an assumption.  For example, if each Customer Success Manager is responsible for 500 customers, you could create a driver that hires an additional Customer Success Manager for every 500 Customers you are planning to acquire. The 500 threshold could be an assumption. 

Custom Table Plan Table Overview

  • Utilize plan drivers to forecast future planning periods with mathematical expressions. Optionally create variables within the driver as an assumption.  
  • Review and manage plan drivers and assumptions by clicking on the fx and gear head icons from the right menu.
  • Global Drivers are available in Custom Tables to calculate custom key performance indicators or metrics where the formula will never change. For example, you might create EBITDA as a Custom Line and use Global Drivers to add back the desired accounts to Net Income. 
  • Global Drivers are prefixed with a [GL] in Custom Tables and the formulas are managed from Setup ⚙️ > Global Drivers.