github-starred/actual
2
0
Fork 0
mirror of https://github.com/actualbudget/actual.git synced 2026-05-21 06:31:58 -05:00
Code Issues 2.1k Packages Projects Releases 57 Wiki Activity

[GH-ISSUE #4244] [Feature] Forecasting with Schedules and Running Balance Reports #27590

New Issue
Closed
opened 2026-04-18 04:10:48 -05:00 by GiteaMirror · 6 comments
GiteaMirror commented 2026-04-18 04:10:48 -05:00
Owner
Copy Link

Originally created by @Jademalo on GitHub (Jan 26, 2025).
Original GitHub issue: https://github.com/actualbudget/actual/issues/4244

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?

Recently https://github.com/actualbudget/actual/issues/3660 was merged, and with it the fantastic ability to set the schedule length to an arbitrary amount of time in the future. This is fantastic for forecasting, but unfortunately it's use is limited to the accounts view with running balance enabled.

On the software I previously used, MoneyWiz, it was possible to create a report that took into account scheduled transactions to create a graph that projected the state of each account in the future. This was incredibly useful, as it produced a simple chart that clearly showed the status of each account. Using this I was able to quickly figure out exactly how much money I had available to budget, as I could look ahead and see when the graph hit its nadir.

For example, say I had £400 in my current account, £200 expected and scheduled monthly expenses, and £300 expected and scheduled monthly income. However, in 4 months, I have an expected expense of £600, say a preorder or a 0% offer like PayPal Credit.
Even though it seems like I have £400 available in the bank, the actual amount I can spend over the next 4 months is only £200 as that's the lowest point the account will reach with the future transactions. If I was to mark the expected future expense immediately, I would end up going into the red which isn't true as I have plenty of cash in the account.

With a "Balance Over Time" report, it would be possible to clearly see that even though I have £400 right now, in 4 months after the expected expense the account will drop down to only £200. When represented as a clear line graph, it's obvious where the lowest point in the account in the future is, and therefore how much money is actually available to spend at any given time instead of just what the current balance is without any knowledge of the future.

Describe your ideal solution to this problem

Essentially, I would like to be able to create a graph of the Running Balance column to be able to quickly and easily forecast expected account balance based on scheduled transactions.

At present the only line reports available are "x-ly change" reports, and there doesn't seem to be a way to set the timescale of a report to forecast beyond the current month.
I would really like to see the option for a "Balance Over Time" report that shows a hard edged line chart clearly outlining the balance of an account at any given time, and the ability to set a report to continue on into the future using schedules to allow for clear forecasting. If multiple accounts could be overlaid on the same graph, this would show an incredibly clear overview of the expected state of every account going forward and clearly indicate how much is actually available to budget in a given month.

I have attached some screenshots below of the example scenario set up in Actual showing how forecasted information is now visible in a given account, as well as an example of that data represented in a graph in MoneyWiz.

Image

Image

Image

Hopefully this is clear enough, for me it's the one feature missing that is preventing me from switching over to Actual completely. When you start adding in multiple expected incomes and expenses on differing schedules along with 0% offers and credit card statements the whole situation gets incredibly complicated very quickly, and it's incredibly useful to be able to see this information at a glance to know how much you actually have available to spend.

Teaching and learning

No response

Originally created by @Jademalo on GitHub (Jan 26, 2025). Original GitHub issue: https://github.com/actualbudget/actual/issues/4244 ### 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? Recently https://github.com/actualbudget/actual/issues/3660 was merged, and with it the fantastic ability to set the schedule length to an arbitrary amount of time in the future. This is fantastic for forecasting, but unfortunately it's use is limited to the accounts view with running balance enabled. On the software I previously used, MoneyWiz, it was possible to create a report that took into account scheduled transactions to create a graph that projected the state of each account in the future. This was *incredibly* useful, as it produced a simple chart that clearly showed the status of each account. Using this I was able to quickly figure out exactly how much money I had available to budget, as I could look ahead and see when the graph hit its nadir. For example, say I had £400 in my current account, £200 expected and scheduled monthly expenses, and £300 expected and scheduled monthly income. However, in 4 months, I have an expected expense of £600, say a preorder or a 0% offer like PayPal Credit. Even though it seems like I have £400 available in the bank, the actual amount I can spend over the next 4 months is only £200 as that's the lowest point the account will reach with the future transactions. If I was to mark the expected future expense immediately, I would end up going into the red which isn't true as I have plenty of cash in the account. With a "Balance Over Time" report, it would be possible to clearly see that even though I have £400 right now, in 4 months after the expected expense the account will drop down to only £200. When represented as a clear line graph, it's obvious where the lowest point in the account in the future is, and therefore how much money is actually available to spend at any given time instead of just what the current balance is without any knowledge of the future. ### Describe your ideal solution to this problem Essentially, I would like to be able to create a graph of the Running Balance column to be able to quickly and easily forecast expected account balance based on scheduled transactions. At present the only line reports available are "x-ly change" reports, and there doesn't seem to be a way to set the timescale of a report to forecast beyond the current month. I would really like to see the option for a "Balance Over Time" report that shows a hard edged line chart clearly outlining the balance of an account at any given time, and the ability to set a report to continue on into the future using schedules to allow for clear forecasting. If multiple accounts could be overlaid on the same graph, this would show an incredibly clear overview of the expected state of every account going forward and clearly indicate how much is actually available to budget in a given month. I have attached some screenshots below of the example scenario set up in Actual showing how forecasted information is now visible in a given account, as well as an example of that data represented in a graph in MoneyWiz. ![Image](https://github.com/user-attachments/assets/369bd832-8ab5-46f6-b1d8-08ce6057afb9) ![Image](https://github.com/user-attachments/assets/ae6d1d14-95f0-4b5a-834d-d135461b0694) ![Image](https://github.com/user-attachments/assets/ce0ab5b4-226a-4b13-b40e-e57b504834bf) Hopefully this is clear enough, for me it's the one feature missing that is preventing me from switching over to Actual completely. When you start adding in multiple expected incomes and expenses on differing schedules along with 0% offers and credit card statements the whole situation gets incredibly complicated very quickly, and it's incredibly useful to be able to see this information at a glance to know how much you *actually* have available to spend. ### Teaching and learning _No response_
GiteaMirror added the needs votesfeature labels 2026-04-18 04:10:49 -05:00
GiteaMirror commented 2026-04-18 04:10:51 -05:00
Author
Owner
Copy Link

@github-actions[bot] commented on GitHub (Jan 26, 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:2614511337 --> @github-actions[bot] commented on GitHub (Jan 26, 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-18 04:10:51 -05:00
Author
Owner
Copy Link

@csytsma commented on GitHub (Aug 29, 2025):

I strongly support this request. I've been looking for a financial app that does the Forecasting, and Actual is sooo close to doing everything I need...except the Forecasting.

<!-- gh-comment-id:3238212218 --> @csytsma commented on GitHub (Aug 29, 2025): I strongly support this request. I've been looking for a financial app that does the Forecasting, and Actual is sooo close to doing everything I need...except the Forecasting.
GiteaMirror commented 2026-04-18 04:10:52 -05:00
Author
Owner
Copy Link

@Alex-AMC commented on GitHub (Sep 27, 2025):

I also strongly support this as a feature. It does seem that everything is there to piece it together 🤔

<!-- gh-comment-id:3342031285 --> @Alex-AMC commented on GitHub (Sep 27, 2025): I also strongly support this as a feature. It does seem that everything is there to piece it together 🤔
GiteaMirror commented 2026-04-18 04:10:53 -05:00
Author
Owner
Copy Link

@PratikSilwal5 commented on GitHub (Feb 22, 2026):

I'd love to pick this up. I'm planning to implement a 'Balance Over Time' report that projects account balances using scheduled transactions. Before I start, can I get feedback on the approach? I'm thinking this would live in the existing reports section as a new report type, pulling from the schedules API and the existing running balance logic. Would that direction make sense to the maintainers?

<!-- gh-comment-id:3941867918 --> @PratikSilwal5 commented on GitHub (Feb 22, 2026): I'd love to pick this up. I'm planning to implement a 'Balance Over Time' report that projects account balances using scheduled transactions. Before I start, can I get feedback on the approach? I'm thinking this would live in the existing reports section as a new report type, pulling from the schedules API and the existing running balance logic. Would that direction make sense to the maintainers?
GiteaMirror commented 2026-04-18 04:10:55 -05:00
Author
Owner
Copy Link

@AlphaHasher commented on GitHub (Mar 23, 2026):

@PratikSilwal5 Yes! That sounds like exactly like the kind of implementation I and other would be happy to see added

<!-- gh-comment-id:4112889382 --> @AlphaHasher commented on GitHub (Mar 23, 2026): @PratikSilwal5 Yes! That sounds like exactly like the kind of implementation I and other would be happy to see added
GiteaMirror commented 2026-04-18 04:10:55 -05:00
Author
Owner
Copy Link

@AveragePiglet commented on GitHub (Mar 29, 2026):

Really like this project, and wished it had a forecast feature, so built my own, might not be exactly what people want but it fits my needs well enough, so if anyone wants to try it they can. Data is purely based from schedules

Image
<!-- gh-comment-id:4149267470 --> @AveragePiglet commented on GitHub (Mar 29, 2026): Really like this project, and wished it had a forecast feature, so built my own, might not be exactly what people want but it fits my needs well enough, so if anyone wants to try it they can. Data is purely based from schedules <img width="1704" height="1058" alt="Image" src="https://github.com/user-attachments/assets/fcde6143-a576-42d8-9f1a-45cfbecf8e42" />
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
theme
transaction import
transaction reconciliation
transactions
translations
upstream
user interface
✅ approved
wontfix
No Label feature needs votes
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#27590
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?