Navigating Spiff

Learn about the Payroll Reporting System

The payroll reporting system is a key business tool at your disposal. With all of your reports in one place, you can easily manage your business and spend more time focusing on what matters most. View detailed reports that break down your payments to the most granular level and allow you to track them over time. Your Account-level Fees, Transition Bonus, Trailer Fees, and Expenses are all clearly broken down and can be reviewed in detail to understand the full scope of your payouts. 

Through the Optimize Portal, access our payroll reporting system:

  • Navigate to Systems & Technology > Payroll Reporting

Once logged in, you can view all the important details and reports pertaining to your monthly payouts, organized in the following sections:

Statements


From the top of the page, you can select the Payout Period for which you would like to view your payment details, 

  • Click on the [Month][Year] dropdown menu to browse through the list of your payout periods
  • Keep in mind, the most recent payout period will be made available on the 15th of each month

Once you select the payout period, you will first see three summary information tiles which provide a snapshot of the key details for that particular period, as well as the option to export all of the data.

  • Total Payouts this Period: view the total aggregated payout amount, net of expenses, for the selected period
  • Payout Trend: view your up-to-date Payout Trend as a percentage increase or decrease as well as your aggregate Past 12 Month Payouts total. With the bar graph, you can see a visual representation of your current period payout in relation to your past twelve month payouts, as well as your average payout amount reference line
  • Payout Breakdown (by rule): view a pie-chart breaking down the various rules of your payout for the selected period. Hover your mouse over each component of the chart to see a quick view of the dollar amount and percentage share of each of your Account-Level Fees, Transition Bonus, Trailer Fees, and Expenses. Click on the particular rule to view more details
  • Export Statement : click the Download button to generate an excel file with your monthly statement, along with the comprehensive data pertaining to the selected payout period


Within the excel file, navigate through the various tabs (bottom of the screen) to view:

  • [DayMonthYear] Summary: view your statement for the payout period detailing the period-specific total figures.
  • ExpensesByRule: view your expenses broken down by Type, with a Description and Amount.
  • Account-LevelFeesByRule: view key metrics including the GST/HST/PST Payable for the period, as well as your account-level fee data at its most granular level with information on each particular client account including the Market Value, Transaction Description, Fee Rate, Amount, Payout Ratio, GST/HST/PST, and the Payout.
  • TrailerFeesByRule: view your trailer commissions and details on their origin including the Client, Account Number, Symbol, Amount, and Payout.
  • TransitionBonusByRule: view your transition bonus data for the period with information including the Client, Account Number, Net Asset Flows, and Payout. 

Account-Level Fees

 In the Account-Level Fees tab, click on the arrow to see more information. 

  • Key Metrics and Data: easily find your GST/HST/PST Payable amounts for the payout period
  • Obligations: view all the individual line items that comprise your Account-Level Fees for the payout period with details on the Account Number, Client, Security Description and Market Value, Transaction Description, Fee Rate, Payout Ratio, Tax, and Payout.
  • Click on the line item to view an information card summarizing the key details of the particular item

Transition Bonus

 In the Transition Bonus tab, click on the arrow to see more information. 

  • Obligations: view all the individual line items that comprise your Transition Bonus for the payout period with details on the Account Number, Client, Asset Inflows, Asset Outflows, Net Assets, and Payout
  • Click on the line item to view an information card summarizing the key details of the particular item

Trailer Fees

 In the Trailer Fees tab, click on the arrow to see more information. 

  • Obligations: view all the individual line items that comprise your Trailer Fees for the payout period with details on the Account Number, Client, Symbol, Security Description, Amount, and Payout.
  • Click on the line item to view an information card summarizing the key details of the particular item

Expenses

 In the Expenses tab, click on the arrow to see more information. 

  • Obligations: view all the individual line items that comprise your Expenses for the payout period with details on the Expense Type, Description, and Payout
  • Click on the line item to view an information card summarizing the key details of the particular item

From each of the tabs described above, click the Search icon on the right side of the Obligations list to search by property (i.e. Name, Account Number, Amount, etc.). This way, you can find and review particular line items of interest.

Tip: take advantage of the Export Statement option to download your payout reports and associated data. You can then manipulate this data in any way you see fit for tracking purposes, and to have it on file for your future reference. This will make things more efficient for you as the system may require some time to load and display all of your data if viewing it online.