How to generate e invoice with free excel utility
Vložit
- čas přidán 5. 08. 2024
- 📍In this session we have shown the live demo of how to generate e invoice with free excel utility. This is free utility provided by CBIC for online e invoice generation. However there are certain limitations in generating e invoicing through Excel method as it is time consuming task and involve human error. Hence we would highly recommend to use a software API integration in your existing ERP system for e invoice generating. You may use clear tax e invoicing integration which is Fast, Dependable and Affordable. Setup in as less as 3 minutes. You can also refer your clients and earn referral commissions as a Clear Tax Partner. Click on the links below to know more.
👉 To refer your client: Click here bit.ly/3srjNuo
👉 Buying e-Invoicing for yourself. Click here to take demo:bit.ly/3cw9LCN
👉 Looking for a GST Software: Take FREE trial today: bit.ly/3fjsYJC
🔗Official GST e invoicing portal - einvoice1.gst.gov.in/
🔗Download Official e invoice verification - bit.ly/2PtSnpp
👨🏻🎓Enroll to our practical course in TDS, ITR & GST Filing
👉Enrollment Link - bit.ly/3uENoRn
👉Create your account
👉Proceed for payment
👉After payment you can access your complete course
👉Get Certificate after course completion
⏰Video is divided in following chapters-
0:00 Intro to e invoice
6:11 GePP Tool for generating e invoice
6:24 Overview and limitation of GePP tool for e invoicing
7:57 Add Supplier Master in GePP tool
9:29 Add Recipient Master in GePP tool
10:55 Add Product Master in GePP tool
13:21 Filing Data for e invoicing in GePP tool
20:55 Generating JSON file from GePP tool
22:02 How to generate IRN and e invoicing
25:10 How to cancel e invoice
25:51 Time limit for cancelling e invoice
28:56 Bulk IRN generation in Excel Utility
33:18 Bulk e invoice generation Format A
33:49 Bulk e invoice generation Format B
33:40 Bulk e invoice generation Format C
35:47 Bulk e invoice generation Format D
37:14 Generating Bulk e invoice through Format A
46:42 Validating and Preparing JSON in Form A for e invoicing
51:08 Bulk e invoicing cancellation
53:27 Outro
📍For Tax consultancy and query please contact below
📩 info@fintaxpro.in
📞9718097735
📍For Digital Content and collaboration
📩 vivek@fintaxpro.in
📞8368741773
Cheers Folks
Thanks for Watching :)
-Team Fintaxpro
Disclaimer- Although all provisions, notifications, updates and live demo are analyzed in-depth by our team before presenting to public. We hereby provide our point of view only and tax matter are always subject to frequent changes hence advisory is only for the benefit of general public. Hence neither Fintaxpro Advisory LLP nor its designated partner are liable for any consequence arises on the basis of You Tube videos.
#einvoicing #liveDemo #GePP #ExcelTool
VERY GOOD NARRATION. THANK YOU VERY MUCH SIR
Hatts off....nicely explanied ....thankyou very much
Thanku aapne bhutt acche se batya hai
Very good teach sir thank u
Tq for your valuable information sir love from karnataka
Good Explanation Sir
Thank you Bro it helped me allot..
Thank u so much sir
superb
Is GST no mandatory for ship to address on the case of Bill to-Ship to
Best
Sir e invoice me 100 items he to konsa format used Kare?
What to do if I want to print Trade name in Invoice in case of Proprietorship firm through this tool. Means can i put Trade name in tab of Legal Name ?
Sir
Can we link Credit note with original invoice no and date of invoice against which Credit note has been issued before generation of IRN...As the offline utility doesn't contain any field for entering the original invoice number and date ?????
Just becoz gst act makes it mandatory to link the credit note with it's invoice
Please reply!!!
HI SIR, AFTER GET E INVOICE, IN GEEP SHOWING PENDING INVOICE ALSO IRN DETAILS COLOUMN BLANK SHOWING " ACK NO., DATE, IRN" , SO HOW TO PUSH HISTORY, WHEN I TRY TO HISTORY SHOWING " THERE ARE NO IRNs to push please import irns and try again" Pls reply how to solve this
If I have more than one items I have to fill
Supplier and buyer details again in next line.?
Very nice video sir please tell in this e invoice where mentioned purchase order no
Nice video
Glad it helps
Sir, when item addition We enter SI. No. System is not receive it show error, why.
Sir, while creating invoice when i click on Add new item i am getting msg " Enter valid trade name in Profile". So not able to add item. .1st time try excel please guide ? I have redownloded the utilities also. Then also same problem.
Sir
Bulk irn generation mein
Jason prepration format mein invoice ko ek baar validate krne ke baad same file mein dobara new invoice ka entry krke validate kar sakte hai kya sir?
Sir, We are doing jobwork thats why rates are differnt for each customer and products can we change rates accordingly
Sir please explain how to Clear pending invoice in Geppt Excel
The compile error in Hidden module: ModuleS1 comes , Please Guide me
2.1 New version required ( old version 2.00 invoice only coming Eway bil no but vehical no ...??? ) Required vehicle no asking Tax inspector top
sir we r a transport company, is e-invoice is applicable on it, as we are a service provider
Sir I have pending invoices 20 in Gepp tool, when am entering invoice number 21 it says please import IRN and they try... How I can import for IRN for old invoices which I have made since two months.. please tell me the process sir..
I need to move pending invoices to generated invoices..
I have same problem
The offline tool shows error while entering data which is as follows "compliation error in hidden module: sheet 1. This errror commonly occurs when code is incompatible with the version, platform, or architecture of this application. "
Please redownload the utility again and try.
Nice information🌹, thanks Sir, some question, where add tcs amount, and when 1 st we make e way bill can we make e invoice. What and which time limits for making e invoice.
Add TCS in other additional amount
Yes we can make e invoice after e way bill
@@FinTaxPro any time limit for making e invoice sir
How to create E-Invoice for unregistered or export clients?
Sir, we generate invoices in excel and our invoice template has certain additional fields which are not validated by IRP portal when we upload the json file with those fields. So, can we generate the QR code image separately so that we can place that QR code on our existing invoice template?
Yes you can generate QR Code separately.
@@FinTaxPro Thanks Sir. Came across this link (czcams.com/video/xLhfHoSh5zg/video.html). Seems to do the job of generating QR Code image.
Plz bataye how can generate seprate bar code and irn number
हमारी फर्म में e invoice 1 October से शुरू हो रहा है । अभी तक 34 Invoice बन चुके है तो क्या e invoice 35 No. से बनेगा या 1 से ?
Make a video how to generate e invoice for rcm invoice
Sir, e invoice mein sac code use kaha par hoga?
Sir, 12:36 integration se kiya matlab hai...?? Is it ARI registration...?? Or something else
Sir plz mera single invoice me 25 item hai , with different qty and taxable amount, plz iska example bataye
Sir, I want a hsn billwise entry tool and gstr3b monthwise entry adjustment/+/- tool .
Sir gst simple process and
Sir meri Income FY 2019-20 me ₹250000/- se kam thi and mene aaj yani 04.04.2021 ko ITR1 file kiya ...data pura fill kar diya and itr verification ke liye adhar otp bhi daal raha hu lekin file nahi ho rahi itr....error msg me likha aa raha hai ki due the for this itr is over ....to kya ₹250000 se kam income wale bhi ab fy 2019-20 ki itr file nahi kar sakenge. Please reply Sir!
No you can't file as per normal process
@@FinTaxPro ok thanks
What about after 20 entry
Plz help
Sir I want to add bank details and vehicle no. How to add. Please help
Sir how to make e-invoice for B-C useing Excel
Can you tell me what should I fill for recipient GSTIN if my recipient is in USA , not registered in GST
I have the same problem rn
Can you pls share the solution if you have
Also, what to enter in pincode for export invoices?
Sir mene Gepp tool k through 6 invoice upload kiye lekin uskem se error ki wajah se sirf 2 invoice ka hi IRN generat hua, ab jo baki k 4 invoice reh gae hai to uska IRN kese generate hoga??
2nd question ye hai k mere gepp tool me generated invoice nahi dikh raha mere 6 k 6 invoice pending list me dikh rahe hai to usko kese update kar sakta hu in gepp tool
aap dobara generate kar sakte ho
gepp offline tool hai aap data seperate jagh maintain kaijiye
@@FinTaxPro
Sir 2nd question k bare me please bata do,
Gepp tool me pending invoice ko generated invoice me kese trf. Kar sakte hai??
Dobara JSON bana k upload kar do
Sir isme truck no kha dalega
quantity nahi he service to kese kare
Sir lucky winner giveway chal raha tha lucky winner ko course kab tak provide hoga
1-2 days
Error 2150 aa raha hai aur failed invoice dikha raha hai duplicate irn error plz guide
Sir mere computer pe gpp gile mei master pe click karne par error aa ja raha add ka option nhi de rha 😒
Problem solved?
Sir please give solution to compile error with hidden module
exel latest version 2013
Sir
Mera name kob lucky list a ayega?😩😩😩
Ecommerce excel sheet link 2021-22
Please reply sir
Please tell me how to enter dispatch from details in the e-invoice. So many I try but it is not responding . run error 2147417848 this was coming. Please tell me how to proceed. The billing address was Jaipur, and the dispatch from the address was an airport please tell me sir