Urenregistratie In Excel

Index

Working Hours Template  

For the Tax Authorities, I have to keep track of how many hours I spend on my business to meet the hour criterion. It is also useful for me to keep track of how many hours I spend on something. In the beginning, I kept a detailed record of this in Excel. 

The Excel 

The first picture gives an overview of the available tabs. I have created a tab for each week and given it a number. These are the weeks in which I can indicate my hours per week. In the Memo tab I can see calculations with the number of hours worked and in the Annual overview hours tab I can see the number of hours I have spent per project in a year.

The week

On the tabs week 1 to week 52 tabs I fill in the hours I spent on a specific project. The names of the projects appear here automatically, because I filled them in on the tab Annual overview hours. I look up the date and the project then go to the cell were they meet and fill in how many hours I worked on that project that day. The system automatically calculates how many hours I worked that day and week. In column J I can see how many hours I spent on a project in that week.

Recycle The Excel Template

Copy the file to use this Excel another year. Empty the Excel with the filled in hours. And in week 1 on Monday, fill in the date that falls on Monday in the week of January 1. Fore 2021 I fill in on Monday December 28, 2020. When I fill this in, the other data is automatically adjusted and the overview is ready for a new year.

Excel Tab Yearly Overview Hours 

In the Annual overview hours tab I fill in the projects I am working on. I can do this at any time. I don't have to fill in all projects at once. First I note the project name and then the hours in the week tabs, otherwise I do not see the project names in the week tabs. This can be done in column A. I have already listed a number of subjects for indirect hours. Be free to customize this. This can be done in the tab Yearly Overview Hours. Column BC shows the total number of hours I worked on a project in that year. I have hidden the intermediate columns, which show the hours per week. These would only make the overview confusing.

 Memo Tab 

I do not need to fill in anything on the Memo tab. I only read the data here. This way I can see whether I am reaching the 1225 hours of the tax authorities or how many hours I am still missing. I can also see per project how large that share of hours is compared to the total number of hours.

Related blogs on my website

• 5 handy Excel tips  probably already known by people, but nobody applies 

• A simple address book template in Excel 

• Begrotingen Bijhouden & Virtueel Assistent Online Workshop 

• Big Data analysis with Real-Statistics in Excel 

• Big Data eCourse 

• Building an Excel database administration 

• Co-organizer Starters Information Market 

• CultuurAnalyses In Excel

• Data Analyst at Altrecht

• Data-manager Kennisbank Filantropie 

• Datamanager VUMC 

• Dataviz Should Be Beautiful & Accurate 

• Declaratieformulier In Huisstijl 

• Doelgericht Begroten In De Sport 

• E-Quality 

• Ecourse 

• Excel eCourses 

• Financial Admin Business 

• Formule Horizontaal Zoeken in Excel  

• Guiselaine & Excel 

• Guiselaine & Projects 

• Handleiding Totaal Systeem In Excel 

• Helpdesk Student-assistent 

• How Can Small Enterprises Benefit From Big Data? 

• How Laudius asked for a Big Data eCourse and I and another teacher made it 

• I want to do more with formulas than addition in Excel

• Ik woon mooi Ik woon In Nieuw-Engeland, Utrecht 

• Independent Data Analyst For Rotterdam Festivals

• ING Interim 

• Interim CBS 

• Internship Police 

• Internship Staal & Select 

• Interviewing & Coding Interviews For De Nederlandse GezinsRaad 

• Invoice Created With Excel 

• Kantoortuinen 

• Les 4 Excel 

• Lombok, Not The Asian One 

• Manage money better 

• Management tools  

• Math In Excel 

• PowerPoint and Word Courses 

• Projects that didn't make it 

• Research 

• Researcher gemeente Rotterdam

• Resultaten Belevingsonderzoek Onder Reiswijzer Gebruikers In 2011 

• Shortcuts, I don’t thinks so 

• Should face to face learning be compared to online learning

• Starten Met Computeren Course 

• Stogo Onderzoek + Advies 

• The 4 Things I Did In Maarssen 

• The Calculation Symbols to Calculate in Excel

• The courses I did in 2020 to deal with numbers even better 

• Things to do near St. Joris bay 

• Tracking My Health In Excel 

• Using a decision tree to determine where to go 

• What is statistics? 

• Who Made Your WordPress Site? Myself. I Want One Too 

• Workshop Administratie Starten Voor Starters & Coaching Ondernemer 

• Workshop Excel Beginners