User Support Forum

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

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.

Hello and thank you for your reply.

I just checked and it's closing to 3110-000 ??

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