PSFS Offering - Contribution List: How to get fund totals for a certain date range using an Excel pivot table

How to get fund totals for a certain date range using an Excel pivot table

First go to the Offering Module and the Contribution List tab. Then select your date range. Click View Contributions to generate the results, then Export to CSVA to export the data to excel. 

 


​​
In Excel highlight your data and choose Pivot Table from the Insert tab. 




In the PivotTable Field List on the right put Posting Date under Column Labels, Fund under Row Lables, and Amount under Values( it will appear as "Sum of Amount"). ​

 

To Group By Year:

Right click on your first Date (this should be in cell B4) and choose Group. Deselect Month and choose year. Then click Ok. This will display the 3 year totals for the various funds. Alternatively you can do Quarters or Months. 


Switching out Funds in the Row Labels for Name will show how much each family gave Yearly, Quarterly, or Monthly depending on which grouping is selected: How do I create a 3 year summary of family's giving history per year?

 

This is a powerful tool that you can use to display many different results based on your data. ​​

Related Articles

How to get the contribution totals for a single batch organized by fund

 

 

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.