I have had it. I am tired of looking for $5.90 every month.
Please does someone have a sure fire way to make reconciling these easier??
Church Distribution Invoices
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
kmalone wrote:I have had it. I am tired of looking for $5.90 every month.
Please does someone have a sure fire way to make reconciling these easier??
Without knowing just what you are doing now, it's difficult to know what would be easier. The nice thing about reconciliation is that there is nothing hidden -- every expense, deposit, and transfer that has cleared is listed on your CUFS, and every MLS transaction can be examined. So if you are patient and systematic, you can always reconcile.
The Budget category can be a bit tricky, since it is zero-based and thus you can balance to the ending balance of each category, even if you fail to record or check off an item in the Budget category. It is possible to reconcile the Budget category by using the YTD totals at the end of the CUFS. A process for doing this is described HERE.
Another issue with Distribution Center invoices is that sometimes the people who make the charges fail to turn in their receipts. But the bishop or stake president is always sent a separate invoice, so the charges should not be a complete mystery, even if you may not be sure just what Budget subcategory to charge the invoice to until you do a bit of detective work. But that would not affect your ability to reconcile.
-
- Member
- Posts: 89
- Joined: Sun Jun 22, 2008 5:03 pm
-
- Senior Member
- Posts: 1267
- Joined: Mon Jul 07, 2008 4:05 pm
- Location: USA
Is it your budget category that is off? I'm probably stating the obvious here, but it appears that once either an expense didn't get entered, or an outstanding check was marked as having cleared when it really hasn't. You've probably tried these, but here goes:kmalone wrote:My complaint stems from always having to find $5.90 in the process of reconciliation. The kicker is I manage budgets over $8 mil on more sophisticated systems. This tells me I am not looking at the obvious, the link helps.
If an expense didn't get entered, the easiest would be to go through the miscellaneous section of your old statements until you find a charge for that amount. Once found, check the reconciliations for that month to see if the expense was ever entered in MLS. If not, enter it.
If it's an outstanding check, compare the printout of outstanding checks from the reconciliation report to the list in your statement. They should match exactly.
Another option for at least locating the expense in MLS (if it exists) is to "view expenses". Sort by amount, and find an expense for $5.90.
I guess another possibility is that an expense got entered incorrectly. Hopefully the YTD method helps with that...
-
- Community Administrator
- Posts: 34490
- Joined: Sat Jan 20, 2007 2:53 pm
- Location: U.S.
It's an old trick, but it probably bears repeating: Add up all the digits of the missing amount and see if they add up to a multiple of "9". If so, then the problem may be that a couple of digits got swapped somewhere.
That kind of problem can be difficult to find since all the transactions are there and unless you carefully check for that, you may not see it. Using this example, $5.90 would not be a digit swap problem, but 27¢ would be.
That kind of problem can be difficult to find since all the transactions are there and unless you carefully check for that, you may not see it. Using this example, $5.90 would not be a digit swap problem, but 27¢ would be.
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.
-
- Member
- Posts: 89
- Joined: Sun Jun 22, 2008 5:03 pm
October Balanced (zeros)
Okay, found the problem.
But I am curious, I balanced October (zeroed unreconciled), and I was curious and looking at Aug and September which now show numbers where there should be zeros while October is balanced.
Please tell me this is normal in how MLS handles this. Should each month remain at zero?:(
But I am curious, I balanced October (zeroed unreconciled), and I was curious and looking at Aug and September which now show numbers where there should be zeros while October is balanced.
Please tell me this is normal in how MLS handles this. Should each month remain at zero?:(
- aebrown
- Community Administrator
- Posts: 15153
- Joined: Tue Nov 27, 2007 8:48 pm
- Location: Draper, Utah
This is normal MLS behavior when you look at previous months.kmalone wrote:Okay, found the problem.
But I am curious, I balanced October (zeroed unreconciled), and I was curious and looking at Aug and September which now show numbers where there should be zeros while October is balanced.
Please tell me this is normal in how MLS handles this. Should each month remain at zero?:(
MLS doesn't really handle going back to look at previous reconciliations. The fundamental problem is that for each transaction there is only one indicator of whether it is cleared. So if a check was outstanding for September, the check box by the check (and its corresponding transfer, if any) would have been unchecked as you reconciled September's statement. But then if that check cleared in October, as you were reconciling October's statement, you would have checked off the check.
When you then return to examine the September reconciliation, that check will now be checked off as cleared, even though it was not cleared as of September 30. That could lead to September's reconciliation no longer being in balance. There are several other similar issues, such as corrections made to September deposits or expenses, or voiding of checks, that can also cause previous reconciliations to no longer balance.
The simple rule is to reconcile each month and print out the reconcilation form. "Go forward and not backward" (D&C 128:22), as it will be difficult or impossible to recreate the situation that existed when you reconciled a prior month.
-
- Member
- Posts: 89
- Joined: Sun Jun 22, 2008 5:03 pm