Question about adjustments made to tithing

Discuss questions around local unit policies for budgeting, reconciling, etc. This forum should not contain specific financial or membership information.
19nazzy-p40
New Member
Posts: 17
Joined: Sat Mar 28, 2009 9:15 pm
Location: Canada

Question about adjustments made to tithing

#1

Post by 19nazzy-p40 »

Last week when I entered the tithing in we had a bit of a unique situation come up, I entered the tithing in the category that I figured I should but after talking about it to my Stake Clerk he mentioned that the amount should've gone into another category and that it isn't a big deal to change it.

I go in today and change that individual's tithing slip so that the one category became zero and the other one was increased and that was that. However, when I checked afterwards I noticed that the slip had now become out of balance with the box stating 'difference.' My tithing slip was now over by $40 instead of staying the same. I thought I maybe had made a mistake entering the adjustment so I made adjustment again, looked at it afterwards and now the slip was over by $80 and the batch report was now off by $80 as well.

After thinking about it, I thought perhaps it stays incorrect on my computer until someone from SLC makes the change. So I'm curious if that is indeed the case because all I was doing was moving the amount from one category to another. The amounts were correct.
jdlessley
Community Moderators
Posts: 9858
Joined: Mon Mar 17, 2008 12:30 am
Location: USA, TX

#2

Post by jdlessley »

19nazzy wrote:Last week when I entered the tithing in we had a bit of a unique situation come up, I entered the tithing in the category that I figured I should but after talking about it to my Stake Clerk he mentioned that the amount should've gone into another category and that it isn't a big deal to change it.

I go in today and change that individual's tithing slip so that the one category became zero and the other one was increased and that was that. However, when I checked afterwards I noticed that the slip had now become out of balance with the box stating 'difference.' My tithing slip was now over by $40 instead of staying the same. I thought I maybe had made a mistake entering the adjustment so I made adjustment again, looked at it afterwards and now the slip was over by $80 and the batch report was now off by $80 as well.

After thinking about it, I thought perhaps it stays incorrect on my computer until someone from SLC makes the change. So I'm curious if that is indeed the case because all I was doing was moving the amount from one category to another. The amounts were correct.
From your description of the actions you took to correct the donation category I can not tell if you followed the correct procedures. You may want to review the procedures in the Question and Answerssection of the Donations page at the LDSTech Wiki. If you followed those procedures all should be well.
JD Lessley
Have you tried finding your answer on the ChurchofJesusChrist.org Help Center or Tech Wiki?
19nazzy-p40
New Member
Posts: 17
Joined: Sat Mar 28, 2009 9:15 pm
Location: Canada

#3

Post by 19nazzy-p40 »

jdlessley wrote:From your description of the actions you took to correct the donation category I can not tell if you followed the correct procedures. You may want to review the procedures in the Question and Answerssection of the Donations page at the LDSTech Wiki. If you followed those procedures all should be well.
Yeah I followed that. I had two items in the Other area when just one of them should've had the entire cost. I just thought it was weird that the amount of the tithing slip increased when all I did was change x amount to 0.00 and added x to the other one.
User avatar
mkmurray
Senior Member
Posts: 3266
Joined: Tue Jan 23, 2007 9:56 pm
Location: Utah
Contact:

#4

Post by mkmurray »

19nazzy wrote:Yeah I followed that. I had two items in the Other area when just one of them should've had the entire cost. I just thought it was weird that the amount of the tithing slip increased when all I did was change x amount to 0.00 and added x to the other one.
I don't know anything about any of this, but I do have a guess at why it may be increasing each time. Perhaps instead of changing the values to $0, you were supposed to do a negative dollar amount in order to truly balance? It appears you are dealing with increments of $40, so perhaps it's -$40?

Somebody with financial experience should probably verify if my statements have any validity whatsoever. :rolleyes:
User avatar
aebrown
Community Administrator
Posts: 15153
Joined: Tue Nov 27, 2007 8:48 pm
Location: Draper, Utah

#5

Post by aebrown »

mkmurray wrote:I don't know anything about any of this, but I do have a guess at why it may be increasing each time. Perhaps instead of changing the values to $0, you were supposed to do a negative dollar amount in order to truly balance? It appears you are dealing with increments of $40, so perhaps it's -$40?

Somebody with financial experience should probably verify if my statements have any validity whatsoever. :rolleyes:
No, that really doesn't make sense. You're dealing here with a donation, where all amounts are positive. When you make an adjustment, you may make a number smaller than it was, but you would never enter a negative amount.

