Look no further for a free, ready to use Excel invoice template. It’s designed for small, limited companies in the UK. We’ve also included some instructions for the template in this post, and tips for tackling late payment.
You can find other free invoice templates for sole traders and freelancers, in either Word or Excel format, as well as a stack of other free tools over on our blog.
Better than a Template, Invoice with Zervant!
Even easier, though, is our free invoice software. You can use it to create and send an unlimited amount of invoices, completely for free. All you need is an email address. Sounds good? Sign up to get started!
Hopefully it makes things a little easier. And if you’re interested in managing your company finances with nothing more than a few clicks why take a look at Zervant’s online invoicing software?
Our template was made using Excel. It automatically calculates VAT and total amounts due. The download has two tabs: one that is blank and ready for you to use, and another one filled in with sample details (just to show what information needs to go where). If you’d prefer a Word version please click here!
Invoice Template Instructions
There are certain key pieces of information that you need to put in every invoice:
- Your company contact information: This goes in the top left corner of the invoice template.
- Client contact information: Add the client’s contact information (we’ve put this in the top left hand corner, underneath your own details).
- Invoice Date: The date you issued or printed the invoice (the default in the example template is today’s date)
- Invoice Number: A unique number that identifies the invoice, usually a sequential, serial number. During the same financial year you should never create two invoices with the same invoice number.
- Client Reference: Enter a unique customer identification number.
- Payment Terms: Enter payment terms for the invoice. The default in our example template is 30 days.
- Due date: The date the invoice should be paid by is automatically calculated, based on the payment terms you enter.
- Late payment interest: The interest rate to be charged if the invoice is late.
- Additional information: If needed, add a brief description about what the invoice includes and any additional terms you may have agreed with the customer.
- Payment details (bottom of the invoice template): Enter the Bank Name, Sort Code and Account Number to be used when the invoice is paid.
- Invoice items: Include any services or products sold, as well as the quantity, unit used, and price. The invoice template will then calculate the total amounts due.
Once you’ve filled everything in, save the document and send it to your client. Make sure you save each invoice with a unique name and reference. This will make it much easier to find them when needed.
If you want more information on how to fill in your invoice template, check out our blog post on invoicing best practice.
What’s even easier than a free invoice template?
Zervant, of course! Create an account and you’ll get free, unlimited invoicing. No catches, fees or hidden costs.