> 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/setups/setup-accounts/setup-customer-database/enter-customer-points-opening-balance.md).

# Enter Customer Points Opening Balance

**YouTube:** [How to Enter Retail Customer Loyalty Points Opening Balance Manually or via Excel?](https://www.youtube.com/watch?v=1KgCv9eewhE)

## How to Enter Retail Customer Loyalty Points Opening Balance Manually or via Excel?

In this tutorial, we will guide you through the process of **entering customer points opening balance** in **Logic ERP** and demonstrate how these points can be redeemed during billing.

***

### Enter Customer Points Opening Balance

* Navigate to the **Enter Customer Points Opening Balance** module.
* Select the **customer** for whom you want to define the opening balance.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Ff0blY3BvvU4Ocl1fBliS%2FChoose%20Customer.png?alt=media&#x26;token=ba546a59-bba5-4426-ae64-b1203f49c048" alt=""><figcaption></figcaption></figure>

* Click **Refresh** to load the selected customer details.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2F9OLUTIy1gWuEDwEYO8PL%2FRefresh%202.png?alt=media&#x26;token=807904b0-9131-4600-b6a1-49b4f0141418" alt=""><figcaption></figcaption></figure>

***

### Enter Opening Balance Details

* Enter the **Opening Balance Date** and the corresponding **Customer Points Opening Balance**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fd6rnL7KpBMnLq1CzU4kJ%2FEneter%20Man.png?alt=media&#x26;token=b107dcb7-327c-4f27-a792-f7617b883c3a" alt=""><figcaption></figcaption></figure>

* To apply the same value across the entire column:
  * Press the **F2 key**
  * Select the required date or value
  * The selected value will be applied to all rows in a single action.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FZeb13vaDlwpV4xTVH6jE%2FDate%20-%20F2.png?alt=media&#x26;token=1570a421-bbef-482b-9006-a3f48082c10a" alt=""><figcaption></figcaption></figure>

* After entering the details, click **Save**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FDlglY7VFUaw7RfZjZNQB%2FSave.png?alt=media&#x26;token=1a5c7540-3ef1-4ced-a514-9a87abf0fd80" alt=""><figcaption></figcaption></figure>

This completes the **manual entry** of customer points opening balance.

***

### Verify Points in Billing Module

* Open the **Billing module**.
* Select the same customer whose opening point balance was entered.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fm6AbAFXmsRGba3soGnD4%2FCustomer%20Loyalty%20Points.png?alt=media&#x26;token=5cce57d9-edbc-4fea-90bd-be866cf7793e" alt=""><figcaption></figcaption></figure>

As you can observe, the **opening balance of 10 loyalty points** is correctly reflected for the customer.

***

### Redeem Customer Points During Billing

* Proceed with billing for the selected customer.
* Upon saving the bill, the **Available Discounts** window appears showing the applicable **points-based discount**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FQBIogfpKIf7ibGn4ZNHl%2FPrompt.png?alt=media&#x26;token=a9aad0c0-107b-4335-8bec-17c429b842a7" alt=""><figcaption></figcaption></figure>

* Select the discount and click **OK**.
* A confirmation window displays:
  * Total points earned
  * Points value as per configuration

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FSXoD4Z4ITZBV8YKIctl4%2FTotal%20Earned%20Points.png?alt=media&#x26;token=41bdf1a9-b32e-475c-a573-6042dcd7df86" alt=""><figcaption></figcaption></figure>

* Click **Yes** to redeem points on the current bill.
* Enter the number of points to redeem and click **OK**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FJjpNHJnRmUD57zDq1Dkx%2FPoint%20Reedem.png?alt=media&#x26;token=60d634c1-5782-418a-8558-519170b4392a" alt=""><figcaption></figcaption></figure>

* Save the bill to complete the transaction.

***

### Import Customer Points Opening Balance from Excel

* Return to the **Enter Customer Points Opening Balance** module.
* Select **Retrieve from Excel**.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fxm8H0s9hFbzdtfBAYmoW%2FRet%20Tick.png?alt=media&#x26;token=0f14d3fd-a251-4aff-862c-63929e32ffce" alt=""><figcaption></figcaption></figure>

* Prepare the Excel sheet with the heading **MEMBERSHIP NUMBER** in column 1 and **OPENING BALANCE** in column 2, with one customer per row below the headings. You may also put the opening balance date in column 3, or enter the date on screen after loading the data.
* Click on the **Excel icon** to browse and select the prepared Excel file.
* Click **Refresh** to load the data.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FY1sp4nrOEVzActf5ocLi%2FrEFREHS.png?alt=media&#x26;token=e2ea49b7-34fc-4786-972d-cf5d91125c34" alt=""><figcaption></figcaption></figure>

* As observed, the imported customer points opening balance details are accurately reflected.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2FMAc5lMjfGNKNLvdb2ltl%2FImported.png?alt=media&#x26;token=11434a2a-745b-4dc4-96e6-a245ef2e141a" alt=""><figcaption></figcaption></figure>

* Click **Save** to complete the import.

This allows you to update opening balances for **multiple customers simultaneously**, saving time and reducing manual effort.

***

### Verify Imported Points in Billing

* Open the **Billing module**.
* Select a customer whose points were imported from Excel.

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fwy7hSXRgy0QIqUnG7TlZ%2F20.png?alt=media&#x26;token=e265cc2d-f935-489c-9cdd-9ff960017ab8" alt=""><figcaption></figcaption></figure>

You will see that the **opening point balance is correctly reflected**, confirming a successful import.

***

### Customer Point Ledger Report

Finally, open the **Customer Point Ledger Report**.\
This report provides a **detailed view of customer loyalty points**, including:

* Opening balance (the **OPENING BALANCE** column is hidden by default; add it from **Set Column Attributes**)
* Points earned
* Points redeemed
* Balance points (the **BALANCE POINTS** column; there is no separate closing balance column)

<figure><img src="https://4031188996-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FXMVkjt8zqHBQX1c9QvFS%2Fuploads%2Fxr6zKdyNzEx017V3ysuz%2FReport%20--.png?alt=media&#x26;token=86433caf-3f1b-4ef0-8144-3f287d867764" alt=""><figcaption></figcaption></figure>

***

### Summary

* Customer points opening balance can be entered **manually or via Excel import**
* Points are automatically reflected in billing
* Customers can redeem points during sales transactions
* Customer Point Ledger Report enables complete tracking and transparency


---

# 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/setups/setup-accounts/setup-customer-database/enter-customer-points-opening-balance.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.
