Montly income and costs

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

Leave a Reply

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