Scribd Logo
Upload

Welcome to Scribd!

  • 68 views

    Quick Guide To Using This Utility For Ereturns: Color Codes

    Uploaded by

    khajuriaonline
    This document provides instructions for using an Excel utility for eReturns filing. It outlines the prerequisites for using the utility which include having Excel 2003 or higher and enabling macros. It describes how to enable macros in Excel 2007 and 2003. It then provides information on using the various buttons in the utility to validate data, navigate between sheets, add and delete rows, and view color codes. It notes that comments should be read for data type and length requirements before filling out data. Finally, it includes an example of Annexure I, which is the Tax Remission Claim Form with fields for company name, address, tax period details, taxable sales amounts, tax collected, price adjustments, remission claimed, and declaration details.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd

    Quick Guide To Using This Utility For Ereturns: Color Codes

    Uploaded by

    khajuriaonline
    68 views6 pages
    This document provides instructions for using an Excel utility for eReturns filing. It outlines the prerequisites for using the utility which include having Excel 2003 or higher and enabling macros. It describes how to enable macros in Excel 2007 and 2003. It then provides information on using the various buttons in the utility to validate data, navigate between sheets, add and delete rows, and view color codes. It notes that comments should be read for data type and length requirements before filling out data. Finally, it includes an example of Annexure I, which is the Tax Remission Claim Form with fields for company name, address, tax period details, taxable sales amounts, tax collected, price adjustments, remission claimed, and declaration details.

    Original Description:

    Tax Remission

    Original Title

    Tax Remission

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides instructions for using an Excel utility for eReturns filing. It outlines the prerequisites for using the utility which include having Excel 2003 or higher and enabling macros. It describes how to enable macros in Excel 2007 and 2003. It then provides information on using the various buttons in the utility to validate data, navigate between sheets, add and delete rows, and view color codes. It notes that comments should be read for data type and length requirements before filling out data. Finally, it includes an example of Annexure I, which is the Tax Remission Claim Form with fields for company name, address, tax period details, taxable sales amounts, tax collected, price adjustments, remission claimed, and declaration details.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    68 views6 pages

    Quick Guide To Using This Utility For Ereturns: Color Codes

    Uploaded by

    khajuriaonline
    This document provides instructions for using an Excel utility for eReturns filing. It outlines the prerequisites for using the utility which include having Excel 2003 or higher and enabling macros. It describes how to enable macros in Excel 2007 and 2003. It then provides information on using the various buttons in the utility to validate data, navigate between sheets, add and delete rows, and view color codes. It notes that comments should be read for data type and length requirements before filling out data. Finally, it includes an example of Annexure I, which is the Tax Remission Claim Form with fields for company name, address, tax period details, taxable sales amounts, tax collected, price adjustments, remission claimed, and declaration details.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 6

    Quick Guide to using this utility for eReturns

    Pre requisites :
    1 Use Excel 2003 onwards.
    2 Enable Macros to use this utility.
    MACROS - ENABLING MACROS IN EXCEL 2007
    1 Click the Microsoft Office Button , and then click Excel Options
    2 Click Trust Center, click Trust Center Settings, and then click Macro Settings
    3 Click the option "Enable all Macros"
    4 Restart your Excel Utility

    MACROS - ENABLING MACROS IN EXCEL 2003


    1 On the Tools Menu, point to Macros >> Security
    2 Now select Security Level as Low or Medium and press OK
    3 Restart your Excel Utility, and if asked whether you want to Enable Macros, Se
    Use Of Buttons :
    Click on Validate button after filling the data to validate the data and
    generate upload sheet.
    Click on Next button for navigating to next sheet.
    Click on Previous button for navigating to previous sheet.
    Click on First button for navigating to first sheet.
    Click on Last button for navigating to last sheet.
    Click on (+) button to add more rows in the existing table.
    Click on (-) button to delete rows from the existing table.

    Color Codes
    -

    Alphanumeric
    Alphabets
    Numbers
    Date
    DropDown

    NOTE:-Please read the Comments provided with every cell,for data type and length of field allowed,

    ility for eReturns

    Excel Options
    d then click Macro Settings

    ou want to Enable Macros, Select YES

    alidate the data and

    us sheet.

    ting table.

    ng table.

    Alphanumeric
    Alphabets

    DropDown

    pe and length of field allowed, before filling the data.

    ANNEXURE I
    TAX REMISSION CLAIM FORM
    Name of the Industrial Unit
    Address of the Industrial Unit
    TIN
    Circle in which registered
    Division in which registered
    Date of filing the quarterly Return
    Tax Period to which Remission Claim pertains
    Tax Period From
    Tax Period To
    Quantum of taxable sales for the tax period
    (a) Negative List/Trade
    i. 5%
    ii 13.5%
    iii Others
    Total Amount of tax collected for the tax period
    (a) Negative List/Trade
    i. 5%
    ii 13.5%
    iii Others
    Total Amount of Price adjustment for the tax period made in selling price
    (a) Remission
    i. 5%
    ii 13.5%
    iii Others
    Amount of Tax Remission Claimed
    Whether declaration form as per Annexure II enclosed
    Name of the Signatory
    Place of Declaration
    Date of Declaration

    EXURE I
    UK Paints India Ltd
    IGC Phase 1 Samba Jammu And Kashmir
    01421111669
    CIRCLE I-JAMMU
    JAMMU
    31/07/2014

    ains
    01/04/2014
    30/06/2014

    d
    (b) Remission
    66376794.00 i. 5%
    ii 13.5%
    iii Others

    eriod
    (b) Remission
    3318829.00 i. 5%
    ii 13.5%
    iii Others

    ax period made in selling price


    66376794.00

    3314635.00
    Rajesh Agrawal
    Samba
    31/07/2014

    # Value in Red Color indicates a Negative Value

    3314635.00

    3314635.00

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31

    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I
    Annexure I

    You might also like