After the adjustment has been made, the Review step of the donation batch will show the original donation, and then immediately below that a line that shows the adjustment. That line will show something like -$40 in the Tithing column and +$40 in the Fast Offering column. But that is simply the result of the adjustment -- there is nowhere in the donation batch that you would ever enter the -$40.

So I would ask 19nazzy, what does the adjustment line look like in the Review panel of View/Update Donation? Does it have a -$40 in one column, a +$40 in another column, and a 0 (it actually shows in MLS as blank) in the Total column?
19nazzy-p40
New Member
Posts: 17
Joined: Sat Mar 28, 2009 9:15 pm
Location: Canada

#6

Post by 19nazzy-p40 »

Alan_Brown wrote:So I would ask 19nazzy, what does the adjustment line look like in the Review panel of View/Update Donation? Does it have a -$40 in one column, a +$40 in another column, and a 0 (it actually shows in MLS as blank) in the Total column?
I'm going from memory but I do not believe so. I know for sure there are no negatives. And each adjustment has $40 in the total column and as my Batch totals are $80 more than what actually in the deposit, I assumed that they were adding to total for some reason. In the review panel with the exception of the *** and note that mentions that is an adjustment, it really looks like those were additional donations.

The thing is the adjustment report that it printed out looked correct but the totals in the computer do not. I know for sure that when I go to edit that specific donation, it has the red 'difference' box there showing that the cheque amount does not equal the totals on the left.

In my other section:
Category X shows as $40 as it should.
Category Y shows as $80 when I know I changed it to zero.

Category X & Y were both originally $20 and I made the initial adjustment as Category X to $40 and Y to $0. When I reviewed it I had Category X as $40 and Category Y as $40 and my total balance was off by $40. I then went in with the 2nd adjustment and kept Category X the same but changed Y to $0. Upon reviewing after, Category X remained $40 but Category Y is now $80. And my total batch amount is off by an additional $80.

My question was if it will stay this way until SLC makes the adjustment? At first I was worried about it screwing up the deposit but as it was made on Sunday, it would've cleared by now.
User avatar
aebrown
Community Administrator
Posts: 15153
Joined: Tue Nov 27, 2007 8:48 pm
Location: Draper, Utah

#7

Post by aebrown »

19nazzy wrote:My question was if it will stay this way until SLC makes the adjustment? At first I was worried about it screwing up the deposit but as it was made on Sunday, it would've cleared by now.
CHQ will not actually adjust any deposit amounts in MLS, so it will stay this way forever unless you can fix it. CHQ has its own record of what your MLS transmitted to them. This will include:
  • The original transmission of the donation batch. You should have the Transmission Report that will tell you exactly what the total amount of the batch was.
  • Any adjustments. These are sent as MLS Messages, so you should be able to go into the "Sent Messages" section of "Messages" and find one or more messages with a subject of "MLS Adjustment". The message will list the batch reference number and date, and then for each category it will list the old amount, new amount, and change. The sum of the changes should be zero.
Based on the original batch transmission and adding in any adjustments, CHQ will have its record of what the batch total is, by category. This is what will be sent to you on the CUFS for May, and you will not be able to reconcile if it doesn't match MLS.

I'm having a hard time understanding how a slip could get out of balance. MLS won't let you adjust a slip and save the change if the left side (donation categories) and right side (funds received) don't match. I assume you are simply editing the existing slip and not clicking either the "New Slip" or "New Donation" buttons.

You may want to ask another clerk in your ward, or your stake clerk or stake financial clerk for assistance. These things are much easier to track down with a fresh set of eyes seeing what's actually happening in MLS.
19nazzy-p40
New Member
Posts: 17
Joined: Sat Mar 28, 2009 9:15 pm
Location: Canada

#8

Post by 19nazzy-p40 »

Alan_Brown wrote:I'm having a hard time understanding how a slip could get out of balance. MLS won't let you adjust a slip and save the change if the left side (donation categories) and right side (funds received) don't match. I assume you are simply editing the existing slip and not clicking either the "New Slip" or "New Donation" buttons.
It let me with no issues, the only thing it prompted me to do was print out a new batch report. And I clicked the save donation on the right side of the slip, not the New Slip or New Donation buttons.
Alan_Brown wrote:You may want to ask another clerk in your ward, or your stake clerk or stake financial clerk for assistance. These things are much easier to track down with a fresh set of eyes seeing what's actually happening in MLS.
Yeah. I sent an additional message to CHQ basically explaining the same thing that I did here. I'll have a talk with my Stake Clerk too. It's just weird, the adjustment reports I printed out look absolutely correct but the MLS totals seem incorrect.

