For make Sumary for GSTR1, GSTR3B and Tally Data, follow the steps

  1. Make this type of data
    1. Make this type of data.jpg


  2. Open Form GSTR - 3B April
    2. Open Form GSTR - 3B April.jpg


  3. Copy values
    3. Copy values.jpg


  4. Pasting on 3.1 row
    4. Pasting on 3.1 row.jpg


  5. Copy Eligible ITC values
    5. Copy Eligible ITC values.jpg

  6. Pasting on row 4
    6. Pasting on row 4.jpg

  7. Again same procedure GSTR 3B with May
    7. Again same procedure GSTR 3B with May.jpg

  8. Again same procedure GSTR 3B with June month
    8. Again same procedure GSTR 3B with June month.jpg

  9. GSTR 3B data April to June is filed in this format
    9. GSTR 3B data April to June is filed in this format.jpg

  10. Now we will open GSTR 1 (June) and Copy B2B and B2C Values
    10. Now we will open GSTR 1 (June) and Copy B2B and B2C Values.jpg

  11. We filed both row B2B and B2C
    11. We filed both row B2B and B2C.jpg

  12. Now we will put formula Press = 
    12. Now we will put formula (equal to).jpg

  13. Go to April sheet and select 3.1 taxable value, then press + button
    13. Go to April sheet and select 3.1 taxable value, then press plus button.jpg

  14. Go to May sheet and select 3.1 taxable value, then press plus button same with june then press enter
    14. Go to May sheet and select 3.1 taxable value, then press plus button same with june then press enter.jpg

  15. Select row and press control R
    15. select row and press control R.jpg

  16. We will get value
    16. We will get value.jpg

  17. Put tally values
    17. Put tally values.jpg

  18. Now Match the both rows
    18. Now Match the both rows.jpg
Ask a doubt
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 14 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.