Icon

Guide to Creating Member Special Assessment Invoices for Members Who Own Shares of One Cabin

Learn how to efficiently manage special assessment and annual capital contribution invoices for shareholders with this concise guide.

By Tim Moody

In this guide, we'll learn how to efficiently handle special assessment invoices for multiple cabin shareholders using QuickBooks. This process involves creating and duplicating invoices for shareholders, ensuring they are correctly categorized under the member annual capital contribution account. We'll focus on using QuickBooks features to streamline the task, such as creating duplicate invoices and verifying entries. This guide aims to provide a concise overview of the steps involved, helping you save time while ensuring accuracy in your financial records.

Let's get started

I recently created a guide on handling special assessment invoices or annual capital contribution invoices for multiple cabin shareholders. These shareholders, such as Tim Quigley, are highlighted in yellow.

1
Click here
Step #1: Click here

I completed all of them first because they are slightly more complicated than the others. The previous guide was more thorough as a result, whereas this one will be concise, showing my personal process which has been refined over the years to be very fast, while remaining accurate.

We are currently handling an emergency special assessment. Today's date is March 12th, and I will use this date for the invoices since the announcement was made today. The spreadsheet I'm using was sent by Steve, and we are proceeding with the $160,000 special assessment.

2
Shown here
Step #2: Shown here

These figures were based on different amounts we might assess. We've decided to assess the full $160,000, so I'll be using these amounts here on the right.

3
Click on "$ 3,472.14"
Step #3: Click on "$ 3,472.14"

These are grouped by cabin. Once I've addressed the multiple cabin shareholders, I like to copy the amount for, say, Mrs. Coolidge's

4
Right-click on "$ 3,472.14"
Step #4: Right-click on "$ 3,472.14"
5
Click on "Copy"
Step #5: Click on "Copy"

I have copied it, and there are four shareholders who do not own other shares.

6
Click here
Step #6: Click here

These four in white are the ones. I'll start with Leslie Feder.

7
Click here
Step #7: Click here
8
Type "feder + Tab + Enter"

I will retrieve the special assessment invoice from 2024.

9
Double-click it to open.
Step #9: Double-click it to open.

If I didn't have one readily available, I would grab the annual capital contribution since they are invoiced similarly. Now, I'm going to create a copy.

10
Click on "Create a Copy"
Step #10: Click on "Create a Copy"

A message will appear saying a duplicate invoice has been created, and I'll click OK.

11
Click on "OK"
Step #11: Click on "OK"

I will know it worked correctly when I check the invoice date, and it matches the current day.

12
Click here
Step #12: Click here

For special assessment invoices, just like the annual capital contribution invoices, we use the accounts receivable called Member annual capital contribution.

This is not a field we usually pay attention to because we typically use the normal AR general accounts. However, for this task, we will use the member annual capital contribution.

13
Click here
Step #13: Click here
14
Click here
Step #14: Click here
15
Next, I will change the notation using a macro key I programmed to type my memo. Without it, I would copy and paste or type "emergency special assessment" directly in the invoice description.
Step #15: Next, I will change the notation using a macro key I programmed to type my memo. Without it, I would copy and paste or type "emergency special assessment" directly in the invoice description.

Include it in the description and the memo in the lower left corner of the invoice

16
Drag "2024 Special Assessment"
Step #16: Drag "2024 Special Assessment"
17
Type "Emergency Special Assessment"
18
For the rate, I copied it earlier, so now I will paste it.
Step #18: For the rate, I copied it earlier, so now I will paste it.

19
Now, I will click save.
Step #19: Now, I will click save.

Here's a neat trick I'm going to show you. Go ahead and create a copy.

20
Click on "Create a Copy"
Step #20: Click on "Create a Copy"

Click "OK" when you see the duplicate invoice notification.

21
Click on "OK"
Step #21: Click on "OK"

Review the spreadsheet Steve sent you.

22
Click here
Step #22: Click here

23
The next person on the list for Mrs. Coolidge's is Keith and Nancy Johnson.
Step #23: The next person on the list for Mrs. Coolidge's is Keith and Nancy Johnson.

24
They are equal in number the amount of money, so no need to re-copy the amount.
Step #24: They are equal in number the amount of money, so no need to re-copy the amount.

In QuickBooks, go to the field at the top left. Delete the customer name and start typing until you find a match.

25
Click on "Leonard -member"
Step #25: Click on "Leonard -member"
26
Type "johnson, k"

27
This is amusing because he's listed as K Johnson, but the "-member" is the clear giveaway you've got the right person.
Step #27: This is amusing because he's listed as K Johnson, but the "-member" is the clear giveaway you've got the right person.
28
Click Save
Step #28: Click Save

Then, I'll create a copy and click OK.

29
Click on "Create a Copy"
Step #29: Click on "Create a Copy"
30
Click on "OK"
Step #30: Click on "OK"
31
Type "Alt + Tab"

