EXCECL TO TALLY AUTOMATION E- COMMERCE

by with No Comment Excel to TallyOneClickPAID UTILITYTally Prime TDLTDL 2020TDL for Tally

 

This is Excel to Tally Automation to Import your E-Commerce Data Entry into Tally wit Easy and quick way. With this software we can import Masters and Vouchers with every detail. It work perfectly with Tally ERP9 and Tally Prime. Support GST and Vat Entries. It holds below features that make it best Excel to Tally E-Commerce Data Import software :
ü Realtime connection with Tally
ü Master and Voucher Creation in Same Sheet
ü Change Tally ledger name and Item name direct from Excel.
ü Import Text, CSV, Excel formats Directly in this sheet

ü Auto Calculation columns of Cell address, Round off, Taxable Value etc with Validate Button
ü Upto 25000 entries with one click
ü Very supportive formats for every type work.
ü Small and supportive file, work with every version of Excel
ü Lifetime Use, No renewal required, 24×7 free support.
Contains below Sheets to powerup Data Entry work:
LEDGER MASTER:
1. OWN GROUP
2. ALIAS
3. FULL ADDRESS WITH CONTACT DETAILS
4. FULL GST DETAILS
5. OTHER DETAIL ENABLING OPTION
6. CREDIT LIMIT
7. LEDGER DESCRIPTION
8. TDS DETAILS
9. BANK DETAILS
10. OPENING BALANCES
STOCK MASTER:
1. OWN GROUP
2. ALIAS
3. BATCH DETAILS
4. GST DETAILS
5. MRP DETAILS
6. STANDERD RATES
7. OPENING BALANCES
UNIT MASTER:
1. FORMAL NAME
2. DECIMAL PLACES
Amazon B2C
1. FULL DETAILED INVENTORY VOUCHER.
2. WITH CLEAR, IMPORT, VALIDATE, POST MASTER NAD POST VOUCHER BUTTONS.
3. GET CSV, TEXT, EXCEL FORMATS DIRECTLY IN TO THE SHEET.
4. AUTO CALCULATION FIELDS TO RELATE VOUCHERS AND ITEMS.
5. SAME AMAZON SHEET FORMAT

6. WITH TCS AND GST EFFECTS
7. NO BOUNDATION FOR DATES, USE LIFETIME
8. MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER
9. DEBIT CREDIT WILL CALCULATE AUTOMATIC
10. ALL LEDGERS WITH SHIPPING, WRAP, DISCOUNT, GST ,TCS ETC.

11. PARTY STATE AND PLACE OF SUPPLY
12. SUPPORT BILLWISE DETAILS
13. GST DETAIL FOR CREDIT AND DEBIT NOTES

Amazon B2B
1. FULL DETAILED INVENTORY VOUCHER.
2. WITH CLEAR, IMPORT, VALIDATE, POST MASTER NAD POST VOUCHER BUTTONS.
3. GET CSV, TEXT, EXCEL FORMATS DIRECTLY IN TO THE SHEET.
4. AUTO CALCULATION FIELDS TO RELATE VOUCHERS AND ITEMS.
5. SAME AMAZON SHEET FORMAT

6. WITH TCS AND GST EFFECTS
7. NO BOUNDATION FOR DATES, USE LIFETIME
8. MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER
9. DEBIT CREDIT WILL CALCULATE AUTOMATIC
10. ALL LEDGERS WITH SHIPPING, WRAP, DISCOUNT, GST ,TCS ETC.

11. PARTY STATE AND PLACE OF SUPPLY
12. SUPPORT BILLWISE DETAILS
13. GST DETAIL FOR CREDIT AND DEBIT NOTES
FLIPKART
1. FULL DETAILED INVENTORY VOUCHER.
2. WITH CLEAR, IMPORT, VALIDATE, POST MASTER NAD POST VOUCHER BUTTONS.
3. GET CSV, TEXT, EXCEL FORMATS DIRECTLY IN TO THE SHEET.
4. AUTO CALCULATION FIELDS TO RELATE VOUCHERS AND ITEMS.
5. SAME FLIPKART SHEET FORMAT

6. WITH TCS AND GST EFFECTS
7. NO BOUNDATION FOR DATES, USE LIFETIME
8. MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER
9. DEBIT CREDIT WILL CALCULATE AUTOMATIC
10. ALL LEDGERS WITH SHIPPING, WRAP, DISCOUNT, GST ,TCS ETC.

11. PARTY STATE AND PLACE OF SUPPLY
12. SUPPORT BILLWISE DETAILS
13. GST DETAIL FOR CREDIT AND DEBIT NOTES
AMAZON SETTLEMENT
1. SPECIAL SETTLEMENT VOUCHER
2. WITH MULTIPLE REFERENCE ENTRY

3. DIRECET GET TEXT FILES INTO THE SHEET
4. AUTOMATIC CALCULATIONS AND SUMMURISED IN SAME SHEET

5. WITH CLEAR, IMPORT, VALIDATE, POST MASTER NAD POST VOUCHER BUTTONS.

