Sub Ledger Master
Introduction
Once the SubLedger Category is created the Subledger master need to be defined. The Subledger master will help to record the transaction at the most detailed level. Subledger category is referred to as “Account detail type” here.
By recording the transaction at the Subledger level, detailed reports can be generated.
Data Table
| Sr. No | Account detail type* | Name* | Code* | Narration |
|---|---|---|---|---|
1 | Telephone | 0999784563 | 001 | Telephone Number |
2 | Other Creditors | Park Welfare Society | Park Welfare | Park Welfare |
The data given in the table is sample data.
Procedure
Data Definition
| Sr No | Column Name | Data Type | Data Size | Is Mandatory? | Definition/ Description |
|---|---|---|---|---|---|
1 | Account Detail Type | Text | 100 | Yes | The Account detail type indicates the name of the subledger category name, this will help the user to identify the subledger account while recording the transaction |
2 | Name | Alphanumeric | 50 | Yes | The name of the subledger master, wherein the user will record the transaction at the most detailed level |
3 | Code | Alphanumeric | 50 | Yes | The unique code gives to the Subledger master |
4 | Narration | Text | 250 | No | A short narration provided to the subledger master |
Steps to fill data
Download the workflow template attached to this page.
Have it open and go through all the headers and understand the meaning of them by referring 'Data Definition' section.
Make sure all the headers, its data type, field size and its definition/ description is understood properly. In case of any doubt, please reach out to the person who has shared this document with you to discuss the same and clear out the doubts.
Identify all subledger master details.
Start filling the data starting from serial no. and complete a record at once. repeat this exercise until the entire data is filled into a template.
Verify the data once again by going through the checklist and taking care of each and every point mentioned in the checklist.
Checklist
The checklist is a set of activities to be performed once the data is filled into a template to ensure data type, size, and format of data is as per the expectation. These activities have been divided into 2 groups as given below.
Common Checklist
This checklist covers all the activities which are common across the entities.
| Sr. No | Checklist Parameter | Example |
|---|---|---|
1 | Make sure that each and every point in this reference list has been taken care of |
Entity Specific Checklist
This checklist covers the activities which are specific to the entity.
| Sr. No. | Activity | Example |
|---|---|---|
1 | The name should be unique and should not contain any special characters | Telephone : [Allowed] #Telephone! : [Not allowed] |
Attachments
Configuration Data Templateconfiguration-data-template-subledger-master.xlsx - 12KB
Sample Datasample-confugration-data-subledger-master.xlsx - 12KB
Last updated