I'll see if they get back to me and go from there. As I said before, it's not a huge deal if this takes some time to fix the amount would've cleared into the bank already so it's just some issues on our end to complete. We just had some issues from months before I was called just fixed on our last statements.
jbh001
Senior Member
Posts: 856
Joined: Thu Mar 13, 2008 6:17 pm
Location: Las Vegas, NV

#9

Post by jbh001 »

19nazzy wrote:I go in today and change that individual's tithing slip so that the one category became zero and the other one was increased and that was that. However, when I checked afterwards I noticed that the slip had now become out of balance with the box stating 'difference.'
When you try to save a slip that has a difference, you get a pop-up error like this:
Image


After making an adjustments you should also have to deal with another pop-up like this:

Image


When you make an adjustment, the review screen will have an entry like this one from the test database:
Image
The three asterisks indicates the previous donation slip that no longer counts.

I am still confused about how and where MLS is showing you are out of balance.

At the very worst, your database may be corrupted. I would get the stake clerk to check this error to be sure.

Another possibility is that MLS has become corrupted some how. The easiest way to fix that is to download and do a clean installation of MLS.

Another possibility that might explain what you described is that you have a computer with components that are beginning to fail.
Attachments
OutOfBalance.png
OutOfBalance.png (10.62 KiB) Viewed 1373 times
ReviewDetail.png
(3.67 KiB) Downloaded 103 times
Warning.png
Warning.png (6.89 KiB) Viewed 1373 times
19nazzy-p40
New Member
Posts: 17
Joined: Sat Mar 28, 2009 9:15 pm
Location: Canada

#10

Post by 19nazzy-p40 »

jbh001 wrote:When you try to save a slip that has a difference, you get a pop-up error like this:
Image
That never came up for me. And really it shouldn't as I never added more than what was originally there. I'll explain the 'out of balance' thing down in a bit.
jbh001 wrote: After making an adjustments you should also have to deal with another pop-up like this:

Image
That I did get and entered my reason.
jbh001 wrote: When you make an adjustment, the review screen will have an entry like this one from the test database:
Image
The three asterisks indicates the previous donation slip that no longer counts.
I do have the 3*** and the name/reason in the next box. I do not have a negative total where the -180.39 is. However, I do not believe I should as my error wasn't in the total amount, just the wrong category. Where the $219.61 is, I have the category entries there that I did make the changes to, but they are the original ones. X says $20, Y says $20 when I changed it to X $40, Y $0. And then where the $39.22 is, mine says $40.

Now because I made another adjustments, there are two of those same entries in the list. So mine looks like:
000|John Smith|$VVV.00||X $20/Y $20|$ZZZ
***|John Smith|$VVV.00||X $20/Y $20|$40
***|John Smith|$VVV.00||X $20/Y $20|$40
--------
Today I double checked the adjustment report that printed out and indeed it says that:
Old:
X $20
Y $20

New:
X $40
Y $0

Which is exactly what I want. But it wasn't showing that in my review screen as X/Y still both showed $20 as indicated above.

jbh001 wrote:I am still confused about how and where MLS is showing you are out of balance.
When I click on John Smith's receipt it shows me:
Tithing/Fast Offering/Etc.. Categories: Correct
Other: Is higher than it should be. - The adjusted amounts appear to have added themselves into the Y category when I have changed them to zero, twice!

So my total's for his tithing slip (left side of the screen) are more than what he actually paid (right side of the screen). I have the box on the lower right hand screen in red that says -$80.00 difference. It appears to me, that the total value of the adjustments (-$20 from one, +$20 to the other, twice) are placing themselves in Category Y for an unexplained reason.

On the batch report that it printed out after my adjustments, the total deposit amount on the first one increased by $40, and increased by another $40 after the 2nd adjustment. Thus currently, my total deposit report for that week is $80 more than it actually was.
jbh001 wrote:At the very worst, your database may be corrupted. I would get the stake clerk to check this error to be sure.

Another possibility is that MLS has become corrupted some how. The easiest way to fix that is to download and do a clean installation of MLS.

Another possibility that might emplain what you described is that you have a computer with components that are beginning to fail.
I guess those are possible but this is the only error that I see. I did my April reconiliation and everything was fine. I did both tithing/expenses today and everything looks fine. The only thing I can see is that something is messed up when trying to do an adjustment [edit: See my next post]. Unfortunately my Stake Clerk is away for a little while (of all the times!), which is why I came here to see if anyone had seen something like this before.
Post Reply

Return to “Local Unit Finance”