Insight into your money

Insight into your money

Who does not want more insight into his or her money? Know what comes in and what costs are fixed costs? With this Excel you can make that very clear. Download here the Excel (Dutch version) and read how you fill it in.

Debts

debt statement

On the debt overview tab you enter which debts you have. Name of the Debtor goes into Column B, Column C becomes the attribute if you have it, Column D Concerns, Column E attribute if you have it, Column F the balance of your debt, Column G the settlement amount, Column H the details and Column I the contact information. At the bottom, the total of your debts and the settlement amount.

Every debt gets its own row. Then you are ready with filling in this tab and we go to the next one.

Income

Income

On the Income tab you fill in your income Column A shows the type of income and in Column B you enter the amount. Supplements such as health care allowance are also part of income and are entered here. There is room to add income that is not mentioned in A9, A19, A28, A29 and A30. In column D you can give the income a characteristic. Do not forget to fill in your income to be able to make a good calculation.

In B34 you get the total income.

Expenditure

expenditure

In the tab Expenditure you indicate your expense per month. It concerns the fixed costs per month, the costs that come back every month. I tried to be as complete as possible with the fixed costs, but if you miss one you can add this on A17, A18, A37, A38 and A39. With attribute you can make comments, this is column D.

In B42 you see the total of your expenses.

Budget

Budget

This tab is partly filled out automatically from the other tabs. Here you see in B4 your total income. In B6 the total of your fixed costs. In B8 you see your total repayments per month. In B10 you can give the living money you need, B12 reservations: You can fill in the money you want to put aside. In B14 you will find how much you have left or are short.

I hope you continue with this to gain more insight into your income and expenses. If you have any questions, you can contact me. For more Excel Templates check the templates page. Read more about Excel in my other Excel blogs. Improve your Excel skills with my Excel lessons.

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

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

Do your administration in Excel

When you start you probably do not have a bookkeeping program or you are a fan of Excel or like to keep track of your bookkeeping yourself. Anyway with this simple template (Dutch version) you can do your accounting in Excel.

Building of your Administration in Excel

Administration-in-Excel

The administration template in Excel consists of a tab for each month of the year and a tab called VAT. On the VAT tab your turnover and VAT per month are calculated, more on this later. And on the tabs of the months you do your actual administration. Let’s start with that

Income and costs

Montly income and costs

We take the tab Jan as an example. In the first orange column, we enter the income and the costs in the 2nd orange column. Every income or expense gets a separate line in this tab.

So the first income comes on line 5. At client A5 you enter the name of the client. At B5 you set the description of the assignment. At C5 the category of type of work. At D5 comes the date that the invoice has been paid. Depending on when you fill this in, it may be that you only fill in the date later. I fill in this schedule as soon as I issue an invoice, but leave the date field empty until the invoice has been paid and then enter that date.At E5 comes the amount that the client owes you exclusive of VAT. At F5 comes the VAT they owe you. In G5, the system automatically counts the total amount they owe you (amount excluding VAT + VAT). This way you enter all your income for January.

On line 9, the system gives you total income excluding both VAT (E9) and VAT (G9). And in F9 the total VAT that you have to pay this month.

You enter the costs in the same way. In A13, the supplier from a product or service. In B13 the description of the service / product. C13 the category of the product or service. You can think of: travel costs, network costs, study costs, operating costs, etc.

In D13 comes the date of purchase product or service. In E13 the amount excluding VAT and in F13 the VAT you paid for the product. In G13, the amount excluding VAT and VAT is added together. This way you enter all your costs for January in this case.

At the end, the total costs for you in line 28 is given. In E28 the amount of costs excluding VAT, F28 the VAT you have to pay and G28 the total amount including VAT.

VAT and Turnover per quarter

VAT and Turnover quarterly

On the VAT tab, everything is automatically calculated when you enter the tabs of the months. In Column B you see the VAT you paid, in column C the VAT received. In column D the difference between received and paid VAT. This is the amount that you have to pay or receive in VAT from the tax authorities.

In Column E you see your gross sales excluding VAT. In column F the quarterly expense Excluding VAT. And in Column G you gross profit before tax per quarter.

If you turn a small turnover with no more than 1345 in VAT to pay, you can use Column I, J and K to get VAT back.

If you have any questions about this administration system or want to expand it, you can contact me. Other Excel templates can be found on the Templates pagina. Read more about Excel in my other Excel blogs. Improve your Excel skilss with my Excel lessons.

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