Reverse Calculated Archive
The reverse calculated archive gives daily loan data for a date range you can specify. This report is similar to the Historical Archive except where the Historical Archive shows daily loan data as it actually existed on the account by taking a snapshot of the data each day, the Reverse Calculated Archive uses the numbers as they currently exist on a loan to calculate what the numbers would have been in the past.
It is important to note the difference between these two methods of doing things. As an example, let’s say you had three apples you were trying to sell.
On day one you sold two apples, but one of your customers took an apple on day one, but didn’t pay until the next day (day two). On day two, you record the second sale from day one when you receive the money. Now your records show two sales on day one. The Reverse Calculated Archive and the Historical Archive will see this situation differently. Since the Historical Archive takes a daily snapshot and at the end of day one you hadn’t recorded the second sale, the Historical Archive will show that on day one you only sold one apple.
The Reverse Calculated Archive sees the information as it is recorded now, and since you recorded the second day-one apple sale the next day, the Reverse Calculated Archive would show that you sold two apples on day one.
To run a Reverse Calculated Archive report, navigate to Reports > Calculated > Reverse Calculated Archive inside a loan account. Enter a date range using the advanced date picker in the field at the top of the report.
You can also select a predefined range from the drop-down next to the field. The options include: Today, Last 7 Days, Last 30 Days, Last 60 Days, Last 90 Days, Last 180 Days, This Month, Last Month, Year to Date, This Year, and Custom Range. Once you’ve chosen your date range, the results will be pulled automatically.
You will see the following information for each day in the report:
- Principal – This is the remaining principal balance on the date.
- Payoff Fees – This is the total of outstanding payoff fees on the date.
- Aging – This is the age of the loan in days on the date.
- Amount Past Due – This is the amount the account is past due on the date.
- Days Past Due – This is the number of days the account is past due on the date.
- Due Discount – This is the amount of discount that is due on the date.
- Due Interest – This is the amount of interest that is due on the date.
- Due Fees – This is the total amount in fees that is due on the date.
- Due Principal – This is the amount of principal that is due on the date.
- Accrued Interest – This is that amount of interest that accrued on the date (per diem interest).
- Net Charge Off – This is the total amount charged off on the account on the date.