6. SAME AMAZON SETTLEMENT FORMAT
RANDOM
1. SIMPLE ACCOUNTING VOUCHERS
2. SALES, PURCHASE, RECEIPT, PAYMENT, CONTRA,JOURNAL ETC IN SAME SHEET.
3. YOUR OWN VOUCHER TYPE
4. NO BOUNDATION FOR DATES, USE LIFETIME
5. MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER
6. SEPARATE DEBIT LEDGERS AND AMOUNT, CREDIT LEDGERS AND AMOUNT
7. SHEET HAS MACRO BUTTONS TO DIRECT POST IN TALLY.

8. SHEET HAS MACRO BUTTONS TO CALCULATE RANDOM DATE AND AMOUNT VOUCHERS.

BANK-VCH:
1. BANK IMPORT WITH SIMPLE BANK FORMAT
2. AUTOMATIC VOUCHER SELECTION
3. SEPARATE CONTRA VOUCHER TYPE
4. NO BOUNDATION FOR DATES, USE LIFETIME
5. ENTRIES DONE WITH RECONCILATION
6. DEBIT AND CREDIT LEDGER OPTION IN SAME COLUMN
7. SHEET HAS MACRO BUTTONS: MASTER CHECK, TALLY LEDGER ALTER, POST IN TALLY.

MULTIPURPOSE SETTLEMENT:
1. IMPORT VOUCHERS WITH UNLIMITED LEDGERS (ONE VOUCHER WITH THOUSANDS OF LEDGER)

2. IDAL FOR FLIPKART SETTLEMENT AND SALARY IMPORT
3. INCLUDE ALL TYPE VOUCHERS- SALES, PURCHASE, JOURNAL, PAYMENT, RECEIPT, CONTRA WITHOUT INVENTORY
4. WITH SINGLE AND MULTIPLE BILL WISE DETAILS

5. WITH COSTCENTER AND COST CATEGORY DETAILS

 

UTILITY ALSO HAVE HELP SHEET, READ CAREFULLY BEFORE USE.
EVERY BUTTON HAS HELP OPTION WITH IT. RIGHT CLICK ON BUTTONS TO GET HELP.
VIDEO HELP: https://youtu.be/6qL2_eJmfFg

WEBSITE : www.Learnwells.com and E2T.in
EMAIL : <Learnwells@outlook.com> and <ssonu@live.com> (Personal Email id)
YOUTUBE : https://www.youtube.com/learnwell/c
FACEBOOK: https://www.facebook.com/learnswell/
CONTACT NO. +91-9131810293 (ASHISH SINGH)

 DOWNLOAD LINK: https://imojo.in/45qf9w

DETAILED VOUCHER TDL

by with One Comment TDL 2019TDL 2020TDL for Tally

 

NOW WORK WILL BE DONE EASILY AND WITH EVERY DETAILS.

In this segment I have special TDL file for your Detailed Voucher. With this you can add BATCH, HSN, GODOWN in your Invoice Vouchers at one place with every Stock Items.

Copy below code and follow instructions

