Answers.Body: <p>Check out Extended Reports Extension <a href="https://civicrm.org/extensions/extended-reports/24" rel="nofollow noreferrer">https://civicrm.org/extensions/extended-reports/24</a>  </p>
  
  <p>Here is a quick rundown of how Civi handles Financial Types.
  The Civi Core  native reports will only pull reports for Financial Types connected with your Price Set Default Financial Type. Which is stored in table civicrm_contribution.financial_type_id.<br>
  The Price Field Financial Type is actually called Line Items in the background. You have to use Extended Reports to be able to pull reports based on Line Item (civicrm_line_item.financial_type_id).</p>
  
  <p>When creating a Message Template use tokens for the civicrm_line_item table Ie.{$lineitem.label} {$lineitem.financial_type_id}</p>
  
  <p>You might have/want to create another Financial Type similar to Donation (maybe Contribution). Then use Donation for the Price Set Default Financial Type and Contribution for the Price Field Financial Type. The just helps you know which one you are seeing in reports and when Pulling Reports, you are sure not to get mixed data (Donations and Processing Fees) like you are seeing now.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-23T16:22:36.783Z
Answers.Text: Thank you! I had discovered Extended Reports a bit ago and find it very helpful. Using the lineitem tokens in message templates is something I haven't explored yet, so thanks for that. Also, your suggestion to use separate financial types for Contributions and Price Fields is excellent.
Answers.UserDisplayName: Phil Morice Brubaker
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-10-21T14:16:37.957Z
Answers.LastActivityDate: 2017-10-21T14:16:37.957Z
Answers.UserDisplayName: Iowa Boy
Body: <p>For some of our contributions, we have two different financial types, and that money needs to be treated differently. For instance, donors can make a donation and choose to add 3% to cover the processing fees. The donation is a "Donation" type, and the fee is a non-deductible "Processor Fees" type. The default Financial Type of the Contribution is "Donation". See image. <a href="https://i.sstatic.net/LKW5O.jpg" rel="nofollow noreferrer"><img src="https://i.sstatic.net/LKW5O.jpg" alt="Screen shot"></a></p>
  
  <p>So, I can see the two different financial types within the Contribution, but when we are printing donor letters or running reports or searching for Contributions, we can only treat it as a "Donation" type (the default type of the Price Set).</p>
  
  <p>We want to be able to print thank you letters with only the donation portion of the contribution ("Thank you for your $10 gift" in this case, not "$10.30"). And, we want to be able to run reports showing how much people have contributed through paying their own processing fees (or whatever the secondary type is).</p>
  
  <ul>
  <li>How is this information stored in the database? </li>
  <li>Is there (could there be) a token available to get only the "Donation" amount? </li>
  <li>Why doesn't the Processor Fee amount (which is configured as "Not Deductible") show up in the "non-deductible amount" field for the Contribution?</li>
  <li>Has anyone else come up with a solution or work-around for this issue?</li>
  </ul>
  
Tags: <civicontribute><price-sets><financial-types>
Title: How can we access only one of multiple financial types in a single contribution?
ThreadText: # How can we access only one of multiple financial types in a single contribution?
  
  (Asked by: username_0 on 2017-03-08)
  
  For some of our contributions, we have two different financial types, and that money needs to be treated differently. For instance, donors can make a donation and choose to add 3% to cover the processing fees. The donation is a "Donation" type, and the fee is a non-deductible "Processor Fees" type. The default Financial Type of the Contribution is "Donation". See image. [![Screen shot](https://i.sstatic.net/LKW5O.jpg)](https://i.sstatic.net/LKW5O.jpg)
  
  So, I can see the two different financial types within the Contribution, but when we are printing donor letters or running reports or searching for Contributions, we can only treat it as a "Donation" type (the default type of the Price Set).
  
  We want to be able to print thank you letters with only the donation portion of the contribution ("Thank you for your $10 gift" in this case, not "$10.30"). And, we want to be able to run reports showing how much people have contributed through paying their own processing fees (or whatever the secondary type is).
  
  * How is this information stored in the database?
  * Is there (could there be) a token available to get only the "Donation" amount?
  * Why doesn't the Processor Fee amount (which is configured as "Not Deductible") show up in the "non-deductible amount" field for the Contribution?
  * Has anyone else come up with a solution or work-around for this issue?
  
  **Tags:** civicontribute, price-sets, financial-types
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-10-21. Score: 2 | Accepted answer
  
  Check out Extended Reports Extension <https://civicrm.org/extensions/extended-reports/24>
  
  Here is a quick rundown of how Civi handles Financial Types.
  The Civi Core native reports will only pull reports for Financial Types connected with your Price Set Default Financial Type. Which is stored in table civicrm\_contribution.financial\_type\_id.  
  The Price Field Financial Type is actually called Line Items in the background. You have to use Extended Reports to be able to pull reports based on Line Item (civicrm\_line\_item.financial\_type\_id).
  
  When creating a Message Template use tokens for the civicrm\_line\_item table Ie.{$lineitem.label} {$lineitem.financial\_type\_id}
  
  You might have/want to create another Financial Type similar to Donation (maybe Contribution). Then use Donation for the Price Set Default Financial Type and Contribution for the Price Field Financial Type. The just helps you know which one you are seeing in reports and when Pulling Reports, you are sure not to get mixed data (Donations and Processing Fees) like you are seeing now.
  
  > **Comments:**
  > **username_0**: Thank you! I had discovered Extended Reports a bit ago and find it very helpful. Using the lineitem tokens in message templates is something I haven't explored yet, so thanks for that. Also, your suggestion to use separate financial types for Contributions and Price Fields is excellent.  
  
  ---
  
  