Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello, I'm the treasurer for a non-profit organization on campus and was looking to get set our bookkeeping set up in quickbooks. I was wondering how I would go about recording different membership types with different amounts. We have 4 membership types and can get these paid either with cash, card, check or through paypal. The first thing that comes to mind would be to give each of our members an invoice with an item code to each membership type (other charge) with the fee tied to each membership type. From here I could receive a payment either in full or broken down in a payment plan. Would I also make each of these other charges a subset of the "membership dues" income account? Or could there be an easier way to get this set up? Thanks!
Solved! Go to Solution.
A warm welcome to the Community, BedrickT.
I'd be delighted to provide with you the steps on how to set up different membership with different amounts in QuickBooks Desktop.
With QuickBooks Desktop, you can create a service item with different amounts to serve as your item code for each membership type.
Here's how:
I've attached some screenshots to guide you through the steps.
Continue this process to set up the other membership type and rates.
For more details about adding items in QuickBooks Desktop, check out this recommended article: Add, edit, and delete items.
Feel free to get back in touch with me if you have other concerns about QuickBooks. I'd love to help.
A warm welcome to the Community, BedrickT.
I'd be delighted to provide with you the steps on how to set up different membership with different amounts in QuickBooks Desktop.
With QuickBooks Desktop, you can create a service item with different amounts to serve as your item code for each membership type.
Here's how:
I've attached some screenshots to guide you through the steps.
Continue this process to set up the other membership type and rates.
For more details about adding items in QuickBooks Desktop, check out this recommended article: Add, edit, and delete items.
Feel free to get back in touch with me if you have other concerns about QuickBooks. I'd love to help.
I agree with @Rose-A
You want Service Items for Dues, because this is your routine activity. Other Charges are, for instance, Postage, Mileage, etc.
You also can use Customer Type. That way, you can use that in reporting, such as Sales by Item, filter on only the one Customer Type. This would let you see if you charged a Customer Type the wrong Dues item, for quality assurance and review. I also like Sales by Customer Summary, with Columns by Item Type or Item Detail = each type of Dues is now a column.
All of the Dues Items link to just the one Dues account. That keeps the P&L simple, and the Items List does the better reporting for you. Item reporting includes Quantity, for instance, when that is helpful to analyze the activities.
This looks great thank you so much! Just to clarify then, all dues routed through these item codes would affect the "membership dues" income account? And to be able to pay these dues I would just go through receive payments and the type of payment the members decide to use? Finally, since they can pay through paypal would I just add that as a payment method? Thanks for the help!
Would it be a matter of using both? As in using the service charge to actually charge the member then attaching a customer type for reporting?
How do I bill members for each different type of membership
They are set up with different values - now how do I bill them
Hi there, @Bsmo.
In QuickBooks, a Bill is used for recording payables or paying expenses. While the Invoice is for recording sales transactions.
To make sure you're able to charge each different types of members with their dues, let's use an Invoice to record their pledges. Here's how:
For future reference, read through our help article: Record an invoice payment. It helps you learn how to receive and mark the invoice as paid in QuickBooks Desktop.
You can also check out the Accounts Receivable workflows in QuickBooks Desktop. It includes steps that can help you in creating each transaction from your selected workflow.
Feel free to comment below if you have more questions. We're always here to guide. Have a great day.
Is there a way to dues income amortization? If someone pays for one year or two years, we'd recognize the income monthly over that one or two years. Is there a way for QB to keep track of membership dues expiration?
Thanks!
I have details to share to with your question about tracking membership dues and expirations, Harold.
If the membership dues are the same amount every period, you can create a memorized transaction. You have an option to either automatically record a transaction or add it to your reminder list. Here's how:
You can also read more details about this feature in this article: Create, Edit, or Delete Memorized Transactions.
I have more articles to share in case you want more guidance when reviewing your income transactions:
Please know that we're just around the corner if you have more questions for us. We're always her to help.
Thanks! I do something similar for amortizing expenses like insurance and also for depreciation expense. But, setting up a separate memorized transaction for each member seems unwieldy. Ideally, an individual dues collection would debit cash and credit prepaid member dues liability. Then, each month, there would be a debit to prepaid member dues liability and credit to dues income. The group I'm working with has options for one year dues or two year dues. The simplest thing is to just recognize the income when it is received, but it seems more accurate to amortize the dues over the one or two years. But I can't think of a way to do it without creating a memorized transaction for each and every dues payment received.
Harold
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here