How to best enter and track restricted grants

I need step by step easy instructions as to the best way to enter and track a restricted grant. We have a Grant account. I have seen suggestions to use sub accounts or departments. Not sure how to use departments.  Any forum I have read seems not clear and doesn’t give a straightforward answer.    An example would help 
If I used sub accounts could I have a restricted grant sub account and then further sub accounts for each grant?   I’m not sure how to easily track spending per grant then.  If I set it up right, what report could I pull to see each grant with revenue and expenses? 
Thanks so much 

I am using Sage 50 premium CA for a non profit playschool 

Barb 

  • 0

    My way of handling the Grants is not considered right for some but it works for me. I use the Liability accounts in blocks of 10 for each grant. By naming them appropriately the revenue accounts, 2xx1, 2xx2, come first and the disbursements are usually accounts 2xx7 and 2xx8. The sub-group total account is always 2xx9. By doing this you can run a Transaction by Account report for each block and it provides all your detail. This works great if there are not a lot of transactions in your fiscal year.

    If you require more accounts, I would suggest using Departments where you can use all of your normal revenue and expense accounts and allocate the entry to the correct department. Once you set up departments you can not delete them.

    You could also do similar using Projects which does not affect your Chart of Accounts but again each entry has to be allocated to a Project. The title can be changed from Project to Grants if you have a number of them. By doing this you can run Project reports which can go over a fiscal year end and not loose the detail for the complete project/grant.

    Remember, Sage 50 is not designed for fund accounting but any one of these three optional work-arounds, with some extra entries at year end, work well..

  • 0 in reply to Alwyn

    Thank you for giving me so many options.   I’m not completely sure I understand what you do in the first option but I think I will try projects so that I can run a projects report and track my grant use.  Will see how it goes!