Answers.Body: <p>i would do the following. use a single price set based on Memberships. add the donation line item in to it with its own financial type.</p>
  <p>then the <a href="https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport" rel="nofollow noreferrer">Extended Report</a> extension should solve your last issue of how much is donation v member fee</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-12-20T18:34:49.577Z
Answers.LastActivityDate: 2020-12-20T18:34:49.577Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>Sorry to come in here after so long, but I've been tearing my hair out trying to figure out how to have CiviCRM do something as seemingly simple as accept a membership amount, and make its financial type &quot;Membership&quot; and a donation and make it's financial type &quot;Donation&quot;. All on the same Contribution page.</p>
  <p>And I just don't understand the above solutions. WE can't create a price set that has Memberships and Donations in it. But when I create a Contribution form with the form contribution type set to Donation, and have a membership also being taken, it will only show one financial type. The donation.</p>
  <p>(I am using Stripe, so it can't do two charges. WHich is fine, since that would cost us two times the fixed transaction fee)</p>
  <p>from petednz - fuzion</p>
  <blockquote>
  <p>single price set. memberships. add the donation line item there with its own financial type.</p>
  </blockquote>
  <p>Add the donation line where? The error says we can't add it in the price set. So where is this donation line going?</p>
  <p>Forgive my irritation, but this seems like such a fundamental REQUIREMENT in ANY country and in ANY tax system, that the sheer difficulty of making it happen is mind boggling.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-04-24T22:38:24.667Z
Answers.Text: We were able to make it work quite nicely using @petednz-fusion's suggestion:
  1. Install Edit Line Item Extension extension
  2. Install Extended Reports extension
  3. Create a price set with your options and financial types as desired. E.g. our membership price set is Membership (fintype=Membership), Donation-Fixed ($25,$50,$100; fintype=Donation), Donation-Other (fintype=Donation)
  4. Add the price set to your Membership Contribution Page on the Memberships tab. Don't enable contributions on the Amounts tab - the system won't let you do both.
Answers.UserDisplayName: Geof Newton
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-04-24T22:44:51.110Z
Answers.Text: 5. Line item details will now appear on extended reports that you create and on the Contributions dashboard.
  
  We don't get line item details from our transaction provider (PayPal) to load to Quickbooks since we're using the basic PayPal integration but we can now reconcile, and categorize, transactions using the CiviCRM reports :-)
  
  cheers - :) gn
Answers.UserDisplayName: Geof Newton
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-04-26T10:05:12.687Z
Answers.Text: Hmmm.... Whats the Edit Line Item extension? I don't see any mention of that by anyone until you mention it. I did indeed eventually work out that a price set can be used to hold the membership and the donation. Very confusing. But I know nothing about the Edit Line Item Extension. Maybe that's the missing piece....
  
  Thanks for the reply and the walk through.
Answers.UserDisplayName: Norman Cates
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-05-03T15:52:57.547Z
Answers.Text: It lets you view and edit Line Items on the CiviCRM backend. Extremely useful if you're entering checks that come in with multiple category splits. See https://civicrm.org/extensions/line-item-editor
Answers.UserDisplayName: Geof Newton
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-04-23T08:56:59.747Z
Answers.LastActivityDate: 2021-04-23T08:56:59.747Z
Answers.UserDisplayName: Norman Cates
Body: <p>We've added the option to accept additional donations when initiating or renewing a membership by enabling the Contribution Amounts section on a contribution page but there doesn't seem to be a way to report on these additional contributions. For example, if a member renews a family membership for $35 and makes a $20 donation, Civi records a $55 membership. We then have to go through each membership and each contribution to figure out how much they donated along with their membership fee. We've tried the ExtendedReport extension which has some great ways to view Price Set info but we can't use contribution price sets on membership pages :-(. Has anyone figured out a way to get this info into a report?</p>
  <p>cheers ... :) gn</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-12-10T18:44:19.917Z
