Interest payments are made at a point in time. From an accounting perspective, the interest owed for each of those payments is accruing during the period between payments. Therefore, accountants have to record the interest owed, but not yet paid, at specific reporting periods. We now let you see accrued interest and interest expenses at the issue detail level and export the information to excel with formatted journal entries.
How It Works
When viewing the Detailed Debt Service page of a given issue, You will see two columns to show Accrued Interest and the associated Interest Expense.
These columns show the expected interest accrual / expense account balance as of the date in the left hand column.
Note: The date is the payment date if using an Actual frequency or the As-Of date if using an Annual, Semi-Annual, Quarterly or Monthly frequency.
Note: When using Actual frequency the accrued interest column is empty. This reflects that the most recent payment made has cleared out the interest accrued so that the next period's interest can begin to accrue.
Exportable Journal Entries
You can export the Debt Service Detail page to excel by clicking the blue export icon in the top right of the screen.
When you export this page the excel download will have two tabs. The first tab, Detail Debt Service, is a formatted excel replica of the data available on the current screen.
The second tab provides the Journal Entries including the Dates, General Ledger Numbers, Account Names, Debits, Credits and Descriptions.
1. Journal entries in DebtBook function on a reversal method. We provide a description in Column F with the relevant reversal dates.
2. The DebtBook application uses actual days instead of months for better accuracy.