Bonus
Producing a Member Bonus Report
The Members/Bonus report provides the bonus allocated for an individual member or all members for a month or a range of months. The report provides the bonus information as well as a detailed report of the attributed revenue by type of work.
To select the report, open the Members report button and click on Bonus. The settings for this report must be created prior to generating the report. These settings are initialized in Payroll/Member Bonuses. The report is only available at the Administrative user level.
Filters
The filters allow a variety of reporting for engineers set up in the Payroll/Member Bonuses table:
- One engineer for a single month or multiple months.
- All engineers for a single month or multiple months.
- Engineers who report to certain managers for one month or multiple months.
Select:
1. Members - One engineer or all engineers set up in the bonus plan.
2. Date Range - One month or multiple months. Predefined months in the Quick Select.
3. Reports To - Filter on engineers who report to specific managers.
4. Select columns to show in the report - Choose the columns to be displayed in the report.
To save the settings, click Filter. To reset the filters to the default, click Reset.
If you select a member who has not been set up, no report will be generated. To set up a bonus program for the specified member who is not currently in the bonus program, go to Payroll/Member Bonuses table to set up the member.
The top section of the report provides information on the member bonus (you can specify to see all of these columns or selected columns in the filter setting). Each row gives a separate month.
1. Member - member name
2. Reports To - specific manager(s) who the engineers report to
3. Month - month specified in the filter
4. Production - attributed revenue
5. Adjustment - an adjustment can be included in the Payroll/Member Bonus table which adjusts revenue for a given month. The adjustment can be positive or negative
6. Net Production - Production - adjustment
7. Target - target production revenue set in the Payroll/Member Bonuses table
8. Excess - currency amount in excess (or below) revenue target
9. Bonus % - Percentage set in the Payroll/Member Bonuses table
10. Bonus amount - If Excess is positive, the amount of the bonus. If Excess is zero or negative no bonus is given.
The bottom section of the report provides detailed information on the type of work, the hours that revenue was generated for this type of work, and the revenue attributed to the engineer(s). The bottom line shows if there is still un-invoiced work for the month. Even though the engineers worked on the un-invoiced client facing time, the time will not be counted until an invoice is sent.
Producing a Report for all Members who are in the bonus program
Example - If "All Members" is selected in the Member filter, a report will be generated with bonuses for all members who are set up in the Payroll/Member bonuses table for a given month or multiple months.
In the example below, three members are shown in the report for the months of July and August. The top of the report has a line for each member for each month in the report and the summary of the bonuses for the month. The bottom information is a summary of he type of work done for the months, hours and revenue generated is a summary for the three members in the bonus program.
Example - In the example below, Member 248 receives a bonus if the attributed revenue exceeds $15,000. The Net Production revenue is $14,476.23 which is below the threshold for bonus $ for the month. But for the month, there was a $1,000 adjustment which brought the revenue to $15,476.23 and gave the engineer a bonus of $71.43. The engineer not only got attributed revenue credit for client facing work, but also some credit for internal technical work (work done for the MSP of a technical nature).
The breakdown of what type of production work was done is shown on the report below. The report can be downloaded to a PDF file for distribution.
Note: Member attributed revenue for agreements is based on the labor revenue generated by a client for the month, the portion of the work done by the member and the efficiency of the agreement for the month. If very little work is done for a client agreement in the month, the efficiency can go up dramatically which distorts member attributed revenue. A setting in the Lookup/Options table provides a way to cap this efficiency. MSPCFO encourages you to talk to your CSR about using this setting. It is initiated in Lookup/Options/Agreement level efficiency/Cap: and has a setting for the Month Start.