Member accounts for Club Dues

James Holmes

Members make voluntary donations to pay expenses.
What sort of account structure is best to keep track of how much each member has contributed each month, and the total

Frankx

Hi @James Holmes

Which version of Quicken are you currently running? If it is Home & Business (etc.) you could setup a "customer account" for each member.  That would allow you to track each one very easily and the reporting would be very simple.

If you are using a lower version, setting up a Quicken payee for each member would probably be best.

Let me know if you have any followups.

Frankx

UKR

How about we try and keep it simple, regardless of Quicken feature level in use ...

Each club member has a name. In Quicken that's the Payee Name. Donations are recorded in a Cash or a Checking account, by Payee Name.
The Cash account represents the cash lock box in your office.

The Checking account is the Club's checking account at a bank. All dues paid by check are recorded here and deposited in the bank.
Excess cash is transferred from the Cash account to the Checking account and deposited in the bank.

Reports by Payee Name will tell you who paid how much, e.g., "Itemized Payees" for Transaction summaries and detail information, "Income and Expense by Payee" will show a spreadsheet with columns by month.

James Holmes

Thank you all for your excellent recommendation. I learned several things from your responses.

volvogirl

You could make each member a separate account or just make a Tag for each member.  I would try using tags.   

When you enter a transaction you either put the tag in the tag column or you can enter it at the end of the category by using a forward slash / to designate the tag. You can add a column for Tag if it's not showing.

Frankx

Hi @James Holmes

Which version of Quicken are you currently running? If it is Home & Business (etc.) you could setup a "customer account" for each member.  That would allow you to track each one very easily and the reporting would be very simple.

If you are using a lower version, setting up a Quicken payee for each member would probably be best.

Let me know if you have any followups.

Frankx

UKR

How about we try and keep it simple, regardless of Quicken feature level in use ...

Each club member has a name. In Quicken that's the Payee Name. Donations are recorded in a Cash or a Checking account, by Payee Name.
The Cash account represents the cash lock box in your office.

The Checking account is the Club's checking account at a bank. All dues paid by check are recorded here and deposited in the bank.
Excess cash is transferred from the Cash account to the Checking account and deposited in the bank.

Reports by Payee Name will tell you who paid how much, e.g., "Itemized Payees" for Transaction summaries and detail information, "Income and Expense by Payee" will show a spreadsheet with columns by month.

James Holmes

Thank you all for your excellent recommendation. I learned several things from your responses.