We have a situation where the Church pays the Electric and Water bills, and is reimbursed by the High School that uses our premises, for a fixed % of each individual bill. There are two electric bills, and three water bills. The Church receives the bills, passes them to the High School, they calculate their percentage, write the Church a single check for the HS share. The Church deposits that as income, off setting the HS share of the total individual bills, and then pays the bills.
The Electric and Water expense accounts are already set up as a combined single account "Utilities", level 4 group account as 25-5030-000.
I want to expand these to Electric, level 5, group as 25-5030-100, with the meters as level 6, detail, meter 1 is 25-5030-110, and meter 2 is 25-5030-120.
The water meters would be: Water, level 5, group, 25-5030-200, and meters 1, 2 and 3 as level 6, detail as 25-5030-210, -220, and -230.
That allows the reports to be printed in any level of detail required. The Church council is only interested in the level 4 group, but I want the level 6 details available to me.
I would like to set up the percentage that the High School reimburses us,
as income accounts with the same level of detail for each meter.
Do these income accounts have to have the same account numbers, except using 25-4030-000 for Utilities, with the others following, or can they be set up as Utilities, 25-4230-000, followed by Electric 25-4230-100,
followed by 25-4230-110 and so forth.
This is because the first income listing is Income, level 2, Group, 25-4100-000, followed by Offerings as 25-4105-000, level 3 group, followed by various level 4 detail accounts. Then comes the HS Occupancy agreement as level 3, group,25-4205-000, and level 4 detail, 25-4210-000.
If I use the 25-4030 series, that falls before the income heading, and would not be listed under income.
Using the 25-4230 series they would fall in sequence under the H S occupancy agreement as income.
Will that work, or must I make other changes in the Income account listings?
Does the fund number in expense and income have to match?
Moderators: Moderators, Tech Support
-
- Posts: 83
- Joined: Tue Sep 23, 2003 4:22 pm
- Location: Our Redeemer Lutheran Church
-
- Program Development
- Posts: 1225
- Joined: Fri Sep 05, 2003 11:43 am
- Location: PowerChurch Software
- Contact:
There is no tie between the expense accounts and income accounts based on account number. So the account number you use to record the money coming in should have no effect on your reporting. And as you pointed out, if you try to, it will put the accounts in the wrong section within the income accounts.