Finance: Team Report
The Finance: Team Report is an Add On Service for Pro Tier Firms. The Finance Tab selection must be requested and turned on by the Firms’ Account Manager.
In this article we will detail the functions inside of the Team Report. Firm Users will be added to the Finance Team Report with data that is retrieved from the Fee Structure Card. If a user is found more than once in a fee structure card, their values are not duplicated, instead they are combined.
Users will be able to show or hide Columns to streamline your data and save.
Once those Columns are saved then you can sort your order in a Ascending/Descending view.
The Team Report will populate the Total Amount Due, reflecting each Firm-Specific Fee Structure Type.
The asterisk (*) symbol next to any amount provides context, informing Users that the amount contains different currencies.
*Note: Total amount due is the sum of Firm User’s commission across all projects for a specific Fee Structure type. Total amount due is retrieved from the Fee Structure table
The Total Amount Paid per Fee Structure Type will populate in the category for each Firm User included in the table.
*Note: Total Paid amount is retrieved from the Distribution table. Total Paid amount is the sum of all payments made to a firm user across multiple projects per Fee Structure Type.
The Total Balance is the total Amount Due less Total Amount Paid per Fee Structure Type per user
The Total Future is equal to the amount due when a payment schedule has not been populated in the Payment Schedule table AND the focused Firm User has an established value in the Fee Structure Table. For a fee to be classified as future, it means:
- Project started in time frame
- Project fee entered
- Fee Structure entered
- No payment schedule
Users can filter by currency and the currency is retrieved from your Projects database.
Users can filter by Client Company which is retrieved from your Projects database.
Users can filter by Projects.
Users can filter by preset or custom Dates.
Date Range: Today, Yesterday, This Week, This Month, This Quarter, This Year, Last 7 Days, Last 30 Days, Last 90 Days, Last Month, Last Quarter, Last Year, Since Inception.
Users can download payment information. Finance permission is required for download.
All downloads are logged in the event table.
Additional Note
- Users are able to see records where they are the focused recipient of the fee structure otherwise the Finance Permission is required to see all finance reporting.