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 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 to fill 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 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. We have tried to be as complete as possible with the fixed costs, but if you miss a 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.

Blog Hiking Travel

7 dingen die ik nog zou willen doen in Spanje

Ik ben al vaker in Spanje geweest en iedere keer ontdek ik nieuwe dingen die ik graag zou willen doen....
Read More
7 dingen die ik nog zou willen doen in Spanje
Blog Hiking Life

De 5 type wandelaars

Er zijn naar mijn mening 5 type wandelaars onder de wandelaars. Ik deel graag met je die 5 type wandelaars...
Read More
De 5 type wandelaars
Blog Travel

5 redenen om in Zuid Spanje te gaan wonen in de winter

Mijn droom is om de winter te ontsnappen. Ik deed dat een hele winter in 2013/2014 door naar Australiƫ en...
Read More
5 redenen om in Zuid Spanje te gaan wonen in de winter
Blog Hiking Travel

7 redenen om een 4Daagse te lopen

Onder het lopen van mijn 2e Vierdaagse ooit heb ik 7 redenen bedacht waarom je ooit in je leven een...
Read More
7 redenen om een 4Daagse te lopen
Blog Hiking Life Netherlands

Afscheid van Strijp-S in Stijl

Hoe neem je in stijl afscheid van Strijp-S? Ik heb 2,5 jaar in Strijp-s, Eindhoven gewoond en de marathonlopers en...
Read More
Afscheid van Strijp-S in Stijl
Blog entrepreneur Investing Life

De 5 lessen die ik leerde uit het boek Blondjes beleggen beter

Ik deel 5 lessen die ik leerde uit het boek Blondjes beleggen beter met je. Nou ben ik verre van...
Read More
De 5 lessen die ik leerde uit het boek Blondjes beleggen beter
Blog Life

1 procent bruto omzet naar de Voedselbank

1 procent omzet naar de Voedselbank Dit jaar wil ik 1 procent van mijn omzet schenken aan goede doelen gekozen...
Read More
1 procent bruto omzet naar de Voedselbank
Blog entrepreneur Life

Databeet verhaal

Databeet verhaal Het Databeet verhaal begint op 13 augustus 2012, op de dag van de linkshandigen. Ik ben zelf linkshandig...
Read More
Databeet verhaal
Blog Hiking Life Travel

Ubud, Hiking through the rice fields

Ubud, hike through the rice fields Back in 2014 I was fierless and went on a Hike through the rice...
Read More
Ubud, Hiking through the rice fields
Blog entrepreneur Life Reading Travel

Reisverhalen inspiratie

Inspiratie Ik volg een Reisverhalencursus op Instagram. Daar werd gevraagd wie inspireren jou met hun schrijven over reizen. Ik moest...
Read More
5 Replies
Reisverhalen inspiratie
Blog Life Travel

Zenuwen voor mijn reis

Zenuwen voor mijn reis In februari 2013 stap ik in de vliegtuig voor een soloreis door Cuba van drie weken....
Read More
Zenuwen voor mijn reis
Blog Curacao Life Travel

Even terug

Even terug Het is eind 2017 ik zet na bijna 7 jaar weer voet aan de grond op mijn geboorte-eiland...
Read More
Even terug
Blog entrepreneur Excel

A simple Address book template in Excel

Address book template With this template you can save all your adresses and phonenumbers of the people you know. There...
Read More
A simple Address book template in Excel
Blog Excel

Calculate in Excel

Do you know how to calculate in Excel? In this blog I explain how to calculate in Excel using symbols...
Read More
Calculate in Excel
Blog entrepreneur Excel Life Research

Dealing better with money

Since I work for myself I earn less, but it seems like I can do more. Not only do I...
Read More
Dealing better with money
Blog entrepreneur Life

Leaving 2019 behind and starting 2020

2019 was over before I could blink. I hope 2020 last longer. WHat happend in 2019? And what am I...
Read More
Leaving 2019 behind and starting 2020
Blog WordPress

Add media to your website

Add media to your website By media we mean image, photo, video and pdf in this case. These things can...
Read More
Add media to your website
Blog WordPress

Publish a blog in WordPress

Blog Blog, blog post, post: These are all terms we use when we talk about blogging. But what do we...
Read More
Publish a blog in WordPress
Blog WordPress

Events on your website

  For the websites I build in WordPress, I use the All-in-One Event Calendar by Time.ly plugin to put an...
Read More
Events on your website
Blog WordPress

The best plugins for 2020

If you build a website in WordPress you need plugins to support that website. Plugins are small parts of a...
Read More
The best plugins for 2020
{"slides_column":1,"slides_scroll":1,"dots":"true","arrows":"true","autoplay":"true","autoplay_interval":2000,"speed":300}

 

