We have our invoices sent to customer mail Id. We need to modify formatting of invoice by the following points:
1. Unit Rate (₹): A column for unit rate to be inserted after Qty, which should be the actual selling price of the product (Unit Rate = Amount/Quantity).
2. Discount (₹): Currently, we have a column for price but we need to insert column for discount amount and then net amount column which shows the final price, i.e., deduction of discount from the price as per attached image.
Currently we have two cases for giving discount to our customer, first one is fixed figure for ex. ₹ 100, and second one is percentage, like 10% on the list price on website prices after application of certain coupons in both cases. So, you are requested to display only discount prices in both cases under discount column in invoice.
3. HSN/SAC Code: HSN/SAC Code should be mentioned on the invoice for each product in a column before QTY. There should be option to upload the same on website through excel file from where we upload all the products. (It is to be 8 digits).
4. CGST & SGST for Intra-State, IGST for Inter-State: Addition of CGST-SGST & IGST at the bottom (subtotal) for the bifurcation of total GST price according to the intra-state or Inter-State respectively as shown in attach image. It should show either CGST/SGST or IGST based on the delivery location automatically.
5. Amount in words: Total amount in invoice should be mention in words below the total price. It should start from left side /alignment. Refer image 1.
6. Signature Authority: There should be an option to upload a signature image. Signing Authority should be placed at the bottom right corner of the invoice, just below the “Amount Chargeable (in words)” with the signature image. On the top, “for Grydle AND SYNC PVT LTD” should be there and below it, “Authorised Signatory”, should be there. Image should be in between these two. Refer image 2.
7. Customer GST number : Customer GST is optional in our billing address, if customer enters their GST then it should be reflected on the invoice under their billing address as well.
8. Title of Invoice: There should be title of invoice on top centre, “Tax Invoice”. And besides it, “(Original For Recipient)”, should be there towards top right.
9. Instead of “Tax Invoice” on right side, it should be “Invoice Number”.
10. Instead of “Order” on right side, it should be “Purchase Order ID”.
11. Instead of “Order Amount”, it should be “PO Amount”.
12. All figures to be in decimal.
13. There should be a “E & O.E.” besides the amount in words on the extreme right. Refer image 1.
14. There should be “State/UT Code:” present below the customer billing and shipping address. It should come automatically in invoice.
15. There should be “Place of Supply:” with State name or UT name on the bottom of shipping address of the customer.
16. There should be “Order Date” on top right below the Purchase Order ID in the invoice.
17. Subtotal should be equal to sum of prices in the net amount column & there should not be any discount row between Subtotal and GST on the bottom right corner.
Note: Please find the attached sample of invoice for your reference.
43 freelancers are bidding on average ₹9544 for this job
Hi there Let me do all the changs you want on the invoice. I offer to do the job without any advance or midterm payment. Get the job done and test if you are satisfied then pay after your complete satisfaction.
I can do changes in invoice formatting for you. I have 8+ years of experience in php. I assure you that I will give 100% quality work. Let us discuss and proceed further in chat. I am online. Please reply.
Hello Sir I can make the changes as listed in document and deliver this in next 2 days at max. I am ready to start right away. Please check my profile for work and experience. Regards Deep