Which version are you in? Look at the menu on the left. If you see Loans with a New label, follow the first set of steps. If your leases sit inside your assets, follow the second set.
In Loans (new)
Current Accrued Interest is the interest that has built up on a loan since its last repayment but has not been paid yet. In Loans, it is worked out in two steps.
Step 1: Building the repayment schedule
When you add a loan, AssetAccountant splits each repayment into an interest part and a principal part. Lenders do not all calculate interest the same way: some count the actual days in each period, some treat every month as 30 days, some use a 360-day year, and some compound interest daily. Loan contracts rarely say which, so AssetAccountant builds the schedule using each of the common methods and keeps the one that matches your loan most accurately:
- If you enter an interest rate, it tries that rate with each method.
- If you do not enter a rate, it first works out the rate from the amount financed and the repayments (the same way as Excel's XIRR function), then tries that rate with each method.
The first method that pays the loan off to exactly zero by the final payment is used. If none does, the closest one is used, and the small difference (usually a few cents) is spread across the interest amounts so the loan still finishes at exactly zero. When the average adjustment is a cent or more per repayment, the schedule shows a message telling you so.
If none of the methods comes close, with a difference of more than 2% of total repayments, you will see a warning asking you to check your loan details, together with a suggested interest rate.
Step 2: Working out the accrued interest on a report date
The interest in each repayment is spread evenly across the days since the previous repayment. On a report date between two repayments, Current Accrued Interest is:
- the share of the next repayment's interest that has built up so far, plus
- any interest from earlier periods that is still unpaid, for example after a payment holiday or a reduced payment.
Example
A $100,000 loan is repaid at $1,000 a month on the 16th. The 16 September repayment includes $312.82 of interest, covering the 31 days from 16 August. At 31 August, 16 of those 31 days have passed (16 August to 31 August, counting both days):
$312.82 × 16 ÷ 31 = $161.46 Current Accrued Interest
On 16 September, the repayment pays the interest accrued for the period just ended, and one day of interest for the next period is accrued on the same date. So on a repayment date, Current Accrued Interest shows one day of the next period's interest rather than zero.
On the Loans screen, the Balance tab shows the interest accrued at the start and end of the period you select.
Loans is new and we are still adding to it. Bulk actions for loans are not available yet. See What is coming next in Loans.
In the current version
The accrued interest is the interest to the date of the report that's calculated as accrued to the end of the month but won't be paid until the next payment date.
It is apportioned on a daily calculation basis.