Icon

Guide to Creating Member Special Assessment Invoices for Members Who Own Shares of Multiple Cabins

Learn how to efficiently create and manage member special assessment and annual capital contribution invoices, with tips on handling multiple cabin owners and ensuring accuracy.

By Tim Moody

In this guide, we'll learn how to create invoices for member special assessments and annual capital contributions using QuickBooks. These invoices are similar in process, with the main difference being the accounts receivable account used. Special assessments occur as needed, while annual capital contributions are done once a year. We'll focus on handling multiple cabin owners and ensuring accuracy in account selection, notations, and amounts. This approach aims to minimize errors and streamline the invoicing process.

Let's get started

Here's a quick guide on creating specific types of invoices. Member special assessment invoices and annual capital contribution invoices are generally created and managed in the same way. The annual capital contribution is done once a year, while special assessments are done as needed. In my 12 years here, special assessments have been rare. However, the camp is currently facing challenges, and this is the second one in a few months. I received an email from Steve today, and as mentioned, Sandy called and spoke with me, so I'm fully informed about the situation.

1
Click on "Sandy will be calling you Wed am to explain but attached is the information you will need to develop the Invoices for a 160K Special essment to be sent ASAP . Just ignore the 12 share Willis trust gift to ourselves ."
Step #1: Click on "Sandy will be calling you Wed am to explain but attached is the information you will need to develop the Invoices for a 160K Special essment to be sent ASAP . Just ignore the 12 share Willis trust gift to ourselves ."

I have already downloaded the attachment. I'll display the PDF on the screen now. It shows the payments each member owes.

2
Click here
Step #2: Click here

This is how it will work, even though this is a specific spreadsheet LMPDF form for a special assessment. The amounts of $100K, $120K, $140K, and $160K were chosen after a lengthy discussion by the steering committee to determine the necessary assessment amount.

3
Click here
Step #3: Click here

They chose to use the $160,000 figure.

4
Click on "160K"
Step #4: Click on "160K"

The method Steve used is the same as for every annual capital contribution, so you can apply the same principles. I'll show you how I do these quickly and efficiently, minimizing errors more than any other method I've found. If you see yellow coloring, it indicates a multiple cabin owner.

5
Click here
Step #5: Click here

It means the owner has more than one share. For example, Quigley has a share of Mrs.

6
Click on "Tim Quigley"
Step #6: Click on "Tim Quigley"

Coolidge's name is highlighted in yellow. If you scroll down, you'll find him again with a share of cabin 2.

7
Click here
Step #7: Click here

Scroll down further, and we find him sharing cabin 3.

8
Click here
Step #8: Click here

Additionally, he has a few shares of Kirkwood, as Kirkwood will always be in an undivided pair.

9
Click here
Step #9: Click here

He has five shares. If you look at the bottom, you'll see the total for all the multiple cabin owners.

10
Click here
Step #10: Click here

If there's no yellow color, it means that is the only share the person owns, or in Kirkwood's case, the only pair of shares.

11
Click here
Step #11: Click here
12
Click on "Mackenzie"
Step #12: Click on "Mackenzie"

With that in mind, I like to focus on one task at the start and then move on to the rest. I'll begin with the multiple cabin owners. First, go into QuickBooks and find the account of the person you're starting with. In my case, that's Tim Quigley, and I've already pulled up his account.

13
Click here
Step #13: Click here

Last November, there was a special assessment. Additionally, at the start of each year, around this date, you will have the annual capital contribution.

14
Click on "2025 Annual Capital Contribution 01/09/2025 Adirondack Bank - Checking : capital improvement fu ... Check : Full Payment : 2024 Special Assessment"
Step #14: Click on "2025 Annual Capital Contribution 01/09/2025 Adirondack Bank - Checking : capital improvement fu ... Check : Full Payment : 2024 Special Assessment"

Both use the accounts receivable annual capital contribution account. This is the main difference compared to a regular invoice.

15
Click on "Adirondack Bank - Checking"
Step #15: Click on "Adirondack Bank - Checking"

We usually ignore that field, as almost everything else is accounts receivable. However, for these invoices, we'll use the annual capital contribution. Since I have a special assessment available, I'll refer to that.

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

If not, I would access the capital contribution and create a copy.

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

A message will confirm a duplicate has been created. Click OK. You'll know it worked if the invoice date is today's date, as copies default to the current day.

18
Click on "OK"
Step #18: Click on "OK"
19
Click on "INVOICE #"
Step #19: Click on "INVOICE #"

Today, I'm working on this the same day Sandy sent out the announcement about the special assessment. I'll keep today's date. You should use your own situation to determine the appropriate date. For this task, we can ignore many details like reservation source and booking date, as they are blank. The terms are special terms, and we'll leave them as they are.