;;……….www.Learnwells.com…….
[#Line : EI ColumnOne]
Option : LWBatchT
[!Line : LWBatchT]
add : fields: after:VCH ItemTitle : LearnWellBatch
[field :LearnWellBatch]
use : name field
Info: “Batch No”
Align : Centre
width :40
Skip:Yes
[#Line : EI InvInfo]
Option : LWBatchD
[!Line : LWBatchD]
add : fields:after: VCH StockItem : LearnWellBatchD
[field : LearnWellBatchD]
Use:VCHBatchName
Set as : $BATCHNAME
Width : 20
Skip:Yes
[#Line:EI ColumnOne]
Add:Field:After:VCH ItemTitle:Learnwells
[Field:Learnwells]
Setas:$$LocaleString:”HSN/SAC”
Width:30
SKIP:YES
[#Line:EI invinfo]
Add:Field:After:VCH StockItem:LearnwellsHSN
[Field:LearnwellsHSN]
Use:Short prompt
Setas:$(StockItem,$stockitem).GSTDetails[Last].HSNCode
[#Line:EI ColumnOne]
Add : Right Field : Before : VCH QtyTitle: Learnwells1
[Field:Learnwells1]
Setas:$$LocaleString:”GODOWN”
Width : 30
SKIP:YES
[#Line:EI invinfo]
Add : Right Field : Before : VCHBilledQty :LearnwellsGDN
[Field:LearnwellsGDN]
Use:Short prompt
Setas:$BatchAllocations[1].GodownName
Width : 30

;;……….www.Learnwells.com…….


FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9 
5. Press F12 and goto Product and Features
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.

Also you can download it with below download button


LIST IN INVOICE

by with 2 Comments TallyTDL 2019TDL 2020TDL for Tally

 

NOW MAKE YOUR OWN LISTS (SALESMAN, SALE  TYPE ETC.) IN VOUCHERS

[#Part: VCHTitle2right]
Option: SaleType:@@IsSales or @@IsPurchase
[!Part :SaleType] 
Add : Line:AtEnd:SaleType
[Line : SaleType]
Field : Medium Prompt,LWSaleType
Local : Field:Medium Prompt:Info:”Sale Type:”
Local : Field:Medium Prompt:Width: 8% Page

[Field:LWSaleType]
Use : Name Field
Storage:SalesTypeLw
Width : 15
Table : LWtbl
[Table : LWtbl]
Title : $$LocaleString:”Types of Sale”
List Name : Counter Sale,Marketing Sale, Campaign Sale, SalesMan Sale, � Not Applicable
Format : $Name

[System: UDF]
    SalesTypeLw:String:1000


FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9 
5. Press F12 and goto Product and Features
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.


EXCEL TO TALLY – AUTOMATION

by with No Comment Excel to TallyExcel VBAOneClickPAID UTILITYTally Prime TDLTDL for Tally

This is Excel to Tally Automation to automate your Data Entry with Tally. It is very helpful to import Excel Data into Tally, easy and quickly. With this software we can import Masters and Vouchers with every detail. It work perfectly with Tally ERP9 and other latest version of Tally. Support GST and Vat Entries. It holds below features that make it best Excel to Tally Data Import software :

ü  Real-time connection with Tally

ü  Match Excel sheet Ledgers and Stock Items direct with Tally and generate uncreated masters list.

ü  Change Tally ledger name and Item name direct from Excel.

ü  Dual Entry System (Direct Oneclick Entry and XML generation also)

ü  Auto Calculation columns of Cell address, Round off, Taxable Value etc with Validate Button

ü  Every time Unlimited Entries with oneclick

ü  Very supportive formats for every type work.

ü  Small and supportive file, work with every version of Excel

ü  Lifetime Use, No renewal required, 24×7 free support.

Contains below Sheets to power-up Data Entry work:

LEDGER MASTER:

1.       OWN GROUP

2.       ALIAS

3.       FULL ADDRESS WITH CONTACT DETAILS

4.       FULL GST DETAILS

5.       OTHER DETAIL ENABLING OPTION

6.       CREDIT LIMIT

7.       LEDGER DESCRIPTION

8.       TDS DETAILS

9.       BANK DETAILS

10.   OPENING BALANCES

STOCK MASTER:

1.       OWN GROUP

2.       ALIAS

3.       BATCH DETAILS

4.       GST DETAILS

5.       MRP DETAILS

6.       STANDERD RATES

7.       OPENING BALANCES

UNIT MASTER:

1.       FORMAL NAME

2.       DECIMAL PLACES

F-D-Invt-VCH

1.       FULL DETAILED INVENTORY VOUCHERS

2.       ITEMS WITH BATCH, GODOWN, DESCRIPTION, MFG-EXPIRY DATES

3.       UNLIMITED STOCK ITEMS WITH EVERY VOUCHER

4.       AUTOMATIC CELL ADDRESSES TO RELATE ITEMS WITH VOUCHER

5.       TAXABLE LEDGER FOR EVERY ITEM FOR ITEM ALLOCATION

6.       YOUR OWN VOUCHER TYPE

7.       NO BOUNDATION FOR DATES, USE LIFETIME

8.       MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER

9.       NO DEBIT CREDIT OPTION (IT WILL CALCULATE AUTOMATIC)

10.   22 LEDGERS IN ONE VOUCHER TO SUPPORT ALL GST RATES WITH EXEMPTED (IT MAY INCREASE)

11.   INCLUDE TRANSPORTING CHARGE, OTHER CHARGE, DISCOUNT, ROUND OFF LEDGERS.

12.   SUPPORT BILLWISE DETAILS

13.   GST DETAIL COLUMNS FOR CREDIT AND DEBIT NOTES

14.   CONSINGEE AND BUYER DETAILS WITH GST TYPE, GST NUMBER, PLACE OF SUPPLY ETC.

15.   FULL DESPATCH DETAILS.

16.   TAX CLASSIFICATION DETAIL COLUMN

17.   SHEET HAS MACRO BUTTONS : MASTER CHECK, TALLY LEDGER ALTER, TALLY STOCK ITEM ALTER, VALIDATE, DIRECT POST IN TALLY WITH XML GENERATE

F-D-VCH:

1.       FULL DETAILED VOUCHERS

2.       YOUR OWN VOUCHER TYPE

3.       NO BOUNDATION FOR DATES, USE LIFETIME

4.       MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER

5.       DEBIT CREDIT OPTION FOR EVERY LEDGER

6.       22 LEDGERS IN ONE VOUCHER TO SUPPORT ALL GST RATES WITH EXEMPTED (IT MAY INCREASE)

7.       INCLUDE TRANSPORTING CHARGE, OTHER CHARGE, DISCOUNT, ROUND OFF LEDGERS.

8.       SUPPORT BILLWISE DETAILS

9.       GST DETAIL COLUMNS FOR CREDIT AND DEBIT NOTES

10.   CONSINGEE AND BUYER DETAILS WITH GST TYPE, GST NUMBER, PLACE OF SUPPLY ETC.

11.   FULL DESPATCH DETAILS.

12.   TAX CLASSIFICATION DETAIL COLUMN

13.   SHEET HAS MACRO BUTTONS : MASTER CHECK, TALLY LEDGER ALTER, VALIDATE, POST IN TALLY.

M-B-Invt-VCH:

1.       MULTI BATCH INVENTORY VOUCHER

2.       FULL DETAILED INVENTORY VOUCHERS

3.       ITEMS WITH MULTIPLE BATCHES, GODOWN, DESCRIPTION, MFG-EXPIRY DATES ETC.

4.       UNLIMITED STOCK ITEMS AND UNLIMITED BATCH FOR EVERY ITEM WITH EVERY VOUCHER

5.       AUTOMATIC CELL ADDRESSES TO RELATE ITEMS WITH VOUCHER AND BATCHES WITH ITEMS

6.       YOUR OWN VOUCHER TYPE

7.       NO BOUNDATION FOR DATES, USE LIFETIME

8.       MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER

9.       NO DEBIT CREDIT OPTION (IT WILL CALCULATE AUTOMATIC)

10.   SUPPORT BILLWISE DETAILS

11.   GST DETAIL COLUMNS FOR CREDIT AND DEBIT NOTES

12.   SHEET HAS MACRO BUTTONS : MASTER CHECK, TALLY LEDGER ALTER, TALLY STOCK ITEM ALTER, VALIDATE, DIRECT POST IN TALLY.

 

SMPL-Invt-VCH:

1.       SIMPLE INVENTORY VOUCHERS

2.       ITEM NAME, UNIT, RATE, AMOUNT

3.       YOUR OWN VOUCHER TYPE

4.       NO BOUNDATION FOR DATES, USE LIFETIME

5.       MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER

6.       SEPARATE DEBIT LEDGERS AND AMOUNT, CREDIT LEDGERS AND AMOUNT

7.       SHEET HAS MACRO BUTTONS : MASTER CHECK, TALLY LEDGER ALTER, TALLY STOCK ITEM ALTER, VALIDATE, DIRECT POST IN TALLY.

 

SMPL-VCH:

1.       YOUR OWN VOUCHER TYPE

2.       NO BOUNDATION FOR DATES, USE LIFETIME

3.       MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER

4.       DEBIT LEDGERS, CREDIT LEDGERS AND THERE AMOUNT

5.       SHEET HAS MACRO BUTTONS: MASTER CHECK, TALLY LEDGER ALTER, POST IN TALLY.

 

BANK-VCH:

1.       BANK IMPORT WITH SIMPLE BANK FORMAT

2.       AUTOMATIC VOUCHER SELECTION

3.       SEPARATE CONTRA VOUCHER TYPE

4.       NO FOUNDATION FOR DATES, USE LIFETIME

5.       ENTRIES DONE WITH RECONCILIATION

6.       DEBIT AND CREDIT LEDGER OPTION IN SAME COLUMN

7.       SHEET HAS MACRO BUTTONS: MASTER CHECK, TALLY LEDGER ALTER, POST IN TALLY.

UTILITY ALSO HAVE HELP SHEET, READ CAREFULLY BEFORE USE.

EVERY BUTTON HAS HELP OPTION WITH IT. RIGHT CLICK ON BUTTONS TO GET HELP.

VIDEO HELP: https://youtu.be/f6bReb0fuR4

WEBSITE : www.Learnwells.comand E2T.in

EMAIL :     Learnwells@outlook.com  and ssonu@live.com(Personal Email id)

YOUTUBE : https://www.youtube.com/learnwell/c

FACEBOOK: https://www.facebook.com/learnswell/

CONTACT NO. +91-9131810293 (ASHISH SINGH)

AUTO IMPORT – PAYROLL | EXCEL2TALLY

by with No Comment Excel to TallyOneClickPAID UTILITYTDL for Tally

THIS IS EXCEL2TALLY- Auto Import – Payroll
WITH THIS WE CAN UPLOAD SALARY/PAYROLL DATA FROM EXCEL TO TALLY WITH ALL DETAILS WITH EMPLOYEE MASTER, ATTENDANCE, PAYROLL VOUCHERS.

MAINTAIN YOUR SALARY SHEET AND IMPORT EVERY TIME IN TALLY WITH ONE CLICK WITH EMPLOYEE MASTER, ATTENDANCE , PAYROLLS.

WITH THIS AUTO IMPORT SOFTWARE NOW YOU CAN UPLOAD ENTRIES WITH BELOW FEATURES:


* EMPLOYEE MASTER :  WITH ALIAS, ADDRESS, ALL GENERAL INFORMATION, BANK DETAILS, STATUTORY DETAILS, MULTIPLE PAYHEADS WITH THERE AMOUNT.


* ATTENDANCE VOUCHER : NOW TAKE ATTENDANCE WITH UNLIMITED EMPLOYEES WITH ALL DETAILS (AS WITH – WORKING DAYS, WORKING HOURS OR ANY OTHER FORM OF WORK THAT YOU WANT TO TAKE WITH ATTENDANCE VOUCHER.) NOW WITH AUTO CELL ADDRESSFOR MULTIPLE VOUCHERS WITH MULTIPLE EMPLOYEES.


* PAYROLL VOUCHER : VOUCHER WITH UNLIMITED EMPLOYEE, MULTI PAY HEADS, MULTI DEDUCTION HEADS, WITH COST CATEGORY, UPLOAD UNLIMITED VOUCHERS AT A TIME. PAYSLIPS WILL BE GENERATED AUTOMATICALLY. NOW WITH AUTO CELL ADDRESS FOR MULTIPLE VOUCHERS WITH MULTIPLE EMPLOYEES


* GENERATE SINGLE OR MULTIPLE PAYSLIPS WITH ALL DETAILS.


* WE CAN ALSO USE IT FOR PAYMENT OR JOURNAL OR OTHER VOUCHERS THAT NEED TO FILL COST CENTER/EMPLOYEE NAME. JUST CHANGE VOUCHER NAME.
*  NOW WITH MULTI COST CATEGORY.
*  MULTI VOUCHERS IN ONE SHEET.
*  AUTO ENTRY IMPORT WITH ONE BUTTON IN SAME SHEET

*  UNLIMITED ENTRIES AT A TIME
*  VERY SIMPLE FORMAT AS PER YOUR SHEET.

 

YOU CAN USE THIS UTILITY IN ALL TALLY VERSIONS AND FOR LIFETIME.

VIDEO : https://youtu.be/Ac2saE9EEfo

MO.NO. +91-9131810293

EMAIL : learnwells@outlook.com
OTHER SITE: E2T.in

Daily Collection TDL – Tally Prime TDL 2021

by with No Comment Tally Prime TDLTDL 2019TDL 2020TDL for Tally
WITH THIS TALLY ERP9 TDL YOU CAN SEE DAILY SALES, DAILY PURCHASE AMOUNT , CONTACT NO. AND CONTACT PERSON AT INVOICE TIME AND CONTACT DETAILS AND GST NUMBER IN LEDGER ACCOUNT.
IT WILL BE VERY HELPFUL TO SEE DAILY BUSINESS AND OUTSTANDING COLLECTION


[#Line : LV Title]
Add : Field : After : LEDMailName : LWContGST

[Field : LWContGST]
Use : Name Field
Set as : $$String:”Contacts: ” + $$LocaleString:($ledgermobile:Ledger:##LedgerName)+ ” ” + $$LocaleString:($LedgerContact:Ledger:##LedgerName) +” – Gstin: ” + $$LocaleString:($Partygstin:Ledger:##LedgerName)
Color : Red
Width:50
Background:Light yellow

[#Line: EI PartyLimit]

Add : Field : After : EI CurrentBalance : TotSales 

[Field : TotSales]

Invisible : NOT ##CurBalanceFlag or NOT @@IsSales
Field : Simple Prompt, Amount Field
Local : Field : Simple Prompt : Info : $$LocaleString:”Today’sTotal Sale:”
Local : Field : Simple Prompt : Width : 14
Local : Field : Amount Field : Set as : @@TrsTotSales
Local : Field : Amount Field : Format : “Symbol,DrCr”
Local : Field : Amount Field : Set always : Yes
Local : Field : Amount Field : Color : Blue

[System : Formula]

TrsTotSales : $$FromValue:$Date:$$ToValue:$Date:$CreditTotals:Group:$$GroupSales 

 ;;……….www.Learnwells.com………;;


[#Line: EI PartyLimit]

Add : Field : After : EI CurrentBalance : TotPurch 

[Field : TotPurch]

Invisible : NOT ##CurBalanceFlag or NOT @@IsPurchase
Field : Simple Prompt, Amount Field
Local : Field : Simple Prompt : Info : $$LocaleString:”Today’s Total Purchase:”
Local : Field : Simple Prompt : Width : 14
Local : Field : Amount Field : Set as : @@TrsTotPurch
Local : Field : Amount Field : Format : “Symbol,DrCr”
Local : Field : Amount Field : Set always : Yes
Local : Field : Amount Field : Color : Blue

;;……….www.Learnwells.com………;;

[System : Formula]

TrsTotPurch : $$FromValue:$Date:$$ToValue:$Date:$DebitTotals:Group:$$GroupPurchase 


[#Line: EI PartyLimit]

Add : Field : After : EI CreditLimit : LWContact

[Field : LWContact]
Invisible : NOT ##CurBalanceFlag 
Field : Simple Prompt, Name Field
Local : Field : Simple Prompt : Info : $$LocaleString:”Contacts:”
Local : Field : name Field : Set as : $LedgerMobile:Ledger:#EIConsignee  + ” ” + $LedgerContact:Ledger:#EIConsignee 


;;……….www.Learnwells.com………;;

FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9 
5. Press F12 and goto Product and Features
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.



EXCEL2TALLY-MASTERS IMPORT

by with No Comment Excel to TallyExcel2TallyXMLPAID UTILITY
THIS EXCEL2TALLY_MasterImport SOFTWARE HELP YOU TO IMPORT EXCEL DATA INTO TALLY ERP OR OTHER VERSION OF TALLY WITH HELP OF  XML. IT IS VERY USEFUL SOFTWARE AND SAVE YOUR LOTS OF TIME. NO RENEWAL REQUIRED- USE LIFETIME WITH MULTI COMPUTER. ALSO CAN UPDATED OLD MASTERS WITH NEW DETAILS.
NOW IMPORT STOCK ITEMS and LEDGER MASTERS IN TALLY WITH BELOW FEATURES :
STOCK MASTER:
1. WITH OWN GROUP
2. WITH FULL GST DETAILS (HSN, GST RATES)
3. WITH ALIAS
4. WITH PART NO.
5. WITH OPENING BALANCES.
6. OPENING WITH MULTIPLE BATCHES
7.OPENING WITH MULTIPLE GODOWNS
8. OPENING WITH MULTIPLE RATES
9. WITH STANDARD COST AND STANDARD SALE RATE
10. WITH MRP DETAIL
11. WITH MULTI UNIT AND WITH CONVERSION ENTRY 
12. WITH 2500 STOCK ITEM ENTRY AT A TIME

LEDGER MASTERS:
1. WITH ADDRESS, PIN, STATE
2. WITH GST TYPE AND GST NUMBER
3. WITH OWN GROUPS
4. OPENING BALANCES WITH BILLWISE DETAILS
5. ENABLE BILLWISE, COST CENTERS, INTEREST, CREDIT LIMITS ETC.
6. SET CREDIT PERIOD
7. SET CREDIT LIMITS
8. WITH LEDGER NOTES AND DESCRIPTION
9. WITH ADVANCE INTEREST CALCULATION
10. WITH FULL CONTACT DETAIL – PHONE NO, MOBILE NO, EMAIL ID, CONTACT PERSION
11. WITH TDS DETAIL AND PAN NUMBER
12. WITH PARTY BANK DETAILS.

YOU CAN USE IT LIFETIME.
YOU CAN UPDATED YOUR OLD MASTERS ALSO
CLICK ON GENERATE BUTTON TO CREATE XML TO IMPORT IN TALLY.

Email: learnwells@outlook.com
Website: www.Learnwells.com
Contact: +91-9131810293

COLUMNAR GST DETAIL WITH ITEM

by with 5 Comments Tally Prime TDLTDL 2019TDL 2020TDL for Tally
WITH THIS TALLY ERP9 TDL YOU CAN SEE SALES, PURCHASE COLUMNAR REPORTS WITH ITEM GST DETAILS LIKE HSN CODE, TAXABLE LEDGER, AND TAX DETAILS.
IT WILL HELP YOU TO FILE GST RETURNS AND OTHER GST RELATED OR BUSINESS RELATED WORKS.


   ;;WWW.LEARNWELLS.COM;; 
[#Collection: Columnar Vouchers of Company]

    Fetch :    AllInventoryEntries.GSTLedItemIGSTRateEx, AllInventoryEntries.GSTItemHSNCodeEx, AllInventoryEntries.GSTEntryLedgerName


[#Line: DSP ColVchTitle]
    Add: Field    : After: DBC GSTIN:LearnWellHSN
    Add: Field    : After: DBC GSTIN:LearnWellldg
    Add: Field    : After: DBC GSTIN:LearnWellRT
    Local : Field:LearnWellHSN : Set as     : $$LocaleString:”HSN”
    Local : Field:LearnWellldg : Set as     : $$LocaleString:”TAXABLE LEDGER”
    Local : Field:LearnWellRT : Set as     : $$LocaleString:”GST Rate”

[#Part: DBC QtyDetails]
    Local :  Field  :   LearnWellldg :  Set as    : $GSTEntryLedgerName

[#Line: DSP ColVchDetail]

    Add: Field    : After: DBC GSTIN:LearnWellHSN
    Add: Field    : After: DBC GSTIN:LearnWellldg
    Add: Field    : After: DBC GSTIN:LearnWellRT

[Field: LearnWellHSN]

        Use            : Short Name Field
        Set as        : $GSTItemHSNCodeEx
        Width       : 0
        Style       : Normal
        Bound       : 8,15
        Invisible    : NOT (##LearnWellSAC AND @@IsGSTOn)
        Scroll     : Yes
        Border         : Thin Left
    
[Field: LearnWellldg]

        Use            : Short Name Field
        Set as        : $GSTEntryLedgerName
        Width       : 0
        Style       : Normal
        Bound       : 8,15
        Invisible    : NOT (##LearnWellLDG AND @@IsGSTOn)
        Scroll     : Yes
        Border         : Thin Left

[Field: LearnWellRT]

        Use            : Short Name Field
        Set as        : $GSTLedItemIGSTRateEx
        Width       : 0
        Style       : Normal
        Bound       : 8,15
        Invisible    : NOT (##LearnWellRT AND @@IsGSTOn)
        Scroll     : Yes
        Border         : Thin Left
        Alignment    : Centre

;;WWW.LEARNWELLS.COM;;


FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9 
5. Press F12 and goto Product and Features
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.



EXCEL TO TALLY – ALL IN ONE_ACCOUNTS ONLY

by with One Comment Excel to TallyExcel2TallyXMLPAID UTILITY
THIS EXCEL TO TALLY SOFTWARE HELP YOU TO EXPORT EXCEL DATA INTO TALLY ERP OR OTHER VERSION OF TALLY LIKE TALLY 7.2, TALLY ERP 9, TALLY ERP, OR GST READY TALLY THROUGH EXCEL SHEET. IT IS VERY USEFUL SOFTWARE AND SAVE YOUR LOTS OF TIME. NO RENEWAL REQUIRED- USE LIFETIME WITH MULTI COMPUTER, NOW WITH VERY SIMPLE FORMAT.
NOW WITH UPDATED VERSION YOU CAN GENERATE –
a) LEDGER MASTER : – NOW IMPORT LEDGER MASTER IN TALLY WITH FULL ADDRESS, GST DETAILS , OPENING BALANCE WITH MULTI BILL WISE REFERENCE AND WITH OWN GROUP.
b) COST-CENTER MASTER :- NOW IMPORT COSTCENTER IN TALLY WITH YOUR OWN GROUP
c) GROUP CREATION :- WITH THIS SHEET YOU CAN CREATE SUB GROUPS UNDER MAIN GROUPS AND ALSO UNDER SUB GROUPS
VOUCHERS : – IT HAS MULTIPLE SHEETS TO IMPORT VOUCHERS IN TALLY. YOU CAN USE ACCORDING TO YOUR DATA. YOU CAN IMPORT ALL TYPE ACCOUNTING VOUCHERS WITH EVERY SHEET.
IT HAS BELOW VOUCHER IMPORT SHEETS WITH THERE ADVANCE FEATURES:
1.    All in One VOUCHER : WITH THIS VOUCHER SHEET YOU CAN GENERATE ALL VOUCHER TYPE (SALES, PURCHASE, PAYMENT, RECEIPT, CONTRA, JOURNAL ETC. OR YOUR OWN CREATED VOUCHER TYPES) WITH MULTIPLE DR. CR. LEDGERS AND MULTIPLE BILLWISE REFERENCE AND MULTIPLE COSTCENTER DETAILS WITH COST CATYEGORY. ALSO THIS SHEET HAS DUAL NARRATION SYSTEM (AUTO OR MANUAL NARRATION). DIRECT COPY PASTE FROM YOUR DATA. DO FAST ENTRIES WITH MULTI REFERENCES AND COSTERCENTERS. YOU CAN USE ALL TYPE VOUCHERS WITHOUT STOCK ITEMS.
2.    AS VOUCHER : WITH THIS VOUCHER SHEET YOU CAN GENERATE ENTRIES WITH SIMPLE FORMAT. DIRECT COPY PASTE FROM YOUR DATA. DO FAST ENTRIES WITH MULTI REFERENCES AND COSTERCENTERS. YOU CAN USE ALL TYPE VOUCHERS WITHOUT STOCK ITEMS.
3.    AS INVOICE :  WITH THIS VOUCHER SHEET YOU CAN GENERATE ENTRIES WITH SIMPLE FORMAT. DIRECT COPY PASTE FROM YOUR DATA. CONSIGNEE DETAILS, BUYERS DETAILS, CREDIT NOTE AND DEBIT NOTES WITH GST NORMS, DISPATCH DETAILS, WITH SINGLE AND MULTI BILL WISE REFERENCES AND COSTERCENTERS. WITH TAX CLASSIFICATION DETAILS. YOU CAN USE ALL TYPE VOUCHERS WITHOUT STOCK ITEMS.
4.    S-C VOUCHER : THIS SHEET IS SPECIALIST FOR JOURNAL VOUCHER. ALSO CAN USE FOR OTHER VOUCHERS. IT CAN IMPORT YOUR EXCEL DATA IN TO TALLY WITH MULTI BILL WISE REFERENCES AND MULTI COSTCENTERS FOR EVERY LEDGER IN ONE VOUCHER.
5.    BANK VOUCHER : WITH THIS BANK VOUCHER SHEET YOU CAN GENERATE ENTRIES OF BANK LIKE, PAYMENT, RECEIPT AND CONTRA WITH MULTI BILL WISE REFERENCE AND COSTCENTER. ALSO YOU CAN RECONCILE YOUR BANK ENTRIES AT ENTRY TIME. YOU CAN GENERATE ENTRIES WITH CHEQUE NUMBER / INSTRUMENT NUMBER, CHEQUE DATES, RECONCILIATION DATES. AND ALSO CAN USE RECEIPT, PAYMENT, CONTRA VOUCHERS AT A TIME.
6.    M-TH VOUCHER :  WITH THIS VOUCHER SHEET CAN GENERATE MULTI VOUCHER TYPE WITH THOUSANDS OF LEDGER IN ONE VOUCHER. (FOR EXAMPLE IF YOU GO TO TAKE ENTRIES FOR JOURNAL, SALES, PURCHASE, RECEIPT, CONTRA, PAYMENT, DR. NOTE, CR. NOTE ETC AT A TIME AND YOUR ONE VOUCHER HAS MANY LEDGERS LIKE HUNDRED OR THOUSANDS LEDGERS IN ONE VOUCHER, YOU CAN USE THIS SHEET).
*NOW FILL COST CENTERS WITH THERE OWN COST CATEGORY IN REFERENCE SHEET FOR ALL TYPE VOUCHERS.
*NOW WITH MULTI LEDGER VOUCHERS WITH MULTIPLE COSTCENTERS.
*NOW WITH ROUND OFF COLUMNS.
NOTE : – ALL SHEETS CAN BE USE FOR ANY VOUCHER CREATION.
ALL SHEETS HAS SIMPLE FORMAT.
IF YOU WANT ANY CHANGES ACCORDING TO YOUR DATA, WE WILL CHANGE FREE OF COST.
YOU CAN USE THIS SOFTWARE IN YOUR ANY COMPUTER.
PAY ONCE USE LIFETIME.

FOR ANY SUPPORT CALL ANY TIME : +91-9131810293.
EMAIL :LEARNWELLS@OUTLOOK.COM
CLICK THE BUTTON TO DOWNLOAD

ITEM DETAILED SUMMARY

by with One Comment TallyTDL 2019TDL 2020TDL for Tally
EVERYTIME WE NEED SOMETHING SPECIAL TO DO PROPER WORK AND TRACK OUR BUSINESS. IN THIS SEGMENT I HAVE SOMETHING SPECIAL FOR YOU.
DOWNLOAD THIS TALLY TDL FILE AND RELAX IN BUSINESS AND LIFE.

WITH THIS TALLY ERP 9 TDL YOU CAN SEE COLUMNAR STOCK ITEMS DETAILS WITH THERE GROUP, UNIT, OPENING AND CLOSING STOCK WITH QUANTITY WITH VALUE , STANDARD COST, SELLING COST, AND MRP DETAILS WITH ONE CLICK. ALSO CAN EXPORT REPORTS IN EXCEL AND PDF FORMAT WITH FILTERED ITEMS.
AND ALSO CAN EDIT STOCK ITEMS DETAILS BY PRESSING CTRL+ ENTER

[#Menu:Gateway of Tally]
Add:Key Item:before:@@locQuit:Item List:I:Display:LEARNWELLItems

[Report: LEARNWELLItems]
Use : DSP Template
Form : LEARNWELLItems
[Form: LEARNWELLItems]
Use : DSP Template
Part : LEARNWELLItemsTT, LEARNWELLItemsRR
Width : 100% Screen
Background:Stone Wash
Bottom Part : LW Note
Bottom Toolbar Buttons : BottomToolBarBtn8,BottomToolBarBtn9,BottomToolBarBtn10
[Part : LEARNWELLItemsTT]
Line : LEARNWELLItemsTT
[Line : LEARNWELLItemsTT]
Use : LEARNWELLItemsRR
Local : Field : LWsrn: Set as : “Srn”
Local : Field : LWItmName: Set as : “Item Name”
Local : Field : LWItmGrp: Set as : “Item Group”
Local : Field : LWItmUnit: Set as : “Item Unit”
Local : Field : LWPrCst: Set as : “STRD.COST”
Local : Field : LWSlCst: Set as : “SELL RATE”
Local : Field : LWMrp: Set as : “MRP”
Local : Field : LWItmGstOP: Set as : “Opening Qty.”
Local : Field : LWOpValue: Set as : “Opening Value”
Local : Field : LWClsQty: Set as : “Closing Qty.”
Local : Field : LWClsValue: Set as : “Closing Value”
Border : Column Titles
Option : Alter On Enter
[Part : LEARNWELLItemsRR]
Line : LEARNWELLItemsRR
Repeat : LEARNWELLItemsRR: STOCKITEM
Scroll : Vertical
Common Border : Yes

[Line : LEARNWELLItemsRR]
Field : LWsrn,LWItmName,LWItmGrp,LWItmUnit,LWPrCst,LWSlCst,LWMrp,LWItmGstOP,LWOpValue,LWClsQty,LWClsValue

[Field : LWsrn]
Use : Short Name Field
Set as : $$Line
Style : Normal
Width : 4
Align : Centre
[Field : LWItmName]
Use : Name Field
Set as : $NAME
Width : 40
Style : Normal Bold
Border : Thin Left
Alter:StockItem
[FIELD:LWItmGrp]
USE:Simple Field
SET AS:$Parent
Width : 20
Style : Normal
Border : Thin Left
[FIELD:LWItmUnit]
USE:Simple Field
SET AS:$BaseUnits
Width : 8
Style : Normal
Border : Thin Left
[FIELD:LWPrCst]
USE: SIMPLE FIELD
SET AS: $STANDARDCOST
Width : 12
Style : Normal
Border : Thin Left
[FIELD:LWSlCst]
USE: SIMPLE FIELD
SET AS: $STANDARDPRICE
Width : 12
Style : Normal
Border : Thin Left
[FIELD:LWMrp]
Use : Name Field
Set As : $MRPDetails[Last].MRPRateDetails[Last].MRPRate
Width : 12
Style : Normal
Border : Thin Left
[Field : LWItmGstOP]
Use : Simple Field
Set as : $OpeningBalance
Width : 12
Style : Normal
Border : Thin Left
[Field : LWOpValue]
Use : Simple Field
Set as : $OpeningValue
Width : 12
Style : Normal
Border : Thin Left
[Field : LWClsQty]
Use : Name Filed
Set as : $ClosingBalance
Width : 12
Style : Normal
Border : Thin Left
[Field : LWClsValue]
Use : Name Filed
Set as : $ClosingValue
Width : 12
Style : Normal
Border : Thin Left
[Part : LW Note]
    Line : LW Note

[Line : LW Note]
    Field : LW Note

[Field : LW Note]
    Set as : “Ctrl+Enter to Edit Item – Always Take Backup – www.Learnwells.com”
    Color : Red
    Style : Large bold
    Fullwidth : yes
[ Collection : LEARNWELLItemsRR]
Type : Stockitem

FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9 
5. Press F12 and goto Product and Features
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.