Posts

Showing posts from October, 2017

How to Convert GSTR2 Report to Excel Format

Today all the tax payers are taking lot of the time for reconciling the GSTR2 report with Purchase Invoice by checking one by using the offline utility software provided by the GST Portal, but here I am introducing the new utility created in the Microsoft Excel Format which will helps us to convert the Json File which is created by the GST Portal to Microsoft Excel Format and it will helps us to reconcile the data by using Vlookup formula in the less time and you can relax in the GSTR2 filing process. Step-1 Download the GSTR2A Report from the GST Portal Step-2 Download the Offline Utility software of the Json file convertor to Excel using the below link (It will work only above version of Microsoft Excel 2010 and above) Step-3 Convert the Json file to CSV Format by uploading the file to site https://json-csv.com/ Step-4 Convert this to CSV Format Step-5 Copy and Paste  the data in  the CSV File to the Excel Utility and pasting same using Paste Special  values Step-6 Co

Late Fee being applied in case of Sept month 3B

You might have received complaint about late fee being applied in case of Sept month 3B . This is not for any delay on filing of Sept month as we have not reached 20th Oct. It is on account of late filing of return for previous period.   The system does entry into ledgers from 3B return on the date on which return is submitted (entries get frozen). The late fee till that date is applied, if date of submission is later than the last date of filing. In case the return is filed later than the date of filing then the late fee for the gap between date of filing and last date of filing return or date of submission (whichever is later) is added in the next month’s return.   In case a taxpayer had submitted last month’s return on 22nd Sept (D1) and filed the return on 26th Sept (D2), then late fee was calculated for 22nd -20th Sept and shown in the payment sheet of Sept Return (2*100*2). . The delay between date of submission (D1) and date of filing (D2) [26th -22nd Sept] amounting to 4*2*

BCAS Initiative - Educational Sevies on GST

BCAS Initiative - Educational Sevies on GST : https://t.co/cAkoUwQelj via @YouTube GST for Charitable Trusts: https://t.co/1oVl4JWUB6 via @YouTube Composition Scheme: https://t.co/UBa6D4k3p1 via @YouTube GST on Co-operative Societies: https://t.co/kFSv9ADUwC via @YouTube GST under Agency Principle: https://t.co/P84NUdGEI7 via @YouTube Procedures for LUT/Bonds/Export Refunds: https://t.co/wShrcJugqJ via @YouTube Levy Provisions under GST: https://t.co/ZtQX2Zdhnx via @YouTube Composite vs. Mixed Supplies: https://t.co/RlStkfja1N via @YouTube Bill to/ Ship to - GST Implications: https://t.co/6TR4ZLncLP via @YouTube Capital Goods - GST Issues around Credit: https://t.co/5kkJElEDnR via @YouTube Moevable Works Contracts: https://t.co/OHM0moHOLd via @YouTube Job Work Provisions: https://t.co/ICNpaYq9fU via @YouTube Works Contracts - Issues for Contractors: https://t.co/1ZGkqGkG6g via @YouTube Government Services: https://t.co/QY41HjC7BE via @YouTube Concept of Supply: https://t.

Various GST Updates

# *GST*: The government is planning to allow quarterly filing of returns instead of monthly, by a vast majority of businesses as nearly 60 Lac businesses account for only 5% of taxes and nearly 4 Lac business account for 95% of the taxes. # *GST*: Small exporters has been exempted from giving bank guarantee - the facility of furnishing LUT, in place of a bond, for exporting goods or services or both shall be allowed to exporters. # *GST*: CBEC has extended the period for intimation of details of stock held on the date preceding the date from which the option to pay tax u/s 10 of the CGST Act is exercised in FORM GST CMP-03 is extended till 31-OCT-2017 - Order No.04/2017-GST, dt.29.09.2017. # *GST*: Deadline for selling unsold pre-GST stock with their revised MRP post implementation of GST along with their old MRPs extended to 31-DEC 2017. # *GST*: CBEC notifies amendment in the CGST Rules 24, 118, 119, 120 & 120A and also amended Form GST REG-29 – Noti.No.36/2017-CT, dt.29.09.2

GST + INCOME TAX Update in Hindi

१) जुलाई महीने के फॉर्म GSTR-1भरने की अंतिम तारीख १०/१०/२०१७. २) सप्टेम्बर महीने के फॉर्म GSTR-3B भरने की अंतिम तारीख २०/१०/३०१७. 3) कंपोसिशन स्कीम के व्यपारियो का ०१/०७/२०१७ से ३०/०९/२०१७ तक के फॉर्म GSTR-4 भरने की अंतिम तारीख १८/१०/२०१७. 4) इनकम टैक्स ऑडिट की अंतिम तारीख ३१/१०/२०१७.

BALANCE SHEET FINALISATION CHECKLIST

Given below is the checklist for finalisation of Balance sheet hope this will help you for sure in finalising the balancesheet of all organisations. Must check the following things before finalising . 1. No Entry On National Holiday. 2. Confirmation of Secured Loans. 3. Confirmation of Unsecured Loans. 4. Confirmation of S.Creditors (Specialy Those With Debit Balance.) 5. Confirmation of S.Debtors (Specialy Those With Credit Balance) 6. Bonus Sheet To Be Tallied With Bonus Paid In Cash And By Cheque. 7. Check Cash For Negative Balance. 8. Electricity Charges For 12 Months Entered Or Not. 9. Salary Sheet – Tally With Salary Paid In Cash+Cheque. Salary of Employees Who Have Not Signed Salary Sheet Should Reflect As Payable. Tally With Salary Summary For Whole Year. 10. Copy of All Full & Final A/C Papers Required. 11. Insurance Exp. – Pre-Paid Entries To Be Done. Copy of All Cover Notes To Be Kept In Balance Sheet File. 12. Other Pre-Paid Exp. Entries Like Licence Fee, AM

GST UPDATE

Late Fees for GSTR 3B for the month of August is waived. Those who have filed the GSTR 3B for the August month with late fees, have to wait for credit in cash ledger. Those who have filed GSTR 3B for the month of July with late fees, their late fees' credit has been given in Cash Ledger.