balance sheet in excel format

News

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

IT Dept pushes additional cases of High Cash Deposits


Income Tax Department pushes additional cases of High Cash Deposits in Second Phase of Operation Clean Money The Income Tax Department ITD has used information received under the Statement of Financial Transactions SFT to identify 5 56 lakh new persons in the second phase of Operation Clean Money OC

GSTN unveils excel template for easy data entry offline


GSTN unveils excel template for to help taxpayers perform easy data entry offline before uploading on the GST portal Excel template together with an offline tool will make uploading large numbers of invoices much easier and quick Offline Tool to be unveiled on July 17 2017 Goods and Services Network

Special Webpage on Goods and Services Tax (GST) on PIB Website


A special webpage on the Goods and Services Tax GST on PIB Website was launched today by Principal Director General Press Information Bureau Shri A P Frank Noronha The webpage can be accessed onhttp pib nic in gst Goods and Services Tax GST a historic tax reform will come into effect from tomorrow i

Minute details of How GST happened


GST roll out Complete transformation of the Indirect Taxation Landscape Some minute details of how it happened Goods and Services Tax GST a historic tax reform will come into effect from tomorrow i e 1stJuly 2017 GST will completely transform the Indirect Taxation landscape in the country involving

More News



Experts Opinions

Ppf balance not shown in balance sheet


Dear Sir An Assesse who is a professional has filed ITR 3 for A Y 2017 18 In the Balance Sheet Asset Side under investments head he has shown Interest on PPF and Deposit in PPF Account during the year but he has not shown the PPF Balance as per last yr He is not doing Tax Audit as his Professional I

Clarification on advertising agency billing format


Dear sir madam 1 Our company is an advertising agency engaged in the activity of publishing ads in news papers 2 publications are charging gst 5 of net taxable amount from us after agency commission 3 In what way we have to bill to Client 4 Weather we have to collect Gst 5 or 18 of Commission receiv

Gst on rent bill format


Pls issue a bill format of GST on Rent

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

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

Discussion

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

Projected balance sheet

I want a projected Balance Sheet format for Proprietorship Concern for availing Cash credits

invoicing format

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

gst sale bill format in composition schm

what type of bill fomat in composite schem

Information about itc of old stock for cloth manufacturers

HelloI am a shawl manufacture and was exempted from any tax registeration before 1july 2017 and do not possessed any tax registeration I have VAT paid bills of my raw material yarn I want to know how much amount of itc would i get and which where and when do i have to fill form Currently i have regu

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
  • Worksheet under GSTR-3B

    Worksheet under GSTR 3B

More Files

Articles

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


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


GST Provisions - Information Technology Sector


It is said that uncertainty in law is the greatest tyranny Software or Information Technology sector has been struggling with uncertainty in taxation matters for long Firstly an issue was raised whether software is a goods or service The issue was always contentious Other issue was raised as to whet


How to Insert a Pivot Table in Excel - Pivot Table Basics


This article was first published on the authors blog MadAboutExcel com Click here to visit the blog Pivot Table as you might be knowing is one of the most sophisticated and useful features of MS Excel I believe most Excel users must have used this feature at some point and many use it quite regularl


Online information and database access or retrieval services - GST


Facts of the case Scenario 1 The Entity is providing its own developed contents allowing the end users to Browse Search Download and purchase for use on device The Entity is the owner or Licensee of copyright in the content Queries What will be the indirect tax implication on account of providing su


More Articles


Updated on : 8/13/2017 1:27:50 PM


ISC

CCI online coaching GST course




CCI Jobs

×
close x
Download GST App    |    x