mis report format excel


Eighteen sectoral group under GST

The Goods and Services Tax GST Council in its 14th meeting held on 18 19 May 2017 approved the constitution of eighteen sectoral groups to ensure smooth roll out of GST The Council has received reports from sixteen out of the eighteen sectoral groups The GST Law Committee comprising of officers of t

Post GST reduction of incidence of Tax on Coal Consumers

In pre GST regime there was Excise Duty on Coal 6 Stowing Excise Duty Rs 10 per tonne of coal production VAT 5 on intra state sale Central Sales Tax 2 on inter state sale on submission of Form C Post implementation of GST all the above mentioned taxes and levies have been subsumed and GST 5 is being

No Shortage of Essential Drugs post GST introduction

Minister of State for Road Transport Highways Shipping and Chemicals Fertilizers Shri Mansukh L Mandaviya in a written reply to a question in Rajya Sabha today informed that as per the information received from the All Indian Origin Chemists Distributors Limited AIOCD there is no shortage of essenti

Relevant part of MAT-Ind AS Committee Report

Relevant part of MAT Ind AS Committee Report dated 17th June 2017 containing recommendations regarding amendment to the provisions of the section 115JB of the Income tax Act 1961 in respect of Ind AS Compliant Companies Under Ind AS there are certain transactions with shareholders related parties wh

NRI to submit foreign bank details only in refund cases

Optional reporting of details of one foreign bank account by the non residents in refund cases Refund generated on processing of return of income is currently credited directly to the bank accounts of the tax payers Availability of the detail of bank accounts in which the refund is to be credited is

More News

Experts Opinions

Gst rate on newspaper advertising commission

Hi I am the owner of Advertising Agency We are the registered agency for Print Advertising Newspapers are giving us 15 agency commission on ad release They are charging 5 GST on their part What GST rate we will charge to client as some of the agency are charging 5 and some of the agency are charging

Formate for mou

Please provide draft formate of MOU in case of name of Private Limited Company starts with word SPANISH which is name of country

Dipfr and financial reporting exam

Sir Mam I am a CA Final student whose Group 1 exam is due in this November I was planning to do Diplomma in IFRS by ACCA whose exam is held in December It would be immensely appreciated if someone could guide me wether the syllabus content of both the exams is more or less similar or I will have to

Invoice format for interior designer + job work contract

Hi All I am going to start Interior Designer Job Contract work business as a proprietor Kindly advise under which category i have to apply for Trade License and also advise the approptiate invoice format for the above business GST Complied Thanks Sushant

Tds on commission paid to non resident

Hi Sir We have to pay commission on export sales to agent residing at Pakistan Is it require to pay TDS on Commission amount if so what is the rate of TDS to be deducted Whether DTAA rate applicable on Commission payment on Export Sales Please clarify


Everything ok but gst form shows pan name mismatch.


HUF Formation

Can a person form a HUF including one son and his family in the HUF while excluding the other son and his family

invoicing format

what is the exact format of invoicing for metals with IGST CGST SGST under new gst law PLS ADVISE

Re: Submission of GSTR 3B

Would we submit gstr3b without payment of difference tax between ITC and total tax liability

Delay in submission of form 108, last date of exam form.

I am facing a major problem My articleship got over in April but I wasnt able to submit Form 108 due to unforseen reasons Now the last date for submission of CA Final November 2017 form is 25th August In no way I will be able to get a certificate of completion from ICAI within that period How can I

More Messages

File Download

  • GSTR 3B Computation

    The file contains GSTR 3B Computation The format is very easy to fill and can be used to collect data from your clients you can provide your Feedback Suggestion on camayur2 gmail com
  • Worksheet GSTR-3B

    GSTR 3B in excel sheet
  • Updated Details Collection Excel for GST Return GSTR-3B

    As everybody is aware the GST Returns for every month needs to be filed by 20th of subsequent month As the regular outward and inward annexures and return GSTR 3 are not yet made available for the months of July and August 2017 a summary return in Form GSTR 3B needs to be filed before 20th of next month An excel sheet for obtaining the details required to fill the GSTR 3B is prepared as the GSTR 3B needs to be prepared and submitted online only as offline utility is not provided yet Basic features of the excel sheet are as follows 1 The details need to be entered in the yellow colored cells only 2 If any incorrect information is entered in the cell the contents of the cells appears in red color Please correct the same to get proper working 3 While entering the details of outward supplies and inward supplies in Table 3 1 select the proper nature of supplies from the drop down wherever it is provided 4 The Integrated Tax Central Tax and State UT Tax is calculated automatically depending on the figures entered under Inter State or Intra State columns and the Rate selected from drop down 5 Cess needs to be entered manually 6 Table 3 2 contains details of state wise inter state supplies to unregistered dealers composition dealers and UIN holders Select the Nature of inter state supplies and state from drop down 7 In Table 3 2 Total taxable value and integrated tax should be less than the taxable inter state supplies and integrated tax shown in Table 3 1 above 8 Details of ITC available ITC reversed and Ineligible ITC needs to be given in Table 4 The description mentioned in yellow cells is given for reference only and can be changed as appropriate in respective case 9 Tax payable in Table 6 1 is auto calculated and arrived by adding the tax payable as per Table 3 1 and deducting the net ITC available and adding ineligible ITC as shown in Table 4 10 The Tax payable figures in Table 6 1 appears in red color if there is net tax payable after adjusting payment through ITC TDS TCS and payment in cash 11 Similarly The Tax payable figures in Table 6 1 appears in red color if interest and late fee payable is greater than the tax paid in cash as the same needs to be paid by cash and can not be paid through ITC 12 The TDS and TCS credit is not applicable at present as the said provisions are not made applicable presently till further instructions
  • GSTR-3B Details collection worksheet in EXCEL

    Data Collection sheet for filling up the GSTR 3B in Excel
  • Amount in words

    Calculate amount in words in excel in Indian rupees

More Files


Failed : Success comes through rapidly fixing our mistakes

Failed Dont worry Success comes through rapidly fixing our mistakes Your journey is not between failure and success It is between a lifelong goal and a commitment in loyalty There is no destination There is no failure and success Let go of that pressure and just be happy on your journey Be committed

9 Excel print settings you probably don't know about

Printing is one area in Excel where I find that users dont take full advantage of the options provided by Excel Below I present 9 Excel print tips which I am sure youd like to know to make the task of printing your worksheets seem like a breeze So lets begin without any ado 1 Print Row and Column Ti

Insight of Documentation under GST - Special Reporting in GSTR 1

It may be noted that in the GSTR 1 return following declarations has to be filed by the supplier has to maintained a consecutive series of all such documents Sr No Nature of document From To Total Number Cancelled Net Issued 1 Invoices for outward supply 2 Invoices for inward supply from unregistere

Classification Mistakes in GST

The GST implementation has raised many major challenges initially as under Law put in place with the following person processes not being ready Drafters who are still working on many formats The IT readiness of the GSTN software needed for claim of credit on stocks uploading of returns The reasonabl

Draft Format of Tax Invoice under GST

Below is the draft format for tax invoice under Goods Services Tax This format is prepared considering the rule of GST regarding valid tax invoice Please note that this is one kind of tax invoice the design can be adopted and modified according to ones needs Points to note 1 In case of export of goo

More Articles

Updated on : 8/12/2017 5:40:53 PM


CCI online coaching GST course

CCI Jobs

close x
Download GST App    |    x