Question Submit

Friday, June 10, 2005

Tracking Groups of Funds in "Super-Classes"

Question:

I'm looking at the books of a non-profit that has over a dozen funds they need to track. It would be nice to create a class for each fund. It would be nice to have a super-class of similar funds, so a report could have columns like these:

Operating Fund

Endowment - Unassigned Fund

Endowment - Assigned Funds - This column would contain a total of numerous "sub-class" funds Scholarship Funds - This column would also contain a total for numerous "sub-class" funds.

I know QuickBooks permits selecting any funds to include in a report. I know that information could be consolidated in a spreadsheet, but does QuickBooks permit creating any kind of super-class or other technique so that collections of classes could be shown in one column next to other collections of classes.

Answer:

Unfortunately, I don't think that "super-classes" are possible within QuickBooks. For this, you would need to find a more robust accounting software product that is based on fund accounting. This probably is overkill for most non-profits as this fund accounting packages can cost tens of thousands of dollars. I would say that from your description you are doing the best you can with what you have. If you really need these reports, you could try to format them in excel.

No comments: