Week

Track worked hours in Excel

For the tax authorities you have to keep track of how many hours you spend on your company to meet the hours criterion. It is also useful for yourself to keep track of how many hours you spend on something. In the beginning I kept that detailed in Excel. I would like to share this Excel (Dutch version) with you.

The Excel

All tabs

The first picture gives you an overview of the tabs that are available. For every week I have created a tab and given a number. These are the weeks in which you can indicate your hours per week. In the Memo tab you can see calculations with the number of hours worked and in the tab Year overview hours you can see the amount of hours that you have spent per project in a year.

The week

Week

On the tabs week 1 to week 52 you fill in the hours you spent on a certain project. The names of the projects appear here themselves, because you enter them on the tab Year overview hours. You look up the date and project and then arrive at a cell and fill in how many hours you have worked on the project that day.

The system automatically counts on how many hours you have worked that day or week. In column J you can see how many hours you spent on the project in that week.

To use this Excel for another year, copy the file. Empty it with the entered hours. And at week 1 on Monday you enter the date that falls on Monday in the week of 1 January. Fore 2019 this is 31 Dec. If you fill this in, the other data will change automatically and the overview will be ready for another year.

Excel tab Annual overview hours

Year overview hours

In the Annual overview hours tab you enter the projects you are working on. This is possible at any time. You do not have to put all projects down at once. First note down the project and then the hours in the week tabs, otherwise you do not see which project is involved. This is possible in Column A. At indirect hours I have already put some things fore you. Be free to adjust them. This can be done on this tab.

In column BC you see the total number of hours you have worked in the year on a project. I have hidden the intermediate columns, with the hours per week. They would only make the overview unclear.

Memo tab

Memo

You do not have to fill in anything on the Memo tab. You only read data here. So you can see if you meet the 1225 hours of the tax office or how many hours you still miss. You can also see for each project how large that share of hours is compared to the total number of hours.

Have fun with it, please let me know if you have any questions: gmcapella[@]yahoo.com. You can also read other blogs about Excel or use another Excel template. If you want to improve your Excel skills browse my Excel courses and see if there is one for you.

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 *