How to download gstr 2a in excel sheet
※ Download: http://chadesehe.botcraftman.ru/?dl&keyword=how+to+download+gstr+2a+in+excel+sheet&source=bitbin.it2
Click the Generate File button shown above to get the link of file generated. To Copy only the Unique Invoices Into New Sheet Select all the data Press Alt+; and Ctrl+C to copy only the filter Data and Ctrl+V in New sheet or You can verify in the same sheet but the total will not work correctly in filtered sheet while reconciliation Errors: we can't do it on merged cell so Unmerge the cells I hope this will provide you a method to easily reconcile Inputs in Gst The author can also be reached at rajatsolanki1 yahoo. Octa GST will read the contents of file and extract the data. To Copy only the Unique Invoices Into New Sheet Select all the data Press Alt+; and Ctrl+C to copy only the filter Data and Ctrl+V in New sheet or You can verify in the same sheet but the total will not work correctly in filtered sheet while reconciliation Errors: we can't do it on merged cell so Unmerge the cells I hope this will provide you a method to easily reconcile Inputs in Gst The author can also be reached at rajatsolanki1 yahoo.
GST portal allows you to download the Json file for GSTR 2A for your inward supplies. Click the Add button. Select all DATA in Sheet and add a Filter 2.
Even in GSTR offline Utility Usermanual they mentioned along with screenshots that we can sol to excel, But there is know such option in GSTR Offline Utility. To Copy only the Unique Invoices Into New Sheet Select all the data Press Alt+; and Ctrl+C to copy only the filter Data and Ctrl+V in New sheet or You can verify in the same sheet but the el will not work correctly in how to download gstr 2a in excel sheet sheet while reconciliation Errors: we can't do it on merged cell so Unmerge the cells I hope this will provide you a method to easily reconcile Inputs in Gst The author can also be reached at rajatsolanki1 yahoo. To add the GSTR-2A data in Octa GST, pan the business file and go to GSTR-2A module. To Copy only the Unique Invoices Into New Sheet Select all the data Press Alt+; and Ctrl+C to copy only the filter Data and Ctrl+V in New sheet or You can verify in the same sheet but the total will not autobus correctly in filtered sheet while reconciliation Errors: we can't do it on merged cell so Unmerge the cells I hope this will provide you a method to easily reconcile Inputs in Gst The author can also be reached at rajatsolanki1 yahoo. JSON file is a type of computer print based on Java that is easy for humans to read and write. It is useful to view the data in a spreadsheet such as Excel or Open Office. Press the CONVERT button below to start the conversion. To Copy only the Unique Invoices Into New Xi Select all the data Press Alt+; and Ctrl+C to copy only the filter Data and Ctrl+V in New sheet or You can verify in the same sheet but the total will not work correctly in filtered sheet while reconciliation Errors: we can't do it on merged cell so Unmerge the cells I hope this will provide you a method to easily reconcile Inputs in Gst The author can also be reached at rajatsolanki1 yahoo. That is making it very difficult for the tax payers to reconcile the entries in GSTR 2A report with purchase invoices. Tip: If you don't see the u names in GSTR2A, you can define the contacts in Octa GST and GSTR-2A module will also show the name of suppliers for easy reference.
Now Export GSTR 2A to Excel for Reconciliation - Clicking Next will show the details of documents reported by that supplier. Clicking Next will show the details of documents reported by that supplier.
You may need to wait for 15-30 mins for the file to be generated. Click the Generate File button shown above to get the link of file generated. Clicking this link will download the file on your computer. Add GSTR-2A file to Octa GST Note: If you don't have Octa GST installed on your computer, please and install it first. Octa GST is a smart and high performance offline software to auto-generate GST returns. To add the GSTR-2A data in Octa GST, open the business file and go to GSTR-2A module. Click the Add button. Select the file downloaded from GST Portal. Octa GST will read the contents of file and extract the data. Important: If you have large number of invoices more than 19,000, GST Portal may generate more than one file. If this happens, please select all those files together while adding in Octa GST. View GSTR-2A Data Once the GSTR-2A data is added in Octa GST, it can be viewed by clicking the View button in GSTR-2A module. One first screen it will show the GSTR-2A data summary by supplier. Clicking Next will show the details of documents reported by that supplier. Tip: If you don't see the supplier names in GSTR2A, you can define the contacts in Octa GST and GSTR-2A module will also show the name of suppliers for easy reference.
