The Budget Widget (Video)

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.

Using the Budget Widget - Step by Step

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

Budget Widget Options

• 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.
  
  
  
• 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.
  
  
  
• 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