Setup and Preparation for Capacity Planning

Plan: Not Available: Intermediate, Pro Available: Elite

Users: Not Available: All users Available:FYI Admins or User Group Permissions

Practice Management Source: Not Available: APS, Iris, MYOB AE & AO, CCH, MYOB Practice Management (formerly GreatSoft) Available: FYI or Xero Practice Manager

The Capacity Planning Report helps practices forecast workload and manage team availability. Before running the report, you must set up the Capacity Planning Template, Job Views, and Automation Processes.

Before You Begin

Before setting up Capacity Planning in FYI, consider the following details. Completing this preparation ensures that all data for users, jobs, and processes are accurate when setting up the Capacity Planning Template, Job Views, and Automation Processes.

Users

Consider which users will be included, and ensure their hours and leave are up to date.

  • Determine which task assignees will be included in the Capacity Planning Report.
  • For each user, confirm their weekly available hours and productivity target, for example, 80%.
  • Review upcoming leave and public holidays for all users. These dates will be recorded in the Leave worksheet of the Capacity Planning Report Template.
Jobs and Views

Prepare the Job data and Job Views to ensure accurate report results.

  • Determine which jobs the Capacity Planning Report will include.
  • Review and define the filters to be used in your Job Views to ensure that only the relevant jobs are included in the Capacity Planning Report.
  • Review the mapping preferences in the Job Practice Settings to specify whether capacity calculates forward from the Start Date or backward from the Due Date.
  • Verify that each Job includes a Start Date, Due Date, and Budget Hours (or Estimated Hours, depending on your FYI plan). If using a Custom Field for the Job Start Date, and a date is not entered, FYI will use the standard Job Start date field instead. Missing data will cause incomplete report results.
Automation Processes and Tasks

Prepare the tasks and time allocations used in Capacity Planning.

  • Identify the Automation Processes that will be used for Capacity Planning, or decide whether new ones should be created.
  • List all tasks that will be included in Capacity Planning. Each task must have an Assignee, Due Date, and Default Time Allocation. Each task will be set up as a step in a Process, or as a task created by an email or document step.
  • Decide on the Time Allocation method for each task: Fixed (same duration for all jobs) or Relative (proportionate to job size or Budget Hours). If using Relative, calculate the time required to complete the task for an average-sized client, and ensure that Budget Hours has been entered into FYI for each job.

Step 1 - Setting up the Capacity Planning Template

To prepare the Capacity Planning Report Template:

  • The Capacity Planning Excel Template must be added to the Knowledge cabinet.
  • The Employees worksheet must be configured with the weekly hours for the users assigned to tasks in the Processes.
  • The Leave worksheet must be configured with the leave dates for the users assigned to tasks in the Processes.

The weekly hours and the leave dates are used to calculate the time Available for the assigned users.

Important Note: Other than the Employee details and Leave date details, all other settings in the Template must not be changed.

The Capacity Planning Report uses advanced Excel functions, such as Pivot Tables. Any other modifications to the provided template may affect how Capacity Planning is calculated and displayed. If changes are made that cause errors or prevent the feature from running correctly, the FYI Support team may be unable to assist.

Download the Latest Capacity Planning Template

Click here to download the latest version of the Capacity Planning Template, or refer to the Managing FYI Excel Master Report Templates article.

Note: Do not upload this file yet to FYI. You will need to edit the Template to add Employees and Leaves, prior to uploading the Template. 

Configure the Employees Worksheet

The Employees worksheet tab is used to track the available hours for users. This can be set up for all users within the practice, or only those assigned to tasks in the Processes used when running the report.

When running the Capacity Report, any users assigned to tasks that are not in the template will be automatically inserted in the first blank row of the Employees Worksheet.

To update the Employees Worksheet:

  1. In FYI, navigate to the Knowledge - Templates tab.
     
  2. Edit the Capacity Planning template. 
     
  3. Click on the Employees worksheet.
     
  4. In the Name column, enter the Employee Name exactly as it displays in FYI
     
  5. Enter the user's available hours into the Weekly hours column. 
    This is the number of hours available for tasks involved in Capacity Planning. For example, if a user works 40 hours full-time, but is only available half of that time for these tasks, enter 20 into the Weekly Hours.
     
  6. Add the productivity target into the Productivity column as a decimal. For example, 80% is entered as 0.8.
     
  7. The Available Hours will be automatically calculated.

2201_Template_Employees_Capacity_Planning.gif

Configure the Leave Worksheet

The Leave worksheet holds the information about any upcoming Leave dates for your users, including Public Holidays or annual leave. This will need to be reviewed and updated where necessary before each time the Capacity Report is run.

This can be set up for all users within the practice, or only those assigned to any tasks in the processes used when running the report.

