Timesheet For Building My Own Home For Tax Purposes

[tttman1]

Hello,

I built a home which is now an income property. I did this all myself and I need to make some time sheets for tax purposes. I would like to keep it as simple as possible. The home was built 6/1/20-7/2/24.
I would like the sheet to have days Sunday - Friday with the dates, how much time worked that day and what kind of task that was done. Tasks could be anything construction related; ie, concrete, framing, drywall, landscaping, painting etc.. I would like it to factor in the rate per hour I would pay myself with totals each month and totals for each year...Wages..

Does something like this exist, or do you know where I could look>

Thanks so much everybody. I haven't needed you all in awhile, but in the past you have streamlined my job so much and the accuracy has been spot on. I haven't had a payroll adjustment in years for my gvt job and you've saved me a lot of time.

Cheer

T

 

[etaf]

you could do something like this and then use a piviot table to summarise by Months and years

I suspect you will want to change the rates over time - so may need lookup to change the rate per hours based on a timescale
could also have a dropdown for the tasks

Not sure if it exists - so created this simple sheet

Timesheet.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	date	day	Task	Time	Rate					Row Labels	Sum of Time
2	1/6/20	Monday		2:24						<06/01/2020
3	1/7/20	Tuesday		2:52						2020	2573.465
4	1/8/20	Wednesday		8:24						2021	7765.842998
5	1/9/20	Thursday		4:48						2022	12908.532
6	1/10/20	Friday		7:48						2023	18133.968
7	1/12/20	Sunday		9:04						2024	2282.470995
8	1/13/20	Monday		10:20						Grand Total	43664.27899
9	1/14/20	Tuesday		11:36
10	1/15/20	Wednesday		12:53
11	1/16/20	Thursday		14:09
12	1/17/20	Friday		15:25
13	1/19/20	Sunday		16:42
14	1/20/20	Monday		17:58
15	1/21/20	Tuesday		19:14
16	1/22/20	Wednesday		20:31
17	1/23/20	Thursday		21:47
18	1/24/20	Friday		23:03
19	1/26/20	Sunday		24:20
20	1/27/20	Monday		25:36
21	1/28/20	Tuesday		26:52
22	1/29/20	Wednesday		28:09
23	1/30/20	Thursday		29:25
24	1/31/20	Friday		30:41
25	2/2/20	Sunday		31:58
26	2/3/20	Monday		33:14
27	2/4/20	Tuesday		34:30
28	2/5/20	Wednesday		35:47
29	2/6/20	Thursday		37:03
30	2/7/20	Friday		38:19
31	2/9/20	Sunday		39:36
32	2/10/20	Monday		40:52
33	2/11/20	Tuesday		42:08
34	2/12/20	Wednesday		43:24
Sheet1

Cell Formulas
Range	Formula
B2:B34	B2	=TEXT(A2,"DDDD")

will be on dropbox for a few days

Timesheet-ETAF.xlsx

Shared with Dropbox

www.dropbox.com

 

[tttman1]

Is there a way to do this so the new sheet populates the dates 2020-24 so I don't have to type each one by one..

 

[etaf]

it has all the dates populated - not sure what you are asking
in column A - from row 2 onwards and NO Saturdays
6th Jan 2020
8th Feb 2024

 

[tttman1]

Ok... I will try it out... Thank you etaf

 

[tttman1]

etaf,
not sure exactly what has happened. There is no Saturday on the sheet and the totals for the month are divisible by 14...So you can see the total for March is 336 when it should be 14 hours.. The grand total is correct, but each monthly total is a multiple of 14.

Thank you

 

[etaf]

you sort of said you did not want a Saturday on the sheet and the time sheet would be

I would like the sheet to have days Sunday - Friday with the dates,

So you can see the total for March is 336 when it should be 14 hours.. The grand total is correct, but each monthly total is a multiple of 14.

No, I dont see what hours you have entered

In my sample i just made up some hours

so not sure where the 336 is

can i see a sample of what you have filled in, via XL2bb or put the spreadsheet on a share

MrExcel has a tool called “XL2BB” that lets you post samples of your data and will allow us to copy/paste your sample data into our Excel spreadsheets, saving a lot of time.

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

You can also test to see if it works ok, in the "Test Here" forum.

Test Here

Use this forum to test your signature, learn bbcode, smilies, XL2BB, etc. Threads in this forum are automatically deleted after no replies for seven (7) days

www.mrexcel.com

OR if you cannot get XL2BB to work, or have restrictions on your PC

then put the sample spreadsheet onto a share

I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.
Please make sure you have a representative data sample and also that the data has been desensitised, remember this site is open to anyone with internet access to see - so any sensitive / personal data should be removed

Make sure you set any share or google to share to everyone

 

[tttman1]

Dang sorry.. I didn't post this photo. Frantically working on taxes

Thanks bro

 

[etaf]

sorry no idea what that image is doing