Adjusting Negative Budget Balances

Discuss questions around local unit policies for budgeting, reconciling, etc. This forum should not contain specific financial or membership information.
AlvinPeterson
New Member
Posts: 4
Joined: Fri Nov 01, 2013 9:55 pm

Adjusting Negative Budget Balances

Postby AlvinPeterson » Tue Feb 16, 2016 6:22 pm

I'm trying to correct an unexpected result of my own doing. I corrected expenses drawn from the wrong categories during the year AFTER the beginning of the new year. Some of these expenses were drawn against budget and should have been from an Other Member Financed Activity and some were drawn against Other that should have been budget. The key to my problem (I believe) is I adjusted these expenses after January 1st. I now have budget categories starting off the new year with negative balances. While this won't impact budget allocation, it does impact budget reporting for the remainder of the year. Are there any tricks to correcting this?
Alvin Peterson
Plano 6th Ward
Plano Texas Stake

jdlessley
Community Moderators
Posts: 6522
Joined: Sun Mar 16, 2008 11:30 pm
Location: USA, TX

Re: Adjusting Negative Budget Balances

Postby jdlessley » Tue Feb 16, 2016 6:37 pm

How did you make the corrections/adjustments? Did you make transfers or did you recategorize?
JD Lessley
Have you tried finding your answer on the LDS.org Help Center page or the LDSTech wiki?

AlvinPeterson
New Member
Posts: 4
Joined: Fri Nov 01, 2013 9:55 pm

Re: Adjusting Negative Budget Balances

Postby AlvinPeterson » Tue Feb 16, 2016 6:39 pm

I recategorized the original expenses.
Alvin Peterson
Plano 6th Ward
Plano Texas Stake

AlvinPeterson
New Member
Posts: 4
Joined: Fri Nov 01, 2013 9:55 pm

Re: Adjusting Negative Budget Balances

Postby AlvinPeterson » Wed Feb 17, 2016 4:35 pm

Hmmm, I'm guessing there isn't an easy "this is how you fix it" answer.
Alvin Peterson
Plano 6th Ward
Plano Texas Stake

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

Re: Adjusting Negative Budget Balances

Postby russellhltn » Wed Feb 17, 2016 5:17 pm

For myself, I'd be cautious about giving advice that goes badly.

If I understand the situation right, by recategorizing an expense from a different year, an adjustment was made to someone's budget subcategory that negativity impacts them. IIRC, at the end of the year, all budget funds are swept into a single parent category. While the ward gets to carry over it's budget funds as a whole, all the individual balances in the subcategories are lost - swept to the main account. So this adjustment ended up being applied to an account that had already been zeroed out.

My suggestion is to create a transfer from the main budget account to this sub account to nullify the adjustment for the affected subcategory. The Other account should be just fine because it always carries over balances from year to year, so it's balance is accurate. Since the transfer is within the budget category, the overall budget is unchanged.
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: 2024
Joined: Mon Sep 24, 2007 8:17 am
Location: Cumming, GA, USA

Re: Adjusting Negative Budget Balances

Postby eblood66 » Wed Feb 17, 2016 6:17 pm

russellhltn wrote: IIRC, at the end of the year, all budget funds are swept into a single parent category.

That's kind of right but not quite. At the beginning of the year all budget categories are set to 0. Any budget funds not used in the previous year will be carried over and will be part of the total available funds to be allocated to budget categories. But those funds don't show up in a parent category. Technically I think they are in the Budget Allocations category but that category is special and isn't treated like the others. It's best to think of that category just as the amount available to allocate to other categories.

russellhltn wrote:My suggestion is to create a transfer from the main budget account to this sub account to nullify the adjustment for the affected subcategory.

My suggestion is similar but slightly different since there really isn't a main budget account. I would create a new category (which I've generally called Prior Year Expenses) and then make transfers from this Prior Year category to the negative categories in order to zero them out. After doing this you'll have zero balances in all the categories except Prior Year Expenses which will be negative.

Then when you set the budgets you should allocate just enough to Prior Year Expenses to compensate for the negative balance. The remainder of your total budget allocation can then be allocated to the other categories like normal.

AlvinPeterson
New Member
Posts: 4
Joined: Fri Nov 01, 2013 9:55 pm

Re: Adjusting Negative Budget Balances

Postby AlvinPeterson » Wed Feb 17, 2016 6:53 pm

Thanks brethren. I like the 'Prior Year Expenses' idea. I'll give that a shot and see if I can make it work. I really appreciate the ideas/suggestions. Lesson learned... reconcile BEFORE the end of the year!
Alvin Peterson
Plano 6th Ward
Plano Texas Stake

robwhitney
New Member
Posts: 1
Joined: Fri Nov 29, 2013 8:21 pm

Re: Adjusting Negative Budget Balances

Postby robwhitney » Sat Apr 09, 2016 4:29 pm

Can I ask, how are you doing transfers to the Budget Sub-Categories. When I try to do this in MLS, I am unable to select the Budget Sub-Categories, therefore, unable to transfer between budget categories. I currently have huge balances in accounts I tried to close and negatives in the parent main budget category. I would like to get everything evened out so my budget reports looks accurate.

jdlessley
Community Moderators
Posts: 6522
Joined: Sun Mar 16, 2008 11:30 pm
Location: USA, TX

Re: Adjusting Negative Budget Balances

Postby jdlessley » Sat Apr 09, 2016 6:05 pm

Budget funds are allocated to the unit budget subcategories in the "View/Edit Budget" menu item. The "transfer" is made by inputting the allocation amounts into each of the subcategories. The allocations are not really transfers since each of the unit budget subcategories exist currently only in the local MLS. Church headquarters does not see these locally created subcategories. As such they only see the overall unit budget amount.
JD Lessley
Have you tried finding your answer on the LDS.org Help Center page or the LDSTech wiki?


Return to “Local Unit Finance”

Who is online

Users browsing this forum: jessehiatt and 1 guest