Assigning amounts of a Fund to another accounting fund.

[Mary Anne]

Question: In my Contribution Module (version 10) I can assign a % of a fund to be posted to a different fund in Accounting. Does the new version 11 allow you to place a specific amount rather than a % ? We would like to be able to save a specific amount out of the General Budget Fund and after that amount is out be able to divide up what is left by %. Could that be made possible in future versions if it is not available now?
Thanks,
Mary Anne

[NeilZ]

Question: In my Contribution Module (version 10) I can assign a % of a fund to be posted to a different fund in Accounting. Does the new version 11 allow you to place a specific amount rather than a % ? We would like to be able to save a specific amount out of the General Budget Fund and after that amount is out be able to divide up what is left by %. Could that be made possible in future versions if it is not available now?
Thanks,
Mary Anne

Its not available now, although it does sound like something that could be added in future.

That said, say you want to save $1000 every Sunday, but only $900 comes in, would that be OK, everything going into a designated or restricted fund??

[Mary Anne]

My intention was to keep all apsolutely necessary moneys in the General Fund for salaries, electric, and other bills and then divide up any remaining monies into specific catigory funds like Fellowship & Activities, Library, etc. The percentages would only come into play after the specified amount was met. If that amount wasn't met no % would be taken out. We'd be in serious financial difficulties in that case and I guess the amount not collected one week would have to be added to the next week's specified amount before any % were taken out.
Right now we take out a % off the top for Missions - CP, State, etc. We could probably figure out different % to take the amount out after the specified amount. Guess it would be too complicated to take some % out of the total and then the rest out after the specified amount was met. But that would be great if if could be done!
Mary Anne

[NeilZ]

My intention was to keep all apsolutely necessary moneys in the General Fund for salaries, electric, and other bills and then divide up any remaining monies into specific catigory funds like Fellowship & Activities, Library, etc. The percentages would only come into play after the specified amount was met. If that amount wasn't met no % would be taken out. We'd be in serious financial difficulties in that case and I guess the amount not collected one week would have to be added to the next week's specified amount before any % were taken out.
Right now we take out a % off the top for Missions - CP, State, etc. We could probably figure out different % to take the amount out after the specified amount. Guess it would be too complicated to take some % out of the total and then the rest out after the specified amount was met. But that would be great if if could be done!
Mary Anne

This sounds like you'd be better off doing this as transfers between funds in Funds Accounting, in that way you can have better control over what you would be moving.

Doing this via the entry in under the Contribution Fund would involve you having to change either the percentage or fixed amount every week as required. Doing this in FA would just require one monthly transfer at the end of the month.

[Mary Anne]

I don't think we have ever come below what our specified amount is for necessities. I doubt that figure would have to be changed from week to week. I was just answering your what if... If the program allowed you to put in a specific amount, that amount could be transfered to an account set up as an Opperating Fund on the accounting side and kept separate from the rest. If the % would work on what was left after that was removed from the General Budget then the %'s wouldn't have to be changed.

Our financial committee wants to use Excel to show weekly accrual for all the various accounts which has never been done before. They said Excel formulas can be set up and after that it would just be a matter of plugging in the weekly contribution amount. I was just trying to find a way to avoid the separate transfers in accounting which we have never really done for accruals. The Treasurer has just been keeping a paper tracking of them and then prints out a monthly report. She list the expenses, substracting them first and giving the balance, then she substracts the total figure for the accruals and gives the available funds total. The listing of the Accruals is on a separate page. She went back to the hand typed report as the people couldn't follow the report printed by the program which she still prints & distributes. If what I suggested could be done it would eleminate all this extra work for the Treasurer.

Mary Anne,
Financial Sec.