Reconciliation Statement for Matching Of Input Tax Credit And Output Liability Between Books And Return

As we know that In GST Audit, Reconciliation Statement is required. Here, I am attaching one sample format of Reconciliation Statement for matching of ITC (As shown in Return-3B) and ITC (As shown in Books of Accounts).

Please give your necessary suggestions For any further Improvement.

Access Denied! Only Regstered Users Can Download The File "Excel format of Reconciliation For Matching ITC and Output Liability". Register Here or Login

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 (6865)
Type : Downloads (296)
Tags : goods and services tax (5353) GST (4956)

11 responses to “Excel format of Reconciliation For Matching ITC and Output Liability”

  1. GAJENDRA SINGH PAWAR says:

    PLZ SEND ME THE FORMAT

  2. Ram says:

    How to download this file?

  3. Bhawna Bagra says:

    AS PER RETURN WHAT SHOULD BE THE OPENING BALANCE ?

    • kotharijp94 says:

      Suppose your July month end liability for CGST is Rs 5000 but it will be paid in August. So your opening Balance of liability for August month will be Rs 5000. Same concept applicable for SGST and IGST as well.

  4. Mohamed@123 says:

    Nice Job, Please segregate the Input credits like Common ITC, ITC on Cap. Goods, Ineligible ITC, etc and also insert Row/ Column for ITC reversal under various Section under GST (i.e. u/c 42 & 43)

  5. JYOTISH1983@GMAIL.COM says:

    why differences in INPUT availed & utilization amount. have what same amount not.

    • kotharijp94 says:

      First Thing I want o clarify to all that why I have not created the blank sheet. I have filled the column with some figures. Because Many clients have changed the entries in software which they omitted during respective GST Period or wrongly entered after filing of GSTR-3B. Due to which Differences exists in 3B Filed and Books of Accounts. That’s why I have used the figures to demonstrate this issue.

    • kotharijp94 says:

      First Thing I want o clarify to all that why I have not created the blank sheet. I have filled the column with some figures. Because Many clients have changed the entries in software which they omitted during respective GST Period or wrongly entered after filing of GSTR-3B. Due to which Differences exists in 3B Filed and Books of Accounts.

  6. shashikantinc says:

    Thank you sir,

    It’s Too Good…..

    Thanks
    Shashikant
    Bangalore

Leave a Reply

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