How to Make Sumary for GSTR1, GSTR3B and Tally Data

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

1. Make this type of data
   
   
   
   
2. Open Form GSTR - 3B April
   
   
   
   
3. Copy values
   
   
   
4. Pasting on 3.1 row
   
   
   
5. Copy Eligible ITC values
   
   
   
6. Pasting on row 4
   
   
   
7. Again same procedure GSTR 3B with May
   
   
   
8. Again same procedure GSTR 3B with June month
   
   
   
9. GSTR 3B data April to June is filed in this format
   
   
   
10. Now we will open GSTR 1 (June) and Copy B2B and B2C Values
    
    
    
11. We filed both row B2B and B2C
    
    
    
12. Now we will put formula Press = 
    
    
    
13. Go to April sheet and select 3.1 taxable value, then press + button
    
    
    
14. Go to May sheet and select 3.1 taxable value, then press plus button same with june then press enter
    
    
    
15. Select row and press control R
    
    
    
16. We will get value
    
    
    
17. Put tally values
    
    
    
18. Now Match the both rows