danceschool.financial app, if installed, provides the ability to do detailed financial accounting of a school’s revenues and expenses. Because this system hooks into the core app, it can automatically keep track of revenues received from students registering for classes. Additionally, it can be set to automatically generate expense items for instructors, substitute teachers, venue rental, and other expenses that are either paid by the hour or on a daily/weekly/monthly basis.
This page describes how to submit individual expense and revenue items, how to set up autogeneration of expense and revenue items, and how to generate reports of financial activity.
Reporting Individual Expense and Revenue Items¶
For miscellaneous expenses and other overhead, the app includes an expense reporting form that permits easy entry of expenses, including optional file attachment for receipts. To use this form, go to the CMS toolbar and choose Finances > Submit Expenses. This form will allow users to submit both flat-price expenses as well as hours of work (for things such as administrative labor). The total expense for hours submitted is calculated using the default rate for the Expense category chosen.
When submitting expenses for reimbursement as opposed to compensation, be sure to check the “Reimbursement” box. This ensures that individuals’ taxable compensation is recorded accurately.
Users with sufficient permissions may also have the option to mark expenses as approved and paid at the time of submission. If you record payments in this way, it is strongly recommended that you enter the payment date in which the expense was actually paid. This ensures that your periodic accounting statements remain accurate.
Miscellaneous revenues are less common, but may be used for things like practice sessions where students pay in cash and the standard registration system is not needed. To use this form, choose Finances > Submit Revenues from the CMS toolbar. Revenues can be associated with a specific class series or event, and receipts can be attached. If you allow instructors or other staff members to collect cash payments temporarily, then you can use the “Cash currenly in possession of” field to indicate the individual that collected the revenue, so that you can be sure that the money is eventually given to the person responsible for its deposit.
Automatic Generation of Expense and Revenue Items¶
If you ran the
setupschool script when installing your project, then you have already selected whether or not to automatically enable automatic generation of expense and revenue items for the above items. However, if you did not take this step, then you can enable automatic generation by going to the site preferences from the CMS toolbar at Apps > Global Settings. From there, select the Financial section, and you will see checkboxes for enabling/disabling automatic generation of expenses. You will also see options to set the categories into which these automatically generated expenses are filed (usually the defaults will be fine), and an option to restrict how far back in time the auto-generation process for Registration proceeds (which you are unlikely to need to change).
There are no further steps to setting up automatic generation of Revenue Items for registrations. However, for venue rental expenses, staff expenses, or other repeated expenses, you will need to set up the rules with which expenses are generated (see below).
Note: By default, automatic generation of expense and revenue items happens once per hour. Through the Repeated Expense Rule admin interface, it is also possible to generate expenses immediately by selecting the rules you wish to apply and choosing “Generate expenses for selected repeated expense rules” from the dropdown. If you are not seeing automatic generation of expenses occurring hourly, be sure that Huey is running. See Huey (and Redis) setup for production for more details.
Setting Repeated Expense Rules¶
There are two ways to set up repeated expense generation rules for Locations and Staff Members:
- Through the administrative change view for the specific Location or Staff Member whose rules you wish to set/change. Expand the collapsible section entitled “Locations’ rental information” or “Staff members’ wage/salary information” to edit details from here.
- Through the Repeated Expense Rule admin, accessible from the CMS toolbar at Finances > Related Items > Repeated Expense Rules.
Rules can be set to generate expenses hourly, daily, weekly, or monthly. The “Day starts at,” “week starts at,” and “month starts at,” parameters define the time point at which expense windows begin and end (“week starts at” and “month starts at” are ignored for expenses that are not weekly or monthly, respectively). And, if you use the admin interface option #2, you also have the ability to specify explicit start/end dates beyond which expenses will not be generated.
For “generic” repeated expenses that are not associated with a Location or a Staff Member, you will need to use the admin interface as specifed in option 2. Here, you will be presented with the option to give this rule a name for record-keeping (e.g. “web hosting fees”), along with options to specify the category of the expense and the recipient of the expense payment. Finally, you have the option to automatically designate these expenses as approved and/or paid.
For expense items associated with Locations or Staff Members, the script generates expenses only in response to the existence of events. So, for example, an hourly expense for an Instructor’s instructional time is generated only for the hours in which the individual is scheduled to teach. Daily, weekly, and monthly expenses are generated only if the location or staff member was scheduled in that period. In contrast, “generic” repeated expenses are generated regardless of whether any events were scheduled in the period in question. So, be sure to apply “hourly” and “daily” generic expense rules with caution.
If you have automatically generated expenses erroneously, you may simply go to the Expense Item admin interface from the CMS toolbar at Finances > Related Items > Expense Items, filter by the rule that was used to generate the expenses, and delete the offending expense items. It is also acceptable to modify or delete expense items that are exceptions to the regular rule from this point. However, be advised that if you delete or change the time window of an expense item and do not update the generation rule that was used to create it, then you may end up with repeated expense items at the next occasion when that rule is applied.
Categories for Staff Members¶
If you are editing the wage/salary information for an instructor or other staff member, you will see a “Category” field, populated with the different categories of event staffing that you have defined on your site (Class Instruction and Substitute Teaching are automatically specified as categories). This field is optional, but recommended. When the script runs that generates expense items, it looks first for a rule to apply that is specific to the category of staffing that is scheduled. If no such rule is found, it then looks for a “catch all” rule in which no category of staffing is specified. If no such rule is found, then the script does not automatically generate expenses for that staffer.
Note that there can be only one rule per instructor and category, so that there is always a unique rule that is applied for any given staffing of an event.
Because the financial app allows for comprehensive expense and revenue tracking, it is possible to produce simple financial summaries that allow you to get a snapshot of your school’s financial performance.
- Monthly summary: Go to “View Monthly Financial Summary” in the “Finances” menu of the CMS toolbar.
- Event summary: Go to “View Financial Summary By Event.” Note that these event-specific entries do not include any revenues or expenses that are not associated with a specific event, such as administrative expenses
- Detailed categorical breakdowns: Go to “Detailed Breakdown” and select the period desired, or select a specific month from the monthly summary page. From the detailed categorical breakdown, you can can also quickly find links to specific expense and revenue items in order to make corrections.
Note also that for accounting purposes, monthly and detailed summaries can be constructed on several different bases, which can be selected within each page:
- Payment basis: Summaries are constructed based on when money is received or spent. This is what is typically used for “cash accounting” for tax purposes.
- Accrual basis: Summaries are constructed based on a notion of when the money is “owed” (e.g. at the end of a class series for instructors). This can help to get a more accurate picture of your financial performance Please be advised that the accrual basis constructed in this project almost certainly does not correspond to generally accepted accounting practices, and therefore it is not recommended to use these statements as a basis for so-called “accrual accounting” for tax purposes.
- Submission basis: Summaries are constructed based on when revenue and expense items are submitted to the database.
Exporting Financial Data¶
If you need to export financial data for analysis using another method (e.g. Excel), you can do so from the Monthly Financial Summary view by clicking the buttons under the “Export Financial Data (CSV)” heading.