The Above Video is a recording from a training on the new Budgeting Module and below are step by step instructions to access the Budget Template.
1. Please navigate to Budgets on the left navigation pane.
2. Click the Year drop down on the upper right hand corner and select the budget year that you would like to access.
3. Click the Budget template name under the BUDGET column.
4. After selecting your Budget, you will be taken directly to the Budget's Entry Screen.
Automatically Fill Out Budget
The Automatically Fill Out Budget function allow you to fill out the budget numbers based on last year's Forecast.
Note that before automatically filling out your budget, you have the option to filter your template so that the autofill will only be applied to the lines that have been filtered for. After selecting the filters make sure to select the Apply Filters button to ensure that the filters selected are applied to the template before starting the Auto Fill.
WARNING – Selecting Automatically Fill Out Budget OVERWRITES any existing data.
Pleaes follow the below steps to auto fill the budget
1. Click Automatically Fill Out Budget button located on the left top of the screen.
2. After you click on Automatically Fill out Budget, you will see the below screenshot. Please select the forecast year that the budget should be based on.
3. Once you select the forecast year, you will see the below screenshot. On this screen, you can enter the percentage that you would like your budget numbers to increase by. Then click Fill out Budget button.
Notes:
- Please enter the percentage number into the Baseline increase text box on the top if you would like to apply the same percentage into all months on budget template OR enter the percentage number into the increase by text box next to each month if you would like to apply the different percentage number for each month.
- You can enter a negative percentage number, example -3%. If you do enter a negative % and there is a negative Forecast amount on the year that you are choosing, then the month(s) will be $0 on the Budget Line.
- Generally the AutoFill builds a solid baseline. You should go through the Budgets and tweak them as needed.
- AutoFill % is calculateed based on Billing, Pending and Pitched (Project) totals of the Forecast Year that you choose.
5. After you click Fill out Budget button, you may see the below warning. This warning will go away after the process of Automatically Fill Out Buget has been completed.
Search for Budget Lines
You can use:
- Filters on the top of the page to filter down to specific attributes (Outlets, Offices, Salespeople, Rev Types, Agency, and Accounts). These attributes may differ depending on what is required by your company.
- Hide Rows Without A Budget - After entering the Budget, if you'd like to hide any rows that do not have a budget you can do so by checking off the 'Hide Rows Without A Budget' checkbox.
- Apply Filters - After setting any necessary filters, make sure to click the Apply Filters button to apply the filters selected to your Budget Template.
Note that you also have the ability to sort the Budget Rows by a specific attribute by clicking the arrows next to each header column
Manually Enter Budget
Please click on one of the fields to enter or edit the budget number, Matrix will display the next, current, and last years' booked numbers under the line that you are about to enter the budget number as shown in the below screenshot.
There is no Save button. Budget numbers are automatically saved as soon as you press Tab on your keyboard to go to the next field.
Note: If you click on one of the fields to enter or edit the budget number, Matrix will display the next, current, and last years' booked numbers under the line that you are about to enter the budget number as shown in the below screenshot.
Copy/Split the Budget Lines
You also have the ability to Copy or Split values across your Budget lines. To do this scroll all the way over to the right of the template lines. After the line totals, you can click on the menu icon in order to copy or split a value across this budget line.
- When selecting Copy, you will be asked to fill out the following options where you can input the amount that you'd like to have copied across all months by checking the All checkbox. The example below shows that a $250 budget will be put on the months of January through December. Click Save to apply your updates. Note: You can uncheck individual months as well and the amount copied will not be copied to the unchecked month.
- When selecting Split, you will be asked to fill out the following options where you can input a total budget amount that you would like to have split across the months checked. The example below shows that $1500 will be split evenly between the months of June, July, and August. Click Save to apply your updates.
Insert the Budget Line
If you cannot find the budget line that you would like add the budget number, you can insert a new budget line. To insert a new link, please follow the below steps:
1. Click on the (+) Add Budget Item or New Business button which is located at the bottom left corner of the page.
2. Fill out all the necessary information. Note that If you wish to enter the New Business, please leave the field empty.
3. Click Save and Finish or Save and add more items if would like to add more lines.
Please click the below links to view more instructions:
- Export and Import budget - to export budget into Excel sheet and import budget from Excel into Matrix.
- View budget change logs - to view the detail of budget changes such as who edited the budget and when the budget was edited.
Keyword Search: budget, Lock budget, unlock budget, automatically fill out budget, fill out budget, work through my budget.