Skip to main content
May 25, 2024
Question

Nonprofit equity and classes for fund management.

  • May 25, 2024
  • 1 reply
  • 0 views

Can someone walk me through adjusting equity accounts? It is a church and I am using classes but I setup qbo by journal entries that offset all starting balances in checking, money market, cds, and endowment…with equity funds for the three types of funds: general fund, temporary restricted funds, and permanent restricted funds.

 

what I thought would happen is that I would have equity funds for the three pieces of the pie and classes for specific funds within those areas (also passthru liability accounts, btw).

 

so as I setup the accounts I used journal entries putting money in checking or endowment, etc and offsetting that with our designated and general fund accounts.  This was the only way I imagined of making balanced double accounting entries. All of my individual funds exist as classes, like individual memorial funds, mission accounts etc. when I set everything up assets=liabilities+equity……the classes do a great job of tracking (though reports with classes leave a lot to be desired), but but as I make deposits the classes then exist “inside” the checking account and my initial journal entries put the classes within the equity accounts.

 

maybe that doesn’t matter, idk.  When I did the initial setup I had everything balance and the opening balance equity fund didn’t have to be touched.  I was so proud of myself. That everything added up.

 

when I make a deposit I can designate a class, and the money comes through a revenue account, but with each deposit the classes grow but there no way to grow the equity accounts that make up my “pieces of the fund.” If I use a journal entry to move money through a clearing account from revenue, the revenue ends up zero, if I try to use retained earnings it messes with my revenue.  Obviously moving money from checking makes less than zero sense. I don’t know how I add to the equity accounts going , but the larger issue is that but how to I adjust equity funds while still keeping revenue correct on p&l report, or is there another way to handle opening balances?

 

there has to be an obvious and easy way to scale equity funds as deposits are made without messing with the balances of the bank and investment accounts and without reducing revenue.  I want all revenue to run through the budget for planning purposes, but I also want each deposit to grow the corresponding equity account.  Help…

 

oh, also, we use breeze Church Management to manage all donor / giving  / statements, so deposits are direct, not using accounts receivable or services & products and the receive payment process.

 

1 reply

Rainflurry
May 27, 2024

@ChurchBooks79 

 

You may want to consider using tags instead of classes.  They're a bit more flexible IMO.

 

"when I make a deposit I can designate a class, and the money comes through a revenue account, but with each deposit the classes grow but there no way to grow the equity accounts that make up my “pieces of the fund.” If I use a journal entry to move money through a clearing account from revenue, the revenue ends up zero, if I try to use retained earnings it messes with my revenue. Obviously moving money from checking makes less than zero sense. I don’t know how I add to the equity accounts going , but the larger issue is that but how to I adjust equity funds while still keeping revenue correct on p&l report, or is there another way to handle opening balances?"

 

The issue here is that you cannot record funds received as both revenue (income) and to a fund equity account since both are credits from a double-entry accounting perspective.  Forgive me if you know this already.  Current year unrestricted donations are revenue.  You can reclass those to an equity account called "Current FY Unrestricted Revenue" or something similar if you need to differentiate them from current year net income.  Or, at year-end, you can make an adjusting journal entry to move them from Retained Earnings to the appropriate equity fund.