Hi,
To manage a loan liability in Odoo when transitioning from the previous year, you can transfer the total liability from the general ledger (GL) to a vendor in Accounts Payable (AP). This allows monthly payments to be tracked against a partner, while keeping the split of principal, interest, and tax clear. For example, a loan liability of 100,000 can be recorded as an opening balance in AP, with separate GL accounts for principal, interest, and tax, ensuring each component is tracked individually.
Monthly payments, such as 6,000 (4,200 principal + 900 interest + 900 tax), can then be made as a single payment in Odoo. The payment is allocated across the AP vendor and the corresponding GL accounts for principal, interest, and tax. This reduces both the vendor balance and the GL liabilities proportionally, allowing accurate tracking of remaining balances.
Using this approach, reports from the Partner Ledger and GL will show the remaining liability for each component at any point in time. This setup ensures that payments, accounting, and reporting remain synchronized, making it easy to monitor principal, interest, and tax portions throughout the year while maintaining accurate financial records.
Reference:-
* https://www.odoo.com/documentation/19.0/applications/finance/accounting/bank/loans.html
* https://www.youtube.com/watch?v=YbeuDi6Y6XM
* https://www.cybrosys.com/blog/how-to-track-and-manage-loans-in-odoo-18-accounting
https://apps.odoo.com/apps/modules/18.0/advanced_loan_management
Hope it helps
Hello community,
I've faced the same problem while importing last fiscal year accounting data in odoo and doing payment for it.
Have anyone faced the same query, respond for it!
Thanks