3

Our accountants are asking for a report that seems pretty reasonable but I am not finding a civicrm report that will deliver it. Maybe there's one that does but not obvious, or an extension?

All of our transactions are complex; very few have only one item. So, the solution needs to be able to group by line item. We need detail on each transaction, including date received and instrument type. And each line item needs to be subtotalled.

The closest I've gotten is "Extended Report - Contributions with Price Set data" or "Extended Report - Price Set Line Items". Both of these will display the desired item detail but don't provide a dollar subtotal for each line item.

4
  • Drupal or not? Wondering if a bit of work to improve Views and line items would give you and others some good outcomes for this
    – petednz - fuzion
    Oct 11, 2017 at 20:11
  • Looking for a native solution. We're on Drupal but don't want to be tied to it.
    – Rob Brandt
    Oct 11, 2017 at 21:33
  • fair enough. let's see what others have to say
    – petednz - fuzion
    Oct 12, 2017 at 0:15
  • I am not sure that there is a "Civi" way to sub-total each Line Item grouping (we use Sorting rather than Grouping). But you can export the report to Excel and very quickly Sum the groupings.
    – Iowa Boy
    Oct 15, 2017 at 4:33

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.