This guide walks you through creating a company, setting up a project, and adding a scenario in PlanGuru. You’ll also learn how to configure your chart of accounts and prepare for forecasting.
1️⃣ Creating a Company
From the Home Page:
-
In the Select a Scenario window, click the green “Create Company” button at the bottom.
-
Enter:
-
Company Name
-
Entity Type
-
Geographical Information (Optional)
-
-
Select your Starting Month for the fiscal year.
⚠️ Important: This setting is inherited by all projects and scenarios within the company and cannot be changed later.
-
Default is January
-
Adjust to match your fiscal year
-
2️⃣ Creating a Project
After creating your Company, you’ll be prompted to create a Project. Choose from three project types:
Project Type | Purpose | Common Use |
---|---|---|
Budget | Sets business goals for the year and creates a baseline for comparison | Annual planning |
Forecast | Updates budget assumptions and supports scenario planning month-to-month | Rolling forecasts |
Strategic Plan | Long-term direction with high-level projections | Multi-year strategy |
💡 Each option has tooltips that explain its purpose and default settings.
You can select one, a combination, or all three.
Your selection will:
-
Set the default model structure (projected years, monthly vs. annual breakdown)
-
Generate a default Project Name (you can edit this later)
-
Prompt you to specify organizational structure (Single Entity; Multi-Departmental available in Free Trial via special request)
-
Ask if you use Account Numbers (check the box if yes and define your account mask per the provided legend)
3️⃣ Adding a Scenario
Once the project is created:
-
Enter a Scenario Name (default: Base Case)
-
Set the Budget Year (first year for projections)
-
Choose Number of Years to plan (up to 10 years)
-
Select how many years are broken down by month (up to 3 years; remaining are annual totals)
-
Define the Forecast Month (first projection month; useful if starting mid-fiscal year)
-
Select Historical Years to include (default: 3; up to 5) and whether they are monthly or annual
Example: If your fiscal year starts in January but you start in April, set Forecast Month to April so you can include actuals for Jan–Mar.
Click Submit to generate your model based on these settings.
4️⃣ Setting Up Your Chart of Accounts
Once the model is loaded, set up your chart of accounts:
Importing Accounts
-
Use PlanGuru's import integrations with QuickBooks Online, Xero, or Excel
See these separate tutorials for step-by-step instructions:
Creating Accounts Manually
-
Right-click → Add Account
-
Enter:
-
Account Number (if applicable)
-
Account Description
-
Account Type (e.g., Trade Receivables, Inventory, Other Current Assets)
-
-
Choosing an Account Type will display relevant projection methods.
5️⃣ Adding Historical Data
To manually input historical data:
-
Open Viewing Options
-
Check Historical Years
-
Expand the year and enter numbers in beige cells (beige = editable)
6️⃣ Creating Account Groups
To organize accounts:
-
Highlight the accounts
-
Right-click → Create Group
-
Assign subaccounts to roll up into their respective parent accounts
This lets you plan and report at both subaccount and parent account levels.
7️⃣ Next Steps: Selecting Projection Methods
Once your chart of accounts is ready:
-
Begin selecting your Projection Methods
-
See our Forecasting & Modeling Overview video for detailed guidance