Fast Offering Report
-
- New Member
- Posts: 2
- Joined: Tue Aug 07, 2012 7:51 pm
Fast Offering Report
Is there a way to generate a report that identifies households that have not contributed a fast offering over a custom date range? Clearly there is a report that identifies households that have contributed a fast offering, but we have been unable to determine an efficient non-manual way of identifying households that have not contributed a fast offering over a custom date range. Any guidance in this regard would be greatly appreciated. Thank you.
- johnshaw
- Senior Member
- Posts: 2273
- Joined: Fri Jan 19, 2007 1:55 pm
- Location: Syracuse, UT
While not sitting in front of a ward level MLS, I recall a report I used to use quite frequently, I think it was a donor report, it was basically a spreadsheet with the contributions in columns and rows. I would print that and note any tithe payer that didn't have a corresponding FO. The financial data in MLS used to be exportable to a spreadsheet where much could be done with the data, but in Finance, we are limited to the reports out there. Maybe someone else has a better idea.
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
JohnShaw wrote:While not sitting in front of a ward level MLS, I recall a report I used to use quite frequently, I think it was a donor report, it was basically a spreadsheet with the contributions in columns and rows.
I don't think MLS has such a report -- that was available back in the FIS days, but I can't find any such report in MLS.
Questions that can benefit the larger community should be asked in a public forum, not a private message.
- johnshaw
- Senior Member
- Posts: 2273
- Joined: Fri Jan 19, 2007 1:55 pm
- Location: Syracuse, UT
The report I'm thinking of is in the Tithing Settlement area of MLS Finance. Select Print Donor Statements, for the Current Year, and the Type of Report is Year-to-Date Donor Summaries by Category. The Tithing and FO columns are separated a bit. Additional benefits from the report show you contributions to other areas as well.
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
Thanks for those details. I got hung up on the term "Donor Report" which made me think of the old FIS days.JohnShaw wrote:The report I'm thinking of is in the Tithing Settlement area of MLS Finance. Select Print Donor Statements, for the Current Year, and the Type of Report is Year-to-Date Donor Summaries by Category. The Tithing and FO columns are separated a bit. Additional benefits from the report show you contributions to other areas as well.
Yes, the Year-to-Date Donor Summaries by Category will give you the raw data that may help answer the original post's question. It will still require a fair amount of manual work:
- That report is only a YTD report. It allows you to select a fiscal year, but not a custom date range as was specified.
- That report has a checkbox for "By Household", but that only basically groups together husband and wife; you'd still have to manually exclude children who are FO donors.
- You'd also need to check the box "Show Reports with Zero Amount" to include households that did not donate at all during the year, since the goal is to identify households that did not contribute.
- This report does allow you to select "Custom" from the Date Range dropdown
- You could click on the "Donor" column heading to sort by donor name
- This will list one line per donation, so you might have to sift through a lot of rows to determine which households had donated.
- You would then have to manually determine which households had not donated, probably by generating a list of households and checking off all those listed on the I&E Detail Report.
Questions that can benefit the larger community should be asked in a public forum, not a private message.
-
- New Member
- Posts: 38
- Joined: Thu Jun 03, 2010 7:31 am
- Location: Woodbridge, VA USA
This might be late but in finance the income and expenses area (where you see what is in the other categories). If you select detailed report on fast offerings you will see all that have contributed. We used this to figure out who we were going to have the deacons visit when we started having them do fast offering collections on fast sunday.