# Create Payment Mode Wise Sale Report

**YouTube:** [How to generate Payment Mode-wise Sale Report?](https://youtu.be/10cMoiV516c)

## How to Generate Payment Mode Wise Sale Report?

In this tutorial, we’ll learn how to configure a **Payment Mode–Wise Daily Sales Report** in **Logic ERP**.

***

### **Access to Account-Wise Daily Sales Report - Item Wise**.

* Navigate to the **Reports/Queries** section.
* Select **Sales Registers**.
* Open **Account-Wise Daily Sales Report - Item Wise**.
* Click on **Configuration**.
* Define a suitable **Configuration Name** for easy reference.

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

* Proceed to the **Report Options** tab.

***

### **Define Report Options**

* Set **Report Consolidation** to **Bill Wise**.
* Enable the **Item Details** option.
* Under **Item Consolidation**, select the specific item-level details you want to display in the report.
* In the **Report Totals** section, enable the **Grand Total** option to view overall totals at the end of the report.

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

***

### **Configure Other Options**

* Navigate to the **Other Options** section.
* Set the **Credit Card Column** display mode to **Credit Card Name-Wise**.

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

* Once all required changes are made, click **Save** to store the configuration.

***

### **Create and Customize the Report**

* From the list of available configurations, select the one you just created.

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

* Click **Create** to generate the report.
* By default, all columns will be displayed.
* To customize:
  * Open **Setup Column Attributes**.
  * Unselect all columns first.
  * Then select only the required columns for your report.
  * Search for the **Credit Cards** column and enable it by ticking the checkbox.

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

* Rearrange the column order as needed using the **arrow keys**.

***

### **View and Analyze the Report**

* Save your settings and refresh the report by pressing **F2**.
* The report will now display **daily sales data categorized by payment mode**.
* All payment modes — such as **Cash**, **Credit Card**, and **UPI** — are shown clearly.
* Each credit card created in the system automatically appears as a **separate column**, showing payments recorded against it in the sales bills.

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

***

**You have successfully configured a Payment Mode–Wise Daily Sales Report in Logic ERP.**


---

# Agent Instructions: 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/create-payment-mode-wise-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.