This format is used to Create/Alter the Ledgers in the Tally.
Columns in Ledgers:
Name
Data Type: Text.
Field In Tally: Name.
Description: Name of the Ledger Group. It is the Primary Key in the Ledgers. If the name already exists in Tally then the old record will be replaced with the new record.
NameAlias
Data Type: Text.
Field In Tally: (alias).
Description: Name Alias for the Ledger.
Parent
Data Type: Text.
Field In Tally: Under.
Description: Name of the Parent Group.
OpeningBillDate
Data Type: Date. (20090331/31-Mar-2008)
Field In Tally: Date.
Description: Bill Date in the Opening Balance.
OpeningName
Data Type: Text.
Field In Tally: Name.
Description: Bill No. in the Opening Balance.
OpeningCreditPeriod
Data Type: Number/Date. (20090331/31-Mar-2008)
Field In Tally: Due Date or Credit Days.
Description: Credit Period in the Opening Balance. This can be a Date or the Number of Days.
OpeningBalance
Data Type: Amount. (10000.00/-10000.00)
Field In Tally: Amount.
Description: Bill Amount in the Opening Balance. Negative Balance indicates Debit Balance.
ContactPerson
Data Type: Text.
Field In Tally: Contact Person.
Description: Contact Person Name of the Party.
Address1, Address2, Address3, Address4
Data Type: Text.
Field In Tally: Address.
Description: Address Lines of the of the Party.
State
Data Type: Text.
Field In Tally: State.
Description: State Name of the Party.
PinCode
Data Type: Text.
Field In Tally: PIN Code
Description: Pin Code Number of the Party.
Phone
Data Type: Text.
Field In Tally: Telephone no.
Description: Telephone Number of the Party.
Fax
Data Type: Text.
Field In Tally: Fax.
Description: Fax Number of the Party.
Data Type: Text.
Field In Tally: E-Mail.
Description: Email Address of the Party.
IncomeTaxNumber
Data Type: Text.
Field In Tally: PAN/IT No.
Description: PAN/IT No of the Party.
SalesTaxNumber
Data Type: Text.
Field In Tally: VAT TIN No.
Description: Sales Tax Number.
TDSDeducteeType
Data Type: Text. (Individual/HUF – Resident/Partnership Firm/etc)
Field In Tally: Deductee Type.
Description: TDS Deductee Type.
ForServiceTax
Data Type: Text.
Field In Tally: Is Service Tax Applicable.
Description: Enable Service tax for the Ledger.
BillWiseOn
Data Type: Text. (Yes/No)
Field In Tally: Maintain Balances bill-by-bill.
Description: Value for Maintain Balances bill-by-bill.
CostCentresOn
Data Type: Text. (Yes/No)
Field In Tally: Cost Centres are Applicable.
Description: Value for Cost Centres are Applicable.
AffectInventory
Data Type: Text. (Yes/No)
Field In Tally: Inventory values Are Affected.
Description: Value for Inventory values Are Affected.