Page 1 of 1

Audits & Audit Issues

Posted: Thu Nov 15, 2007 1:30 pm
by ddbrownphd-p40
I'd like to hear suggestions on how best to prepare for and handle audits.

In particular the reconcilation of the Other account seems to almost always be a problem. Even though everything reconciled at one time, once a change is made then the Income & Expense report pulled from MLS no longer matches the monthly reconcilaton report. What is the best way to do the audit reconciliation? This is a recurring problem for most of the units in our stake.

Posted: Sun Nov 18, 2007 2:15 pm
by atticusewig
In our stake, our auditors are instructed
to use the "Custom" option for the date
range in the Income/Expense report,
and set it to the audit period.
That way any changes made after
the audit period won't affect balancing
the "Other" account.

- Atticus

Changing old transactions

Posted: Mon Dec 17, 2007 9:51 am
by aebrown
atticusewig wrote:In our stake, our auditors are instructed to use the "Custom" option for the date range in the Income/Expense report, and set it to the audit period. That way any changes made after the audit period won't affect balancing the "Other" account.

Unfortunately, the above statement is not true. In MLS you can make corrections to checks and donations after the fact (even after the year end), which will affect reports for earlier time periods.

For example, I can generate an Income and Expense report for Jan 1-Jun 30 and print it out. Then on August 20 I notice that a check written for $100 against the Other category on April 15 really should have been in the Budget category. I go to the check and change the category of the check.

If I now run that same Income and Expense report, I will find that there is $100 less in expenses, and a resulting balance that is $100 higher. This happens because the MLS transaction that makes the correction has a date of April 15, even though the transaction that shows the correction on the Church Unit Financial Statement will have a date of August 20. In my opinion, this is incorrect. A transaction automatically generated in MLS should have the same date it will have on the CUFS.

This odd way of doing accounting creates a moving target. You can't have a consistent month-end close, you can't have a reliable Income and Expense Report for a past time period, and you can't go back and reconcile a previous month and expect to see the same numbers you saw when you reconciled it the first time. I just spent two hours with a ward financial clerk trying to dig through a maze of transactions and corrections, some affecting the previous year, and many affecting previous months, and it was a lot harder than it had to be, since I could not generate reports that corresponded properly to any CUFS.

troubles with 'Other' accounts

Posted: Mon Dec 31, 2007 1:30 pm
by rwardell-p40
Along this same line I have been working with a ward who has been chasing some errors in the way the other account is used. As a result, adjustments were made (Check was sent to SL) so the Monthly report from Salt Lake is '0' but there is still a remaining balance showing in the local ledger. The local clerk took over and has been unable to find when this error was made. Can anyone help me get this taken care of without throwing off the reconciliations for the past year as this has drug on for some time.