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 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.
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
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.
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.