Comments.Text: "we can't use contribution price sets on membership pages". To clarify. Do you mean that when you use a Price Set for a membership page (which you can) that you cannot get something you need working? or that if you do use a Price Set that the ExtReport does not help. not quite clear
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-12-15T15:36:08.473Z
Comments.Text: We're taking additional contributions as part of the membership and if you enable a price set on the Amounts page you get the error: "You cannot enable both a Contribution Price Set and Membership Signup on the same online contribution page." We've considered adding the additional donation options to the Membership price set but we may still run into the reporting problem - how much of the transaction was membership vs. donation?
Comments.UserDisplayName: Geof Newton
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-12-15T20:12:05.960Z
Comments.Text: i would do the latter. single price set. memberships. add the donation line item there with its own financial type. then the Extended Report extension should solve your last issue of how much is donation v member fee
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-12-16T17:46:50.160Z
Comments.Text: I think I found the key: this help text is behind the Financial type on the Contribution page - "NOTE: If you are using this contribution page for membership signup and renewals, the financial type configured in the membership type settings will be used when recording the membership payment. The financial type selected here will only be used if you are also collecting additional contributions ..." Since I had both set as Membership, the contributions also reported as Membership. Going to try this change first and then consolidated Price Set if this doesn't work - cheers ... :) gn
Comments.UserDisplayName: Geof Newton
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-12-20T04:13:44.857Z
Comments.Text: The 16 December modification didn't help - it simply lumped the entire transaction in to the Donation financial type and was equally unreportable. As mentioned above by @petednz, the Price Set with line items dedicated specifically to financial types of Member Dues and Donations seems to be the only way to get reporting on contribution pages which include both membership signup and donation options. - :) gn
Comments.UserDisplayName: Geof Newton
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-12-20T18:35:25.273Z
Comments.Text: Geof, i added my suggestion as an answer - if you could +1 and/or Accept so it helps others. thx
Comments.UserDisplayName: petednz - fuzion
Tags: <civimember><contributions><reports><financial-types>
Title: Reporting on contribution amounts when added to a membership page
ThreadText: # Reporting on contribution amounts when added to a membership page
  
  (Asked by: username_0 on 2020-12-10)
  
  We've added the option to accept additional donations when initiating or renewing a membership by enabling the Contribution Amounts section on a contribution page but there doesn't seem to be a way to report on these additional contributions. For example, if a member renews a family membership for $35 and makes a $20 donation, Civi records a $55 membership. We then have to go through each membership and each contribution to figure out how much they donated along with their membership fee. We've tried the ExtendedReport extension which has some great ways to view Price Set info but we can't use contribution price sets on membership pages :-(. Has anyone figured out a way to get this info into a report?
  
  cheers ... :) gn
  
  **Tags:** civimember, contributions, reports, financial-types
  
  > **Comments:**
  > **username_1**: "we can't use contribution price sets on membership pages". To clarify. Do you mean that when you use a Price Set for a membership page (which you can) that you cannot get something you need working? or that if you do use a Price Set that the ExtReport does not help. not quite clear  
  > **username_0**: We're taking additional contributions as part of the membership and if you enable a price set on the Amounts page you get the error: "You cannot enable both a Contribution Price Set and Membership Signup on the same online contribution page." We've considered adding the additional donation options to the Membership price set but we may still run into the reporting problem - how much of the transaction was membership vs. donation?  
  > **username_1**: i would do the latter. single price set. memberships. add the donation line item there with its own financial type. then the Extended Report extension should solve your last issue of how much is donation v member fee  
  > **username_0**: I think I found the key: this help text is behind the Financial type on the Contribution page - "NOTE: If you are using this contribution page for membership signup and renewals, the financial type configured in the membership type settings will be used when recording the membership payment. The financial type selected here will only be used if you are also collecting additional contributions ..." Since I had both set as Membership, the contributions also reported as Membership. Going to try this change first and then consolidated Price Set if this doesn't work - cheers ... :) gn  
  > **username_0**: The 16 December modification didn't help - it simply lumped the entire transaction in to the Donation financial type and was equally unreportable. As mentioned above by @petednz, the Price Set with line items dedicated specifically to financial types of Member Dues and Donations seems to be the only way to get reporting on contribution pages which include both membership signup and donation options. - :) gn  
  > **username_1**: Geof, i added my suggestion as an answer - if you could +1 and/or Accept so it helps others. thx  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2020-12-20. Score: 2 | Accepted answer
  
  i would do the following. use a single price set based on Memberships. add the donation line item in to it with its own financial type.
  
  then the [Extended Report](https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport) extension should solve your last issue of how much is donation v member fee
  
  
  ---
  
  ### Answer by username_2 on 2021-04-23. Score: 0
  
  Sorry to come in here after so long, but I've been tearing my hair out trying to figure out how to have CiviCRM do something as seemingly simple as accept a membership amount, and make its financial type "Membership" and a donation and make it's financial type "Donation". All on the same Contribution page.
  
  And I just don't understand the above solutions. WE can't create a price set that has Memberships and Donations in it. But when I create a Contribution form with the form contribution type set to Donation, and have a membership also being taken, it will only show one financial type. The donation.
  
  (I am using Stripe, so it can't do two charges. WHich is fine, since that would cost us two times the fixed transaction fee)
  
  from username_1
  
  > single price set. memberships. add the donation line item there with its own financial type.
  
  Add the donation line where? The error says we can't add it in the price set. So where is this donation line going?
  
  Forgive my irritation, but this seems like such a fundamental REQUIREMENT in ANY country and in ANY tax system, that the sheer difficulty of making it happen is mind boggling.
  
  > **Comments:**
  > **username_0**: We were able to make it work quite nicely using @petednz-fusion's suggestion: 1. Install Edit Line Item Extension extension 2. Install Extended Reports extension 3. Create a price set with your options and financial types as desired. E.g. our membership price set is Membership (fintype=Membership), Donation-Fixed ($25,$50,$100; fintype=Donation), Donation-Other (fintype=Donation) 4. Add the price set to your Membership Contribution Page on the Memberships tab. Don't enable contributions on the Amounts tab - the system won't let you do both.  
  > **username_0**: 5. Line item details will now appear on extended reports that you create and on the Contributions dashboard.  We don't get line item details from our transaction provider (PayPal) to load to Quickbooks since we're using the basic PayPal integration but we can now reconcile, and categorize, transactions using the CiviCRM reports :-)  cheers - :) gn  
  > **username_2**: Hmmm.... Whats the Edit Line Item extension? I don't see any mention of that by anyone until you mention it. I did indeed eventually work out that a price set can be used to hold the membership and the donation. Very confusing. But I know nothing about the Edit Line Item Extension. Maybe that's the missing piece....  Thanks for the reply and the walk through.  
  > **username_0**: It lets you view and edit Line Items on the CiviCRM backend. Extremely useful if you're entering checks that come in with multiple category splits. See https://civicrm.org/extensions/line-item-editor  
  
  ---
  
  