Icon

Streamlining Member Timesheets: A Guide to Efficient Time Tracking

Learn how to efficiently manage and update member timesheets with this comprehensive guide. Discover tips for syncing with office systems, ensuring transparency, and preparing for future reservations.

By Tim Moody

In this guide, we'll learn how to manage member timesheets using Google Drive and QuickBooks. The objective is to ensure accurate tracking of member reservations and enhance transparency between members and the office. We'll explore how to input reservation data into individual spreadsheets, color-code entries for clarity, and share these sheets with members securely. This process aims to streamline operations and provide members with a clear view of their reservations.

Let's get started

In Chrome, I created a bookmark for Google Drive and placed it on the far left of the bookmark bar. So let's go to the drive.

1
Click on "Drive"
Step #1: Click on "Drive"

Clicking on that will take you directly to the starred area.

2
Click here
Step #2: Click here

The first one is member time tracking. The other three—office forms, tours, and weddings—are synced with the office computer. Their location is listed as "my computer."

3
Click here
Step #3: Click here

Any changes you make here will sync with the computer and vice versa. If you access the file explorer and go into office forms, any actions you take will directly affect what's in office forms on the drive.

4
Click here
Step #4: Click here
5
Click on "Office Forms"
Step #5: Click on "Office Forms"
6
(same as here - synced)
Step #6: (same as here - synced)

