Quarterly Report Discrepancy: MLS vs. Web

Discuss where to obtain or how to fill out specific reports or forms.
deuel
New Member
Posts: 18
Joined: Sun Apr 01, 2012 6:53 pm

Quarterly Report Discrepancy: MLS vs. Web

Postby deuel » Thu Jan 16, 2014 5:39 pm

While preparing our Quarterly Report, I noticed 4 pre-filled data lines (i.e. Single Adults, Endowed Members, Primary) had differing numbers between MLS and that displayed under the Clerk's Resources on "lds.org" - any thoughts and/or similar experiences?

The most notable are the two lines concerning Primary Children ["3 - 11" and "0 - 2"]. It seems those "age 3 on January 1st of the Reporting Year" were probably included on the wrong line of the Online Quarterly Report, because the difference is equal to the number of kids that turned 3 years-of-age during 2013. Unfortunately, the web site version does not provide a list of members in the various categories, as does MLS.

User avatar
showseason
Member
Posts: 115
Joined: Sat Feb 26, 2011 9:56 pm
Location: Medford, OR

Re: Quarterly Report Discrepancy: MLS vs. Web

Postby showseason » Fri Jan 17, 2014 8:28 am

Same issue here. In fact some numbers appeared to change when I moved out members after the 1st of the year. I opted to use the MLS version for my report because of this.

lajackson
Community Moderators
Posts: 6139
Joined: Mon Mar 17, 2008 9:27 pm
Location: US

Re: Quarterly Report Discrepancy: MLS vs. Web

Postby lajackson » Fri Jan 17, 2014 8:56 am

MLS locks the statistics at the last/first day of each quarter. The Web version does not seem to lock them, but rather seems to display current statistics. I also prefer MLS.

It will be interesting to see what changes come when we prepare the 2014 1Q report in April.

scgallafent
Church Employee
Church Employee
Posts: 1049
Joined: Mon Feb 09, 2009 4:55 pm
Location: Riverton, Utah

Re: Quarterly Report Discrepancy: MLS vs. Web

Postby scgallafent » Fri Jan 17, 2014 9:47 am

deuel wrote:The most notable are the two lines concerning Primary Children ["3 - 11" and "0 - 2"]. It seems those "age 3 on January 1st of the Reporting Year" were probably included on the wrong line of the Online Quarterly Report, because the difference is equal to the number of kids that turned 3 years-of-age during 2013. Unfortunately, the web site version does not provide a list of members in the various categories, as does MLS.

There was an issue with the Primary calculation when the calculation routine ran at the beginning of the quarter. It has been fixed, but the calculated values weren't changed retroactively.

In the current configuration, the baseline statistics are calculated early in the morning (unit local time) on the first day of the quarter. When the quarterly report is sent from MLS, the baseline values calculated by MLS overwrite the values that were calculated at Church headquarters. Since the MLS-calculated values will overwrite the incorrect values, the decision was to let MLS push the corrections rather than try to go back and recalculate the statistics retroactively.

scgallafent
Church Employee
Church Employee
Posts: 1049
Joined: Mon Feb 09, 2009 4:55 pm
Location: Riverton, Utah

Re: Quarterly Report Discrepancy: MLS vs. Web

Postby scgallafent » Fri Jan 17, 2014 9:50 am

lajackson wrote:MLS locks the statistics at the last/first day of each quarter. The Web version does not seem to lock them, but rather seems to display current statistics. I also prefer MLS.

The web version should lock them at the beginning of the quarter (see above), but will update as the reports are submitting using MLS.

eblood66
Senior Member
Posts: 2028
Joined: Mon Sep 24, 2007 8:17 am
Location: Cumming, GA, USA

Re: Quarterly Report Discrepancy: MLS vs. Web

Postby eblood66 » Fri Jan 17, 2014 11:21 am

scgallafent wrote:
deuel wrote:The most notable are the two lines concerning Primary Children ["3 - 11" and "0 - 2"]. It seems those "age 3 on January 1st of the Reporting Year" were probably included on the wrong line of the Online Quarterly Report, because the difference is equal to the number of kids that turned 3 years-of-age during 2013. Unfortunately, the web site version does not provide a list of members in the various categories, as does MLS.

There was an issue with the Primary calculation when the calculation routine ran at the beginning of the quarter. It has been fixed, but the calculated values weren't changed retroactively.

In the current configuration, the baseline statistics are calculated early in the morning (unit local time) on the first day of the quarter. When the quarterly report is sent from MLS, the baseline values calculated by MLS overwrite the values that were calculated at Church headquarters. Since the MLS-calculated values will overwrite the incorrect values, the decision was to let MLS push the corrections rather than try to go back and recalculate the statistics retroactively.

Does that mean the statistics won't get updated if you submit the report via Clerk Resources and not MLS?

scgallafent
Church Employee
Church Employee
Posts: 1049
Joined: Mon Feb 09, 2009 4:55 pm
Location: Riverton, Utah

Re: Quarterly Report Discrepancy: MLS vs. Web

Postby scgallafent » Fri Jan 17, 2014 1:52 pm

eblood66 wrote:Does that mean the statistics won't get updated if you submit the report via Clerk Resources and not MLS?

They will NOT get updated if you use Clerk Resources to submit the report. You don't have the ability to modify the baseline values from Clerk Resources, so you need to submit the report using MLS in order to use the MLS-calculated values instead of the existing values.

eblood66
Senior Member
Posts: 2028
Joined: Mon Sep 24, 2007 8:17 am
Location: Cumming, GA, USA

Re: Quarterly Report Discrepancy: MLS vs. Web

Postby eblood66 » Fri Jan 17, 2014 2:11 pm

scgallafent wrote:
eblood66 wrote:Does that mean the statistics won't get updated if you submit the report via Clerk Resources and not MLS?

They will NOT get updated if you use Clerk Resources to submit the report. You don't have the ability to modify the baseline values from Clerk Resources, so you need to submit the report using MLS in order to use the MLS-calculated values instead of the existing values.

I've already submitted via the web (I just ignored the incorrect count for primary children and put in the correct number who attended). If I resubmit in MLS on Sunday will that update the report appropriately?

scgallafent
Church Employee
Church Employee
Posts: 1049
Joined: Mon Feb 09, 2009 4:55 pm
Location: Riverton, Utah

Re: Quarterly Report Discrepancy: MLS vs. Web

Postby scgallafent » Fri Jan 17, 2014 2:34 pm

eblood66 wrote:
scgallafent wrote:
eblood66 wrote:Does that mean the statistics won't get updated if you submit the report via Clerk Resources and not MLS?

They will NOT get updated if you use Clerk Resources to submit the report. You don't have the ability to modify the baseline values from Clerk Resources, so you need to submit the report using MLS in order to use the MLS-calculated values instead of the existing values.

I've already submitted via the web (I just ignored the incorrect count for primary children and put in the correct number who attended). If I resubmit in MLS on Sunday will that update the report appropriately?

Yes. As long as the MLS report is submitted by January 30, the MLS baseline values will overwrite the generated baseline values that you see in Clerk Resources.

russellhltn
Community Administrator
Posts: 20762
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

Re: Quarterly Report Discrepancy: MLS vs. Web

Postby russellhltn » Fri Jan 17, 2014 2:56 pm

However, I think MLS values might change based on records being moved out. We've observed that with HT/VT stats.
Have you searched the Wiki?
Try using a Google search by adding "site:tech.lds.org/wiki" to the search criteria.


Return to “Reports and Forms”

Who is online

Users browsing this forum: No registered users and 1 guest