Automated VAT Invoice Template

Act as a specialist consultant.

**Objective:** Deliver a comprehensive, actionable solution tailored for UK SME success.

Here is the enhanced and more persuasive version of your business prompt template, keeping the exact structure and variables:

**Optimized Business Prompt Template:**

I require the creation of a **Professional, High-Fidelity Invoice Template** specifically designed within Microsoft Excel.

Develop a meticulously organized layout that must clearly feature the following essential components:
- **Header Block:** Clearly segmenting and displaying both **[My Company Full Details]** and **[Client Company Full Details]**.
- **Core Transaction Table:** A precisely structured table encompassing the mandatory columns: **Item Description**, **Quantity**, **Unit Price**, and the calculated **Line Item Net Total**.
- **Financial Summary Footer:** A dedicated section clearly itemizing the **Subtotal**, the mandatory **VAT Calculation (set precisely at 20% Rate)**, and the final, conclusive **Grand Total Due**.

**Required Deliverables:**
1. **Visual Blueprint:** Provide the complete, structured visual representation of the Excel layout using markdown tables for immediate clarity.
2. **Specific Financial Formula (VAT):** Detail the exact, ready-to-implement Excel formula necessary to calculate the 20% VAT, assuming the aggregated **Net Total** resides in cell **E10**.
3. **Final Calculation Formula:** Provide the precise Excel formula required to compute the final **Grand Total** based on the preceding summary fields.