Customer Ledger

Implementation Updated by Implementation

What is Customer Ledger?

A customer ledger is a record of all of a company's accounts receivable. A customer ledger is a specific part of a company's general ledger devoted entirely to the company's transactions with its customers.


In customer ledger, user can see all transaction  made with customers. Also it is treated as confirmation between both parties on closing balance.

Use Case

Suppose there is a firm “XYZ Ltd”. They want to maintain a ledger to keep specific customer record with all happened transactions.

With this option, User can maintain all customer records specifically.

Steps to be performed for Customer Ledger

1.Go to Account Receivables

2.Go to Reports and click on Customer Ledger Reports.

2.1.Select Customer and enter period and then click on search.

2.2.Customer Ledger Report will open with complete details.

3.There are 3 types of sorting a)Posting Date Wise b)Document Date Wise c)Document Number Wise.

4.If user is using Customer Clearing or Bill Receivable option then they can see open i.e. pending bills to be cleared by selecting open in clearance it will show only open bills.

4.1.a)If user want to see quantity details as if user is using Material Management too then tick on Quantity Details

b)User can see the quantity details in Narration.

4.2.a)If user want to see every transaction in single line then click on marked button in screen shot.

b)Here user can see the entry reflection is one line.

4.3.a)User can take print out for confirmation from Customer. Just click on marked icon in screen shot.

b)This is confirmation page

5.Print-> Click on marked icon in screen shot

5.1. here user can print report with different filters a)Agent Wise b)Ledger Group Wise (if different ledger groups are maintained for customers) c)Only Debit balance customers d)Only credit Balance customers e)Only zero balances customers f)All customers g)And if user want to take printout of a specific customer then just select customer and click on “Get PDF”. Also user can download report in excel with same filters just click on Get “Get XLS”.

6.User can set page layout of customer ledger. As if user does not want a column to show in report and want to move the column then user can use page layout.

How did we do?

Customer Foreign Clearance

Debit Note