Sage for Two Business Units

SUGGESTED

Sage 50 Pro Accounting (Release 2017.2), single licence.

I am the Treasurer for a small Not-For-Profit society, which I'll call a Chapter.  Sage is probably overkill for what we do but it's what I inherited and I've been happy so far.  I am not an accountant by trade or education.

Originally, the Chapter was synonymous with one business unit, i.e one Chart of Accounts, one bank account, no credit cards, and using Projects to report on reoccurring and unique events.  Chapter reporting is easy and no payroll is required - there are no employees.  It's all worked reasonably well.

Recently, we have been contemplating creating a second unit (and in theory there could be more in the future) and must determine how the finances are going to be handled,  One of my tasks related to this expansion is to advise the Board of Directors (BOD) on how we're going to manage the additional unit financially and what tools can be used to do so; can we continue to use Sage and, if so, how and at what cost?

The units do the same type of work, just would have different occasions for the work and would have different membership (although, clearly, Sage doesn't care what the membership is).  Thus, the Chart of Accounts for both units would be the same, and if not entirely so, small additions would solve the problem.  The units would report independently to the BOD and the BOD would have to roll up the unit reporting for a Chapter report.  Projects would still be used since each unit could have its own events and units could collaborate on others.  There would be Chapter level expenses requirements (and possibly revenue streams) that would apply to both units albeit not necessarily in a 50-50 proportion.

I have several questions:

  1. Can Sage handle this structure, and if so, what version of Sage must we have?  I understand that there is a Departments function but it's not in my current version of Sage.  Might it solve the problem?
  2. Can we continue to use the Projects function for events that affect both units?  I can see independent projects (i.e. one of the two units alone) working the same way but if both units collaborate on the same project can the expenses and revenues be split not only by GL but also unit?

If there is another way to provide accounting for multiple units within the Chapter, I'm open to suggestions.

  • 0
    SUGGESTED

    With your current version, you could run each unit in it's own file.  Dumping reports to Excel and some Excel magic formulas will consolidate your reporting quickly enough.  Problems will arise with only one bank account (reconciliations become manual instead of using the Reconciliation module) and when vendors send you one invoice that affect projects from both units (you will have to split them and send the vendor two payments).

    Using Departments will require you to upgrade from Pro to the current Sage 50 Premium 2020.2 because 2017 is no longer for sale, so upgrades of 2017 are not possible.  However, upgrading your current file will be as easy as taking a backup of your file, installing the new 2020.2, opening your current file and letting the program perform the upgrade.  Once you upgrade, you can't take that same file back again.

    You should be aware that Departmental reporting for the Balance sheet is not elegant, nor complete.  The Departmental reporting for the Income Statement is pretty good and still allows you to use projects independently or together.  Within the reporting of Projects you can see the departmental breakdown if you wish.  If you don't need Departmentally separated Balance Sheet reporting, this might be your best option based on the information you have provided.