Invoice

Create invoices in Excel

If you do not have an accounting program that makes invoices. You can do this in Word or Excel. In Word you need a calculator to do the calculations or you do them in Excel and then move them to your Word document. I therefore created a billing system in Excel that is easy to use. You can download (Dutch version) and use the Excel invoice system. Below is the explanation.

Enter invoice data

Invoices

On the tab 2020 Invoice you can see the invoice numbers in Column A. These are in order as the tax authorities require. If you need more than 30 invoices, you can extend the list downwards and copy and make new tabs for invoice 31 and further.

In Column B you enter the client, in column C the person to whom the invoice is to go, In column D the address of the company, In column E the postcode and Column F the place of residence of the company. In column G comes the date of the invoice. Often the date that you create the invoice. In Column H you enter the amount you want to collect excluding VAT. In Column I you give a description of your service.

VAT

Total

In column J and K you do not have to do anything in it when calculating H the amounts are calculated. The formula with which this is done can be seen in the figures above.

In column L you can keep track of whether the invoice has been paid and in Column M you have to think about when you for example send a reminder or a term that is different than the 2 weeks on the invoice.

Each line is a different invoice. You can see the details you enter on the tab with the same invoice number.

The invoice itself

Invoice

Each invoice has its own tab, in which the details entered on the Invoices tab are automatically entered.

On the Invoice tab 202001 You still need to replace Right above Address, Postcode and city with your own address. This also applies to A22 in which you have to enter your bank account number, company name and city. And also A30- A38 fill in your own details. Once entered on the Invoice 202001 tab it is automatically adjusted in the other tabs.

Send invoice

Save invoice

You can not send the Excel to your client. You want to send a PDF this can be done after you have entered everything in for example tab Invoice 202001 and then choose files for copy save. In leaf that opens, choose the folder in which you want to save it. You give the invoice a name. The most convenient is the invoice number, client name and assignment name. When saving as choose PDF. Then click on save and then you have an invoice in pdf that you can send to your client.

If you have any questions or want to expand the invoice system, please feel free to contact me. Other Excel templates can be found on the Templates page. Read also more about Excel in my other Excel blogs. Improve your Excel with my Excel courses.

Blog Life

Varied vegetarian food

I have been eating less meat for a long time, but didn't no how to vary with vegetarian food.  I've...
Read More
Varied vegetarian food
Blog entrepreneur Hiking Investing Life

2nd quarter and charity 3rd quarter turnover

Business is starting to pick up again in terms of work. The second quarter turnover was better than the first,...
Read More
2nd quarter and charity 3rd quarter turnover
Blog

hip, Instagram cooking class

I had the taste of taking Instagram courses after the travel writing course and finance course. So when the opportunity...
Read More
hip, Instagram cooking class
Blog Curacao Reading

5 Less known slavery stories

There are a lot of books and movies out there about slavery and even some blockbusters, but today I want...
Read More
5 Less known slavery stories
Blog Investing Life

7 lessons I learned from the finance course on Instagram

Because I would like to reach FIRE (Financial independent and Retire early) in a few years and want to get...
Read More
7 lessons I learned from the finance course on Instagram
Blog Investing Life

7 Tips to save on groceries

Groceries always come out more expensive than you had in mind and then you also forget some ingredients and you...
Read More
7 Tips to save on groceries
Blog entrepreneur Hiking Life Travel

My after Corona Bucket List

I would like to share with you my bucket list for after Corona era. Actually, it is more of a...
Read More
My after Corona Bucket List
Blog Investing Life

I don’t want to know about my student debt

Last week I took part in the student debt challenge of Maaike van fuck that student debt (fuck die studieschuld)....
Read More
3 Replies
I don’t want to know about my student debt
Blog Life

Chocolate fair

For the second time I couldn't stop myself from going to the Chocolate fair in Amsterdam in February. It is...
Read More
Chocolate fair
Blog Hiking

Not one but two walking related conferences just before spring starts

This year I went to the Mountain climbing conference in Nieuwegein as well as the Walking & Cycling Fair in...
Read More
Not one but two walking related conferences just before spring starts
Blog Hiking Travel

Hiking between Cascais and Sintra

Cascais is the escape city for Lisbon, Portugal if you want to be by the sea. I traveled twice to...
Read More
Hiking between Cascais and Sintra
Blog Life

No I am not ….

No, I am not eating more Unfortunately, was it that easy. That I started eating more and by eating less...
Read More
No I am not ….
Blog Life

No reason Retroprints

Would you like to try out our retroprints in exchange for a blog on your website? Actually yes, I wanted...
Read More
No reason Retroprints
Blog Curacao Hiking

Caracasbaai peninsula

I would like to take a long walk on Curaçao. In the meantime, there are about three organizations that offer...
Read More
Caracasbaai peninsula
Blog Life

1 percent turnover to Wegloophuis Utrecht

1 percent turnover to charity This year 1 percent of my turnover goes to charity. A different charity each quarter....
Read More
1 percent turnover to Wegloophuis Utrecht
Blog Curacao entrepreneur

1st quarter 2020

1st quarter 2020 The first quarter of 2020 started with me as a digital nomad working on Curaçao. That means...
Read More
1st quarter 2020
Blog Hiking Travel

7 things I would like to do in Spain

I have been to Spain before and every time I discover new things that I would like to do. That's...
Read More
2 Replies
7 things I would like to do in Spain
Blog Hiking Life

The 5 types of hikers

In my opinion there are 5 types of hikers among the hikers. I would like to share with you those...
Read More
The 5 types of hikers
Blog Life Travel

5 reasons to live in southern Spain in winter

My dream is to escape the winter. I did that all winter in 2013/2014 by going to Australia and New...
Read More
5 reasons to live in southern Spain in winter
Blog Hiking Travel

7 reasons to walk a 4 Days hike

  While walking my 2nd Four Days Marche I have thought of 7 reasons why you should walk a 4...
Read More
7 reasons to walk a 4 Days hike
{"slides_column":1,"slides_scroll":1,"dots":"true","arrows":"true","autoplay":"true","autoplay_interval":2000,"speed":300,"lazyload":""}

Sharing is appreciated

Leave a Reply

Your email address will not be published. Required fields are marked *