Introduction
A deduction master is defined to create a reference between ledger codes and to the standard and statutory deductions that is deducted in various creditor bills. By defining this deduction master, accounts department can process the remittance of all the deductions done for a time period at once and keep track of the same.
An example of a deduction is what is deducted from salary bill as income taxes.
Data Table
Sr. No* | Deduction Name* | Deduction Code* | Subledger Type | Account Code* | *Remitted To | IFSC Code | Account No | Description |
|---|---|---|---|---|---|---|---|---|
1 | CPF Deduction | CPF | Employee | 3502003 - CPF Deduction | Central Provident Fund Board | UBIN0XXXX69 | 2XXXX1234XX4 | CPF Deduction |
2 | TDS Deduction | TDS | Contractor | 3502001 - TDS Deduction | Central Government | ICICI00XXXX7 | 6XXX97156XX5 | TDS Deduction |
3 | TDS from Employees | TDS Employees | Employee | 3502008 - TDS Employee | Central Government | HDFC00XXX51 | 9XXXX759691XX7 | TDS from Employees |
Note: Data given in the table is a sample data.
Procedure
Data Definition
Sr No | Column Name | Data Type | Data Size | Is Mandatory? | Definition/ Description |
|---|---|---|---|---|---|
1 | Deduction Name | Text | 250 | Yes | The name for the deduction head, wherein users use this deduction head name while posting the transactions into the system and also user can generate individual report using the deduction name. |
2 | Deduction Code | Alphanumeric | 20 | Yes | A unique code that identifies the deduction name, this will help the user to easily identify the deduction type while doing a transaction. |
3 | Subledger Type | Text | 250 | No | The Subledger type is the value which will tell the party type associated with the deduction. This will be aligned with the standard set of sub-ledger types in DIGIT like - Contractor, Supplier and Employee. Example: When a payment to be made for a contractor, TDS deduction is done and “Contractor” would be mapped to the subledger type. |
4 | Account Code | Alphanumeric | 50 | Yes | A particular GL code would be mapped for the deduction code, these accounts codes would be used in the transaction when a deduction need to be made. If the subledger type is present then the GL code has to be a control code of that subledger. If subledger type is blank, then the GL code code mapped will be a non-control code. |
5 | Remitted To | Text | 250 | Yes | The “Remitted To” represent the relevant government department to which all the statutory remittances like Provident fund, TDS, CPF and ESI etc are deducted and remitted as per the Act. So while making the payment the “Pay To” will be set to this value. |
6 | IFSC Code | Alphanumeric | 11 | No | The Bank IFSC code pertaining to the bank branch to which the payment will be made for this particular deduction. |
7 | Account No | Alphanumeric | 25 | No | The Bank account number represent the account number to which all the deduction which are made would be remitted. |
8 | Description | Text | 250 | No | A short description shows the deduction details for which the remittance made to the relevant government department. |
Steps to fill data
Download the data 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 different types of deduction.
Start filling the data starting from serial no. and complete a record at once. repeat this exercise till 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.
Entity Specific Checklist
This checklist covers the activities which are specific to the entity.
Sr. No. | Activity | Example |
|---|---|---|
1 | Deduction Code should to be unique and no special character is allowed. | CPF : [Allowed] #CPF! : [Not allowed] |
2 | The format of the Account Code to be 7 to 9 digits numeric and unique no repetitive code should be entered. Only detailed account code should be listed here and this should be an active code in the COA master. | Click on Chart of Accounts for master details. |