VAT Receipts (Rules, Examples, and Excel Templates)

What a VAT receipt does

A VAT receipt records a sale and the value-added tax charged on it. It helps the buyer support an input VAT claim, where local rules allow one. It also gives both sides a record of the taxable amount, tax rate, and payment due. For the seller, it supports sales records and output VAT reporting.

A VAT receipt may also be called a VAT invoice. The exact name and format depend on the country and type of sale. A receipt alone does not make every VAT claim valid. The buyer must meet local claim rules, and the purchase must qualify. Keep the original record with related proof of payment.

Rules are local. In the European Union, invoice details depend in part on the type of invoice and transaction. See the European Commission’s VAT invoicing rules for an overview. Check the tax authority in the country where the sale takes place before setting your process.

Key details to include on a VAT receipt

A full VAT invoice commonly names the seller and customer, gives the issue date, and uses a unique invoice number. It should describe the goods or services and state the supply date when that differs. It should also show the taxable amount, VAT rate, VAT due, and total payable. Local rules may ask for more details.

Include each party’s VAT number when the rules require it. The buyer’s VAT number is often needed for business-to-business sales or reverse charge transactions. Do not add a VAT number if the business is not registered to collect VAT. A wrong number can create problems for both parties.

• Seller details: legal or trading name and business address.
• Customer details: name and address, where required.
• Invoice record: a unique number and issue date.
• Supply details: goods or services, supply date, and taxable amount.
• Tax details: VAT rate, VAT amount, and total due.
• Special wording: the required note for a reverse charge or other special case.

Small sales may qualify for a simplified invoice. These often need fewer details, but the rules set limits and conditions. Do not assume a till slip meets the test. Confirm the threshold and required fields with the local tax authority.

When the reverse charge applies, the seller may not charge VAT. The buyer accounts for the tax instead. The invoice must include the wording required by local law, such as a statement that the reverse charge applies. Use the exact phrase set by the relevant authority. Do not treat a generic note as valid in every country.

VAT receipt examples and templates

A VAT receipt template can make routine billing faster and help staff include key fields each time. It is a starting point, not proof of compliance. Set it up for your country, business type, and usual sales. Review it when rules or services change.

Here is a simple VAT receipt example for a standard-rated sale. The figures use a made-up 20% rate for illustration only. Tax rates differ by place and product. Replace these details with the rate and wording that apply to your sale.

Field	Example
Seller	Northside Design Ltd, 10 Market Road
Customer	Oak Studio, 4 River Lane
Invoice number and date	NS-1042, 11 November 2026
Service and taxable amount	Design work, 500.00
VAT at 20%	100.00
Total due	600.00

The table shows the basic math: 500 multiplied by 20% gives 100 VAT. The total is 600. A real receipt should show the currency and any other fields required by local rules. If a sale has more than one tax rate, list each rate and amount on its own line.

Choose a template that lets you change the customer, date, invoice number, and line items without changing formulas. Store a clean master copy. Give each issued receipt a unique number, then save a fixed copy of the final record. This reduces accidental edits after sending.

Non-VAT receipts and special cases

A non-VAT receipt is a record for a sale where VAT is not charged. This can apply when a seller is not VAT-registered, or when a specific sale is exempt or outside the scope of VAT. Those cases are not the same. The receipt should not show VAT as if it had been charged.

Where local rules allow, state that no VAT was charged and give the relevant reason. An unregistered seller should not present the document as a VAT invoice or claim a VAT amount. A buyer usually cannot deduct input VAT from a sale where no VAT was charged. Keep a clear record of the sale and the basis used.

A reverse charge sale is different from an ordinary non-VAT sale. The seller may leave VAT off the bill, while the buyer reports the tax under the local rules. The receipt must carry the required reverse charge wording and, where needed, the buyer’s VAT number. Check cross-border rules before billing.

Issue timing also varies by country and transaction. Some rules set a deadline based on the supply date, while others allow different timing for certain sales. Set a clear billing deadline in your workflow, then confirm the legal limit with your tax authority. Late invoices can affect records and claims.

Create a VAT receipt in Excel

A VAT Excel template suits businesses with repeat sales and simple billing needs. Use one sheet for the receipt and a separate protected area for rates and business details. Keep the layout plain, so staff can spot missing fields. Avoid hard-coding a tax rate into every line.

1. Add the required fields. Include seller and customer details, date, invoice number, supply details, taxable amount, VAT rate, VAT amount, and total.
2. Set up the line table. Use columns for description, quantity, unit price, tax rate, and line total.
3. Add formulas. Multiply quantity by unit price for each taxable amount. Multiply that amount by the VAT rate to calculate tax.
4. Sum the receipt. Add line amounts and VAT amounts separately, then show the full amount due.
5. Test before use. Try a zero-rated or non-VAT case, plus a sale with more than one rate.
6. Save a fixed copy. Export or save each issued receipt so later edits do not change the record.

For example, if the taxable amount is 500 and the rate is 20%, the VAT formula returns 100. A spreadsheet might use a formula like =500*20% for a simple test. In a working template, link the formula to the amount and rate cells instead. That makes the file easier to reuse.

Lock formula cells and leave input cells open for staff. Add a check that flags a blank invoice number or customer name. Do not let the sheet guess whether a sale is exempt or subject to reverse charge. A person should choose the right tax treatment before the receipt is sent.

Common questions about VAT receipts

Is a VAT receipt needed to claim input VAT? Often, yes. A valid VAT invoice or receipt is commonly needed to support a claim, but local rules decide what counts and which purchases qualify. Keep the document and proof of payment.

How soon must a VAT receipt be issued? The deadline depends on the country and sale type. Some tax systems set a specific period after the supply. Check the local rule and set your billing process to meet it.

What wording belongs on a reverse charge receipt? Use the wording required by the local tax authority. It should make clear that the buyer accounts for VAT, but the exact phrase can vary. A generic note may not meet the rule.

Can an unregistered seller issue a VAT receipt? An unregistered seller can give a normal receipt where local rules allow. They must not show VAT as charged or call it a VAT invoice if that would mislead the buyer. State clearly that no VAT was charged.

Can I use an Excel VAT receipt template? Yes, if it includes the fields required for your sales and calculates tax correctly. Test the formulas, keep invoice numbers unique, and save an unchanged copy of each issued receipt.