I've printed a sub account report below based on my -104 sub accounts. I just did a preview of this post and the report is all bunched together. Hopefully you can understand my question.
When I initially set it up the accounts my thinking was to combine our Student Ministries info, both the General Fund budgeted income/expenses and the Restricted Fund income/expenses, into one report so I could see the whole picture. But I've discovered that having the Release account with a -104 sub account is causing a double-dip of the expenses. When I spend Restricted money the report shows it coming out twice, once out of the 4850-104 release account and once out of the 5512-104 expense account.
To fix this, can I just move the 4850-104 account to a new account of 4850-000, and make sure it is the restricted release account for Student Ministries? Then when I print the sub account report this one will be missing and I'll see what's available for Student Ministries?
Thank you,
Nancy
07/06/2014 08:12 PM Sub-account Report Page: 1
July 2013 - May 2014
Budget
Account Account Name Category Beg. Balance Period Curr. Balance Annual Difference
Sub-account 104
01-4240-104 Student Min. - Offering Income 0.00 855.00 855.00 0.00 855.00
01-4401-104 Student Ministry Income Income 0.00 685.01 685.01 0.00 685.01
01-4840-104 Student Ministry Income 0.00 (324.31) (324.31) 0.00 (324.31)
Sub-account 104 Income 0.00 1,215.70 1,215.70 0.00 1,215.70
01-5512-104 F.D. - Student Ministry Expense 0.00 2,052.70 2,052.70 1,650.00 402.70
Sub-account 104 Expense 0.00 2,052.70 2,052.70 1,650.00 402.70
Sub-account 104 Income/Expense 0.00 (837.00) (837.00) (1,650.00) 813.00
change release account?
Moderators: Moderators, Tech Support
-
- Posts: 31
- Joined: Thu Jul 25, 2013 4:29 pm
- Location: Abbotsford, BC CANADA
-
- Posts: 1338
- Joined: Sun Oct 07, 2007 9:50 am
- Location: Potsdam, NY
- Contact:
Re: change release account?
Before you do anything else, there may be a simple fix.
5512-104 should close-to 01-3110-000 unrestricted net assets.
I'm guessing you have it closing to 01-3240-104 (or whatever account number you are using) temporarily restricted net assets.
If so, and if you change the equity account on 5512-104, everything should correct itself instantly!
Remember, the restriction is on the income, not the expense.
5512-104 should close-to 01-3110-000 unrestricted net assets.
I'm guessing you have it closing to 01-3240-104 (or whatever account number you are using) temporarily restricted net assets.
If so, and if you change the equity account on 5512-104, everything should correct itself instantly!
Remember, the restriction is on the income, not the expense.
You can watch my PowerChurch tutorials now on YouTube!
Visit http://www.youtube.com/user/EmpowerYour ... ture=watch
Visit http://www.youtube.com/user/EmpowerYour ... ture=watch
-
- Posts: 31
- Joined: Thu Jul 25, 2013 4:29 pm
- Location: Abbotsford, BC CANADA
Re: change release account?
Hello and thank you for your reply.
I just checked and it's closing to 3110-000 ??
I just checked and it's closing to 3110-000 ??
-
- Posts: 1338
- Joined: Sun Oct 07, 2007 9:50 am
- Location: Potsdam, NY
- Contact:
Re: change release account?
Oh well. No easy fix.
It is a little hard to read your columns, because this forum squeezes out spaces.
I am going to use the third column in to figure this out.
---------------------------
01-4240-104 $ 855.00
01-4401-104 $ 685.01
01-4840-104 $(324.31)
Total 104: $1,215.70
01-5512-104 $2,052.70
----------------------------
It appears you are not releasing the correct amount.
01-4840-104 should be $(1,540.01), because that is total amount of restricted income that you have. It should all be released.
I suggest making this transaction:
DB 01-4840-104 $ 1,215.70
CR 01-4999-000 $ 1,215.70
It is a little hard to read your columns, because this forum squeezes out spaces.
I am going to use the third column in to figure this out.
---------------------------
01-4240-104 $ 855.00
01-4401-104 $ 685.01
01-4840-104 $(324.31)
Total 104: $1,215.70
01-5512-104 $2,052.70
----------------------------
It appears you are not releasing the correct amount.
01-4840-104 should be $(1,540.01), because that is total amount of restricted income that you have. It should all be released.
I suggest making this transaction:
DB 01-4840-104 $ 1,215.70
CR 01-4999-000 $ 1,215.70
You can watch my PowerChurch tutorials now on YouTube!
Visit http://www.youtube.com/user/EmpowerYour ... ture=watch
Visit http://www.youtube.com/user/EmpowerYour ... ture=watch