Answers.Body: <p>I had a client today with the same issue, so I added this functionality.  Thanks to Pradeep's answer I was able to implement this in about 10 minutes.</p>
  
  <p>Version 4.4+ of the <a href="https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport" rel="nofollow noreferrer">Extended Report</a> extension contains this improvement.  All reports that can use financial transactions - e.g. "Bookkeeping Report with Extra Fields" - can now include, filter, sort and group by payment processor.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-05-10T21:48:29.447Z
Answers.LastActivityDate: 2019-05-13T14:42:25.490Z
Answers.LastEditDate: 2019-05-13T14:42:25.490Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>Change the Name so you can differentiate them. Got to Administer > CiviContribute > Payment Processors. You can click edit and change the name of your PayPal credit card processor to PP Credit Card (or whatever you want). This will work for going forward. You will have to update the contribution table to change the historical contributions.</p>
  
  <p><a href="https://i.sstatic.net/QgIQp.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/QgIQp.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.sstatic.net/QshYp.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/QshYp.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.sstatic.net/jbKqT.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/jbKqT.png" alt="enter image description here"></a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-02T13:21:36.627Z
Answers.Text: This will not work. The payment processors are already named differently and you cannot search/report on transactions for a given payment processor.
Answers.UserDisplayName: Justin Moore
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-03T16:16:08.610Z
Answers.Text: This works for us. I do not have 2 Processors but we do have 2 credit card options and we use native reports to view them. But the results would be the same as I show. I added screenshots to my answer showing it working.
Answers.UserDisplayName: Iowa Boy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2018-01-03T16:27:59.580Z
Answers.Text: I'm guessing right now if you Go to Administer > CiviContribute > Payment Processors you will see Credit Card twice, one with PayPal and one with AuthorizeNet as the Processor Type. If you edit these and rename them, I'm almost certain it will rename all of the historical transactions in your data base. You may want to rename your ACH so they are also different. You might not be pulling reports directly by Payment Processor but you can select the Payment Method/Payment Type (depending on which report you are using) to view the transactions for the Payment Processor of your choice.
Answers.UserDisplayName: Iowa Boy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-30T01:50:27.283Z
Answers.LastActivityDate: 2018-01-03T16:19:47.983Z
Answers.LastEditDate: 2018-01-03T16:19:47.983Z
Answers.UserDisplayName: Iowa Boy
Answers.Body: <p>There are no such reports in CiviCRM that will filter Contribution by Payment Processor. Payment Processor and Payment Method have different meaning. Payment method can be used by N processor. Here are some solutions</p>
  
  <ol>
  <li><p>Going forward have your system to use unique payment method for a payment processor with same name and then you can filter the report using Payment method. So that in future it can be tracked easily using payment method. However, for historical data I won't recommend you to update the Payment method since you will need to update in two tables i.e civicrm_contribution.payment_instrument_id and civicrm_financial_trxn.payment_instrument_id. Changes to civicrm_financial_trxn might impact on Bookkeeping entries for those which are exported in batch and closed for accounting period. </p></li>
  <li><p>Build a custom report for contribution having Payment processor as filter and/or column.</p></li>
  <li><p>Use <a href="https://docs.civicrm.org/dev/en/latest/hooks/hook_civicrm_alterReportVar/" rel="noreferrer">AlterReportVar</a> hook to add filter and/or column for existing contribution reports and build query accordingly.</p></li>
  </ol>
  
  <p>The basic query to retrieve contribution done using payment processor is </p>
  
  <pre><code>SELECT cc.id FROM civicrm_contribution cc
    INNER JOIN civicrm_entity_financial_trxn ceft
      ON ceft.entity_id = cc.id
        AND ceft.entity_table = 'civicrm_contribution'
    INNER JOIN civicrm_financial_trxn cft 
      ON cft.id = ceft.financial_trxn_id
  WHERE cft.payment_processor_id = 1; 
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-12-30T05:34:24.420Z
Answers.LastActivityDate: 2017-12-30T05:34:24.420Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>Is there support for filtering contribution reports by payment processor? </p>
  
  <p>We have credit card (Authorize.NET) and PayPal (new). How can I report on just PayPal transactions?</p>
  
  <p>The only difference I see is in the transaction ID format. Both payment methods say 'credit card' on the contribution.</p>
  
