> 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-learning-hub-tutorials-and-best-practices/reports-queries/sale-registers/daily-sale-report-with-c.card-details.md).

# Daily Sale Report with C.Card Details

Navigate to **Reports/Queries\Sale Registers** and click on "Daily Sale Report with C.Card Details".

The **Daily Sale Report with C.Card Details** lists each day's sale bills by how they were paid: **cash**, **credit**, **cheque**, **credit card** and **gift voucher**. Card payments show the card number, card type, card account and the card holder's details; cheque payments show the cheque details; credit and cheque payments show the customer's details. Use it to tally each day's collections by payment type, and the card collections by card account.

## Run the report

1. Choose a configuration (see [**Daily Sale Report with C.Card Details - Configuration**](https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/reports-queries/sale-registers/daily-sale-report-with-c.card-details/daily-sale-report-with-c.card-details-configuration.md)).
2. Enter the date range.
3. Select **Credit Card Account**, **Credit Card Number**, **Branch** or **Credit Card Types** if needed.
4. Run the report.

At least one payment type must be ticked in the [configuration](https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/reports-queries/sale-registers/daily-sale-report-with-c.card-details/daily-sale-report-with-c.card-details-configuration.md) — only the ticked payment types are listed and counted in the totals.

## How a day is laid out

For each day (and each branch, when **Branch Totals** is ticked), the report lists the payments in this order:

1. **CASH** — cash bills with numbers running one after another in the same series are shown on one row as a range, from the first bill number to the last, with their amount and quantity added up.
2. **CREDIT** — one row per bill, with the customer's details.
3. **CHEQUE** — one row per bill, with the cheque details and the customer's details.
4. **CREDIT CARD** — one row per card payment. A bill paid with two cards shows two rows.
5. **GIFT** — one row per bill paid partly or fully by gift voucher.

A bill paid in more than one way (for example part cash, part card) appears under each of its payment types, each row showing the amount paid that way.

## The columns

| Column                                                                                                                                                                                    | Meaning                                                                                                                                                                                                                    |
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **SNO.**                                                                                                                                                                                  | the row number                                                                                                                                                                                                             |
| **BILL DATE**, **BILL NO.**                                                                                                                                                               | the bill's date and number; for cash, a range of bill numbers                                                                                                                                                              |
| **TYPE OF SALE**                                                                                                                                                                          | **CASH**, **CREDIT**, **CHEQUE**, **CREDIT CARD** or **GIFT**; on totals lines, the name of the total                                                                                                                      |
| **BILL AMOUNT**                                                                                                                                                                           | the amount paid by that payment type                                                                                                                                                                                       |
| **TOTAL QUANTITY**                                                                                                                                                                        | the bill's total quantity — see **Quantity** below                                                                                                                                                                         |
| **BRANCH NAME**                                                                                                                                                                           | the branch of the bill                                                                                                                                                                                                     |
| **CHQ/CC NO.**                                                                                                                                                                            | the cheque number, or the credit card number                                                                                                                                                                               |
| **CREDIT CARD NAME**                                                                                                                                                                      | the card type, for example VISA                                                                                                                                                                                            |
| **CC ACCOUNT NAME**                                                                                                                                                                       | the account the card payment is posted to                                                                                                                                                                                  |
| **CC DESCRIPTION**, **CC REFERENCE ID**, **CC REFERENCE NUMBER**, **CC TRANSACTION DATE**, **CC REQUEST REFERENCE ID**                                                                    | the details recorded against the card number. They belong to the card, not to the single payment, so every payment made with the same card shows the same values; **CC REQUEST REFERENCE ID** is the card's latest request |
| **BANK NAME**, **BRANCH**, **CHEQUE DATE**, **ACCOUNT NO.**                                                                                                                               | the cheque details. A bill paid only by cheque shows the cheque number and date; **BANK NAME**, **BRANCH** and **ACCOUNT NO.** are filled when the cheque was entered as one of the bill's payment lines                   |
| **FIRST NAME**, **MIDDLE NAME**, **LAST NAME**, **HOUSE NO.**, **ADDRESS**, **PHONE-1**, **PHONE-2**, **PAGER NO.**, **MOBILE NO.**, **MEMBERSHIP NO.**, **CITY NAME**, **LOCATION NAME** | the customer's details on credit and cheque rows; on card rows, the card holder's name, address, phone and city in **FIRST NAME**, **ADDRESS**, **PHONE-1** and **CITY NAME**                                              |
| **REMARKS 1**, **REMARKS 2**, **REMARKS 3**                                                                                                                                               | the remarks entered on the bill                                                                                                                                                                                            |