Please share on social

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 in which 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 you owe (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 comes 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. In E28 the amount of costs excluding VAT, F28 the VAT you paid 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.

Blog Hiking Travel

7 dingen die ik nog zou willen doen in Spanje

Ik ben al vaker in Spanje geweest en iedere keer ontdek ik nieuwe dingen die ik graag zou willen doen....
Read More
7 dingen die ik nog zou willen doen in Spanje
Blog Hiking Life

De 5 type wandelaars

Er zijn naar mijn mening 5 type wandelaars onder de wandelaars. Ik deel graag met je die 5 type wandelaars...
Read More
De 5 type wandelaars
Blog Travel

5 redenen om in Zuid Spanje te gaan wonen in de winter

Mijn droom is om de winter te ontsnappen. Ik deed dat een hele winter in 2013/2014 door naar Australiƫ en...
Read More
5 redenen om in Zuid Spanje te gaan wonen in de winter
Blog Hiking Travel

7 redenen om een 4Daagse te lopen

Onder het lopen van mijn 2e Vierdaagse ooit heb ik 7 redenen bedacht waarom je ooit in je leven een...
Read More
7 redenen om een 4Daagse te lopen
Blog Hiking Life Netherlands

Afscheid van Strijp-S in Stijl

Hoe neem je in stijl afscheid van Strijp-S? Ik heb 2,5 jaar in Strijp-s, Eindhoven gewoond en de marathonlopers en...
Read More
Afscheid van Strijp-S in Stijl
Blog entrepreneur Investing Life

De 5 lessen die ik leerde uit het boek Blondjes beleggen beter

Ik deel 5 lessen die ik leerde uit het boek Blondjes beleggen beter met je. Nou ben ik verre van...
Read More
De 5 lessen die ik leerde uit het boek Blondjes beleggen beter
Blog Life

1 procent bruto omzet naar de Voedselbank

1 procent omzet naar de Voedselbank Dit jaar wil ik 1 procent van mijn omzet schenken aan goede doelen gekozen...
Read More
1 procent bruto omzet naar de Voedselbank
Blog entrepreneur Life

Databeet verhaal

Databeet verhaal Het Databeet verhaal begint op 13 augustus 2012, op de dag van de linkshandigen. Ik ben zelf linkshandig...
Read More
Databeet verhaal
Blog Hiking Life Travel

Ubud, Hiking through the rice fields

Ubud, hike through the rice fields Back in 2014 I was fierless and went on a Hike through the rice...
Read More
Ubud, Hiking through the rice fields
Blog entrepreneur Life Reading Travel

Reisverhalen inspiratie

Inspiratie Ik volg een Reisverhalencursus op Instagram. Daar werd gevraagd wie inspireren jou met hun schrijven over reizen. Ik moest...
Read More
5 Replies
Reisverhalen inspiratie
Blog Life Travel

Zenuwen voor mijn reis

Zenuwen voor mijn reis In februari 2013 stap ik in de vliegtuig voor een soloreis door Cuba van drie weken....
Read More
Zenuwen voor mijn reis
Blog Curacao Life Travel

Even terug

Even terug Het is eind 2017 ik zet na bijna 7 jaar weer voet aan de grond op mijn geboorte-eiland...
Read More
Even terug
Blog entrepreneur Excel

A simple Address book template in Excel

Address book template With this template you can save all your adresses and phonenumbers of the people you know. There...
Read More
A simple Address book template in Excel
Blog Excel

Calculate in Excel

Do you know how to calculate in Excel? In this blog I explain how to calculate in Excel using symbols...
Read More
Calculate in Excel
Blog entrepreneur Excel Life Research

Dealing better with money

Since I work for myself I earn less, but it seems like I can do more. Not only do I...
Read More
Dealing better with money
Blog entrepreneur Life

Leaving 2019 behind and starting 2020

2019 was over before I could blink. I hope 2020 last longer. WHat happend in 2019? And what am I...
Read More
Leaving 2019 behind and starting 2020
Blog WordPress

Add media to your website

Add media to your website By media we mean image, photo, video and pdf in this case. These things can...
Read More
Add media to your website
Blog WordPress

Publish a blog in WordPress

Blog Blog, blog post, post: These are all terms we use when we talk about blogging. But what do we...
Read More
Publish a blog in WordPress
Blog WordPress

Events on your website

  For the websites I build in WordPress, I use the All-in-One Event Calendar by Time.ly plugin to put an...
Read More
Events on your website
Blog WordPress

The best plugins for 2020

If you build a website in WordPress you need plugins to support that website. Plugins are small parts of a...
Read More
The best plugins for 2020
{"slides_column":1,"slides_scroll":1,"dots":"true","arrows":"true","autoplay":"true","autoplay_interval":2000,"speed":300}

Please share on social