20
Click here
Step #20: Click here
21
Click here
Step #21: Click here

I will only change the notations and the amount of money. First, I'll ensure the account is correct. When I created the duplicate, it reverted to the general accounts, so I need to change it to the member annual capital account.

22
Click here
Step #22: Click here
23
Click on "A / R Member annual cap contrib ."
Step #23: Click on "A / R Member annual cap contrib ."

That part is something we're not used to handling, and I'm glad I noticed it when I did! It's easy to overlook. The last thing you want is to be halfway through and realize you haven't been making the necessary changes. Even though we duplicated one that was already set up, QuickBooks defaults to the usual AR. For multiple cabin owners, I prefer to set the notation correctly for each line, specifying the share each line is referencing (I don't always bother with the single cabin shareholders).

24
Click on "2024 Special Assessment - Mrs. C's"
Step #24: Click on "2024 Special Assessment - Mrs. C's"

Where it says "2024 Special Assessment," click to the right of the text. This will highlight everything to the left. Press the backspace key to delete it. I have a macro set up to type "Emergency Special Assessment" automatically.

25
Type "Backspace"
26
Type "Emergency Special Assessment"

If I didn't have a macro available, I would simply copy and paste it.

27
Click on "2024 Special Assessment - Cabin 2"
Step #27: Click on "2024 Special Assessment - Cabin 2"

You can do that on each line.

28
Type "Emergency Special Assessment"
29
Click on "2024 Special Assessment - Cabin 3"
Step #29: Click on "2024 Special Assessment - Cabin 3"
30
Type "Emergency Special Assessment"
31
Click on "2024 Special Assessment - Kirkwood" and fix this one too. You get the point.
Step #31: Click on "2024 Special Assessment - Kirkwood" and fix this one too. You get the point.

The notations are all correct. Now, I need to ensure the rate is accurate.

32
I will highlight Mrs. Coolidge's rate and delete it.
Step #32: I will highlight Mrs. Coolidge's rate and delete it.

Refer to the PDF for the correct amount:

33
Highlight "$3,472.14"
Step #33: Highlight "$3,472.14"

I can copy and paste to ensure I don't make any mistakes.

34
Right-click on "$3,472.14"
Step #34: Right-click on "$3,472.14"
35
Click on Copy
Step #35: Click on Copy

Go back to the invoice, then paste it.

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

Proceed to Cabin 2.

I'll scroll down in the PDF, find the amount, copy it, and paste it.

37
Right-click on "$ 2,768.33"
Step #37: Right-click on "$ 2,768.33"
38
Click on "Copy"
Step #38: Click on "Copy"
39
Right-click here
Step #39: Right-click here
40
Click on "Paste"
Step #40: Click on "Paste"

Next up:

41
Right-click on "$2,768.33"
Step #41: Right-click on "$2,768.33"
42
Click on "Copy"
Step #42: Click on "Copy"
43
Paste
Step #43: Paste
44
Highlight "$3,002.93" and copy it
Step #44: Highlight "$3,002.93" and copy it
45
Go back into QB and paste
Step #45: Go back into QB and paste
46
Once I have completed all of those, it shows 12,011.73 for the total
Step #46: Once I have completed all of those, it shows 12,011.73 for the total

Out of curiosity, if I look over here, it's 12,011.72

47
🤔
Step #47: 🤔

The total at the bottom for multiple cabin owners, including Tim Quigley, is 72.

One penny too high. 👀

48
Click on "3,002.93"
Step #48: Click on "3,002.93"

Quickly addressing a rounding error, I'll reduce the invoice by one penny.

49
Type "2"
50
Finally, there's the memo at the bottom left.
Step #50: Finally, there's the memo at the bottom left.

I'll highlight everything, delete it, and use my macro to type "emergency special assessment."

Then save and close.

51
Click on "Save & Close"
Step #51: Click on "Save & Close"

On this screen, when I scroll up on the account, I should see a record dated 3/12/25. It should show an emergency special assessment affecting the accounts receivable member annual capital contribution account for that amount.

52
As seen here:
Step #52: As seen here:
53
Step #53:

That's it. This is the hardest example because it involves a multiple cabin owner. I'll stop here and create a separate, more concise guide that covers a few examples quickly. I'll wait until I finish with the multiple cabin owners before doing that.

Always ensure it hits the accounts receivable account, the notation is correct, and the amount is accurate. Then you're good to go! These are super easy but we just don't do them very often, so they seem intimidating.

Guide to Creating Member Special Assessment Invoices for Members Who Own Shares of Multiple Cabins