> ## Documentation Index
> Fetch the complete documentation index at: https://docs.controller360.com.br/llms.txt
> Use this file to discover all available pages before exploring further.

# Commercial Monitoring

Commercial Monitoring compares sales, contribution, purchase, and expense targets and results daily, allowing deviations to be identified and more effective actions to be taken.

```text theme={null}
Gross Profit Calculation
[Sales Amount] x [Margin %] ÷ [100] = Gross Profit
```

## **Check Commercial Monitoring Data**

[**Click here**](/content/docs/en/verification-guide/commercial-monitoring) to access the Verification Guide;

## **Follow the Steps for Commercial Monitoring**

[**Click here**](https://youtu.be/JTZBmLPGcSI) to watch the complete and detailed **Mobile Commercial Monitoring Video**

<Tabs>
  <Tab title="Portal">
    ## **Commercial Monitoring**

    Follow the steps below as shown in the images.

    1- Controllership> **Commercial Monitoring**

    <Frame>
      <img src="https://mintcdn.com/controller-tech/MxGfRo8KrZylQJRB/images/MC_01-2.png?fit=max&auto=format&n=MxGfRo8KrZylQJRB&q=85&s=785fed4e76929b0f4737ccec49eb5f9f" alt="MC 01 2" width="2040" height="1042" data-path="images/MC_01-2.png" />
    </Frame>

    – As shown in the figure below, we can see the default **Commercial Monitoring** home screen.<br />– It is divided into 4 Monitoring Groups: **SALES, CONTRIBUTION, PURCHASES**, and **EXPENSES**.<br />– In this example, we will use Filter>Type>**Merchandising**

    <Frame>
      <img src="https://mintcdn.com/controller-tech/MxGfRo8KrZylQJRB/images/MC_04-1.png?fit=max&auto=format&n=MxGfRo8KrZylQJRB&q=85&s=77ccbac6ae4cae5fb4e4f87ace587bad" alt="MC 04 1" width="2232" height="945" data-path="images/MC_04-1.png" />
    </Frame>

    2- This area allows you to define the criteria for the **Commercial Monitoring** analysis, making it possible to view the results from different perspectives and levels of detail. See the details of the Commercial Monitoring Toolbar below;

    <Frame>
      <img src="https://mintcdn.com/controller-tech/MxGfRo8KrZylQJRB/images/MC_02.png?fit=max&auto=format&n=MxGfRo8KrZylQJRB&q=85&s=6a056fdacb3530b1697baee74f7a763a" alt="MC 02" width="1920" height="945" data-path="images/MC_02.png" />
    </Frame>

    * See how to access the lower levels in the image below.

    <Frame>
      <img src="https://mintcdn.com/controller-tech/MxGfRo8KrZylQJRB/images/MC_03.png?fit=max&auto=format&n=MxGfRo8KrZylQJRB&q=85&s=f39d95c5db932f01b567f5e838f61fd0" alt="MC 03" width="1920" height="945" data-path="images/MC_03.png" />
    </Frame>

    See the details of each Commercial Monitoring Sales column below.

    <Frame>
      <img src="https://mintcdn.com/controller-tech/MxGfRo8KrZylQJRB/images/MC_Legendas_Vendas.png?fit=max&auto=format&n=MxGfRo8KrZylQJRB&q=85&s=34cf6ca13eb5d210237820ea3af9d9f2" alt="MC Sales Legends" width="2040" height="802" data-path="images/MC_Legendas_Vendas.png" />
    </Frame>

    See the details of each Commercial Monitoring Contribution column below.

    <Frame>
      <img src="https://mintcdn.com/controller-tech/MxGfRo8KrZylQJRB/images/MC_03_Legendas_Contribui%C3%A7%C3%A3o.png?fit=max&auto=format&n=MxGfRo8KrZylQJRB&q=85&s=cf74a42c7fd40f90e9ce94bd0ca39ee4" alt="MC 03 Contribution Legends" width="2040" height="430" data-path="images/MC_03_Legendas_Contribuição.png" />
    </Frame>

    See the details of each Commercial Monitoring Purchases, Inventory, Loss, Breakage, Consumption, and Expenses column below.

    <Frame>
      <img src="https://mintcdn.com/controller-tech/MxGfRo8KrZylQJRB/images/MC_03_Legendas_Compras.png?fit=max&auto=format&n=MxGfRo8KrZylQJRB&q=85&s=9cc4848d971fd0a97a434a16bf7baccc" alt="MC 03 Purchases Legends" width="2040" height="1050" data-path="images/MC_03_Legendas_Compras.png" />
    </Frame>

    ## **Table Legends**

    **SALES** Table Legend

    <img src="https://mintcdn.com/controller-tech/OorSAChFNVfXfATx/images/08-1.png?fit=max&auto=format&n=OorSAChFNVfXfATx&q=85&s=bb5a823c81ac817f261584aee544b761" alt="08 1" width="2040" height="1042" data-path="images/08-1.png" />

    **CONTRIBUTION** Table Legend

    <img src="https://mintcdn.com/controller-tech/OorSAChFNVfXfATx/images/09.png?fit=max&auto=format&n=OorSAChFNVfXfATx&q=85&s=3d79a52494a5e3a7a98a52544c7fe052" alt="09" width="2040" height="1042" data-path="images/09.png" />

    **PURCHASES** Table Legend

    <img src="https://mintcdn.com/controller-tech/OorSAChFNVfXfATx/images/10.png?fit=max&auto=format&n=OorSAChFNVfXfATx&q=85&s=6ed94f5564a78e2828cfd52909caf73a" alt="10" width="2040" height="1042" data-path="images/10.png" />

    ## **What Is Shown in the Exchange Stock Balance?**

    The Inventory Monitoring routine records the inventory position when the consistency check is performed.<br />In summary, the inventory shown in this routine corresponds to exchanges that have not yet been completed with the supplier. In other words, these are items that have already been negotiated and are still awaiting action from the supplier, and that appear on the Stock/Exchange screen when the consistency check for that day is completed.<br />When the return invoice is issued to the supplier or the item is removed from the stock/exchange, the system no longer considers that item after a new consistency check is performed, as it is no longer part of the exchange stock.<br />Important: exchanges made with end consumers are not included in this validation.

    <br />

    ## **Data – Commercial Monitoring**

    |            **Controller360**           | **VR Master**                                 | **Filter**                                                     |             **Column**            |
    | :------------------------------------: | :-------------------------------------------- | :------------------------------------------------------------- | :-------------------------------: |
    |          Sales, Actual Amount          | Administrative Queries > Inbound and Outbound | Period, Store, View \[**Merchandising**]                       |               Sales               |
    |        Sales, Promotional Amount       | Administrative Queries > POS Sales            | Period, Store, View \[**Merchandising**], Promotion \[**Yes**] |             Net Sales             |
    |      Sales, Non-Promotional Amount     | Administrative Queries > POS Sales            | Period, Store, View \[**Merchandising**], Promotion \[**No**]  |             Net Sales             |
    |             Sales, Receipt             | Administrative Queries > POS Sales            | Period, Store, View \[**Merchandising**]                       |            Receipt Qty.           |
    |          Sales, Average Ticket         | Administrative Queries > POS Sales            | Period, Store, View \[**Merchandising**]                       |          Average Receipt          |
    |       Contribution, Actual Amount      | Administrative Queries > Inbound and Outbound | Period, Store, View \[**Merchandising**]                       | Sales – Cost of Sales<sup>1</sup> |
    |                                        |                                               |                                                                |                                   |
    |  Purchases, Inbound Amount<sup>2</sup> | Administrative Queries > Inbound and Outbound | Period, Store, View \[**Merchandising**]                       |              Inbound              |
    |                                        | Inventory > Internal Transfer                 | Period, Merchandising, Store                                   |           Cost incl. Tax          |
    | Purchases, Outbound Amount<sup>3</sup> | Administrative Queries > Inbound and Outbound | Period, Store, View \[**Merchandising**]                       |              Outbound             |
    |                                        | Inventory > Internal Transfer                 | Period, Merchandising, Store                                   |           Cost incl. Tax          |
    |                                        |                                               |                                                                |                                   |
    |      Purchases, Inventory Balance      | Inventory > Inventory Monitoring              | Date, Store, View Mode \[**Merchandising**]                    |       Total, Cost incl. Tax       |
    |             Purchases, DDV             | Inventory > Inventory Monitoring              | Date, Store, View Mode \[**Merchandising**]                    |                DDV                |
    |       Purchases, Exchange Balance      | Inventory > Inventory Monitoring              | Date, Store, View Mode \[**Merchandising**]                    |      Exchange, Cost incl. Tax     |
    |        Purchases, Loss (Actual)        | Inventory > Loss                              | Period, Store, View Type \[**Merchandising**], Summary         |          Total incl. Tax          |
    |      Purchases, Breakage (Actual)      | Inventory > Breakage                          | Period, Store, View Type \[**Merchandising**], Summary         |          Total incl. Tax          |
    |     Purchases, Consumption (Actual)    | Inventory > Consumption                       | Period, Store, View Type \[**Merchandising**], Summary         |          Total incl. Tax          |

    <br /><sup>1</sup>The **Cost of Sales** used by Controllership to calculate the **contribution amount** is the **cost including tax**.<br />If the **“Use Average Cost”** flag is enabled in the ***configuration* of the *Price Management* routine** in ***VR Master***, it will not be possible to verify the cost of sales.<br /><sup>2</sup>Inbound Amount is the sum of the inbound column in the Inbound and Outbound report and the cost including tax of internal transfers.<br /><sup>3</sup>Outbound Amount is the sum of the outbound column in the Inbound and Outbound report and the cost including tax of internal transfers.<br />The Controllership **Total Purchases** is the sum of the<sup> 2</sup>**inbound** amounts and <sup>3</sup>**outbound** amounts from Commercial Monitoring.<br />Controllership **does not retrieve information** about **transfers** between **stores** directly from **inventory**. Only outbound invoices with the **transfer type** are included. The “**Include Store Inventory Transfers**” option in the Inbound and Outbound report parameters must remain unchecked.<br />Controllership uses the **inbound types** added to the **Inbound and Outbound settings** to **determine what is considered a merchandise purchase**.<br />Controllership uses the **outbound types** added to the **Inbound and Outbound settings** to **determine** which purchased merchandise was **transferred or returned**.<br />An **Internal Transfer** generates an outbound movement from merchandising level 1 of the **selected product** and generates an **inbound movement** in the **merchandising category specified** in the Merchandising field. *Always enter transfers with operation type = inbound (requires VR Master 4.1.36+).*

    <br />Important: Daily actual data will only be sent and updated <br />after the POS consistency check.

    <br />
  </Tab>

  <Tab title=" Mobile">
    <Note>
      Coming soon
    </Note>
  </Tab>
</Tabs>
