github-starred/actual
2
0
Fork 0
mirror of https://github.com/actualbudget/actual.git synced 2026-11-09 10:45:04 -06:00
Code Issues 3.0k Packages Projects Releases 58 Wiki Activity

[GH-ISSUE #4201] [Feature] Amortization Schedule #43437

New Issue
Closed
opened 2026-04-26 03:52:51 -05:00 by GiteaMirror · 3 comments
GiteaMirror commented 2026-04-26 03:52:51 -05:00
Owner
Copy Link
Copy Source

Originally created by @ElDubsNZ on GitHub (Jan 20, 2025).
Original GitHub issue: https://github.com/actualbudget/actual/issues/4201

Verified feature request does not already exist?

  • I have searched and found no existing issue

💻

  • Would you like to implement this feature?

Pitch: what problem are you trying to solve?

Updating personal loans or mortgages each schedule period to account for the lowering repayments as each payment period passes is inefficient. Loans and mortgages amortize with each payment.

When repaying a loan, there are two components to your repayment. The interest, and the principal.

As you pay more of the loan off, the amount of interest generating reduces because there's less loan. Actual doesn't have a system to handle this, so we must manually adjust schedules by the small amount required to tidy this up.

Describe your ideal solution to this problem

There are a few different calcuations, which the wiki on Amortizing loans covers pretty well.

All Actual needs, is a small menu on the schedule where you enter the current balance (or it takes this from the account), the interest rate, and the maturity date, and the type of amortizing loan. And with repeating schedules, you'll already be entering the payment frequency so that's already built in.

It could then calculate the next schedule payment based on the details provided.

For a simple equated monthly installment, it's going to divide the remaining amount by the number of payments before maturity, then it's going to calculate the interest at the next payment date, add that to it, and the principle + interest is the payment.

Different types are possible, some people go on a payment holiday, so the interest will be added, but no repayment made. Some people are on "interest only" where they're paying the interest and no principal, etc...

The wiki above has the calculations required.

Teaching and learning

A simple menu that guides people through creating these in the schedule rule creator would suffice, it'd have the fields required to create this as from a user perspective, it's fairly simple.

Originally created by @ElDubsNZ on GitHub (Jan 20, 2025). Original GitHub issue: https://github.com/actualbudget/actual/issues/4201 ### Verified feature request does not already exist? - [x] I have searched and found no existing issue ### 💻 - [ ] Would you like to implement this feature? ### Pitch: what problem are you trying to solve? Updating personal loans or mortgages each schedule period to account for the lowering repayments as each payment period passes is inefficient. Loans and mortgages amortize with each payment. When repaying a loan, there are two components to your repayment. The interest, and the principal. As you pay more of the loan off, the amount of interest generating reduces because there's less loan. Actual doesn't have a system to handle this, so we must manually adjust schedules by the small amount required to tidy this up. ### Describe your ideal solution to this problem There are a few different calcuations, which the wiki on [Amortizing loans](https://en.wikipedia.org/wiki/Amortizing_loan) covers pretty well. All Actual needs, is a small menu on the schedule where you enter the current balance (or it takes this from the account), the interest rate, and the maturity date, and the type of amortizing loan. And with repeating schedules, you'll already be entering the payment frequency so that's already built in. It could then calculate the next schedule payment based on the details provided. For a simple equated monthly installment, it's going to divide the remaining amount by the number of payments before maturity, then it's going to calculate the interest at the next payment date, add that to it, and the principle + interest is the payment. Different types are possible, some people go on a payment holiday, so the interest will be added, but no repayment made. Some people are on "interest only" where they're paying the interest and no principal, etc... The wiki above has the calculations required. ### Teaching and learning A simple menu that guides people through creating these in the schedule rule creator would suffice, it'd have the fields required to create this as from a user perspective, it's fairly simple.
GiteaMirror added the needs votesfeature labels 2026-04-26 03:52:51 -05:00
GiteaMirror commented 2026-04-26 03:52:53 -05:00
Author
Owner
Copy Link
Copy Source

@github-actions[bot] commented on GitHub (Jan 20, 2025):

✨ Thanks for sharing your idea! ✨

This repository uses lodash style issue management for enhancements. That means enhancement issues are automatically closed. This doesn’t mean we don’t accept feature requests, though! We will consider implementing ones that receive many upvotes, and we welcome contributions for any feature requests marked as needing votes (just post a comment first so we can help you make a successful contribution).

The enhancement backlog can be found here: https://github.com/actualbudget/actual/issues?q=label%3A%22needs+votes%22+sort%3Areactions-%2B1-desc+

Don’t forget to upvote the top comment with 👍!

<!-- gh-comment-id:2601237520 --> @github-actions[bot] commented on GitHub (Jan 20, 2025): :sparkles: Thanks for sharing your idea! :sparkles: This repository uses lodash style issue management for enhancements. That means enhancement issues are automatically closed. This doesn’t mean we don’t accept feature requests, though! We will consider implementing ones that receive many upvotes, and we welcome contributions for any feature requests marked as needing votes (just post a comment first so we can help you make a successful contribution). The enhancement backlog can be found here: https://github.com/actualbudget/actual/issues?q=label%3A%22needs+votes%22+sort%3Areactions-%2B1-desc+ Don’t forget to upvote the top comment with 👍! <!-- feature-auto-close-comment -->
GiteaMirror commented 2026-04-26 03:52:54 -05:00
Author
Owner
Copy Link
Copy Source

@superzanti commented on GitHub (Jan 29, 2025):

I would love this feature!

<!-- gh-comment-id:2620487806 --> @superzanti commented on GitHub (Jan 29, 2025): I would love this feature!
GiteaMirror commented 2026-04-26 03:52:54 -05:00
Author
Owner
Copy Link
Copy Source

@alex-t-grey commented on GitHub (May 27, 2025):

Even if they only implemented the ability for dynamic calculations in a Schedule, it would allow you to set up interest charges.

For example: Amount = Account Balance * Interest Rate / 12 would give you the correct interest charge for the month at the time the transaction is created.

This wouldn't require any new UI either, so may be faster to implement.

<!-- gh-comment-id:2912502935 --> @alex-t-grey commented on GitHub (May 27, 2025): Even if they only implemented the ability for dynamic calculations in a Schedule, it would allow you to set up interest charges. For example: `Amount = Account Balance * Interest Rate / 12` would give you the correct interest charge for the month at the time the transaction is created. This wouldn't require any new UI either, so may be faster to implement.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
AI generated
API
bank sync
budgeting
bug
can’t replicate
dependencies
docker
documentation
electron
experimental feature
feature
feedback
goal templates
good first issue
help wanted
importers
maintenance
needs info
needs testing
needs triage
needs votes
openid
payees
pull-request
Mirrored from GitHub Pull Request
 regression
reports
responsive
rules
schedules
server
✨ merged
split transactions
tech debt
tech-support
theme
transaction import
transaction reconciliation
transactions
translations
upstream
user interface
✅ approved
wontfix
No labels feature needs votes
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
GiteaMirror ninjasurge (Kaehlen Rog)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#43437