Deduction
Introduction
A deduction master is defined to create a reference between ledger codes and the standard and statutory deductions that are deducted in various creditor bills. By defining this deduction master, the 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
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
The data given in the table is sample data.
Procedure
Data Definition
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 an 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 Category
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 payment to be made for a contractor, TDS deduction is done and “Contractor” would be mapped to the sub-ledger type. Click SubLedger Category for the master details
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 needs to be made. If the sub-ledger type is present then the GL code has to be a control code of that sub-ledger. If sub-ledger type is blank, then the GL 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 represents 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 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.
Entity Specific Checklist
This checklist covers the activities which are specific to the entity.
1
Deduction Code should 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.
Attachments
Configuration Data Templateconfiguration-data-template-deduction.xlsx - 10KB
Sample Datasample-confugration-data-deduction.xlsx - 10KB
Last updated
