Setting up multiple funds, each with their own bank account

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
GSA Candace
Posts: 8
Joined: Sun Dec 27, 2020 2:02 pm

Setting up multiple funds, each with their own bank account

Post by GSA Candace »

We just bought PowerChurch for 2021. I used set-up assistant to enter all the information for our General fund using our main bank account. We also have a Building fund, Benevolent fund, Memorial fund, etc. each with their own bank account and some have linked investments and/or liabilities. I can add the Funds in Maintain Chart of Accounts, but only the set-up assistant has a place for bank account balances, outstanding cheques, liabilities, etc. How do I enter in the opening balances for the secondary bank accounts and investments once I close the assistant?

Zorak
Tech Support
Tech Support
Posts: 2703
Joined: Thu May 13, 2004 8:59 am
Location: PowerChurch Software
Contact:

Re: Setting up multiple funds, each with their own bank account

Post by Zorak »

This is done by entering a transaction in Accounting > Fund Accounting > Enter Transactions.

To add a beginning balance to a new bank account in a new fund would look something like the following:

02-1120-000 Checking (Debit) $500
02-3110-000 Unrestricted Equity (Credit) $500

If you are tracking the equity (AKA fund balance, net assets) in separate, restricted accounts in each fund, then you would instead choose the appropriate equity account in that fund.

GSA Candace
Posts: 8
Joined: Sun Dec 27, 2020 2:02 pm

Re: Setting up multiple funds, each with their own bank account

Post by GSA Candace »

Thanks Zorak, I'll try that.

cmdouglas0330
Posts: 5
Joined: Wed May 27, 2020 5:13 pm

Re: Setting up multiple funds, each with their own bank account

Post by cmdouglas0330 »

I have a similar issue. For 2020; Our location has a Main Checking Acct; A separate Savings Acct for our Building Fund (where we deposit the funds that come into our main checking acct for the building fund); and later in 2020 we closed the Saving Bldg Fund acct; and opened a MMA Savings. I am trying to reflect all of that activity within PCH but seem to be missing some pieces because the reporting when trying to "move" funds from one restricted acct under the Main Checking in Fund 01 to the Savings restricted acct under Fund 02 is off. Would I do as you have listed here...Set up the Saving Bldg Fund Acct: 02-1120-000 Checking (Debit) $500 // 02-3110-000 Unrestricted Equity (Credit) $500 OR would I use the Restricted Equity acct for the Bldg Fund? Next, would I then Release Funds from the appropriate restricted acct to the Unrestricted or Restricted Equity Acct (depending on your response); and finally create a transfer between the Funds in 02 from the Closed Savings Bldg Acct to the Opened MMA Savings Acct? This is my dilemma. :wall:

NeilZ
Posts: 9477
Joined: Wed Oct 08, 2003 12:20 am
Location: Monett MO
Contact:

Re: Setting up multiple funds, each with their own bank account

Post by NeilZ »

cmdouglas0330 wrote:
Thu Apr 01, 2021 4:42 am
I have a similar issue. For 2020; Our location has a Main Checking Acct; A separate Savings Acct for our Building Fund (where we deposit the funds that come into our main checking acct for the building fund); and later in 2020 we closed the Saving Bldg Fund acct; and opened a MMA Savings. I am trying to reflect all of that activity within PCH but seem to be missing some pieces because the reporting when trying to "move" funds from one restricted acct under the Main Checking in Fund 01 to the Savings restricted acct under Fund 02 is off. Would I do as you have listed here...Set up the Saving Bldg Fund Acct: 02-1120-000 Checking (Debit) $500 // 02-3110-000 Unrestricted Equity (Credit) $500 OR would I use the Restricted Equity acct for the Bldg Fund? Next, would I then Release Funds from the appropriate restricted acct to the Unrestricted or Restricted Equity Acct (depending on your response); and finally create a transfer between the Funds in 02 from the Closed Savings Bldg Acct to the Opened MMA Savings Acct? This is my dilemma. :wall:
I would do as I suggested in the original thread you started. This example is for creating a beginning balance in a new checking account. It can be used for creating a new savings account that is NOT temporarily restricted.

However, if this Building Fund Account is ONLY used for savings of funds for a future purchase of property as you mentioned, then its ALREADY restricted in the fact that its a separate bank account (savings) and its completely separated from the normal Operations Fund Account 01. There's no need to create a temp restricted account in the Fund 02.

That said ... you didn't say in the original thread that you did not yet create the savings account. If this is true, then you can use this method by cutting the check in 01, depositing it in the savings account, and then use the example to create the beginning balance in the savings account.

Don't get confused about what you should be doing on a normal basis every week.
Neil Zampella

Using PC+ since 1999.

cmdouglas0330
Posts: 5
Joined: Wed May 27, 2020 5:13 pm

Re: Setting up multiple funds, each with their own bank account

Post by cmdouglas0330 »

Thank you Neil! However, I thought I mention in the original that I had a Savings account to start. We have a Savings acct at the start of 2020; but closed it around June 2020 and opened a MMA Savings in June 2020. I was trying to reflect those actions; my apologies. So I will not place any fund accounts in Fund 02 as restricted since the account is separate. I will keep the Funds in 01 as restricted as the contributions come in to the Main Account from donors. Thanks this has really helped.

Post Reply