Adding & Editing Sub Ledger - Others in Ginesys HO

A sub ledger, or subsidiary ledger, is a subset of the general ledger used in accounting. It shows details for part of the accounting records such as property and equipment, prepaid expenses, etc. Sub ledgers are basically used to bifurcate a broader head into multiple sub head to keep more control transparency and reporting purpose.This article describes how to manage Sub-Ledger Others in Ginesys HO.

Add Sub - Ledger Others

Prerequisites

The user's role must have access to the Sub Ledgers - Others feature by enabling Add application operation in Ginesys Web - Admin - Security - Roles through Ginesys Web - Finance - Setup - Chart of Account.
The parent Ledgers must be created for which ledger to be created.

Step-by-step guide

The steps are as follows:

Go to Ginesys Web > Finance > Chart of Accounts > Sub Ledger - Other.
Click on the Add button.
Add Sub Ledger - Other window will open.
Put in the Sub Ledger ID and Name fields. These are the mandatory fields.

There are two tabs- General and Finance.

General Tab

The General tab contains the sections like - General, Goods & Service Tax Details, Billing Details and Shipping Details etc.

General

The General section includes the following fields:

Field name	Function
Class Name	This field allows to choose the Class Name for your sub ledger from the drop down. This is a mandatory field.
Class Type	This field displays the Class Type. This field auto populates as soon as you select the Class Name. In this case, this will always display Other.
AR Ledger	This field allows you to choose the ledger whose sub ledger it would be. Here, the values has to be selected from a drop down list.
Cheque Label	This field records the Account name which will be used to draw cheques for payment. It could be name of a particular person or an organisation.
PAN	This field records the PAN number of the person for whom the sub ledger is being created.
Transporter Name	This fields helps you to choose the transporter name from the drop down list.
Remarks	This is a text only field. It allows you to note any needed information about the sub ledger.

Goods & Service Tax Details

This section displays the Goods & Service Tax details. This section includes the following fields:

Field Name	Function
GST Category	This field allows you to choose the GST category of the sub ledger. This is a mandatory field.
GST Identification No.	This field displays the GST Identification No. The GSTIN No. should be of exact 15 digits. This field also includes a date field, which allows you to select the date of the GSTIN number.
GST State	This field fills its value automatically after entering the GST Identification No.

Billing Details

This tab allows you to enter the billing details of the entity for whom sub ledger is being made. This includes the following fields:

Field Name	Function
Contact person	This has two related fields: Name (name of the contact person) and Mobile Number (mobile number of the contact person).
Address	This has seven (7) related fields: Address City Std Code District State Pin Code Country Address, City and Pin code are user inputs; however, City can be selected from the lookup. The Std Code, State and Country fields are automatically displayed on selection of City.
Phone Number	In this section, three (3) Office numbers of the person or entity can be recorded along with his Fax Number and his Residence Number.
Email	This section has the option of recording two (2) Email ids of the person or entity.
Website	The person or entity's website link can be recorded here.

Shipping Details

Field Name	Function
Contact person	This has two related fields: Name (name of the contact person) and Mobile Number (mobile number of the contact person). These are mandatory fields.
Address	This has seven (7) related fields: Address City Std Code District State Pin Code Country Address, City and Pin code are user inputs; however, City can be selected from the lookup. The Std Code, State and Country fields are automatically displayed on selection of City.
Phone Number	In this section, three (3) Office numbers of vendor can be recorded along with his Fax Number and his Residence Number.
Email	This section has the option of recording two (2) Email ids of the person or entity.
Website	The person or entity's website link can be recorded here.
Copy Billing Address (button)	The button allows copying of the Billing Address details into the corresponding fields to avoid redundancy.

Finance tab

The Finance tab allows you to make transactions using the ledgers. You will get two sections under the Finance tabs - Allow to transact with these Ledgers and Applicable Sites.

Allow to transact with these Ledgers:

Apart from the AR/AP ledger, if the customer has to do other financial transaction, then the respective ledger needs to be tagged in this block. Only the General type ledgers selected here will be allowed for transaction with the selected customer. The Add Row button allows you to add a blank row at the bottom of the list.

