2

I need a report of contributions which has a row for each contribution, and then analysis by showing a column for each financial type, and the total amount of the contribution in the right financial type column. Is there any way of doing this without programming an extension?

I include a screenshot of the kind of thing I need. The columns to right of VAT are financial types, so each payment is broken down into VAT (if applicable) and one or more financial types.

enter image description here

1
  • How many financial types are we talking about? You want hard-coded columns for each one?
    – Coleman
    Sep 18 '20 at 18:56
2

I am not sure you would get the exact requirement you looking for but you can use contribution pivot reports to group the records based on financial type via

  1. Extended report

or

  1. Report plus
3
  • Thanks a lot Pradeep. I tried a bit but could not see how to configure each financial type to have its own column. I will try again. Sep 17 '20 at 12:54
  • Column would be difficult. I think you are referring to financial type of line item associated with contribution Sep 17 '20 at 12:56
  • You don't need it to be its own column if you use a pivot as Pradeep is saying, which can sum up the contributions by the financial type, which I'm guessing is why you want it in its own column. You can also export to excel and do a pivot table there.
    – Demerit
    Sep 17 '20 at 13:16
2

The new search extension (ships with 5.30 but is still hidden & you have to install via the api) gets close - you can see it's giving numbers for financial type & I don't have a friendly theme enabled but the totals are there

search creator

3
  • The numbers for financial type thing should be fixed by 5.31.
    – Coleman
    Sep 21 '20 at 15:11
  • Thank you Eileen and Coleman. The thing is I need one row per contribution, not totals, and with the breakdown by financial type shown as columns. I will provide an example screenshot. Sep 22 '20 at 6:55
  • I've updated the screenshot to reflect what will be in the 5.31 release (which will be in rc from first Wed in Oct)
    – eileen
    Sep 25 '20 at 12:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.