Directly upload excel file to prepare GSTR-1 on ClearTax GST Online Software
Compatible with Excel 2010, 2013 and 2016
Learn How Easy GST Invoicing Offline Excel Utility is with This Guide
Learn How to use GST Offline Excel Utility in Hindi
Upload Invoices on ClearTax GST Software to File Returns in One Click
After creating invoices with ClearTax GST Excel Invoicing Tool, upload all invoices to the ClearTax GST software. The online software auto-populates the return forms using the uploaded invoices. Review summary and file your returns seamlessly.
Get GST Excel Invoicing Tool Installed in seconds
Submit your Email id. We will send the Excel file & How to use guide on email. Download it from your email
Unzip the zip file downloaded and open the excel file named. Please make sure you have Microsoft Excel 2010, 2013 or 2016 with Microsoft Windows
A dialogue box on Microsoft Excel Security Notice pops up. Click on the Enable Macros Option
Start creating invoices
Frequently Asked Question
Which version of Excel is required?
Excel 2010, 2013 & 2016 will support the file. If you’re an Excel 2007 user, install this plugin to run the Offline Utility Software.
What is this GST Excel Invoicing Offline Utility for? Is this for billing, accounting or filing?
Many business do not have internet connection. Creating GST bills can be very hard for them. ClearTax GST Offline helps them create GST bills without internet. Businesses can later use this invoice data to file GST returns through ClearTax GST software. They can also share the data with their CAs/ Tax Professionals for filing.
When I create an invoice with special characters, I am unable to print the invoice
Please use only hyphen (i.e. ‘-’) in invoice numbers. For example, if you want to create invoice with the number ‘’Sales/GST/17-18/2′, please use ‘Sales-GST-17-18-2’. Using ‘/’ in your invoice number will lead to issues in printing the same
I’m unable to edit the fields. My GST Excel Invoicing Offline Utility isn’t working properly.
When you open the Utility, you will be asked to ‘Enable editing’ and ‘Enable macro’. Please choose ‘Yes’ for both.
Does it work on Apple Mac?
No, All the features don’t work for Mac
I have Windows XP? Does it work on that?
File will be functional of Windows XP if the system has Excel 2013 or newer version installed.
What is MRP calculator?
MRP calculator is used for calculating the taxable amount per item if you know the final item value. That is, if you know the final amount of the item you are selling is INR 2,000 and you want to create an invoice with taxes calculated based on this final amount, you can use the MRP calculator. We do a reverse calculation considering the discount you want to give and the GST rate and create your invoice.
I have created an item in the Item master with 20% discount. But I want to give only 10% discount to a certain customer. Do I need to change my Item master every time?
No. You can change the discount %, GST rates and item value, at an item-level when you create an invoice. You can do this by simply changing the values when you’re creating the invoice.
My company logo is a .JPEG file. How do I upload this logo to ClearTax GST Offline?
Right now, we support only .PNG format. However you can open your .JPEG logo file in Microsoft Paint, and save the file with the .PNG format. You can upload this new file to ClearTax GST Offline.
Attend FREE Training to learn about GST & GST Software
Training in English and हिन्दी
Attend at your convenience – 6 sessions every day; 6 days every week
~50,000+ businesses, CAs and Tax Professionals have already benefited
Clear offers taxation & financial solutions to individuals, businesses, organizations & chartered accountants in India. Clear serves 1.5+ Million happy customers, 20000+ CAs & tax experts & 10000+ businesses across India.
Efiling Income Tax Returns(ITR) is made easy with Clear platform. Just upload your form 16, claim your deductions and get your acknowledgment number online. You can efile income tax return on your income from salary, house property, capital gains, business & profession and income from other sources. Further you can also file TDS returns, generate Form-16, use our Tax Calculator software, claim HRA, check refund status and generate rent receipts for Income Tax Filing.
CAs, experts and businesses can get GST ready with Clear GST software & certification course. Our GST Software helps CAs, tax experts & business to manage returns & invoices in an easy manner. Our Goods & Services Tax course includes tutorial videos, guides and expert assistance to help you in mastering Goods and Services Tax. Clear can also help you in getting your business registered for Goods & Services Tax Law.
Save taxes with Clear by investing in tax saving mutual funds (ELSS) online. Our experts suggest the best funds and you can get high returns by investing directly or through SIP. Download Black by ClearTax App to file returns from your mobile phone.
Office Address - Defmacro Software Private Limited, C 245A, Ground floor, Room No 1, Vikas Puri, West Delhi, New Delhi, Delhi 110018, India
Cleartax is a product by Defmacro Software Pvt. Ltd.