Field Names	Functions
General Ledger Name	The values in this field are selected from a drop down list, which displays the Name, Type and Site Applicable of the non-extinct General nature ledgers.
Extinct	If selected, it will extinct the tagging of the respective Sub Ledger with the customer.

Applicable Sites: The Applicable Sites tab allows you to select sites for the sub ledger.

Field Name	Function
Site Name	This displays the selected sites applicable for the selected Sub Ledger. Site can be selected through the Select Site button.
Site Type	This displays site type of applicable sites.
Extinct	Since selected sites cannot be deleted, the Extinct option has been provided. If required the Sub Ledger - Site tagging can be made extinct.
Select Site (Button)	On clicking this button, the Select Site window opens which lists all sites and site types from which user can select the sites for which the selected Sub Ledger will be applicable. On clicking the Populate button, the selected sites populates in the main window. Important Applicable sites will be enabled only for the selected ledgers which are Site applicable. Applicable sites are tagged to selected Sub Ledger. At least one site selection is mandatory if site is applicable for the selected sub ledger. Multiple site selection allowed.

TDS

Although it is customary to deduct TDS for services rendered, yet jobbers and other service providers often apply and get certain relaxations on the TDS rate based on various criteria. These are attested by the exception certificates awarded by the government to a specific service provider for a particular financial year. Such details of a service provider is captured in the Exception Details section of the TDS tab.

The TDS Applicable checkbox needs to be checked to enable the TDS window.

Specify TDS Source- The source name for TDS calculation must be selected mandatorily from the drop down box. The source name is an identifier for the different TDS heads of Corporate and Non Corporate type. It is displayed from TDS Source Definition.

TDS Information

Field Name	Function
Add Row (Button)	It adds a blank row at the bottom of the list.
TDS Name	Name of the tax to be deducted from TDS Section Definition.
Section	Display field which is automatically populated once TDS name is selected.

Exception Details

Field Name	Function
Date From	Calendar field, must take value within current financial year. Only last date entry TDS Name wise can be modified.
Date To	Calendar field, must take value within current financial year. Only last date entry TDS Name wise can be modified. Note: Date From ≦ Date To
Certificate No.	The Government of India issues a Certificate to some entities for Lower Deduction of TDS. The Certificate Number allows you to capture this detail, if present. Duplicate number is not allowed.
Max Limit	The maximum amount till which the exception rate of TDS provided in the next column will be applicable. For example: The TDS Rate for commercial entity may be 5% for upto 200,000.00 and above that a general rate of 10% may be applicable.
TDS Rate	The rate at which the TDS will be deducted as long as the service amount is within the exception limit. Important It cannot be : Zero Negative Blank - if Maximum Limit has been provided

Once all the necessary details are filled in click on the Save button and save the details .

Edit Sub Ledger - Other

Prerequisites

The user's role must have access to the Sub Ledgers - Others feature by enabling Modify application operation for the feature Sub Ledgers - Others feature in Admin - Security - Roles through Finance - Setup - Chart of Account.
The parent Ledgers must be ready for this ledger to be created.

Step-by-step guide

The steps are as follows:

Go to Ginesys Web > Finance > Setup > Sub Ledger - Others.
Sub Ledger - Others module will open.
Select one sub ledger you want to edit.
Go to Action > Edit or double click on the selected sub ledger.
Edit Sub Ledger - Others window will open.
All the data will be populated.
Edit the required field.
Click on the Save button to save the edited data.

Note: One time master creation for section 194Q has to be done manually with tagging of all eligible TDS source and their respective TDS rate.

Reflection in Vendor Master

Under TDS Information block, a new column has been introduced for TDS Type in Vendor, Customer, Employee and Other sub ledger master.
The TDS Name can be quickly chosen by the new TDS Type column in the drop-down list.
Note: One time effort is to be applied to mark the eligible vendors for TDS Applicable and specify the Exception Limit for the year.
- Check: Sum of Invoice value already created during this year, needs to deducted from maximum exception limit, for respective vendors.
- Ex: If total value of Invoice raised till 30th June is 20Lacsfor a given vendor, then exception limit for that Vendor should be 30Lacs i.e.(50L - 20L). From next year Limit should be on full value i.e. 50Lacs.

Online Printing option is now available from version 12.6.6 onwards.

To go back to the main page click on the link : How To: Manage Setup in Ginesys Finance