I see that the next one is Jennifer Wainwroth. (I'm sorry - it's spelled Weinraub but that is so funny I'm leaving it. What a typo! AI voice transcription at its finest)

32
Click on "Jennifer Weinraub & David Evelyn"
Step #32: Click on "Jennifer Weinraub & David Evelyn"
33
Type "Alt + Tab"

As long as you're careful and choose the correct accounts, this can save a lot of time.

34
Type "weinra"
35
Click here
Step #35: Click here
36
Click "Save" again.
Step #36: Click "Save" again.
37
Click on "Create a Copy"
Step #37: Click on "Create a Copy"
38
Click on "OK"
Step #38: Click on "OK"

The final one is Barbara Bailey.

39
Type "bailey"
40
Click here
Step #40: Click here
41
Click on "Save & Close"
Step #41: Click on "Save & Close"

Save and close. That was a whirlwind of speed. We will double-check to ensure we did it correctly.

42
We're back at Leslie Feder's account because that's where we initially started.
Step #42: We're back at Leslie Feder's account because that's where we initially started.

We will check to ensure the invoice was created.

43
Yep! We see it here on today's date. It is affecting the accounts receivable member annual capital contribution account and has the notation "emergency special assessment."
Step #43: Yep! We see it here on today's date. It is affecting the accounts receivable member annual capital contribution account and has the notation "emergency special assessment."

44
We can confirm it is for the correct amount of money.
Step #44: We can confirm it is for the correct amount of money.

Let's look up Keith Johnson's account.

45
Click here
Step #45: Click here
46
Type "johnson, k + Tab + Enter"

We see the same thing here.

47
Here's the invoice!
Step #47: Here's the invoice!

Go through and double-check each account. It's a massive time saver because if the amounts and notations are the same, you can save the same invoice to multiple accounts, more or less, very quickly this way.

Next, go down to the next cabin. This is where the rate will change (not between EVERY cabin, but some).

48
Click on "$2,721.41"
Step #48: Click on "$2,721.41"

I'm going to copy the amount of money right here.

49
Right-click on "$ 2,721.41"
Step #49: Right-click on "$ 2,721.41"
50
Click on "Copy"
Step #50: Click on "Copy"
51
Step #51:
52
Step #52:
53
All of the non-yellow shareholders for Presidents owe "$2,721.41"
Step #53: All of the non-yellow shareholders for Presidents owe "$2,721.41"

We will open Eric Leach's account.

54
Type "leach + Tab + Enter"
55
Pull up the related invoice to duplicate.
Step #55: Pull up the related invoice to duplicate.
56
Click on "Create a Copy"
Step #56: Click on "Create a Copy"
57
I'm using my macro key to insert the notation where needed.
Step #57: I'm using my macro key to insert the notation where needed.
58
Type "Emergency Special Assessment"
59
Click here
Step #59: Click here
60
Type "Emergency Special Assessment"
61
Then, I'll go to the rate, paste in the new amount, and save it.
Step #61: Then, I'll go to the rate, paste in the new amount, and save it.
62
Type "Ctrl + V"
63
Click on "Save"
Step #63: Click on "Save"
64
Click on "."
Step #64: Click on "."

65
I am doing a final check to ensure the correct amount is applied,
Step #65: I am doing a final check to ensure the correct amount is applied,
66
then creating a copy.
Step #66: then creating a copy.
67
The next person on the list for the cabin I'm working on is John Kuriawa.
Step #67: The next person on the list for the cabin I'm working on is John Kuriawa.

68
Type "kuriawa"
69
Click here
Step #69: Click here

I'll save a copy to his account, and then create another copy (and so on, and so on, and so on).

70
Click here
Step #70: Click here
71
Click on "Create a Copy"
Step #71: Click on "Create a Copy"
72
Click on "OK"
Step #72: Click on "OK"
73
Type "Alt + Tab"

The next one is Bradley Steck.

74
Type "Alt + Tab"
75
Type "bradley-"
76
Click here
Step #76: Click here
77
Click on "Save"
Step #77: Click on "Save"

Save it.

78
Click on "Create a Copy"
Step #78: Click on "Create a Copy"
79
Click on "OK"
Step #79: Click on "OK"
80
Type "sanson"
81
Click on "Sanson / Wright -member"
Step #81: Click on "Sanson / Wright -member"
82
Click on "Save"
Step #82: Click on "Save"
83
Click on "Create a Copy"
Step #83: Click on "Create a Copy"
84
Click on "OK"
Step #84: Click on "OK"
85
Type "kalbfus"
86
Click on "Kalbfus / Hamilton -member"
Step #86: Click on "Kalbfus / Hamilton -member"
87
Click on "Save"
Step #87: Click on "Save"
88
Click on "Create a Copy"
Step #88: Click on "Create a Copy"
89
Click on "OK"
Step #89: Click on "OK"

90
Type "schmitt"
91
Click on here
Step #91: Click on here
92
Click on "Save"
Step #92: Click on "Save"
93
Click on "Create a Copy"
Step #93: Click on "Create a Copy"
94
Click on "OK"
Step #94: Click on "OK"

95
Type "isaac"
96
Click here
Step #96: Click here
97
Click on "Save & Close"
Step #97: Click on "Save & Close"

Fast as hell! :)

98
Click on "Account"
Step #98: Click on "Account"
99
Double-click
Step #99: Double-click

These are sorted by date, so you'll see the ones you've just completed all in a row here.

100
Click here
Step #100: Click here

You will see them dated March 12th, the name on the account, the memo,

101
Click here
Step #101: Click here

and the amount will be on the far right of the screen.

102
Over here
Step #102: Over here

Ensure every person is accounted for, and check your totals at the very end. Don't go fast if it's causing you to make errors - accuracy is EXTREMELY important. This is my workflow, but I've done these for years. I also double and triple check everything at the end. Please do the same :)

If anyone has questions, feel free to ask. This process is straightforward. The key tip is to ensure they are using the correct A/R account, as we often overlook accounts receivables. Typically, 99% of our work defaults correctly to the same account. However, special assessments or capital contributions must differ.

103
...the below image is in no way, shape, or form relevant to this guide. It does not belong here, yet, here it is. 🤔
Step #103: ...the below image is in no way, shape, or form relevant to this guide. It does not belong here, yet, here it is. 🤔