Advertisement
Advertisement
Skip to content
Follow Us on
Advertisement
TOP STORIES
Goods and Services Tax

GST Reconciliation Tool in Excel Format

Advertisement


I have made an attempt to make GST Reconciliation simple and Easy to find mistakes. User of the Sheet have to fill the data as per  Master data sheet requirement. On Left side of master data sheet user have to fill portal data and on right side of the master data sheet user have to fill Data as per Books.

After feeding all required data just  click on summery where we can find all the summery of data which is feeded in master sheet.  Master Sheet has button of removing all commas and space just click that button and after that  we have to move to consolidation of data sheet, where we can see all party details as per books books and portal data.

Advertisement
Access Denied! Only registered users can download this file. Register or Login.

Author Info

subodh
Name: subodh
Qualification: Graduate
Location: Maharashtra
Articles Published: 1

Join TaxGuru's Network for the latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.

22 Comments
  1. where can i get the data as per portal data in GST website as you have mentioned in the master sheet
    kindly help.

  2. i past data in master sheet .but data showing in only summery sheet. no data showing in other sheet

  3. how to use this tool,Thank you so much its very usefull how do i change the font size & font clr in sheet. its protected.

    1. There is Tax Amount Column In master Data which is locked so please Feed Data as per column detail till sgst amount if you going to paste data in tax amount there will error …….

Leave a Reply

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