DESKTOP EDITION CLOUD EDITION SERVER EDITION GUIDES FORUM

Loan accounts - automated interest calculation


#1

I use several loan accounts. These are required to be interest bearing. This means that every month, interest on the loan balance must be calculated and accrued to the balance. To be truly accurate, every time the loan balance changes, you should re-calculate the interest for the days since the last change. These amounts should be summed at the end of each month and added to the balance. To do this, I have to keep a separate spreadsheet with the calculations and manually transfer the amounts to the loan account every month. If a historical transaction is added, all of the values in the spreadsheet change and thus all the interest transactions for the complete loan account must be changed in manager. It would be great if these interest calculations could be performed by manager automatically. You would only need to configure the interest rate and the method of interest accrual (daily/monthly/yearly).


#2

Wow, if this kind of functionality is built into Manager it it makes an already outstanding product unique!


#3

“IF” Manager did have such a feature then the monthly accounting entry would have to be manually triggered rather then being an automatic end of month entry as transactions relating to the month may remain unprocessed until some point in the future.

The question is - once the accounting entry has been posted, can that interest entry or any previous month interest entry be allowed to be adjusted due to a historical transaction. Each month affect by that historical transaction would have to be re-triggered.

What if that transaction was in a prior year, and end of year accounts and tax returns were completed.
While a transaction can be processed to the original date, re-calculating the interest could be problematic, otherwise the concept has merit but probably not a wide application - one to put in the melting pot for future consideration


#4

@John_Hope_Bailie, what are these loan accounts? Loans you give to other entities? Because that’s the only time I’d consider this to be useful.


#5

Good points. I was interested as to whether this was of general interest. I guess not. Also it seems tricky to implement. Thanks for the comments.


#6

Yes. You are correct. Typically when several people are involved in owning a property (or a business) and they assist by paying for various expenses without the intention of being reimbursed until a later date. One wishes to keep track of this as well as interest that the outstanding balance should earn in order to be fair to the lender


#7

I forgot to add, on the assumption that you can’t re-trigger a month, you could always use a General Journal to take up any prior period interest adjustments.