Each day should be added as a separate entry to ensure the leave is applied correctly when the Capacity Report is run. For example, if a user is taking 5 working days as annual leave, there should be 5 rows in the spreadsheet. For public holidays, a separate row will need to be added for each user.

There is no need to record weekend dates in the Leave worksheet. The report runs on a seven-day cycle, so weekends will not affect practices using Capacity Planning at a monthly level. However, if you are running Capacity Planning at a weekly level, you should include weekend dates in the worksheet.

  1. In the Name column, enter the Employee Name exactly as it displays in FYI
     
  2. Enter the start Date of the leave, e.g. 06/10/2025.
     
  3. Enter the total Leave Hours being taken for each day, e.g. 8.0 hours.

The following is an example of the Leave dates for users including a Public Holiday, and one user taking a week of leave.

2202_Template_Leave_Capacity_Planning.gif

Once these steps have been completed, save the Template. You will be instructed to import the template into FYI after creating the required Job Views.

Step 2 - Create Job Views

For each Process used in Capacity Planning, a Job View needs to be set up and selected as the Filter in the Process. 

The Job View determines the Client Jobs used when calculating the capacity required. For example, to run a Capacity Planning Report for jobs due to begin next quarter, create a Job View with a filter for the Job Start Date covering the next quarter.

You can use existing Job Views or create new ones specifically for Capacity Planning. Once the Processes have been set up, additional Views can be added as and when needed and used to run the Capacity Planning Reports.

When running the Capacity Planning Report, a different view can be selected from the View selected in the Automation Process. For example, if the default is filtered by a particular division for the next quarter, when running the Capacity Planning, a view can be selected for a different division, or changed to a view of jobs due in the next six months.

This allows you to run the report without having to make any changes to the process, including where the same process is also used outside of Capacity Planning.

To create the Job Views for Capacity Planning:

  1. In FYI, click the Jobs menu to load the Jobs List.
    2151 NL Jobs List.gif
  2. Customise the Job List by adding and removing columns as needed, and applying any required filters, for example, filtering to Annual Compliance Jobs, or by the Job Start or End Date. 
     
  3. Save the view.
     
  4. Repeat the steps to create additional views as required.

Step 3 - Importing the Report Template into FYI

Once the report has been downloaded and your practice data and Job Views are set up, the Capacity Planning Report Template must be imported to the Knowledge workspace.

  1. In FYI, click the Knowledge menu option at the top. 
     
  2. Drag and drop your Capacity Planning Report Template into the Knowledge - Templates list.
     
  3. Update the Name if required.

    Merge Fields can be used to customise the name each time a report is created. For example, when running a Capacity report in January 2025, using a Merge Field of "Capacity Report - {{ "now" | date: "%B %Y" }}", the report would be created with the name "Capacity Report - January 2025". Refer to Formatting Merge Fields for detailed information on available formatting options.
     
  4. Click Create to import the template into your Templates list.
    4530_Capacity_Planning_Report_Import.gif
  5. From the Filing section in the drawer, ensure the following fields are configured:

    - Merge Fields option is toggled Off.
    - Merge Names is toggled On.
    - Excel Report is toggled On
    3022_Import_capacity_report_to_templates_list.gif
  6. Select the default View type and View to run the report for. This can be changed when running the report.
     
  7. Update the AutoFile Defaults to the relevant cabinet and categories. You may wish to use a Cabinet that is only available to users in a User Group with Cabinet Security enabled. The filing details can be changed when running the report.
     
  8. Set the Status field to Active.

Step 4 - Setting up the Automation Processes

Your practice is responsible for setting up the Automation Processes used in Capacity Planning. New Processes can be created specifically for Capacity Planning, or existing processes can be adapted, for example, Checklists or BAS Reminders. 

For detailed information on creating and testing processes, refer to Custom Processes. Information on individual steps is available from the Process Step Details section.

When running the Capacity Planning Report, you can select multiple Processes. Results from all selected Processes are combined, allowing flexibility in how Jobs are selected via different Views.

These Processes define the Tasks and required time calculated by the Capacity Planning Report. Tasks may be stand-alone or linked to document actions, for example, sending an email, creating a document, or scheduling a meeting. Each Task used for Capacity Planning must include a time allocation.

Note: When running the Capacity Planning Report, any selected Processes will not create emails, documents, or tasks. They will only be used to calculate the time allocation. Run the Custom Process to complete each step and create documents and tasks as required.

Selecting the View for the Process Filter

The Filter in the Process must be set to Job - View Filters, and a Job View must be selected. The View that is selected in the process will be offered as the default when the Capacity Planning Report is run.

4567_Automation_Filter_Job_View_Filters.gif

Adding Task Steps with the Assignee and Due Date

