Termporarily Restricted accounts not working...

[rlcox]

I have a few temporarily restricted accounts and every time I have set them up, I have gone back to the manual and followed the instructions for setting these accounts up. However, something isn't right. When I click on the Release Restricted Funds button, only the first two accounts show up. I can't choose the other accounts even though I have them set up the same as the first two. What am I missing? My reports are showing I still have $725 in a scholarship fund that only has $375 left, as well as other similar situations. Thanks!

[JohnDMeyers]

I'm not sure what you are calling accounts.

If you use the Maintain Donor Restriction wizard, you can name the restrictions. You say that only two "accounts" are showing up. Do you mean that only two "named" restrictions are showing up or only two "account numbers" are showing up?

When you release from restriction, two accounts should appear, by the way.
One is the contra-income account, usually in the 01-4810-000 range, and the other is the general release income account, typically 01-4999-000.

Are those the two accounts (the numbers may not be an exact match to my example)?

This thread covers setting up temporarily restricted accounts.
http://powerchurch.com/forum/viewtopic. ... ion#p14579

[rlcox]

I have five temporary restrictions:

Mission and Ministry
Christmas Candy
Bridges to the Future
Choir Robes
Community Scholarship Fund

I have set them all up in the same way. I have had to pull the instructions each time because I can't remember what accounts I need to set up so I pull out the instructions that were separate from the manual and go through it each time I have a restriction.

When I push the Release Restrictions button when writing a check, only the Mission and Ministry and Christmas Candy accounts are listed. I am not given the option to release the Bridges or choir robe money. I actually have at least two other monies that should be restricted but have ceased setting up TR because I can't access anything.

So my reports show that I still have $750 sitting in the scholarship fund when actually there should only be $400 left. We bought the choir robes and exhausted all the funds but when I run reports it shows I still have $2,300 in the fund because I wasn't able to release them.

Does that make more sense?

Thanks!

[JohnDMeyers]

When you say that it shows you have $750 still in the scholarship fund, I think you are reporting to me that you see $750 in the Income account for scholarship. If that is the case, then you are seeing the correct amount. When set up correctly, your Temporarily Restricted Equity account tells you the balance still under restriction.

Here's the scenario:

There are three accounts unique to each restriction:
01-3210-000 Scholarship Equity (Temp Restriction section of Equity)
01-4210-000 Scholarship Income (Temp Restriction section of Income) [closes to 01-3210-000]
01-4810-000 Scholarship Release [closes to 01-3210-000]



When you receive $750.00 into your Scholarship Income (and General Checking), your Income and Expense Statement and Balance Sheet report together will show this:

01-4210-000 $750.00 (income and expense)
01-3210-000 $750.00 (balance sheet)

When you release $350.00 you show this:
01-4210-000 $750.00 (income and expense)
01-3210-000 $400.00 (balance sheet)

and when you release the remaining $400.00 you show this:
01-4210-000 $750.00 (income and expense)
01-3210-000 $0.00 (balance sheet)

The release of $350.00 does this:
DB 01-4810-000 $350.00 (closes to 01-3210-000)
CR 01-4999-000 $350.00 (closes to 01-3110-000)

NOTE: the 01-4210-000 is not affected. 01-3210-000 and 01-3110-000 are affected because they are respective equity accounts that 4810 and 4999 close to.

You can "manually" adjust your restricted amounts once you see what is happening with all the accounts.

Your "Changes in Equity" report in Fund Accounting is a handy picture of this whole scenario as well.