Use DATEVALUE Function To Convert a Text to Date

 Using the DATEVALUE function is a basic method to convert a date into an actual date which is stored as a text.

 

 

Voucher type wise Printer Selection Tally TDL

 

 Voucher type wise Printer Selection–

 

Introduction
•With This Add-onuser gets Facilitytoselect Printer as perVoucher TypeforVoucher Printing. User can select different Printer for different vouchertype andthat printer will be automatically selected when that voucher is printed.

 

 

Installation
1.Copy the Txt file in Tally.ERP9 Folder.
2.Gateway of Tally→F12→Product & Features→F4 (Manage Local TDL)→Select Yes in Load TDL on Start upand give the file name of Txt File. After pressing the Enter Key will show TDL Status which should be Active.

 

 

 Click Here for Download 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

[System:UDF]
    
    VCHPrinter:String:02345

[System    : Formula]
    VCHPrinter    : $VCHPrinter:VoucherType:##SVVoucherType

    
[#Part: VTYP BehaviourMain]    
    Add:Lines:At End:VCH Printer LINE
    
[Line:VCH PRinter LINE]
    Space Top:1% page
    Field:Medium prompt,VCH Printer Line
    Local:Field:Medium prompt:Info:"Select Printer for This Voucher"
    
[Field:VCH Printer Line]
    Use        : Name Field
    Storage : VCHPrinter
    Color    : BLue
    Table       : List of Printers
    Show Table  : Always
    Background    : WHite
    
            

[#Form: Contra Color]

    Set    : SVPrinterName    : @@VCHPrinter

[#Form: Payment Color]

    Set    : SVPrinterName    : @@VCHPrinter

[#Form: Receipt Color]

    Set    : SVPrinterName    : @@VCHPrinter

[#Form: Journal Color]

    Set    : SVPrinterName    : @@VCHPrinter

[#Form: Payroll Color]

    Set    : SVPrinterName    : @@VCHPrinter

[#Form: Debit Note Color]

    Set    : SVPrinterName    : @@VCHPrinter

[#Form: Credit Note Color]

    Set    : SVPrinterName    : @@VCHPrinter


[#Form: Purchase Color]

    Set    : SVPrinterName    : @@VCHPrinter

[#Form: Memorandum Color]

    Set    : SVPrinterName    : @@VCHPrinter

[#Form: Reversing Journal Color]

    Set    : SVPrinterName    : @@VCHPrinter

[#Form: Delivery Note Color]

    Set    : SVPrinterName    : @@VCHPrinter

[#Form: Receipt Note Color]

    Set    : SVPrinterName    : @@VCHPrinter

[#Form: Rejection Inward  Color]

    Set    : SVPrinterName    : @@VCHPrinter

[#Form: Rejection Outward Color]

    Set    : SVPrinterName    : @@VCHPrinter

[#Form: Sales Order Color]

    Set    : SVPrinterName    : @@VCHPrinter

[#Form: Purc Order Color]

    Set    : SVPrinterName    : @@VCHPrinter

[#Form: Attendance Color]

    Set    : SVPrinterName    : @@VCHPrinter

[#Form: POS Invoice Color]

    Set    : SVPrinterName    : @@VCHPrinter

FOUR STEPS ON HOW TO CRACK TALLY PASSWORD EASILY

 This is most common and this is major part of this article.
In case if you do not have any backup or nothing and want to want to recover your Data Password then follow this below steps :

    Create a New Company with Same Name of your data by putting some suffix or prefix to name.
    While creating New company select financial year carefully. E.g if your main Data FY start with 2017 to 2019 then you need to mention financial year begin with Apr-2017. You may keep login if or password for new company but it is not compulsory.
    Once you have logged in New Company pass dummy entries in Tally dated on 31st March 2018 & 31st March 2019 (Last date of each financial year)
    Now in new company Press F11>> Enable Accounting feature / Inventory Feature / Tax Feature you remember (In case if you do not remember what were those feature then enable all the option in each feature)
    Now Close Shut the company and open Data folder of Newly created company>> Copy the file name called as Company.900  
    Once you copied the file open the Data folder of Main data for which you have lost the password >> Paste the Copied file from new company>>It will ask to override>>Click to override (Please make sure you have taken data backup of Main Data before this)
    Now restart Tally>> Do Not login company in Tally>> While you see select company list >> It will reflect two company with same name (same name of newly created company)
    Now press CTL+ALT+R>>Select Company Main Old Data (Identify the old data with data folder Number) Rewrite Yes>> Backup No>>After Completing Rewrite>> Check out the (It may ask user login and password in case if you have kept id and password for newly created company)
    In case after login data it shows some error the follow the Zero Rewrite (To know please see my other blog on Data error and solution)

Adding Indian Style Commas to numbers in MS Excel - Using Cutom Number Format

  Well, the better way to use Indian Style commas while working in MS Excel is to change the 'Region and Language' Setting of your Windows system. However, there is another work around in MS Excel to automatically add commas to number in Indian Style i.e. first comma at three digits and then the subsequent commas are at interval of 2 digits. For instance, 1,000,000 will appear as 10,00,000. This is particularly useful when you are working with currency in INR. 

 Steps to follow:

    1. Select the range which needs to be formatted. Let's take the following sample data which uses the default 1000 comma separator :

 

    2. Press Ctrl + 1. This will open the number format dialog box and then select Custom category shown below.

 

    3.    The add the this custom number format string [>1000000]"Rs" #\,##\,##\,##0"/-";[>=100000] "Rs "##\,##\,##0"/-";"Rs "##,##0"/-" into the 'Type Text Box' as shown below.

 

Restrictions on Cash Transactions and Penalty on Contravention

 

Expenditure made in cash

Threshold Limit – Cash payment exceeding Rs 10,000 to a person in a single day. The limit is extended to Rs. 35,000 in case the payments are being made for plying, hiring or leasing of goods carriage to a person in a single day.

Related Section – 40A(3) of the Income Tax Act 1961 which provides that any expenditure in respect of which payment is made in a sum of exceeding Rs. 10,000 (or Rs 35,000 in the case for good carriage) to a person in a single day otherwise than by account payee cheque on a bank or by an account payee bank draft or through use of electronic clearing system shall not be allowed as deduction.

Disallowance – Whole amount of such expenses shall not be allowed as the deduction to the assessee at the time of computation of income under Profit & Gains from Business or Profession. No additional penalty is imposed on payor or receiver. 

Exemption – This section 40(A)(3) doesn’t apply in certain cases given in Rule 6DD of Income Tax rules.

Restriction on receiving cash

Threshold Limit – Rs 2,00,000

Related Section – 269ST of Income Tax Act 1961 which provides that no person shall receive an amount of Rs 2,00,000 or more: –

• in aggregate from a person in a day (even against different bills)
• in respect of a single transaction (even on different days)
• in respect of transactions relating to one event or occasion from a person (For example, a caterer receives cash of more than Rs. 2 lakh in respect of a marriage even if separate bills are made and payment are received on separate days.)

otherwise than by an account payee cheque or an account payee bank draft or use of electronic clearing system through a bank account.

Penalty – Sum equal to the amount of such receipt shall be liable to be paid by the receiver as the penalty under Section 271DA of Income Tax Act. No penalty shall be imposable if such person proves that there were good and sufficient reasons for the contravention. Also, the penalty is imposed on the receiver, not on the payor.

Exemption – This section is not applicable

(i)  any receipt by—

• Government
• any banking company, post office savings bank or co-operative bank

(ii)  transactions of nature referred to in section 269SS;

(iii)  such other persons or class of persons or receipts, which the Central Government may, by notification in the Official Gazette, specify.

Restriction on donation in cash

Threshold Limit – Donation exceeding Rs 2,000 in cash to certain funds, charitable institutions etc

Related Section – 80G of Income Tax Act 1961 which provides the deduction on donation to certain funds, charitable institutions etc. Some donations qualify for either 50% or 100% tax deduction without any upper limit where some donation qualify for either 50% or 100% tax deduction subject to maximum limit of 10% Adjusted Gross Total Income.

Restriction on Deduction – The maximum amount of deduction shall not exceed Rs 2,000 in respect of donation made in cash.

Restriction on medical insurance premium

Threshold Limit – No threshold limit is applicable. 

Related Section – 80D of Income Tax Act 1961 which provides the deduction, up to a maximum limit of Rs 1,00,000 on payment of medical premium and preventive health checkup, to individual or HUF. 

No Deduction – No deduction is allowed for the medical insurance premium if it is paid in cash.

Exemption – Maximum deduction of Rs 5,000 can be claimed by the assessee for the preventive health checkup. This deduction shall remain available even if the payment is made in cash.

Restriction on taking or accepting loan, deposits and specified sum

Threshold Limit – Rs 20,000 or more

Related Section – 269SS of Income Tax Act 1961 which provides no person shall take or accept any loan, deposit and specified sum from any other person in cash, if

a) the amount of such loan or deposit or specified sum or the aggregate amount of such loan, deposit and the specified sum is Rs. 20,000 or more o

b) on the date of taking or accepting such loan or deposit or specified sum, any loan or deposit or specified sum is taken or accepted earlier by such person from the depositor is remaining unpaid (whether repayment has fallen due or not), the amount or the aggregate amount remaining unpaid is Rs. 20,000 or more o

c) the amount or the aggregate amount referred to in clause (a) together with the amount or the aggregate amount referred to in clause (b) is Rs. 20,000 or more.

Note: – Specified sum” means any sum of money receivable, whether as advance or otherwise, in relation to transfer of immovable property, whether or not the transfer takes place.

Penalty – Sum equal to the amount of such loan or deposit or specified sum so taken or accepted shall be liable to be paid by the receiver as the penalty under Section 271D of Income Tax Act. The penalty is imposed on the receiver, not on the payor.

Exemption – This section shall not apply to any loan or deposit or specified sum is taken or accepted from, or any loan or deposit or specified sum taken or accepted by,—

• the Government
• any banking company, post office savings bank or co-operative bank
• any corporation established by a Central, State or Provincial Act;
• any Government company
• such other institution, association or body or class of institutions, associations or bodies which the Central Government may, for reasons to be recorded in writing, notify in this behalf in the Official Gazette
• where the person from whom the loan or deposit or specified sum is taken or accepted and the person by whom the loan or deposit or specified sum is taken or accepted, are both having agricultural income and neither of them has any income chargeable to tax under this Act.

Restriction on repayment of loan, deposits and specified advance

Threshold Limit – Rs 20,000 or more

Related Section – 269T of Income Tax Act 1961 which provides no person shall repay any loan, or deposit with it or any specified advance in cash, if

a) the amount of the loan or deposit or specified advance together with the interest, if any, payable thereon, is Rs. 20,000 or more or

b) the aggregate amount of the loans or deposits held by such person on the date of such repayment together with the interest, if any, payable on such loans or deposits, is Rs. 20,000 or more or

c) the aggregate amount of the specified advances received by such person either in his own name or jointly with any other person on the date of such repayment together with the interest, any, is Rs. 20,000 or more.

Note: – Specified advance means any sum of money in the nature of advance, by whatever name called, in relation to transfer of an immovable property, whether or not the transfer takes place.

Penalty – Sum equal to the amount of such loan or deposit or specified sum so repaid shall be liable to be paid by the payer as the penalty under Section 271E of Income Tax Act. The penalty is imposed on the payer, not on the receiver.

 Exemption – This section shall apply to repayment of any loan or deposit or specified advance has taken or accepted from: –

• Government
• any banking company, post office savings bank or co-operative bank
• any corporation established by a Central, State or Provincial Act
• any Government company
• such other institution, association or body or class of institutions, associations or bodies which the Central Government may, for reasons to be recorded in writing, notify in this behalf in the Official Gazette.

Comparsion of section 194Q and 206C(1H)

 

Bank Statement import

For Tally ERP Version ODBC PORT Setup..! 

Click here to download from Gdrive

Follow the step by step instrcutions:

* Open Tally

* Press F12 Key for CONFIGURE

* Go to -> ADVANCED CONFIGURATION Option

* SET -> Tally Acting Option  - BOTH

* SET -> Enable ODBC Server Option  - YES

* SET -> PORT Option  - 9005

* Restart Tally & Make Sure Tally ODBC is ON at the Bottom of Tally.

* Click on the Main Tab"Tally "in Excel and Send Data to Tally

* Please See calculator panel in tally for Ledger Creation and other information   *If there is need to retrive the ledger from Tally press control+shift+z for predefine and      predict the ledger  *For any doubts , please call  @ 9788932173                                                                            Important Points  before pasting bank statement in this work book-Check the amount Fields are number and date field should be date as excel should recognize as date  ,Remove "," between amounts and blank space before importing