Skip to main content

How the budget is calculated:

  • A. Retrieves the target entered for the store/month
  • B. If data corresponding to the current month exists, the system will retrieve the daily and commercial category share values from the same month of the previous year, taking into account the days of the week and fixed-date national holidays.
    • Example: Current month 09/2019; the calculation will be based on data from 09/2018.
    • The system automatically considers all events based on days of the week, such as “Mother’s Day” and “Produce Wednesday.”
  • C. If there is no data for the current month, the system will calculate the data based on the previous month.
    • Example: Current month 09/2019; the calculation will be based on data from 08/2019.
  • D. The entered average is used to calculate purchases, losses, breakages, and product consumption.
Contribution Margin Calculation:
Margin = 100 – (totalCustoComImposto / (totalVenda / 100)
The Loss, Breakage, and Consumption shown in Controllership are based on Purchases because they are directly related to merchandise purchases. Their averages are also added to COGS, making the Purchase Limit more accurate and complete. The Loss, Breakage, and Consumption shown in Analytics are based on Sales, providing the percentages of these indicators in relation to actual Sales.

How to create a budget

Click here to watch the Complete Video;Follow the step-by-step instructions below to Create a Budget
  1. Controllership> Budget
Budget CC Budget 01
  1. Click the “Create Budget” button
Budget CC Budget 02
  1. Select the Store for which you want to create the “Budget,” as shown in the image below, and then set the period.
Budget CC Budget 03
  1. Next, click the “Magnifying Glass,” as shown in the image below. When you click it, the calculated data will appear automatically.
Budget CC Budget 04
  1. Carefully review each field described in the image below;
Budget CC Budget 05
  1. As shown in the image below, enter a value for the growth rate in this field. Notice that when you enter the rate, a value will automatically be calculated in the “Suggested Target” field. In our example, we used a 10% rate. See the result
The Previous Period used in the budget calculation contains the same number of days as the period selected for the calculation.Period 07/2026The month has 31 days PeriodStart = 22/06/2026 PeriodEnd = 22/07/2026

Result: for the date 23/07/2026

Budget CC Budget 06
  1. When you click the button shown in the image above, it copies the values from the “Suggested Target” and automatically pastes them into the “Sales Target” field. You can also adjust the values manually if necessary;
Budget CC Budget 07
– See the created “Sales Target” value in the image below.
The [Save and Calculate] button takes you directly to step 11, while [Save and Continue] saves the budget and keeps you in the same window to create a new budget.
Budget CC Budget 08
  1. Notice that the budget was successfully [Created]. Follow the next step to calculate the plan.
Budget CC Budget 09
  1. To generate the reports, you must run [Calculate]. Click the [Calculate] button;
Budget CC Budget 10
  1. You can select more than one store at the same time.
    Click the [Calculate] button;
    The Loss, Breakage, and Consumption shown in Controllership are based on Purchases because they are directly related to merchandise purchases. Their averages are also added to COGS, making the Purchase Limit more accurate and complete.
Budget CC Budget 11
  1. Notice that the plan has already been calculated. Simply click the back button.
Budget CC Budget 12
  1. Budget successfully created. Notice that the Status is now shown as “Calculated.”
Budget CC Budget 13

How to Calculate a Budget

Follow the steps below to Calculate a Budget;
  1. Controllership> Budget
Image 31
  1. Select the Store whose Budget you want to “Calculate.” – Notice that the “Calculate” button will only appear after you select the store.
02
  1. You can select more than one store at the same time.
    Click the [Calculate] button;
    The Loss, Breakage, and Consumption shown in Controllership are based on Purchases because they are directly related to merchandise purchases. Their averages are also added to COGS, making the Purchase Limit more accurate and complete.
03
  1. Notice that the plan has already been calculated. Simply click the back button.
04
  1. Budget successfully calculated. Notice that the Status is now shown as “Calculated”;
05

How to Modify or Recalculate a Budget

Follow the steps below to Recalculate a Budget
  1. Controllership> Budget
Image 13
  1. Select the Store whose Budget you want to “Modify.” – Notice that the “Modify” button will only appear after you select the store.
Budget Modify Budget 02
  1. Carefully review the fields below. Fields marked with “Colors” can be edited.
    To complete all “Changes,” click SAVE.
    Contribution Margin Calculation:
    Margin = 100 – (totalCustoComImposto / (totalVenda / 100)
Budget Modify Budget 03

How to Export a Budget

Follow the steps below to Export a Budget;
  1. Controllership> Budget
Image 13
  1. Select the Store whose Budget you want to “Export.” – Notice that the “Export” button will only appear after you select the store.
Export 02
  1. You can select more than one store at the same time. Click the [Export] button;
Export 03

4 Ways to Edit Sales Targets and Commercial Categories

4 Editing Methods 02A

How to Edit Sales Targets BY DAY/MONTH

Click here to watch the Complete Editing Video;Edit Sales Targets by Day/Month Follow the steps shown in the images below.
  1. Controllership> Budget
How to Edit a Budget Day Month 01
  1. Click “Edit” and choose one of the editing options. In the example below, we are editing by “Days/Month.”
How to Edit a Budget Day Month 02
  1. This screen allows you to manually adjust the indicators used to distribute the daily Sales Target, adapting the plan for holidays, seasonality, special events, or specific commercial strategies.
    The system automatically recalculates the modified values, maintaining the consistency of the budget for the period.
How to Edit a Budget Day Month 03
  1. This feature automatically redistributes the values after a manual change, ensuring that the total target remains at 100% and the indicators remain consistent. When you edit a value, the system automatically calculates the resulting difference and provides tools to redistribute this balance among the other records.
How to Edit a Budget Day Month 04

How to Edit Sales Targets BY DAYS/COMMERCIAL CATEGORIES

Click here to watch the Complete Editing Video;Edit Sales Targets by Days/Commercial Categories
  1. Controllership> Budget
Image 13
  1. Click “Edit” and choose one of the editing options. In the example below, we are editing by “Days/Commercial Categories.”
Edit Day Commercial Category 02
  1. See below the columns that can be edited;
Edit Day Commercial Category 03
  1. See the editing process below;
Edit Day Commercial Category 04
  1. See the target editing and redistribution processes below;
Edit Day Commercial Category 05

How to Edit Sales Targets BY MONTH/COMMERCIAL CATEGORY

Click here to watch the Complete Editing Video;Edit Sales Targets by Month/Commercial Category Follow the steps shown in the images below.
  1. Controllership> Budget
Image 13
  1. Choose the Store you want to “Edit” and select the Editing type, as shown in the image below.
Edit Month Commercial Category 02
  1. See below the columns that can be edited;
Edit Month Commercial Category 03
  1. See the editing process below;
Edit Month Commercial Category 04
  1. See how to edit the values in the example below
Edit Month Commercial Category 05

Average Margin (Budget) vs Contribution Margin %

When calculating the Average Margin while Creating the budget, Controller uses the average from the last two months, or the customer enters the desired margin. This margin is used to calculate the Break-Even Point.
Average Margin 01
When moving to the next routine, Calculate Budget, Controller uses historical data to distribute the Sales target by commercial category and then by day, while respecting the period’s seasonality. This defines the Contribution Margin, which is also based on previous months.The Margin determined after this entire calculation is the Contribution Margin shown in the budget details and as an indicator on the Contribution Margin % Card in Metrics.
Average Margin 02

Check Expenses: Controller 360 vs VR Master

See below the “Disbursement” field, which displays the expenses entered in VR Master.
Check Expenses 00
To check the data, go to:
Finance/Accounts Payable/Supplier
01
See how the data appears in VR Master for checking in the image below;
02 (1)