[go: up one dir, main page]
Scribd
Upload
96 views1 page

Invoice Template with VAT Calculation

This document appears to be an invoice template containing fields for the company name and address, invoice number, date, terms, list of items ordered including description and unit price, totals for subtotal, VAT, deposit, and balance due. It contains formulas to automatically calculate totals and amounts due based on entered values.

Uploaded by

mpvuk
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF or read online on Scribd
96 views1 page

Invoice Template with VAT Calculation

This document appears to be an invoice template containing fields for the company name and address, invoice number, date, terms, list of items ordered including description and unit price, totals for subtotal, VAT, deposit, and balance due. It contains formulas to automatically calculate totals and amounts due based on entered values.

Uploaded by

mpvuk
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF or read online on Scribd
You are on page 1/ 1

A B C D E F G H

1 Company Name
2 Address1
3 City
4 Post Code
5 Telephone
6 Email
7
8 To:
9
10
11
12
13 Date delivered Terms Invoice No 44537.78
14 Date 07/12/21 18:46:41
15
16 No of units Description Unit Price Amount
17
18 =SUM(H14)
19
=NOW()
20
21
22
23
24
25
26
27
28
29 =IF(G17="","",PRODUCT(G17,A17))
30
31
32
33
34 =IF(SUM(H17:H41)>0,SUM(H17:H41),"")
35
36
=IF(H42="","",H42*17.5%)
37
38
39
40 =IF(H42="","",SUM(H42:H43)-H44)
41
42 Subtotal
43 VAT
44 Deposit
45 Balance due

You might also like