Tags: <civicontribute><civireport><contributions>
Title: Can we report on contributions by payment processor?
ThreadText: # Can we report on contributions by payment processor?
  
  (Asked by: username_0 on 2017-12-29)
  
  Is there support for filtering contribution reports by payment processor?
  
  We have credit card (Authorize.NET) and PayPal (new). How can I report on just PayPal transactions?
  
  The only difference I see is in the transaction ID format. Both payment methods say 'credit card' on the contribution.
  
  **Tags:** civicontribute, civireport, contributions
  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_3 on 2017-12-30. Score: 4 | Accepted answer
  
  There are no such reports in CiviCRM that will filter Contribution by Payment Processor. Payment Processor and Payment Method have different meaning. Payment method can be used by N processor. Here are some solutions
  
  Going forward have your system to use unique payment method for a payment processor with same name and then you can filter the report using Payment method. So that in future it can be tracked easily using payment method. However, for historical data I won't recommend you to update the Payment method since you will need to update in two tables i.e civicrm_contribution.payment_instrument_id and civicrm_financial_trxn.payment_instrument_id. Changes to civicrm_financial_trxn might impact on Bookkeeping entries for those which are exported in batch and closed for accounting period. 
  Build a custom report for contribution having Payment processor as filter and/or column.
  Use AlterReportVar hook to add filter and/or column for existing contribution reports and build query accordingly.
  
  The basic query to retrieve contribution done using payment processor is 
  SELECT cc.id FROM civicrm_contribution cc
    INNER JOIN civicrm_entity_financial_trxn ceft
      ON ceft.entity_id = cc.id
        AND ceft.entity_table = 'civicrm_contribution'
    INNER JOIN civicrm_financial_trxn cft 
      ON cft.id = ceft.financial_trxn_id
  WHERE cft.payment_processor_id = 1;
  
  
  ---
  
  ### Answer by username_1 on 2019-05-10. Score: 3
  
  I had a client today with the same issue, so I added this functionality. Thanks to Pradeep's answer I was able to implement this in about 10 minutes.
  
  Version 4.4+ of the [Extended Report](https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport) extension contains this improvement. All reports that can use financial transactions - e.g. "Bookkeeping Report with Extra Fields" - can now include, filter, sort and group by payment processor.
  
  
  ---
  
  ### Answer by username_2 on 2017-12-30. Score: 1
  
  Change the Name so you can differentiate them. Got to Administer > CiviContribute > Payment Processors. You can click edit and change the name of your PayPal credit card processor to PP Credit Card (or whatever you want). This will work for going forward. You will have to update the contribution table to change the historical contributions.
  
  [![enter image description here](https://i.sstatic.net/QgIQp.png)](https://i.sstatic.net/QgIQp.png)
  
  [![enter image description here](https://i.sstatic.net/QshYp.png)](https://i.sstatic.net/QshYp.png)
  
  [![enter image description here](https://i.sstatic.net/jbKqT.png)](https://i.sstatic.net/jbKqT.png)
  
  > **Comments:**
  > **username_0**: This will not work. The payment processors are already named differently and you cannot search/report on transactions for a given payment processor.  
  > **username_2**: This works for us. I do not have 2 Processors but we do have 2 credit card options and we use native reports to view them. But the results would be the same as I show. I added screenshots to my answer showing it working.  
  > **username_2**: I'm guessing right now if you Go to Administer > CiviContribute > Payment Processors you will see Credit Card twice, one with PayPal and one with AuthorizeNet as the Processor Type. If you edit these and rename them, I'm almost certain it will rename all of the historical transactions in your data base. You may want to rename your ACH so they are also different. You might not be pulling reports directly by Payment Processor but you can select the Payment Method/Payment Type (depending on which report you are using) to view the transactions for the Payment Processor of your choice.  
  
  ---
  
  