Stake Audit Request

Discuss where to obtain or how to fill out specific reports or forms.
kmalone-p40
Member
Posts: 89
Joined: Sun Jun 22, 2008 4:03 pm

Stake Audit Request

Postby kmalone-p40 » Sun Aug 17, 2008 4:18 pm

Just finished my Stake Audit and and was asked for a print out for the sub-categories of the "Other" budget.

Is there a default report for this or something else?

1historian-p40
New Member
Posts: 49
Joined: Sun Mar 16, 2008 8:36 pm
Location: North Higlhands, California

other catagory

Postby 1historian-p40 » Sun Aug 17, 2008 5:20 pm

I assume you are talking about your financial audit. If so what you do is click on income expense report under the finance category and then change report type to summary by subcategory and then check the box next to "other". it will then select all of the other accounts and display them on one page for the auditor. you can also select the time period so it will be accurate for the audit i.e June 30th or DEC 31st.

kmalone-p40
Member
Posts: 89
Joined: Sun Jun 22, 2008 4:03 pm

Postby kmalone-p40 » Sun Aug 17, 2008 7:03 pm

1historian wrote:I assume you are talking about your financial audit. If so what you do is click on income expense report under the finance category and then change report type to summary by subcategory and then check the box next to "other". it will then select all of the other accounts and display them on one page for the auditor. you can also select the time period so it will be accurate for the audit i.e June 30th or DEC 31st.



But how do you print it?

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

Postby lajackson » Sun Aug 17, 2008 7:42 pm

kmalone wrote:But how do you print it?


After you do everything in 1historian's post, look at the bottom left corner of the screen and click on the Print button. Click ok when the Windows printer box appears.

Or did I entirely misunderstand the question?

kmalone-p40
Member
Posts: 89
Joined: Sun Jun 22, 2008 4:03 pm

Postby kmalone-p40 » Mon Aug 18, 2008 6:18 am

The way it is described above is what I looked for.

I don't recall "Other" being a Sub-category. I think I know what the problem is.

Thanks.

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

Postby lajackson » Mon Aug 18, 2008 9:00 am

kmalone wrote:I don't recall "Other" being a Sub-category. I think I know what the problem is.


Other is one of the categories, and it usually has a number of subcategories. The auditor is looking for the contents of the Other account and the purpose of the funds in that account. The MLS report is the best way to obtain that information for the audit.

Be sure to change the report type to Summary by Subcategory, and it helps to select a custom period, in the case of this audit, from 1 Jan 2008 to 30 Jun 2008.

MLS > Finance > More
Under Reports/Reconcile select Income and Expense Report

Change Report Type to Summary by Sub-Category
Change Date Range to Custom and pick the start and end dates [1 Jan 2008 to 30 Jun 2008]

Check the box next to Other
(This will also cause all of the Other subcategories to be checked)

Print.

Happy auditing.

clerker-p40
Church Employee
Church Employee
Posts: 12
Joined: Fri Nov 02, 2007 10:46 am

Postby clerker-p40 » Tue Aug 19, 2008 10:54 pm

If you have a balance in the plain 'other' account it is because something was entered in from a reconcile. This is usually because of an NSF Check, a deposit error, or an incorrect entry. You can find out where the balance came from in your Income and Expense Report. Select 'Details by Sub-Category' and choose the 'other' account. Make sure you show the applicable date range. There shouldn't be any expenses or donations, since MLS will not allow those transactions from other. The transfers portion of the report will show 'other item' entries in the reconcile and transfers done. You can go to the reconcile month shown by the date and adjust the entries out of other.

kmalone-p40
Member
Posts: 89
Joined: Sun Jun 22, 2008 4:03 pm

Postby kmalone-p40 » Wed Aug 20, 2008 1:10 pm

I appreciate all the help but I have a suspcion that there was an error in budget set up for classifying sub-categories into the Other account.

I need to drop by the WC office to verify this first, I want to be careful here, you never know who at the stake level is reading this. :p


I could be totally wrong and not know what I am looking at.:rolleyes: Probably the case.....

Esogs-p40
New Member
Posts: 5
Joined: Sun Apr 06, 2008 9:49 pm

Postby Esogs-p40 » Sun Aug 24, 2008 2:51 pm

I was also audited today, and asked to print out the other account for the months being audited. Which I did, only to find that the Other balances didn't match the MLS other balances in the monthly reconciliation report.

So, I do the reconciliation report monthly, it has the starting and ending balances from the bank, and then the MLS balance, and then any adjustments, and they adjust to $0.00 which is what I think they are supposed to do.

But then, when in August, when I print the "Other" balance with a custom date of Jan 1 to Jan 31, the balance doesn't match what is in the church finance report, nor what is on my monthly reconciliation for that month. Its like, it matched in January, but it doesn't match running a custom report in August for January.

I don't know if this is clear enough, but I'm really confused. Also, if I go "back" now and look at past reconciliations, I see that at least some of them no longer reconcile. In other words, my printed reconciliation from January 2008 which did reconcile, if I re-run the reconcilation for January, now no longer reconciles.

I think I might be missing something.

Esogs-p40
New Member
Posts: 5
Joined: Sun Apr 06, 2008 9:49 pm

Today's updates affects past reconcile

Postby Esogs-p40 » Sun Aug 24, 2008 3:23 pm

I just found this discussed in the forum thread:

http://tech.lds.org/forum/showthread.php?t=768&highlight=reconcile

If the information here is correct, when our Stake Auditor comes by and asks us to run an Income/Expense report for the month that they are auditing, the auditor should NOT be surprised if the Income/Expense report doesn't match the church finance statement or the reconciliation report for that month.

Basically, if any adjustments were made to things like categories, such as if you are correcting an entry for a member from one category to another, that correction is recorded in the month the transaction was first entered, not in the month you are making the correction.

It is sometime pretty hard for me to follow what is happening on the reconcilations.


Return to “Reports and Forms”

Who is online

Users browsing this forum: No registered users and 1 guest