> For the complete documentation index, see [llms.txt](https://kb.logicerp.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/faqs/reports/generate-company-brand-wise-monthly-consolidated-sale-report.md).

# Generate Company/ Brand-wise Monthly Consolidated Sale Report

**YouTube:** [How to generate Company/Brand-wise Monthly Consolidated Sale Report?](https://youtu.be/IeuymXbqsGk)

## How to generate Company/ Brand-wise Monthly Consolidated Sale Report?

In this Tutorial, we’ll configure a **brand-wise monthly sales report** based on **quantity** and **net value**.

***

### **Access the Sales Register Report**

* Go to the **Reports and Queries** section.
* Under **Sales Registers**, open the **Sales Register Cross Tab Report**.
* Click on **Configuration** to create a new report and define a **suitable configuration name**.

<figure><img src="/files/Dwtbz9p0iCHR1Ay84ZkY" alt=""><figcaption></figcaption></figure>

***

### **Configure Report Option**

* In **Report Options**, under **Report Consolidation**, enable the **Period** and **Item Column** options.
* From the **Item Consolidation Options** list, select **Company** and move it to the top using the arrow keys.
* In the **Total Section**, enable the **Grand Total** option to display overall totals.
* Adjust the report order by moving **Item** to the top.
* You can also apply **period-wise totals**.
* If the period chosen is **monthly**, the report will show **month-wise totals** automatically.

<figure><img src="/files/wHWj8XYMoZ6benRI7fG8" alt=""><figcaption></figcaption></figure>

***

### **Enable Transaction and Period Settings**

* Under **Transaction Options**, enable the setting to **view transaction details** and tick the option to display them **by quantity**.

<figure><img src="/files/tcPpBzzf116bGBww12AK" alt=""><figcaption></figcaption></figure>

* Next, go to the **Other Options** tab.
* Set the **Column As** to "**Period"** and **Period As** to "**Monthly"** to generate a month-wise report.

<figure><img src="/files/a9LixD99AghV5TvUuREM" alt=""><figcaption></figcaption></figure>

***

### **Save Configuration and Customize Columns**

* Save the configuration and select it from the **Available Configurations** list.

<figure><img src="/files/UV3yCunxqGeVo9GQaPXy" alt=""><figcaption></figcaption></figure>

* By default, all columns will be displayed.
* To customize, open **Setup Column Attributes**.
* Unselect all columns first, then select only the required ones — such as **Company Name**, **Total Quantity**, and **Net Amount**.
* Use the **search bar** to quickly find and enable any column.
* You can also **rearrange column order** using the arrow keys.

<figure><img src="/files/gYKg48qPqhPfSA9CeLNc" alt=""><figcaption></figcaption></figure>

* Save the settings and press **F2** to refresh the report.

***

### **View the Report Output**

* The report now displays **month-wise consolidated sales for each brand**, clearly showing how much quantity of each brand was sold in every month.

<figure><img src="/files/mw4VR7Zu7s0EixDgnx3x" alt=""><figcaption></figcaption></figure>

***

### **Switch to Net Value View**

* To view **net sales value** instead of quantity:
  * Open **Configuration** by pressing "**F5"**, go to **Transaction Type Settings**,
  * Untick **Total Quantity** and enable **Net Sale Value**.

<figure><img src="/files/1JWVqNJrkZiwf7JKSTh3" alt=""><figcaption></figcaption></figure>

* Save and refresh the report.
* The report will now show **month-wise net sales values for each brand**.

<figure><img src="/files/mw4VR7Zu7s0EixDgnx3x" alt=""><figcaption></figcaption></figure>

***

**You have successfully configured a Brand-wise Monthly Sales Report in Logic ERP.**


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://kb.logicerp.com/logic-erp-installation-configuration-and-troubleshooting-solutions/faqs/reports/generate-company-brand-wise-monthly-consolidated-sale-report.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.