SETTING UP FUNDS

[First Presbyterian Toronto]

We are using version 10 and have Windows XP Professional
We have been using PC+ for many years and had our Chart of Accounts set up under 01-General Fund which included all our checking/savings/cd's/investments/etc. Recently our treasurer wanted to run Income and Expenses reports seperately on these items. We set-up 02 investments/interest, 03 savings. We specified which accounts we wanted included in these funds, however when we run the reports no accounts show-up. We then tried setting up an 04 account called operating expenses and specified which accounts we wanted tied to it. Again, when we run an income/expense report nothing shows up in it. We tried deleting our investments/interest from 01-general fund which it will not let us do as we have posted transactions to it. Are we missing something? Some step we need to do to run a seperate report specifying only transactions in these accounts? We've tried wading through Custom Reports and that hasn't worked either. Thanks for any help.

[JohnDMeyers]

To answer the first part, about creating an 02, 03, and 04 fund:

Even if you create these funds and set up the chart of accounts, you won't get any data until you post some transactions in them.

If you wanted to create fund 02 investment income and expense for the calendar year 2008, you could do this:

Get the starting balance for any checking, savings, or investment accounts as of Jan 1, 2008 that you want to be in fund 02. Enter this balance as the starting balance for each asset account:
DB bank or investment (asset) account
CR net unrestricted assets (or use the appropriate restricted equity if applicable)

Run an income/expense report for Jan - Dec 2008, and write down the amount in the accounts that you want in the new fund.

Each income line item that you want included in the new fund:
CR income account
DB bank or investment (asset) account

Each expense line item:
DB expense account
CR bank or investment (asset) account

To keep your consolidated reports accurate, you will have to make reversal (or transfer) entries for all these in fund 01. It could be a lot of work.

[wms7328]

Setting up separate accounting funds for the different types of assets will work but unless you pay expenses directly from these separate bank accounts, then it's going to involve a lot of enteries. I would suggest you set up the different bank accounts as separate assets under your general operating fund. Fund 01 in your case. Then when you transfer funds out of savings to checking to pay expenses, you would show the transfer from one asset fund (savings) to regular checking account asset. If you want to show the income and expenses from each asset you can run a check register report for that asset fund and it will show you the transactions.