Tracking Fund Balances

by Anne Laechel
(Brainerd, MN)

I'm setting up my Chart of Account in Aplos and have A LOT of restricted funds.

I don't want to set them all up as separate funds, but I'm not sure how I would know the current balance of the fund otherwise.

My current software uses a single account for each fund which records both income and expense.

Would I create a single income account and a single expense account within my new "Restricted Fund" fund, and then redirect my historical data to those accounts and tag each transaction to the appropriate purpose?

I might need to create a new transaction to account for any older transactions we are not importing.

Comments for Tracking Fund Balances

Click here to add your own comments

Dec 04, 2022
Tracking Restricted and Designated Funds
by: Vickey

Michelle Brown of "The Church Finance Training Network" does an awesome job of explaining the difference between "designated" and "restricted" funds on her FAQ page:

https://www.churchfinances.org/faqs

As far as tracking "restricted" and "designated" funds, there are several options on how to do that effectively, but how you do it depends on your accounting software and what "version" you are using.

You said you were using Aplos. In Aplos, I like to limit the number of "funds" I use. I use Aplos funds for tracking 990 categories for nonprofits, but for my church clients in Aplos, I use the funds to track the ones I want to appear on the Balance Sheet.

Not all "funds" need to show on the Balance Sheet, so I use "tags" to track those ministries, programs, events, etc.

Just keep in mind that you do not want to "double" track "stuff" by setting up income and expense accounts AND fund accounts to track one fund. For example, you would not want to set up an income, expense, and fund account all to track the "Children's Ministry".

If you are using a "fund" titled "Children's Ministry", you can use an income account (Designated Donations) to record donations to the CM and use "normal" expense accounts such as ministry supplies, events, food, etc. and "assign" the CM fund account to "track" the income and expenses and create a report for that fund.

Feb 08, 2023
Tag Balance in Aplos
by: Anne Laechel

I have set up all our designated fund accounts as Tags within a Fund called "Dedicated Funds," with one "Restricted income" and one "Restricted Expense" account. At this point, the only way for me to find out the balance of each Tag is to run a Tag Statement Custom account, with a date range that includes all the data in the database (July 1, 2017-present). Is that the way it is supposed to be or is there another way?

Click here to add your own comments

Join in and write your own page! It's easy to do. How? Simply click here to return to Accounting.

If you want to DIY your payroll, I highly recommend you look at using Gusto! It is very user friendly and their support is awesome! Plus they know how to set up and maintain payrolls for churches and nonprofit organizations.

Note: I am a "partner" of Gusto, but as I have told you before ... I never recommend anything that we or our clients have not tried and love =)



Share this page:
Enjoy this page? Please pay it forward. Here's how...

Would you prefer to share this page with others by linking to it?

  1. Click on the HTML link code below.
  2. Copy and paste it, adding a note of your own, into your blog, a Web page, forums, a blog comment, your Facebook account, or anywhere that someone would find this page valuable.