Download UK VAT Credit Note Excel Template


Popular Categories in Excel Template
Trednding in Excel Template

GST Debit Note Format

GST implement from 1st July 2017. As a register business will now have to issue …

Read More

EBIT Per FTE Calculator

EBIT Per FTE Calculator is ready-to-use excel template to calculate the earnings before investment and …

Read More

Bill Paying

Bill pay is a handy service offered by many banks and credit unions. This service …

Read More

Project Schedule

Our project schedule template is used to create a simple timeline for your project without …

Read More
Generic filters

UK VAT Credit Note is an excel template that helps to issue a VAT compliant credit note when the goods are returned or an invoice is overbilled.

A Credit note is a document that supplier issues to their customer for a reduction in invoice or discount in the price on the original VAT invoice. Goods return or reduction in billing amount reduces tax liability as the goods or services supplied have been reduced by the amount.

We have created a simple UK VAT Credit Note Excel Template with predefine formulas and formatting. Issue a VAT compliant credit note to your customer in a few minutes.

Contents of UK VAT Credit Note Excel Template

This template has 2 sheets: UK VAT Credit Note Template and Customer Database Sheet.

Customer Database Sheet

The customer database sheet consists of customer details as customer id, customer name, customer address, customer phone, Customer VAT number, and customer email address.

The purpose of creating this sheet to save time and simplify your work. You need to update the database sheet once with the customer details as per requirement.

Furthermore, a drop-down is created using the data validation function. When you select the customer name, the customer section fetches all relevant details using VLOOKUP function.

UK VAT Credit Note Template

Credit Note Template consists of 4 sections: Supplier Details, Customer Details, Credit Note Details, and Other Detail.

Supplier Detail

Supplier Details Section consists of the company name, logo, address and VAT number.

Customer Detail

Customer detail section consists of the following details:

Company Name
Street Address
VAT Number
Credit Note Number
Customer ID
Invoice Number

As already discussed, this section is interlink with data validation and the VLOOKUP function to the database sheet. Just select the name of customer and this section is filled automatically.

Credit Note Details

Insert the details of goods return or overbilling. This section consists of columns that are Description, Quantity, Unit Price and Amount. In the end, there is subtotal line.

Quantity X Unit Price = Amount.

Other Detail

Other details section consists following:

Also, Amount in words: It automatically convert the amount in words using Spell Number GBP.

Terms & Conditions: Insert your credit note with terms and conditions.

VAT computation: So, Insert the VAT percentage manually. The VAT amount is calculate on the percentage.

Taxable Amount X VAT % = VAT Amount

VAT Amount + Taxable Amount = Final Invoice Amount

Company seal: Moreover, After printing invoice you can stamp the invoice with a company seal.

Signature: Sign the invoice after printing the invoice by authorize personnel.

Thank You Note: Insert a thank you note of your choice here.

So, your VAT Compliant Credit Note is ready to print. It is helpful to small and medium scale businesses to issue a credit note.

Download UK VAT Credit Note Excel Template

To use this free Excel Template, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets. 

After installing Excel or Spreadsheet, download the xlsx file of this template to use it

Once extracted, you can open the file using Excel and start entering data or customizing the template.

Click The Button Below To Download UK VAT Credit Note Excel Template

Instruction :

All Excel templates and tools are sole property of User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from  Completely Free. All our templates are designed by Professionals

Popular Excel Templates: