Page 1 of 1
Setting up a Restricted Fund...Part Trois
Posted: Wed Aug 22, 2012 3:28 pm
by Roy MacLean
OK...I've set up the bookwork as outlined in Part Deux. Had to make two changes in account numbers...01-5840-000 is now 01-5410-000, and the "Winter Account" is renamed the Radio Advertising Fund.
I'm still having a rough time getting my head around how to reconcile the checkbook for the ONE account that I have. All the money for the Radio Advertising Fund comes in from the ONE account. If I post the monies coming in through Radio Advertising Fund (Contributions Fund 201), that makes the ONE account short by a like amount. How do I handle this so that I can balance the ONE Account that contains both the General Fund and the Radio Advertising Fund?
Re: Setting up a Restricted Fund...Part Trois
Posted: Wed Aug 22, 2012 4:32 pm
by JohnDMeyers
I need to know what the account number where you have Fund 201 pointing to, and what is the account number of the account that is short.
Does the Radio money get deposited in the General Fund checking at the bank?
Fund 201 should be pointing to the account number that represents the physical bank. In other words, if you are depositing the Radio money in a savings account, and Fund 201 debits a checking account, that won't work very well.
Re: Setting up a Restricted Fund...Part Trois
Posted: Mon Sep 17, 2012 12:00 pm
by Roy MacLean
JohnDMeyers wrote:I need to know what the account number where you have Fund 201 pointing to, and what is the account number of the account that is short.
Does the Radio money get deposited in the General Fund checking at the bank?
Fund 201 should be pointing to the account number that represents the physical bank. In other words, if you are depositing the Radio money in a savings account, and Fund 201 debits a checking account, that won't work very well.
John, Fund 201 points to the General Fund checking...if I am understanding what you are asking for. The money for the Radio Fund comes in through the General Fund checking account at the bank.
Re: Setting up a Restricted Fund...Part Trois
Posted: Mon Sep 17, 2012 1:08 pm
by JohnDMeyers
Ok. So you deposit the money in the checking account at the bank, and you record it in PowerChurch as being in the checking account. That is good, so far.
Here's how I think I would set things up to do what you are trying to do, and have only one account to reconcile.
01-1110-000 checking
01-1110-101 Radio Fund
Create restriction:
01-3210-101 Radio Fund Equity (Temporarily Restricted)
01-4210-101 Radio Fund income (Temporarily Restricted) closes to 3210-101
01-4810-101 Radio Fund Release (Temporarily Restricted) closes to 3210-101
Contribution Fund 201
01-1110-101 Radio Fund
01-4210-101 Radio Fund income
Expense account
01-5410-000 Winter Account (closes to 01-3110-000 unrestricted)
Once you have all these accounts, money comes into fund 201 in Contributions, and out through 01-5410-000 with a release, like this:
Spend $50
CR 01-1110-101 Radio Fund $50
DB 01-5410-000 Winter Account $50
DB 01-4810-101 Radio Fund release $50
CR 01-4999-000 general release $50
Re: Setting up a Restricted Fund...Part Trois
Posted: Mon Sep 17, 2012 1:09 pm
by JohnDMeyers
Make sure 01-5410-000 closes to 01-3110-000 unrestricted net assets.
This is a common mistake, to have it close to a restricted equity fund.