Invoice Structure Overview
An invoice needs to contain the following structure: the header, the client’s details, the invoice details, payment info, and a note.
1. Header Section
An invoice: have a header with the title INVOICE along with your business name, logo, address, phone number, email , and optionally your business registration number, and a GST/VAT number, if you have one
2. Client Details
have your client’s name and company , client address and contact info
3. Invoice Details
and an invoice number like INV-001, an invoice date, due date, and payment terms, e g. “Net 15” or “Due on receipt” ;
4. Product or Service List
have a list of sold products or services, such as Name, Quantity, Unit Price, and Total. For example, “Service”, “2”, “hours”, “$50”, “$100”. (You can add more rows if necessary.)
5. Totals
Also, create subtotal, taxes , discounts, and grand total;
6. Payment Information
include your payment info with bank account info, PayPal or UPI, or other payment methods, and the currency to be paid in (for example USD$, PKR ETC)
7. Final Note
note, thank the client and add any specific terms you need to remember to include as indicated above.
Let’s Create it,
1ST STEP:
First step header, Merge first 7 rows to Column G as shown In Image.

2nd STEP:
Add Logo Of Company and Header invoice, as shown In image.

3rd STEP:
Now add Company detail (Like Company Name, Contact Number, Email, and Location) and invoice number and Date From row 9 shown in image.

4th STEP:
Now Add Customer details from row 16 as shown In below image, use emojis for better visuals:

5th STEP:
Add Product Details, SN(Serial number), Tax etc from Row 22, As shown In below Image.

6th STEP:
ADD Sub Total, Discount (Optional) Grand Total Payment Method (Use Dropdown for it to easily select Payment Method for example cash or bank same for Down Payment)
Total Use (=SUM() Formula) and final Note thanks to client.

LAST STEP:
Add Footer For More Professionalism and better visuals it is optional. And format the invoice According to Your Own colours and style.

FINAL LOOK:

Hope you liked it! Thanks for reading till the end. We’ll meet again in the next exciting topic.