mirror of
https://github.com/actualbudget/actual.git
synced 2026-07-16 15:14:02 -05:00
[GH-ISSUE #4244] [Feature] Forecasting with Schedules and Running Balance Reports #79231
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/actual#79231
Reference in New Issue
Block a user
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?
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?
💻
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.
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
@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 👍!
@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.
@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 🤔
@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?
@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
@Icarus-A7 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