The Reports Functionality shows a dashboard of reports under various Report heads. The features are;
Access to the various Report sections and their Reports.
The “System Reports”
Transaction Summary Report
Invoice / Statement Summary Report
Invoice Courtesy Copy Report
Account Summary Report
Plan - Interested Party Report
Fee Run History Report
Invoice Payment Status Report
Exception Notifications Report
Invoice/Advice Alert Report
The “Analysis” Report
Actual Vs Expected Report
Revenue Projection Report
Fee Analysis Report
Monthly Payment Accruals Report
The “Accounts” Report
Cash Receipts Journal
Revenue Sharing Carry Over
Aged Fee Receivables
Payment Account Report
Fee Waiver Report
Ad Hoc Fee Report
Plan Fund Equalization Report
Revenue Offset Report
The “Plan Management” Report
Missing Fee Schedule Report
Plan Report
ETF Report
New Plans Report
As per requirement each Report page can have the following features;
Exporting a list to excel
Filtering a list categorically
Generating a 2nd Invoice
Download a PDF version of the generated Report
Download an Excel version of the generated Report
Download a CSV version of the generated Report
To access the various reports, choose the “Reports Dashboard” feature under the “Reports” functionality. This takes you to the “Jiffy.ai Billing Reports Center” page that has the below listed reports available.
The reports here provide internal periodic full, or partial logs of the Billing System.
Report |
Description |
Transaction Summary |
Click on the “View Report” button. This Report lists the summary of all the Billing Account Transactions in the system. |
Invoice / Statement Summary |
Click on the “View Report” button. This Report lists all the Billing Invoices and the Payment Statements in the system. |
Invoice Courtesy Copy |
Click on the “View Report” button. In the popup window, choose the options based on which you would like to view the report and click on the “Show” button to view those Invoices that has a Courtesy Copy generated for an Advisor in that month and year. |
Account Summary |
Click on the “View Report” button. This Report summarizes the details of all the Interested Parties Accounts (Billing and Payment) created in the system, and their status. |
Plan - Interested Party |
Click on the “View Report” button. This Report shows all Interested Parties that are linked to the Plans in the system through the Fees configured in the Plans. |
Fee Run History |
Click on the “View Report” button. This Report lists those Fees that have been run at least once and shows the count of the “Transactions” in each Fee which is the log of all Fees processed by the system. |
Invoice Payment Status |
Click on the “View Report” button. This Report lists the Invoices in the system whose status is Paid, Unpaid and Partially Paid, and shows the mode of payment that can be Check, ACH or Plan Debit. |
These reports analyze, interprets and pinpoints new opportunities of growth.
Report |
Description |
Actual Vs Expected |
Click on the “View Report” button. In the popup window, choose the options based on which you would like to view the report and click on the “Generate Report” button to view a report of the Payment Summary that shows an indication of variances between the actual vs. expected. |
Revenue Projection |
Click on the “View Report” button. In the popup window, choose the options based on which you would like to view the report and click on the “Generate Report” button to view a report that projects what the revenue is going to be for the next 12 months. |
Annual Fee Analysis |
Click on the “View Report” button. In the popup window, choose the options based on which you would like to view the report and click on the “Generate Report” button to view a report of the Annual Fee Analysis of the Billing System. |
Monthly Payment Accruals |
Click on the “View Report” button. This Report shows the Monthly Accrual Payment Transactions got after a Fee Run. |
These reports provide a better understanding of the Financial Information in the system.
Report |
Description |
Cash Receipts Journal |
Click on the “View Report” button. In the popup window, choose the options based on which you would like to view the report and click on the “Generate Report” button to view a report of the credits applied in the billing module to the account |
Carry Over Amount |
Click on the “View Report” button. In the popup window, choose the options based on which you would like to view the report and click on the “Generate Report” button to view a report of the capture of the carryover amount. |
Aged Fee Receivables |
Click on the “View Report” button. In the popup window, choose the options based on which you would like to view the report and click on the “Generate Report” button to view a report of the unpaid customer invoices by date ranges. |
Manual Payments |
Click on the “View Report” button. In the popup window, choose the options based on which you would like to view the report and click on the “Generate Report” button to view a report of the manual payments entered. |
Fee Waiver Report |
Click on the “View Report” button. In the popup window, choose the options based on which you would like to view the report and click on the “Generate Report” button to view a report of the fees waived for the Interested Parties. |
Ad Hoc Fee Report |
Click on the “View Report” button. In the popup window, choose the options based on which you would like to view the report and click on the “Generate Report” button to view a report of the Ad Hoc Fees attached to the Plans. |
These reports summarize key information about the Plans and how they are managed.
Report |
Description |
Missing Fee Schedule |
Click on the “View Report” button. In the popup window, choose the options based on what you would like to view the report and click “Generate Report” button to view a report of the Plans without a Fee Schedule. |
Plan Report |
Click on the “View Report” button. In the popup window, choose the options based on what you would like to view the report and click “Generate Report” button to view a report of the Fees by Plan, Payment Account Type, Branch Code, Fee Type and so on. |
Advisor Fee Report |
Click on the “View Report” button. In the popup window, choose the options based on which you would like to view the report and click on the “Generate Report” button to view a report to see the external vendor payment details. |
ETF Report |
Click on the “View Report” button. In the popup window, choose the options based on which you would like to view the report and click on the “Generate Report” button to view a report of the Plans that holds the ETF funds. |
Based on the reports you are on, you have the options to;
Export a List to Excel
Filter a Report List
Generate a 2nd Invoice
Download the Report as;
Excel
CSV
This option if seen on a Report page, lets you export to an Excel file the list of data displayed on that Report page. To use this functionality, click on “Export to Excel” button. The list is generated and output to an Excel file that will be saved locally in the system.
Note: It is also possible to export a list of users to an excel file based on categorical filters. To do this, apply the filters and click on the “Export to Excel” option to get the filtered list in the excel file.
This option if seen on a Report page, lets you list the data shown under that Report based on different categories of filtering that you can choose from. To use this functionality, click on the “Show Filters” option on the page you are on.
Choose the categories on which you want to filter the list and click on the “Search” button to generate the data based on your filter.
To remove the filters, click on the “Reset” button, and to hide the filter feature, click on the “Hide Filters” option (an option that toggles between Show and Hide Filters)
This option if seen on a report page, lets you generate a “Second Notice” of an already created invoice. This second Invoice can be downloaded as a PDF file.
The “Generate 2nd Invoice” option is only possible for those invoices whose status is “Unpaid” or “Partially Paid”.
To use this functionality, check the checkbox of the invoice whose “Second Notice” is required and click on the “Generate 2nd Invoice” button.
If you wish to download the PDF version a generated Report this is possible from the generated report’s popup window. Click on the “Download” button and click on the “PDF” option. This generates a PDF version of the same report that is downloaded locally.
If you wish to download the Excel version a generated Report this is possible from the generated report’s popup window. Click on the “Download” button and click on the “Excel” option. This generates an Excel version of the same report that is downloaded locally.
If you wish to download the CSV version a generated Report this is possible from the generated report’s popup window. Click on the “Download” button and click on the “CSV” option. This generates a CSV version of the same report that is downloaded locally.