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.
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.
- Portal
- Mobile
How to create a budget
Click here to watch the Complete Video;Follow the step-by-step instructions below to Create a Budget- Controllership> Budget

- Click the “Create Budget” button

- Select the Store for which you want to create the “Budget,” as shown in the image below, and then set the period.

- Next, click the “Magnifying Glass,” as shown in the image below. When you click it, the calculated data will appear automatically.

- Carefully review each field described in the image below;

- 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
Result: for the date 23/07/2026

- 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;

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.

- Notice that the budget was successfully [Created]. Follow the next step to calculate the plan.

- To generate the reports, you must run [Calculate]. Click the [Calculate] button;

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

- Notice that the plan has already been calculated. Simply click the back button.

- Budget successfully created. Notice that the Status is now shown as “Calculated.”

How to Calculate a Budget
Follow the steps below to Calculate a Budget;- Controllership> Budget

- Select the Store whose Budget you want to “Calculate.” – Notice that the “Calculate” button will only appear after you select the store.

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

- Notice that the plan has already been calculated. Simply click the back button.

- Budget successfully calculated. Notice that the Status is now shown as “Calculated”;

How to Modify or Recalculate a Budget
Follow the steps below to Recalculate a Budget- Controllership> Budget

- Select the Store whose Budget you want to “Modify.” – Notice that the “Modify” button will only appear after you select the store.

- 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)

How to Export a Budget
Follow the steps below to Export a Budget;- Controllership> Budget

- Select the Store whose Budget you want to “Export.” – Notice that the “Export” button will only appear after you select the store.

- You can select more than one store at the same time. Click the [Export] button;

4 Ways to Edit Sales Targets and Commercial Categories

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.- Controllership> Budget

- Click “Edit” and choose one of the editing options. In the example below, we are editing by “Days/Month.”

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

- 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 Sales Targets BY DAYS/COMMERCIAL CATEGORIES
Click here to watch the Complete Editing Video;Edit Sales Targets by Days/Commercial Categories- Controllership> Budget

- Click “Edit” and choose one of the editing options. In the example below, we are editing by “Days/Commercial Categories.”

- See below the columns that can be edited;

- See the editing process below;

- See the target editing and redistribution processes below;

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.- Controllership> Budget

- Choose the Store you want to “Edit” and select the Editing type, as shown in the image below.

- See below the columns that can be edited;

- See the editing process below;

- See how to edit the values in the example below

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.

Check Expenses: Controller 360 vs VR Master
See below the “Disbursement” field, which displays the expenses entered in VR Master.
Finance/Accounts Payable/Supplier

.png?fit=max&auto=format&n=1bTJvCBiGyykVHT3&q=85&s=37f0013c2a9f02b86ff1f66c452b79b2)