Finally getting to the point, member time tracking is available now. You can find it in the drive, specifically in "My Drive" (but obviously, I "starred" it, so it's very quick to access)

7
Click here
Step #7: Click here
8
....I should probably click download right now.
Step #8: ....I should probably click download right now.

Just to ensure there's a backup, this will prepare a download for me. I'm glad I'm doing this because we really need a backup. I've spent a lot of time on this. Anyway now you can open up the time tracking folder.

9
Double-click on "Member Time Tracking ★"
Step #9: Double-click on "Member Time Tracking ★"

If you enter here, you'll find a spreadsheet for each member.

10
There's a master list at the top. This is antiquated, and can be ignored.
Step #10: There's a master list at the top. This is antiquated, and can be ignored.

Each member has their own, listed under their last name.

11
Click here
Step #11: Click here

For example, if I go into QuickBooks and pull up Axelrod's account, I can see she has a reservation in 2025.

12
Click here
Step #12: Click here
13
Click on "Customers"
Step #13: Click on "Customers"
14
Type "axelrod + Tab + Enter"
15
Behold! Janice. She only has one reservation in 2025.
Step #15: Behold! Janice. She only has one reservation in 2025.

Back in chrome, double-click on her spreadsheet to open it in a new tab.

16
Double-click here
Step #16: Double-click here

Most of these have four individual sheets, which you can see at the bottom. You'll find the current year and the following year.

17
Click on "2025 Reservations ▼"
Step #17: Click on "2025 Reservations ▼"
18
These other two are informational. Based on feedback from MJ, which was very helpful, I will be removing the WPC seasons sheet altogether, merging it with the rest.
Step #18: These other two are informational. Based on feedback from MJ, which was very helpful, I will be removing the WPC seasons sheet altogether, merging it with the rest.

I might show you that at the end. For now, let's focus on what's important. The main task is to add member reservations that already exist onto these spreadsheets (for 2025 mostly, if not entirely - I don't think there are any 2026 reservations yet...WAIT, there are, but only one or two, like Weinraub). Overall, this project isn't major and it's a low priority, yet I'm excited about it. After talking with MJ today and seeing its importance to her, I'm even more enthusiastic.

19
So, you're mostly familiar with these already because I actually copy/pasted the ones from Excel that we've printed and used in the green binder for years. Then I just added a little to them. The idea, though, is unchanged.
Step #19: So, you're mostly familiar with these already because I actually copy/pasted the ones from Excel that we've printed and used in the green binder for years. Then I just added a little to them. The idea, though, is unchanged.

This is essentially what we've been doing in the green book. However, I've arranged it so each member has their own copy.

20
In the long run we'll click the share button and set access to anyone with the link.
Step #20: In the long run we'll click the share button and set access to anyone with the link.
21
This one was already set correctly it seems 🤔
Step #21: This one was already set correctly it seems 🤔

22
Then we can click here to copy the link and send it to the member.
Step #22: Then we can click here to copy the link and send it to the member.

This allows the member to view their own time without seeing other members' time.

This is about transparency, and I believe it really touched MJ. It impressed upon me that this is meaningful, as members have never experienced this level of transparency with the office. I think it's beneficial for both the members and us. I'm excited to share it. If you could address a few members' reservations, it would be very helpful.

Once these are ready, I plan to send an email to the members to inform them about it. I'll show you this quickly.

23
Click on "Tim Moody"
Step #23: Click on "Tim Moody"

I will include the "Streamline Your Reservations" tutorial in the email.

24
Click here
Step #24: Click here

I'm sending that to the members. It's going over this as well, but it's directed at the members. I'll likely revise it now that I've decided to remove the one sheet. But I digress...

25
Click on "Axelrod - Google Sheets"
Step #25: Click on "Axelrod - Google Sheets"

Anyways, if you do anything, all I'd ask is that you go to QuickBooks, find the member, and check their reservations. Then just put them in the timesheets.

26
Click here
Step #26: Click here
27
You usually don't need to pull up the invoice. You can just view it on their account screen and check the notation. I can see she's in Longfellow.
Step #27: You usually don't need to pull up the invoice. You can just view it on their account screen and check the notation. I can see she's in Longfellow.
28
However, it's better to pull it up to copy the notation and paste it into the spreadsheet.
Step #28:  However, it's better to pull it up to copy the notation and paste it into the spreadsheet.

I'm copying the notation and then heading back into the spreadsheet.

Then I'm gonna paste it in here...now, I haven't decided yet if this is the final PLACEMENT for the notation, I might change it later. I'm not sure where it looks best. For now, I've been going to the N column though.

29
Click here
Step #29: Click here

There is a small separation that way, and then I'll paste in the notation.

Press the X button at the top right to do that.

30
That's good, just like that.
Step #30: That's good, just like that.

I have also extended that column to make it look like this.

31
Drag "||"
Step #31: Drag "||"
32
Click on "6/28/2025 - 7/5/2025"
Step #32: Click on "6/28/2025 - 7/5/2025"

I would color code that. Let's pick a color and make it red.

33
Click here
Step #33: Click here
34
Click here
Step #34: Click here

Now, I go to the week I plan to use from her share. In this case, I'm using the summer dates.

35
Click here
Step #35: Click here

You can do it in a couple of ways.

You can simply type.

For example, if you type 6/28/25, you can then click into the next field.

36
Type "6/28/25"
37
Click here
Step #37: Click here

Now, I want you to look at that pure wizardry.

38
Click on "6/28/2025"
Step #38: Click on "6/28/2025"

It automatically formatted it as 2025, even though I just typed 25. 🧙‍♂️

39
Click here
Step #39: Click here

Usually I just type 6/29/25, then press the Tab key on the keyboard, located just above Caps Lock, to skip to the next field.

40
Type "6/29/25"

Type 6/30/25, then press Tab to proceed, etc.

Alternatively, you can double-click on the field itself.

41
Double-click here
Step #41: Double-click here

This will bring up a small calendar since these are formatted as a date field.

42
Click on "March 2025"
Step #42: Click on "March 2025"

You can go through the months in this way.

43
Double-click on ">"
Step #43: Double-click on ">"
44
Click on ">"
Step #44: Click on ">"
45
Click on "1"
Step #45: Click on "1"
46
Double-click here
Step #46: Double-click here

Oh! I didn't realize that! 👀

47
Click on "2"
Step #47: Click on "2"

It remembered the month - oh, this is better. 🧙‍♂️

48
Double-click here
Step #48: Double-click here
49
Click on "3"
Step #49: Click on "3"
50
Double-click here
Step #50: Double-click here

Oh, I actually really like that. (I was geeking out about this simple wizardry)

51
Click on "4"
Step #51: Click on "4"

That's amazing. It remembers that I was in July and makes it really fast. (I got excited and started shouting into the microphone)

At this point, if you click on night one (in our example 6/28/25), hold the shift key on your keyboard and then press night seven...you can change the text color of all 7 nights.

52
Click on "6/28/2025"
Step #52: Click on "6/28/2025"

53
Click on "7/4/2025"
Step #53: Click on "7/4/2025"
54
Click on "A"
Step #54: Click on "A"

I will choose red.

55
Click here
Step #55: Click here
56
Now, I click off it, and you can clearly see that the dates in the summer field are all red.
Step #56: Now, I click off it, and you can clearly see that the dates in the summer field are all red.
57
This corresponds to the reservation over here, which is also red.
Step #57: This corresponds to the reservation over here, which is also red.

All right. If I had another reservation to add here, I would make it blue, green, or purple.

58
Click here
Step #58: Click here
59
I would then post the notation for that reservation here and color code it accordingly.
Step #59: I would then post the notation for that reservation here and color code it accordingly.

That's it. This makes it easy to see what they've reserved. We log the exact nights she is staying because if she has seven nights allotted for the summer, we need to know each specific night. This allows us to review later and ensure they are correctly allocated.

60
This calculates automatically BTW.
Step #60: This calculates automatically BTW.

Anything populated to the left will count as one. If all seven nights are used, it will show seven nights used and zero nights remaining here.

61
Click here
Step #61: Click here

This is what it's doing.

62
... I'm not sure why it bolds the first night.
Step #62: ... I'm not sure why it bolds the first night.

I'm not sure if it's been doing that on all of them.

63
I'll unbold it, 🤔
Step #63: I'll unbold it, 🤔

So - it's not a big process, except for some members who have many bookings. I literally just finished this one because she didn't have any other reservations. That was all I had to do for hers.

If I check her account from 2025 onwards, it only shows Longfellow in the summer, and there's nothing for 2026 yet.

64
Click here
Step #64: Click here

65
I won't do anything in 2026's sheet as a result.
Step #65: I won't do anything in 2026's sheet as a result.

You can see it's blank. The other sheets are just informational, and I don't do anything with them. At this point, if I were doing more, I can simply close out, go to Bailey (next member down the list), and pull up Barb Bailey in QuickBooks to check her bookings.

66
Click here
Step #66: Click here
67
Double-click here
Step #67: Double-click here
68
Click here
Step #68: Click here
69
Click on "×"
Step #69: Click on "×"
70
Click here
Step #70: Click here
71
Type "bailey + Tab + Enter" 🧙‍♂️
72
Nada! Upon reviewing her account, there are no reservation-based invoices for 2025. There is, however, a special assessment.
Step #72: Nada! Upon reviewing her account, there are no reservation-based invoices for 2025. There is, however, a special assessment.

There's also the capital contribution, but there's no reservation activity at all. So, at that point, what are you going to do? You're going to close her spreadsheet. Done! 😎

73
Click here
Step #73: Click here
74
Click on "x"
Step #74: Click on "x"

You're done, so that's good. As you can imagine, Fred Beltz will be a bigger one, right?

75
Double-click here
Step #75: Double-click here
76
Lots of shares!
Step #76: Lots of shares!
77
I placed this over here and put these two knights (LOL @ glitter AI) here, but I assure you he has more.
Step #77: I placed this over here and put these two knights (LOL @ glitter AI) here, but I assure you he has more.

He's gotta have much more time than that...

78
Type "beltz + Tab + Enter"
79
Click on "07/26/2025 - 08/09/2025 & Presidents , Longfellow + Osgood"
Step #79: Click on "07/26/2025 - 08/09/2025 & Presidents , Longfellow + Osgood"

... look at that cat.

80
...
Step #80: ...