Hello Friends, I have received good reviews for my last article from members.  So from your good support, today I am writing my second article. Hope it will be useful to all of you. As we all know that GST was implemented from 1st July 2017 and many of our clients have started to prepare the Financial Statements for the year ended 31st March 2018.

During the audit, we have to reconcile the statutory dues in books with return filed. In case of any discrepancy found will be reported to management and thereafter will be corrected. For Reconciliation of Output Tax, Input Tax and Payment of GST with books and return, I have prepared a simplified format. You can find out the differences by entering value from GSTR-3B return and books. Please find the enclosed herewith this sheet.

Your comments and suggestions are highly appreciated.

Download Reconciliation of GSTR-3B with Books in Excel Format

Author Bio

Qualification: CA in Job / Business
Company: Krayman Consultants LLP
Location: Gurugram, Haryana, IN
Member Since: 16 Dec 2017 | Total Posts: 2

My Published Posts

More Under Goods and Services Tax

Posted Under

Category : Goods and Services Tax (8052)
Type : Downloads (321)
Tags : goods and services tax (6503) GST (6104)

7 responses to “Reconciliation of GSTR-3B with Books in Excel Format”

  1. Manoj kumar Garg says:

    We enter output tax in b2c but actually invoice is for
    B2b. Now what to do.

  2. V.S.Ravindran says:

    Very encouraging and time-saving. Thank you

  3. GAJENDRA SINGH PAWAR says:

    PLZ PROVIDE ME THE FORMAT

  4. PRATEEK GUPTA says:

    please provide format

  5. hari says:

    Thank you

  6. kotharijp94 says:

    Thanks Sudarshan!

  7. tsudarshan says:

    good excel sheet

Leave a Reply

Your email address will not be published. Required fields are marked *

Featured Posts