The Budget Widget (Video)

Modified on Tue, Dec 17 at 4:21 PM

The Budget Widget simplifies budgeting by doing the math for you! Whether you need to adjust your budget to a flat amount or by a percentage, the Budget Widget makes it easy. The Budget Widget is available on all unlocked worksheet lines unless they are controlled by a Special Purpose Worksheet. Using the Budget Widget is best practice for updating your budget lines.

Select a calculation method from the Adjustment Type dropdown and enter the requested information. Then, click Preview to perform the calculation and display the results for each month. A total for the year is located at the bottom of the list of months. Enter Notes on any month and copy to additional months. Once you are ready to post the results of your selections, click Save.

Alternatively, you can choose to Paste from Excel. Values are copied from Excel into all months of a year.

Data can be pasted per these rules:

Frozen months are ignored.
The values in the clipboard must be Tab or Enter separated (i.e., a horizontal or vertical selection from Excel).
Pasting always starts in the first month.
If there are more than 12 values in the selection to be pasted, only the first 12 will be used.
If there are fewer than 12 values, all values will be used, and remaining months are untouched.

You may also choose to use CTRL-V to paste the values from any month forward by clicking in the starting month desired.

Each Adjustment Type is detailed below, following the Step by Step instructions.

Using the Budget Widget - Step by Step

Select an unlocked worksheet to edit.
Click the Budget Widget button on the worksheet line.
From the Budget Widget window, adjust amounts as needed.
Adjust the monthly amounts manually, use Paste from Excel, or use the Adjustment Type dropdown. (See below for a detailed explanation of each option).
If you used an Adjustment Type to create values, click on Preview to see the results without committing to them just yet.
Add any Notes as needed.
Click Save to post your amounts and Notes back to the worksheet line.

Budget Widget Options: Weekly, Bi-weekly, Monthly, Quarterly, and Annual

Weekly, Bi-weekly, Monthly, and Quarterly spread a rate across a year with the indicated frequency.

Monthly totals corresponding to that rate are automatically calculated for the entire fiscal year.
Annual divides the specified rate by 12 to determine the monthly value.
Optional: For Monthly, Quarterly, Annual, and Adjust choices, specify a starting month.
Optional: For Weekly and Bi-weekly, specify a starting day of the week and/or month.
If a starting month is specified, the calculations do not affect existing amounts for previous months.
Regardless of whether a starting month is specified for an Annual amount, the monthly rate is one-twelfth of the annual amount.

Examples of Weekly, Bi-weekly, Monthly, Quarterly, and Annual

Weekly - Enter the starting date and the amount. Martus will calculate the weekly amount taking into consideration the months with five weeks.
Bi-Weekly - Enter the starting date and the amount. Martus will calculate the bi-weekly amount taking into consideration the months with 3 bi-weekly dates.

Monthly - Enter the starting and ending months and the amount. Martus will update every month within the date range with that value. Note: It will not adjust other months' values.
Quarterly - Enter the starting and ending months and the amount. Martus will update one month every 3 months with that value.

Annual - Enter the starting and ending months and the amount. Martus will divide the amount evenly between the months selected, with remaining pennies in the last month.

Budget Widget Options: Adjust and Additional Amounts

Adjust and Additional Amounts are two different ways to modify the currently-budgeted monthly values for this line item.

Adjust up or down by a percentage (100% keeps the amounts the same).
Enter an Additional Amount (specified per month) to be added or subtracted. Use a negative number to reduce the budget amount.
Optional for Adjust, specify a starting month to apply the adjustment beginning with that month.

Examples of Adjust and Additional Amounts

Adjust - Enter the starting and ending months, and a value with which to adjust amounts. Martus will adjust the values that are currently on the line by the percentage input. For example, an input of 105 will increase the amounts by 5%. An input of 95 will decrease amounts by 5%.
Additional Amounts - Enter an amount for each month as appropriate. Martus will add this amount to the current amounts.

Budget Widget Options: Allocation, Burn Rate and Copy Existing Values

Allocation, Burn Rate and Copy Existing Values reset the budgeted values based on the selected source budget and/or actuals. Your options include the current year, the prior year, and the trailing 12 months of actuals. The budget source is the default Dashboard budget for the specified year.

Allocation spreads an annual total in proportion to the values in your source to the new monthly budget amounts. Any leftover pennies are included in the last month of the budget year.
Burn Rate calculates the average of the months being sourced and places that into available months that do not have a value or are not frozen. Months with no source selected are ignored in the calculation.
Copy Existing Values sets the new monthly budget amounts equal to the source.

Examples of Allocation, Burn Rate, and Copy Existing Values

Allocation - Enter an amount and choose a source (actuals and/or budget) for each month. Each month's total will be compared to the original total of the reference data (4,365.00) to provide a percentage per month. That percentage is then calculated against the amount indicated (5,000.00) and the monthly amounts are displayed.
Copy Existing Values - Enter an adjustment value and choose which reference data to use per month. Martus will utilize the appropriate data and adjust it by the adjustment value as appropriate.
Burn Rate - This option will take the total of the months sourced (3,450.96) and divide it by the total months sourced (5) and apply that calculated average to all unfrozen months (690.19).

Use the links below to navigate through the learning path.

The Budget Worksheet << Budget Basics - Learning Path >> Budget Reporting - Planner Summary