**MIDDLE NAME**, **LAST NAME**, **HOUSE NO.**, **PAGER NO.**, **MEMBERSHIP NO.** and **LOCATION NAME** are filled for a retail customer. For a bill made to a customer account, **FIRST NAME** shows the account's contact person, with the account's address, phones and city. Cash and gift rows do not show customer details.

## Totals

Each total can be switched on in the [configuration](https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/reports-queries/sale-registers/daily-sale-report-with-c.card-details/daily-sale-report-with-c.card-details-configuration.md):

* **CASH TOTAL**, **CREDIT TOTAL**, **CHEQUE TOTAL**, **CREDIT CARD TOTAL** and **GIFT TOTAL** after each payment type (**Sale Totals**).
* **CREDIT CARD ACCOUNT TOTAL** for each card account within a day (**Credit Card Account Wise Total**). The day's card rows are then grouped by card account, in alphabetical order.
* **DATE TOTAL** at the end of each day (**Date Totals**).
* **BRANCH TOTAL** at the end of each branch (**Branch Totals**).
* **GRAND TOTAL** at the end of the report (**Grand Totals**).

The date, branch and grand totals add up only the payment types that are ticked.

## Sale returns

Sale returns are shown with a minus amount and a minus quantity, and are taken off the totals.

> **Example — one day at the Main Road branch**
>
> Asha pays ₹2,000 in cash for 2 pieces. Vikram pays ₹5,000 for 3 pieces: ₹1,000 in cash and ₹4,000 by card. Meena returns 1 piece bought earlier, worth ₹800, against a cash refund.

With every payment type ticked, and **Sale Totals**, **Credit Card Account Wise Total** and **Date Totals** ticked, the day shows:

| TYPE OF SALE              | BILL AMOUNT | TOTAL QUANTITY |
| ------------------------- | ----------- | -------------- |
| CASH (Asha)               | 2,000       | 2              |
| CASH (Vikram)             | 1,000       | 3              |
| CASH (Meena's return)     | -800        | -1             |
| CASH TOTAL                | 2,200       | 4              |
| CREDIT CARD (Vikram)      | 4,000       |                |
| CREDIT CARD ACCOUNT TOTAL | 4,000       |                |
| CREDIT CARD TOTAL         | 4,000       |                |
| DATE TOTAL                | 6,200       | 4              |

The three cash rows show as separate rows here so the amounts can be followed; when the bill numbers run one after another in the same series, the report shows them on one row as a range. Vikram's quantity is shown once, on his cash row, and left blank on his card row.

## Quantity

**TOTAL QUANTITY** is the whole bill's quantity. A bill paid in more than one way shows its quantity on one of its rows only — the cash row if there is one, otherwise credit, then cheque, then gift voucher, then card — and leaves it blank on its other rows, so each bill's quantity is counted once in the totals. Payment types that are not ticked are skipped when choosing that row.

## Good to know

* Selecting a **Credit Card Account** lists only bills that have a card payment. The card rows are limited to the chosen accounts; the same bills' cash, credit, cheque and gift rows are still listed.
* **Credit Card Number** and **Credit Card Types** limit only the card rows. The cash, credit, cheque and gift rows of every bill in the date range are still listed.
* When branch rights apply to reports, you see only the branches you have rights to.
* With **Branch Totals** unticked, the rows run date by date across all the chosen branches, with one **DATE TOTAL** per day.
* Within each payment type, rows run in bill-number order. A bill paid with two cards lists its card rows by card account.
* A zero amount or quantity is shown blank.


---

# 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 by asking a question.

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/reports-queries/sale-registers/daily-sale-report-with-c.card-details.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