All Process steps used for Capacity Planning must have a Task with an Assignee and Due Date. This can be done from the Create Task step, or from the Task section of a drawer when using an automation step to create a document.

Create Task Step Task Section in the Step Drawer

For a Create Task step, the Assignee and Due Date are selected in the relevant fields.

2203_Assignee_in_Step_for_Capacity_Planning.gif

Task Field Details
Assignee

Determines the user against whom the Allocated time will be added to in the Capacity Planning Report.

You can select a specific person as the Assignee, or use Merge Fields to select the Job Partner, Manager, or a Custom User Role. If the Job does not have a Partner/Manager/Custom User Role, the task Assignee will be "Unassigned".

Due Date

Determines when the Task will be completed, and therefore whether or not it falls within the period for which the Capacity Planning is being run.

The Due Date is relative to the Start Date of each of the Jobs that trigger the Process (as determined by the Job View that is selected when the Process runs), plus the Due Date in the Process Step. It is not the Due Date of the Job itself.

Merge Fields can be used to select the Due Date, for example, a Job Custom Field.

The Month and the Week selected for Capacity Planning are based on the date at the start of the week where the Due Date falls. For example, a Due Date is calculated to be 01-08-2023 (Tuesday). However, the start of the week is 31-07-2023. In this scenario, the Month for Capacity Planning is July.

Setting the Default Time Allocation in Process Steps

Each Task Step must include a Default Time Allocation, used by the Capacity Planning Report to calculate the time for tasks assigned to each user.

2204_Time_in_Step_Capacity_Planning.gif

The Default Time is set as the estimated time that the action or Task would take for an 'average' size Job, and entered as hours and minutes. For example:

  • 00:05 for 5 minutes
  • 00:45 for 45 minutes
  • 01:00 for 1 hour
  • 01:30 for 1 hour and 30 minutes

When selecting the Allocation method, time can be entered as either Fixed or Relative.

Allocation Detail
Fixed

Fixed would be used for an action or Task that would always be a certain length of time regardless of the size of the client. For example, a Step for a Meeting where the meeting would always be allocated 1 hour regardless of the size of the client and the Job Estimated Hours. The Time for the Task would be set up as Fixed.

2206_Fixed_Time_in_Step_Capacity_Planning.gif

Relative

Relative is used to calculate the time for the Task relative to the total budget hours for a Job. 

For any Allocations that are Relative, the total of the Default Times for all Tasks in the Process is calculated, and compared to the Job Budget Hours. Any Task "Relative" times are then calculated and proportionately increased or decreased based on the total for the Job that is being considered. For example,

  • The total of all Default Times in the Tasks in the Process is 10 hours.
  • A Task has been set up as Relative, so it will allocate the time proportionate to the estimated total of the Job.
  • The Default Time of this Task is 30 minutes (00:30).
  • The Budget Hours for one of the Jobs that triggered the Process is 30 hours. For this Job, the Time allocations for this Task will be increased by three times the Default Time. The time allocated for this Task, for this Job, will be 1 hour 30 minutes.
  • The Estimated Hours for a different Job that triggered the Process is 2 hours. For this Job, the Time allocations will decrease and allocate it as one-fifth of the Default Time. The time allocated for this Task, for this Job, will be 6 minutes.

2205_Relative_Time_in_Step_Capacity_Planning.gif

Step 5 - Update Job Fields

When a Capacity Planning Report is run, it uses the Budget Hours in each Job and either the Job Start Date or Job Due Date.

  • An FYI Admin can select whether the Capacity Planning Report should run forward from the Job Start Date, or backward from the Job Due Date. This can be configured from the Practice Settings - Jobs - Mappings tab.  Refer to Managing Mappings

    Note: For Pro practices, a Custom Field may be used for the Job Start Date and Job Estimated Hours. This will allow practices to use Custom Fields in FYI specifically for Capacity Planning, rather than maintaining values in XPM.

Review the jobs to be included in Capacity Planning, and update them where required:

  • The Job Start Date or the Job Due Date determines if the Job and the task are relevant for the dates that the Capacity Planning Report is being run for. Dates must be selected for each of these fields in the Job. If using a Custom Field for the Job Start Date, and a date is not entered, FYI will use the default Job Start date instead.
     
  • If a task in the Process is set to Relative time, the Job’s Budget Hours are used to allocate time proportionally in Capacity Planning. Budget Hours must be entered into FYI for each job.
569 Job Summary Workflow Jobs Elite.gif

Download Files

Was this article helpful?
1 out of 2 found this helpful

Stay Up-To-Date

  • Events

    We host a range of product demos, training webinars, workshops and more.

  • Service Status

    Check for updates on the FYI Platform

  • What's New

    Round-up of new features, fixes, and other important announcements.