Calculated Interest Accrual Report
The calculated interest accrual report is designed to show you how much interest has accrued over a specified date range. This report works similarly to the accrued interest report on an individual loan, but shows data for all of the accounts within your company.
To run a calculated interest accrual report, navigate to Reports > Administration > Calculated Interest Accrual inside your company account.
The primary parameters for this report are a simple date range and non-consecutive dates.
To view interest accrual over a date range, enter a date range in the date range field (under the Date Period drop-down). Select a begin and an end date from the advanced date picker.
You can also select one of the predefined date ranges from the Date Period drop-down. The options are Today, This week, 30 days, Month to date, Year to date, Yesterday, Last week, Last month, Last year, Custom, and Other.
Custom and Other warrant some additional explanation. Other is simply the option that is automatically selected when you choose a date range using the advanced date picker. Custom, however, gives you the option to enter the date range using two fields: a Date From as a number of days ago and a Date To as a number of days ago.
These field defaults to the current week.
You can also select non-consecutive dates using the Date Selection field. To do this, click in the field and select a date from the date picker. Now click to add that date. You can repeat this process as many times as you want.
You can further filter the accounts that appear in this report using the advanced option search filters. Once you’ve entered your search data, click to run the report.
Creating a Pivot Table
If you would like to see how much interest accrued per loan for the selected date range, you will need to use the pivot table feature in Excel.
To export the report information into Excel, select Data Options > Excel Data Dump.
Once you have exported the information into Excel, inside of the excel spreadsheet select Insert > Pivot Table > OK. Once the PivotTable Fields box has appeared on the right-hand side of your screen, click and drag the "Accounts" field to the Rows area and the "Accrued Interest" field to the Values area as shown below:
Once you have generated the pivot table, the numbers shown on the left-hand side of the table are the Loan ID's and the numbers on the right-hand side are the sums of accrued interest for each specific Loan ID during the selected date range.