Scribd Logo
Upload

Welcome to Scribd!

  • 39 views

    TOT3 Return

    Uploaded by

    merciefedherico_4977
    This document provides instructions for enabling macros in different versions of Microsoft Excel to allow validation of an Excel sheet. It describes clicking through File and Tools menus to access Macro Settings and selecting "Enable all macros". It recommends upgrading to Excel 2007 Service Pack 2 if macros are not working. It also notes that fields in white can be edited, grey are disabled, and light grey show descriptions. The regional date format should be set to "English(United States)". Clicking "Validate" will check for errors and generate an upload file if none exist.

    Copyright:

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

    TOT3 Return

    Uploaded by

    merciefedherico_4977
    39 views14 pages
    This document provides instructions for enabling macros in different versions of Microsoft Excel to allow validation of an Excel sheet. It describes clicking through File and Tools menus to access Macro Settings and selecting "Enable all macros". It recommends upgrading to Excel 2007 Service Pack 2 if macros are not working. It also notes that fields in white can be edited, grey are disabled, and light grey show descriptions. The regional date format should be set to "English(United States)". Clicking "Validate" will check for errors and generate an upload file if none exist.

    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 enabling macros in different versions of Microsoft Excel to allow validation of an Excel sheet. It describes clicking through File and Tools menus to access Macro Settings and selecting "Enable all macros". It recommends upgrading to Excel 2007 Service Pack 2 if macros are not working. It also notes that fields in white can be edited, grey are disabled, and light grey show descriptions. The regional date format should be set to "English(United States)". Clicking "Validate" will check for errors and generate an upload file if none exist.

    Copyright:

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

    TOT3 Return

    Uploaded by

    merciefedherico_4977
    This document provides instructions for enabling macros in different versions of Microsoft Excel to allow validation of an Excel sheet. It describes clicking through File and Tools menus to access Macro Settings and selecting "Enable all macros". It recommends upgrading to Excel 2007 Service Pack 2 if macros are not working. It also notes that fields in white can be edited, grey are disabled, and light grey show descriptions. The regional date format should be set to "English(United States)". Clicking "Validate" will check for errors and generate an upload file if none exist.

    Copyright:

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

    Help on Enable Macro (Enable Validate button):

    FOR EXCEL 2010 :-


    To "Enable Macro" please follow steps below.
    1
    2
    3
    4

    FOR EXCEL 2007 :-


    To "Enable Macro" please follow steps below.
    1
    2
    3
    4

    FOR OTHER EXCEL VERSIONS :-


    To "Enable Macro" please follow steps below.

    2
    3
    4

    Change your regional date option from "Control Panel --> Region and Language

    Please click on "Validate" button to check errors in excel sheet. If there is no error in excel sheet then uplo
    Note : While opening a MS Excel 2007 file, macro security issue may arise. To overcome this issue, upgrad
    MS Excel 2007 Service Pack 2
    Enable Validate button):

    To "Enable Macro" please follow steps below.


    Click the File Menu (Office BackStage), and then select Options from the left sidebar.
    Click Trust Center, click Trust Center Settings, and then click Macro Settings.
    Select "Enable all macros". Click on 'OK'.
    Open the file again.

    To "Enable Macro" please follow steps below.


    Click the Microsoft Office Button , and then click Excel Options.
    Click Trust Center, click Trust Center Settings, and then click Macro Settings.
    Select "Enable all macros". Click on 'OK'.
    Open the file again.

    RSIONS :-
    To "Enable Macro" please follow steps below.
    Select the Tools menu option and then select Macro and Security. In the resulting Security dialog, set the s
    to Low by clicking the Low radio button.
    Close the file and any other instances of the application currently running on the computer (close all excel
    that also use the application you are currently running).
    Open the file again.
    Click the Enable button to allow the macro to run.

    Fields marked in White color is enabled and data can be entered in that field.
    Fields marked in Grey color is Disabled.
    Fields marked in Light Grey color is showing Description of field.

    Change your regional date option from "Control Panel --> Region and Language" to "English(Unites States)"

    " button to check errors in excel sheet. If there is no error in excel sheet then upload file gets generated.
    MS Excel 2007 file, macro security issue may arise. To overcome this issue, upgrade to
    ck 2
    Sr. No. Section Name Field
    Error Description Reference Cell
    Turnover Tax Return

    Section A : Return Information


    Personal Identification Number * A017813780F
    Type of Return * Original
    Return Period From * 01/05/2023
    Return Period To * 31/05/2030
    Are you a partnership? * No

    9.0.0 8

    XLS EXCEL 1997-2003

    2023 05

    2 12
    over Tax Return

    Version 9.0.0
    Section B : Details of Local Purchas
    PIN of Supplier Name of Supplier Invoice Date
    Details of Local Purchases
    Invoice Number Description of Goods / Amount (Ksh)
    Services

    Total 0.00
    Section C : Details of Turnover Tax Paid
    Section C1 : Advance Payment
    Payment Registration Date of Deposit Amount of Turnover Tax
    Number Paid (Ksh)

    Total 0.00

    Section C2 : Self Assessment Tax


    Payment Registration Date of Deposit Amount of Turnover Tax
    Number Paid (Ksh)

    Total 0.00
    Total (Section C1 Total + Section C2 Total) 0.00
    Section N1 : Advance Payment
    P
    a
    y
    m
    T
    o
    t
    a
    Section E : Details Of Partners
    PIN of Partner Name of Partner Partner’s Profit Sharing
    Ratio

    Total
    Amount Payable based on
    Ratio

    0.00
    Section D : Calculation of Tax Due
    Sr. No. Description
    1 Local Purchases (Total of "Amount" from B_Details_of_Purchases)
    2 Turnover for the Period *
    3 Turnover Tax Rate (%)
    4 Tax Due (2 * 3)
    Turnover Tax Paid in Advance (Total of "Amount of Turnover Tax Paid" from
    5 C_TOT_Payment_Credits)
    6 Presumptive Tax Credit
    7 Credits u/s 12A - Advance Tax on Commercial Vehicle
    8 Net Tax Payable / Refundable (4-5-6-7)
    Amount (Ksh)
    0.00
    5,000.00
    1.00
    50.00

    0.00
    0.00
    0.00
    50.00 50

    You might also like