Income and Expense Detail Report - Out of Balance

Discuss where to obtain or how to fill out specific reports or forms.
jae_markham
New Member
Posts: 2
Joined: Wed Sep 21, 2016 10:15 am

Income and Expense Detail Report - Out of Balance

Postby jae_markham » Fri Sep 22, 2017 10:52 am

I have run an Income and Expense Detail Report for a Ward Missionary.

Missionary Donations shows $3515.00 (Sister Missionary)

Expenses Shows $7200.00

Transfers Shows $3000.00

Ending Balance $-685.00

Ending Balance should be $-85.00....HOW CAN I CORRECT TO SHOW THAT IT IS ONLY $85 THAT IS OWED BY THE FAMILY?

eblood66
Senior Member
Posts: 2454
Joined: Mon Sep 24, 2007 8:17 am
Location: Cumming, GA, USA

Re: Income and Expense Detail Report - Out of Balance

Postby eblood66 » Fri Sep 22, 2017 12:36 pm

Are you looking at the entire period for the missionary? The default view usually only shows the current year. If there was a negative balance at the beginning of the year then you'll see something like that. So if the missionary left before the beginning of the year then you'll need to use a custom period to get the entire picture.

I don't have MLS in front of me but there should be a drop down box in the upper right corner which indicates the time period for the report. Use the Custom option and select dates that cover from the month before the missionary left until the current date.

russellhltn
Community Administrator
Posts: 22542
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

Re: Income and Expense Detail Report - Out of Balance

Postby russellhltn » Fri Sep 22, 2017 12:36 pm

How are you getting $-85.00? I used the numbers you gave and got the same ending balance. ($3515 - $7200 + $3000 = -685)

Where is the extra $600 coming from?

Edit: I notice you're not listing an opening balance. And since most missions last longer then a calendar year, that's probably the issue.
Have you searched the Wiki?
Try using a Google search by adding "site:tech.lds.org/wiki" to the search criteria.

eblood66
Senior Member
Posts: 2454
Joined: Mon Sep 24, 2007 8:17 am
Location: Cumming, GA, USA

Re: Income and Expense Detail Report - Out of Balance

Postby eblood66 » Fri Sep 22, 2017 1:36 pm

russellhltn wrote:How are you getting $-85.00? I used the numbers you gave and got the same ending balance. ($3515 - $7200 + $3000 = -685)

Your right. I should have checked the math. Based on those numbers nothing looks out of order. $7200 is 18 * 400 so it probably is the entire mission amount.

jae_markham
New Member
Posts: 2
Joined: Wed Sep 21, 2016 10:15 am

Re: Income and Expense Detail Report - Out of Balance

Postby jae_markham » Fri Sep 22, 2017 1:55 pm

I will check the dates when I go back to the chapel and run the Report, I think that is probably the issue.

Thank you for your Responses!

scgallafent
Church Employee
Church Employee
Posts: 1250
Joined: Mon Feb 09, 2009 4:55 pm
Location: Riverton, Utah

Re: Income and Expense Detail Report - Out of Balance

Postby scgallafent » Fri Sep 22, 2017 4:22 pm

jae_markham wrote:I will check the dates when I go back to the chapel and run the Report, I think that is probably the issue.

Are you running the report from MLS or LCR Finance? You can generate the income and expense report for a missionary from LCR Finance.

From the Income and Expense Summary page, click the arrow next to Ward Missionary Fund and then click on the missionary's name. The report defaults to the current year, but you can set a custom date range to extend back to before the start of the missionary's mission.


Return to “Reports and Forms”

Who is online

Users browsing this forum: No registered users and 1 guest