Objective

Build a professional invoice generation system.

Worksheets

  1. Customer_Data
  2. Product_Master
  3. Invoice
  4. Invoice_Data

Invoice Fields

  • Invoice Number
  • Invoice Date
  • Customer Name
  • Address
  • Product
  • Quantity
  • Unit Price
  • Amount
  • GST
  • Grand Total

Formulas

Amount

=Quantity*Unit_Price

GST

=Amount*18%

Grand Total

=Amount+GST

Advanced Features

  • Customer drop-down
  • Product drop-down
  • XLOOKUP for prices
  • Automatic invoice number
  • GST calculation
  • Print-ready invoice
  • PDF export

Optional Advanced Task

Use VBA to create a Generate Invoice button.

PreviousNext