Reconciliation - Temporary Items
-
- New Member
- Posts: 4
- Joined: Mon Feb 02, 2009 12:11 pm
- Location: Holladay, UT, USA
Reconciliation - Temporary Items
Two financial clerks ago, a "temporary item" was created in order to reconcile something that happened several months earlier. The dates recorded are more than three years (plus the current year) ago, thus neither MLS nor I now have records. This temporary item is still lingering. No one ever fixed the problem. If I remove the "temporary item" then things do not reconcile. The last clerk called headquarters and asked them about this and yet they were not able to solve the problem. When headquarters was asked whether or not they were concerned, the consensus was, "no." The stake clerk does not know what the problem is either. I have tried and tried to figure out what went wrong (as well as the clerk before me), but we cannot figure it out, and now we are afraid it was too long ago so we do not have enough information to make a confident decision. What can I do to get rid of this "temporary item" and still reconcile?
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
There are only two ways to eliminate a temporary item:applejack wrote:Two financial clerks ago, a "temporary item" was created in order to reconcile something that happened several months earlier. The dates recorded are more than three years (plus the current year) ago, thus neither MLS nor I now have records. This temporary item is still lingering. No one ever fixed the problem. If I remove the "temporary item" then things do not reconcile. The last clerk called headquarters and asked them about this and yet they were not able to solve the problem. When headquarters was asked whether or not they were concerned, the consensus was, "no." The stake clerk does not know what the problem is either. I have tried and tried to figure out what went wrong (as well as the clerk before me), but we cannot figure it out, and now we are afraid it was too long ago so we do not have enough information to make a confident decision. What can I do to get rid of this "temporary item" and still reconcile?
- The item gets corrected on a subsequent Church Unit Financial Statement, and thus the temporary item is no longer needed, and you can just check it off as you reconcile that statement. This is typically what is done, for example, when a donor check bounces and so the Other category has been charged on the CUFS. When the corresponding donation has been canceled in MLS, but the credit to the Other account has not yet shown up on the statement, you make a temporary item for the Other account; in the next month when the credit shows up, you just check off the temporary item.
- You make the temporary item permanent by creating an Other Item during reconciliation (or creating some other expense or transfer transaction). This would seem to be the best course of action now. It's a pity that the item was not corrected in a timely manner so that the real reason could be researched. Generally if a temporary item lasts more than a couple of months, something is wrong. But previous clerks were negligent, and there's not much you can do about that now.
-
- New Member
- Posts: 4
- Joined: Mon Feb 02, 2009 12:11 pm
- Location: Holladay, UT, USA
Yeah, unfortunately this did not fix the problem way back when.Alan_Brown wrote:The item gets corrected on a subsequent Church Unit Financial Statement, and thus the temporary item is no longer needed...
Alan_Brown wrote:You make the temporary item permanent by creating an Other Item during reconciliation (or creating some other expense or transfer transaction).
I think I will try this and report back. Hopefully no other problems will arise.
Alan_Brown wrote:You didn't say what the problem was..."
That's just it. I don't know what the problem is. All I can determine is that church headquarters (the financial statement from them) "says" that MLS is shy $200 in the "Missionary" account (when the temporary item is removed). With the temporary item, things zero. I cannot even tell more specifically "what" under the category of "Missionary." The "reason" listed with the temporary item just gives a date, which is of course too long ago to have records of. So definitely one thing I have learned is to be more descriptive whenever I get a chance with the records I deal with.
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
Given that the issue is confined to the Missionary account, creating the Other Item should take care of the problem. If I understand you correctly, the Church thinks you have $200 more in Missionary than your MLS records show. So you will have get a $200 credit by fixing this problem, which is definitely nicer than the other way around!applejack wrote:All I can determine is that church headquarters (the financial statement from them) "says" that MLS is shy $200 in the "Missionary" account (when the temporary item is removed). With the temporary item, things zero. I cannot even tell more specifically "what" under the category of "Missionary." The "reason" listed with the temporary item just gives a date, which is of course too long ago to have records of. So definitely one thing I have learned is to be more descriptive whenever I get a chance with the records I deal with.
One think you might watch out for: generally the Missionary account is not used; rather the Ward Missionary account has all transactions related to missionaries serving from your ward. I just helped someone zero out the Missionary account in another thread: Moving Beginning balance from Missionary to Ward Mission.
-
- New Member
- Posts: 4
- Joined: Mon Feb 02, 2009 12:11 pm
- Location: Holladay, UT, USA
Alan_Brown wrote:Given that the issue is confined to the Missionary account, creating the Other Item should take care of the problem. If I understand you correctly, the Church thinks you have $200 more in Missionary than your MLS records show. So you will have get a $200 credit by fixing this problem, which is definitely nicer than the other way around!
I am wrong (sorry). To be more clear, the "Reconciliation Report" lists the "MLS Balance" under "Missionary" as $200 more than the "Church Unit Financial Statement's" "Adjusted Statement Balance." I interpret that to mean that MLS has $200 that headquarters should have taken out long ago. Transferring $200 out of "MLS Missionary" should fix it. Fortunately there is a small surplus to do this.
Alan_Brown wrote:You make the temporary item permanent by creating an Other Item during reconciliation (or creating some other expense or transfer transaction). This would seem to be the best course of action now.
I was in MLS last night and created an "Other item" on last month's reconciliation. I figured it was alright to mess with this because we just went through it Sunday and the Bishop has not yet signed it. I wanted to see what happened. Well, by entering a -$200 under "Missionary," things reconciled (zeroed). MLS states the following:
"Other items are items that appear on your Church Unit Financial Statement but have not been entered into MLS."
This seems appropriate since it "appears" that $200 was never taken out. (Maybe this correction showed up on a financial statement years ago under "Miscellaneous Disbursements and Credits" and was never entered into MLS.)
But now I have another question. There is a check box next to my newly entered "Other item" that reads:
"Check this box to automatically create transfer entries for this item."
I stopped here because I did not want to do something I could not reverse at this point. Should this box be checked. What happens then? Does the "Other item" go away? Will things still be reconciled?
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
That check box is checked by default, because usually you want to create corresponding transfer entries (for example, if you use Other Items to create a Budget expense for Distribution Services, you still want to create the corresponding transfer item to bring your statement balance for Budget to 0). But in this case we want to create just a single entry, without the corresponding transfer entries, so it seems that you should leave it unchecked.applejack wrote:There is a check box next to my newly entered "Other item" that reads:
"Check this box to automatically create transfer entries for this item."
I stopped here because I did not want to do something I could not reverse at this point. Should this box be checked. What happens then? Does the "Other item" go away? Will things still be reconciled?
The Other Item will not go away in either case. If the box is not checked, it will simply become a single transfer transaction. Checking the box would cause a second transfer transaction (in the opposite direction) to be created, which would almost certainly not reconcile.
However, note that the MLS help file (topic "Other Items") says in regards to this check box:
So perhaps you need to consult with Clerk Support, since I am advising you to leave it unchecked.There is a small box with a check mark on the left end of the line of fields that appears. Do not remove this check mark unless told to do so by the administration office.
-
- New Member
- Posts: 4
- Joined: Mon Feb 02, 2009 12:11 pm
- Location: Holladay, UT, USA
Alan_Brown wrote:That check box is checked by default...
Hmmm...After a clicked to add the "Other item," the box was not checked. I was afraid to check it. Thanks for your information and advice though.
Alan_Brown wrote:So perhaps you need to consult with Clerk Support, since I am advising you to leave it unchecked.
Yes, I should call them again. Again, thank you for your suggestions and advice. I really appreciate it!
- mcallaghan
- Member
- Posts: 52
- Joined: Sun Nov 01, 2009 9:58 am
- Location: Celebration, FL, USA
- Contact:
I'm glad I found this thread, though I'm sorry to be resurrecting it. I believe I face the same problem. We have three different temporary items that we've been carrying for more than four years. Apparently there were some bounced tithing checks way back when. The individuals in question aren't here anymore, and I'd like to get rid of the temporary items for good.
From what I read above, it seems that these members got "credit" for their tithing, even though they really didn't pay it. Am I reading that correctly? The temporary items fixed the original returned check imbalance, and successive clerks have been pushing them forward for years. I presume there is no way to go back four years and fix that particular donation batch, so can I just create a negative tithing adjustment now? Seems weird, but I really want to fix this.
Thanks!
Mike
From what I read above, it seems that these members got "credit" for their tithing, even though they really didn't pay it. Am I reading that correctly? The temporary items fixed the original returned check imbalance, and successive clerks have been pushing them forward for years. I presume there is no way to go back four years and fix that particular donation batch, so can I just create a negative tithing adjustment now? Seems weird, but I really want to fix this.
Thanks!
Mike
-
- Community Administrator
- Posts: 34505
- Joined: Sat Jan 20, 2007 2:53 pm
- Location: U.S.
In the U.S., MLS currently holds records back to 2006. (3 years plus current). As long as the donations are between 2006 and 2009, I think you should be able to go back and cancel the affected donation.
Note that the 2006 records will be purged automatically when you close out the year.
Note that the 2006 records will be purged automatically when you close out the year.
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.
So we can better help you, please edit your Profile to include your general location.
So we can better help you, please edit your Profile to include your general location.
- mcallaghan
- Member
- Posts: 52
- Joined: Sun Nov 01, 2009 9:58 am
- Location: Celebration, FL, USA
- Contact: