Bank loan repayment handling in bank statements


(Richard PALO) #1

Has anybody come up with an easier way to enter monthly bank loan repayments in statements than manually?

It would be interesting to be able to make an amortization table associated to a loan, and for each monthly payment generate the capital, interest and [optionally] insurance move lines to the appropriate accounts.

Perhaps the new payment rule could be used somehow here…


(Sebastien Marie) #2

using a payment rule permit to create the move automatically, but it is based on the bank values. it will not check it is the expect value.

I am using such configuration for loan: a rule match on Company, Statement Journal and description (my bank include loan identification number in it), and a Statement line is created automatically. I have 3 rules (one for capital, one for interest and one for insurance).

On Statement validation, the accounting Move are created.