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.
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.
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.
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.
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.
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:
- In FYI, navigate to the Knowledge - Templates tab.
- Edit the Capacity Planning template.
- Click on the Employees worksheet.
- In the Name column, enter the Employee Name exactly as it displays in FYI.
- 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.
- Add the productivity target into the Productivity column as a decimal. For example, 80% is entered as 0.8.
- The Available Hours will be automatically calculated.
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.
- In the Name column, enter the Employee Name exactly as it displays in FYI.
- Enter the start Date of the leave, e.g. 06/10/2025.
- 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.
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:
- In FYI, click the Jobs menu to load the Jobs List.
- 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.
-
Save the view.
- 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.
- In FYI, click the Knowledge menu option at the top.
-
Drag and drop your Capacity Planning Report Template into the Knowledge - Templates list.
- 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.
- Click Create to import the template into your Templates list.
- 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. - Select the default View type and View to run the report for. This can be changed when running the report.
- 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.
- 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.
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.
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.
For a Create Task step, the Assignee and Due Date are selected in the relevant fields.
For steps that create a document, expand the Task section, and change the Create a task field to Yes. The Task fields will be displayed accordingly.
| 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. |
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.
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. |
| 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,
|
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.