> 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/cash-card-status-report.md).

# Cash Card Status Report

**YouTube:** [Cash Card Status Report](https://youtu.be/7ta4rdMK3hM?si=mTf4NxSNhNmQQaq7)

**Available on:** Desktop · Web

Navigate to **Reports/Queries\Sale Registers** and click on "Cash Card Status Report".

The **Cash Card Status Report** shows where each cash card stands: the balance it started the period with, the money recharged onto it, the scheme credit given, what was spent on sale bills, what was refunded, and the balance left. Use it to check card balances, to see how much of a balance can be refunded in cash, and to match the cards with the customer's ledger. Cash cards are issued and recharged in the **Cash Card Manager** — to learn about it, [Click Here](https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/billing/cash-card-manager.md).

## Run the report

1. Choose a configuration (see [**Cash Card Status Report - Configuration**](https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/reports-queries/sale-registers/cash-card-status-report/cash-card-status-report-configuration.md)).
2. Enter the **From** and **To** dates. Keep them inside the financial year you are logged in to — the recharges, refunds and sales of the period are read from that year only. To see an earlier year, log in to that year.
3. Select **Branch** or **Cash Card** if needed. You can choose more than one of each. Leave them empty to include all.
4. Run the report.

You see only the branches you have rights to. When **Show Data For Current Branch Only** is ticked in the configuration, only the branch you are logged in to is shown, whatever you pick under **Branch**.

## How the rows are laid out

The **Report Consolidation** settings in the [configuration](https://kb.logicerp.com/logic-erp-learning-hub-tutorials-and-best-practices/reports-queries/sale-registers/cash-card-status-report/cash-card-status-report-configuration.md) decide what one row stands for:

* With **Cash Card** ticked, each card gets its own row. Without it, all cards are added together.
* With **Branch Wise** ticked, the rows are split by branch. With **Bill Date** ticked, they are split by date.
* With **Document No.** ticked, the report works card by card and date by date, and shows **one row for each document** of a card — every recharge, refund and sale bill — in date order, with a running balance. This is the best view for following a single card's history. Journal entries are not listed in this view.

With **Document No.** ticked, a card that was recharged or used before the **From** date starts with an **Opening Balance B/F** row (the words appear in the **ACCOUNT NAME** column), which carries the balance brought forward.

## The columns

Shown when the report opens:

| Column                       | Meaning                                                                                                                                                                                                                                                   |
| ---------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **SNO.**                     | the row number                                                                                                                                                                                                                                            |
| **BRANCH NAME**              | the branch, when **Branch Wise** is ticked. The names of totals rows also appear here                                                                                                                                                                     |
| **VOUCHER DATE**             | the date, when **Bill Date** is ticked                                                                                                                                                                                                                    |
| **NET SALE AMOUNT**          | the part of the sale bills paid with the card in the period — not the whole bill value                                                                                                                                                                    |
| **CARD OPENING BALANCE**     | the card's balance before the **From** date; left blank when it is below zero                                                                                                                                                                             |
| **CARD RECHARGES**           | the money recharged onto the card in the period, by cash and by credit card                                                                                                                                                                               |
| **TOTAL CARD AMOUNT**        | opening balance + recharges + the scheme credit given on those recharges                                                                                                                                                                                  |
| **CARD REFUND AMOUNT**       | the money paid back to the customer from the card in the period                                                                                                                                                                                           |
| **CARD BALANCE AMOUNT**      | total card amount less sales, refunds and journal entries against the card; left blank when it is below zero                                                                                                                                              |
| **AVERAGE PER BILL**         | net sale ÷ the number of sale bills. With **Cash Card** ticked or cards selected, only bills paid with a card are counted; otherwise every sale bill of the period is counted                                                                             |
| **AVERAGE PER CARD**         | net sale ÷ the number of cash cards that have ever been recharged or refunded in the selected branches. It is not limited to cards used in the period, so treat it as a rough guide                                                                       |
| **ACCOUNT NAME**             | the account on the card's transactions, usually the card holder. On a recharge it can be the account the money was received into, such as a counter collection account                                                                                    |
| **SCHEME AMOUNT**            | the scheme credit given on the card's recharges in the period                                                                                                                                                                                             |
| **ACTUAL REFUNDABLE AMOUNT** | the card balance less all the scheme credit the card has received, including scheme received before the **From** date. The scheme credit can be spent on the card but is not refunded in cash, so this is the amount that can be refunded to the customer |
| **LEDGER DEBIT**             | the amounts debited to the customer's account: card sales, refunds, the old balance moved out when the card is recharged, and journal entries against the card                                                                                            |
| **LEDGER CREDIT**            | the amounts credited to the customer's account: each recharge as posted — the card's earlier balance moved back in, the new recharge, and the scheme credit                                                                                               |
| **DOCUMENT NO.**             | the recharge, refund or sale bill number — only when **Document No.** is ticked                                                                                                                                                                           |

More columns are available and can be switched on in the report's column settings:

| Column                                                    | Meaning                                                                                                                                                            |
| --------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| **BILL COUNT**                                            | the number of sale bills, counted the same way as for **AVERAGE PER BILL**                                                                                         |
| **CASH CARD NUMBER**                                      | the card number, when **Cash Card** is ticked. Shown in red when the card has expired, if **CARD EXPIRY DATE** is also shown and the card still has a balance      |
| **TOTAL COLLECTION**                                      | recharges less refunds                                                                                                                                             |
| **SALE AGAINST DUES**                                     | the sale up to the amount of the opening balance. When the sale exactly equals the opening balance it is left blank, and the whole sale shows under **TODAY SALE** |
| **TODAY SALE**                                            | the rest of the sale, above the opening balance. With **Document No.** ticked, it is that bill's sale                                                              |
| **REFUNDABLE SECURITY AMOUNT**                            | the **Security Amount for Cash Card - Cash** set in **Global Settings**, shown for cards with a total card amount                                                  |
| **REFUNDABLE TOTAL AMOUNT**                               | total card amount less sales, for cards with a total card amount. It is not added up on totals rows                                                                |
| **CLOSING BALANCE AMOUNT**                                | total card amount less sales and refunds. Journal entries are not taken off here, unlike **CARD BALANCE AMOUNT**                                                   |
| **CASH RECHARGE AMOUNT**, **CREDIT CARD RECHARGE AMOUNT** | the cash part and the credit card part of **CARD RECHARGES**                                                                                                       |
| **CARD EXPIRY DATE**                                      | the card's expiry date, for cards with a balance. Shown in red when it has passed                                                                                  |
| **JV AMOUNT**                                             | journal entries against the card in the period                                                                                                                     |
| **CARD REEDEMED AMOUNT**                                  | the card amount used on sale bills in the whole of the logged-in financial year, whatever dates you enter                                                          |

With **Document No.** ticked, the columns that only make sense for a whole card — **TOTAL CARD AMOUNT**, **BILL COUNT**, the averages, **SALE AGAINST DUES**, **REFUNDABLE SECURITY AMOUNT**, **REFUNDABLE TOTAL AMOUNT**, **JV AMOUNT** and **CARD REEDEMED AMOUNT** — are left blank. **CARD OPENING BALANCE** shows the card's brought-forward balance on every row, and **CARD BALANCE AMOUNT** and **CLOSING BALANCE AMOUNT** show the running balance after each document.

## Balance, scheme and refundable amount

When a card is recharged with a scheme, the customer gets the scheme credit on top of the money paid. The scheme credit can be spent on the card but is not refunded in cash. So the report shows two balances:

* **CARD BALANCE AMOUNT** — the full value on the card, scheme included.
* **ACTUAL REFUNDABLE AMOUNT** — the part that can be refunded in cash. It can go below zero when more than the money paid in has been spent.

> **Example — Ravi's card, 1 to 30 September**
>
> Ravi's card has ₹2,000 on it on 1 September. On 5 September he recharges ₹1,000 and gets a ₹100 scheme credit. Later in the month he spends ₹1,500 on bills paid with the card.

With **Cash Card** ticked, his row shows:

| CARD OPENING BALANCE | CARD RECHARGES | SCHEME AMOUNT | TOTAL CARD AMOUNT | NET SALE AMOUNT | CARD BALANCE AMOUNT | ACTUAL REFUNDABLE AMOUNT | LEDGER CREDIT | LEDGER DEBIT |
| -------------------- | -------------- | ------------- | ----------------- | --------------- | ------------------- | ------------------------ | ------------- | ------------ |
| 2,000                | 1,000          | 100           | 3,100             | 1,500           | 1,600               | 1,500                    | 3,100         | 3,500        |

The total card amount is ₹2,000 + ₹1,000 + ₹100. After ₹1,500 of sales, ₹1,600 is left on the card, of which ₹1,500 can be refunded in cash — the ₹100 scheme credit can only be spent. **LEDGER CREDIT** is Ravi's ₹2,000 balance moved back in with the ₹1,000 recharge and the ₹100 scheme. **LEDGER DEBIT** is the ₹2,000 moved out plus ₹1,500 of sales. The difference, ₹400, is how much the card balance fell.

## Matching with the customer's ledger

**LEDGER DEBIT** and **LEDGER CREDIT** show what was posted to the customer's account, so the report can be matched line by line with the customer's ledger. When a card that already has a balance is recharged, that balance is posted out of the account and back in with the new recharge, so it appears in both columns. It is not counted as a refund in **CARD REFUND AMOUNT**. Scheme credit the card received on earlier recharges is included again in the credit.

## Totals

**Branch Wise**, **Bill Date**, **Cash Card** and **Grand Total** totals can be switched on under **Report Totals** in the configuration. **Branch Wise** totals need **Branch Wise** ticked under **Report Consolidation**, and **Bill Date** totals need **Bill Date** (or **Document No.**) ticked. On a totals row, **CARD BALANCE AMOUNT** and **CLOSING BALANCE AMOUNT** add up each card's latest balance, and the averages are left blank.

## Good to know

* The report shows the cards' figures only; double-clicking a row does not open the documents behind it.
* To check one card's history entry by entry, you can also use **View Card History** in the **Cash Card Manager**.


---

# 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/cash-card-status-report.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.
