One checking account - multiple funds. Please help!

[whoknows]

Hi.
We have only one checking account that needs to be updated with all contributions and checks that are written. However, we want to be able to keep up with individual balances for the different ministries. The software was setup by someone that is no longer here and it hasn't been maintained. I just deleted old data and have begun entering all of 2008 checks and contributions. The chart of accounts is setup for the different ministries, but it looks like if I post it this way, the checking account will not reflect the full contribution:
01-1111 Security Federal Checking Contributions 01-1111 50.00
07-1117 WOMEN'S MINISTRY Contributions 07-1117 14.57
01-4101 Tithes & Offerings Tithes & Offerings 50.00
07-4701 W M-Offerings W M Offerings 14.57

Their was a total of 64.57 that was deposited into the checking account. How can I set this up so that the Women's ministry has the correct amount, but the checking account fund also matches the real checking account.
Thanks!!!

[NeilZ]

Hi.
We have only one checking account that needs to be updated with all contributions and checks that are written. However, we want to be able to keep up with individual balances for the different ministries. The software was setup by someone that is no longer here and it hasn't been maintained. I just deleted old data and have begun entering all of 2008 checks and contributions. The chart of accounts is setup for the different ministries, but it looks like if I post it this way, the checking account will not reflect the full contribution:
01-1111 Security Federal Checking Contributions 01-1111 50.00
07-1117 WOMEN'S MINISTRY Contributions 07-1117 14.57
01-4101 Tithes & Offerings Tithes & Offerings 50.00
07-4701 W M-Offerings W M Offerings 14.57

Their was a total of 64.57 that was deposited into the checking account. How can I set this up so that the Women's ministry has the correct amount, but the checking account fund also matches the real checking account.
Thanks!!!

Are you entering data through the contributions module, or directly into accounting ?? If I remember right your checking account should have the same account number across the funds. So, your 07-1117 should not be used but you should have a 07-1111 Checking account instead.

You should really be updating Funds Accounting up via Contributions. You should have two Contribution Funds setup to do the following (found under maintain List of Contribution Funds):

Name: Reg Tithes/Offerings
Debit : 01-1111
Credit: 01-4101

Name: Women's Ministry
Debit: 07-1111
Credit 07-4701

I hope this helps.

[whoknows]

Thanks!!! I will try to change the chart of accounts to work that way. We did enter this information through the contributions module.