Customer Sub Ledger Balance – A summary of the activity
This activity allows you to set the criterion to generate the sub ledger balance of a customer. A company requires the sub ledger balance of a customer at the end of every financial period. The debit and the credit balance can be viewed for the customer in both the transaction currency and the base currency of the company. It can also be viewed for a period of time, which could be a financial period / year or a date range.
You can search by specifying the range of customers for whom you want to view the balance. You can also select the date range for which you want to view the balances and the currency in which you want to view the report. The system generates the balance details based on the search criterion entered. You can view the details of the customer, the finance book, the debit and credit balances in the base currency and account currency, the net balance in the base currency and the date on which the report has been generated.
Detail customer subledger balance
The detail customer subledger balance is generated when the “Report Type” field is set as "Details".
|
Report Heading |
Customer Ledger |
|
Header Information |
Finance Book, Account, Account Code |
|
Columns Printed |
Group Header Details Label, Customer Description, Customer Code, Amount In (Currency) Data Element Details Transaction Date, Transaction Type, Transaction Number, Narration, Debit and Credit Opening Balance for a customer and given start date Net Customer Balance of the fields Debit and Credit for each transacted currency Net Account Balance of the fields Debit and Credit for each transacted currency |
Summary-wise customer subledger balance
The summary-wise customer subledger balance is generated when the “Report Type” field is set as "Summary".
|
Report Heading |
Customer Ledger |
|
Header Information |
Finance Book, Account, Account Code, Amount In (Currency) |
|
Columns Printed |
Data Element Details Customer Code, Customer Name, Opening Balance, Period Debit, Period Credit, Closing Balance |
Click here to know more about generating the customer sub ledger balance.