[GH-ISSUE #1497] [Feedback] Spending report #7495

Closed
opened 2026-04-10 17:21:12 -05:00 by GiteaMirror · 28 comments
Owner

Originally created by @MatissJanis on GitHub (Aug 9, 2023).
Original GitHub issue: https://github.com/actualbudget/actual/issues/1497

Use this issue to post feedback about the new spending report by @kyrias .

It is currently behind a feature flag - enable it as an experimental feature to test it.

Screenshot 2023-08-09 at 08 39 45
Originally created by @MatissJanis on GitHub (Aug 9, 2023). Original GitHub issue: https://github.com/actualbudget/actual/issues/1497 Use this issue to post feedback about the new spending report by @kyrias . It is currently behind a feature flag - enable it as an experimental feature to test it. <img width="1440" alt="Screenshot 2023-08-09 at 08 39 45" src="https://github.com/actualbudget/actual/assets/886567/378421af-747e-4c8b-b67e-aa482097ec88">
GiteaMirror added the feedback label 2026-04-10 17:21:12 -05:00
Author
Owner

@MatissJanis commented on GitHub (Aug 9, 2023):

Some smaller suggestions:

  • could we make the category side-nav be always visible? Then we can remove the "filter" toggle icon
  • can we increase the space between the category filters in the side-nav? They feel very squished together right now
  • can we align the eye icon with the root-level category filter?
Screenshot 2023-08-03 at 21 51 14

PR: https://github.com/actualbudget/actual/pull/1548

<!-- gh-comment-id:1670828568 --> @MatissJanis commented on GitHub (Aug 9, 2023): Some smaller suggestions: - [x] could we make the category side-nav be always visible? Then we can remove the "filter" toggle icon - [x] can we increase the space between the category filters in the side-nav? They feel very squished together right now - [x] can we align the eye icon with the root-level category filter? <img width="235" alt="Screenshot 2023-08-03 at 21 51 14" src="https://github.com/actualbudget/actual/assets/886567/02ebdfc5-2c3c-4798-a68c-10120e49c22d"> PR: https://github.com/actualbudget/actual/pull/1548
Author
Owner

@Kidglove57 commented on GitHub (Aug 11, 2023):

I love the work that has been done! The thing I would really like to see is a “select all” or “deselect all” button rather than deselecting categories one by one.

<!-- gh-comment-id:1675318766 --> @Kidglove57 commented on GitHub (Aug 11, 2023): I love the work that has been done! The thing I would really like to see is a “select all” or “deselect all” button rather than deselecting categories one by one.
Author
Owner

@Crazypkr1099 commented on GitHub (Aug 11, 2023):

Hello @MatissJanis and @kyrias, I love your work you are doing with actualbudget.

I would like to suggest if you could check out another app called "Homebank" and view how they do their reports. I can post some pictures here as well, but if we could somehow implement what they have, I feel actualbudget would be amazing for reports.

It gives some ideas on how to view data and export reports. I wish I was able to code, but unfortunately I can't, and not able to learn for a while.

Please let me know what you think, im not the creator or anyway affiliated with Homebank, just a general supporter of the reports, which im hoping actualbudget will be able to recreate and make them better.

Thanks!

Ps. If this comment is not allowed (which I would understand) please copy down everything and delete it. I just want to show an example how I feel reports should be displayed graph and tablewise

Screenshot 2023-08-11 192512
Screenshot 2023-08-11 192630
Screenshot 2023-08-11 192718

<!-- gh-comment-id:1675516804 --> @Crazypkr1099 commented on GitHub (Aug 11, 2023): Hello @MatissJanis and @kyrias, I love your work you are doing with actualbudget. I would like to suggest if you could check out another app called "Homebank" and view how they do their reports. I can post some pictures here as well, but if we could somehow implement what they have, I feel actualbudget would be amazing for reports. It gives some ideas on how to view data and export reports. I wish I was able to code, but unfortunately I can't, and not able to learn for a while. Please let me know what you think, im not the creator or anyway affiliated with Homebank, just a general supporter of the reports, which im hoping actualbudget will be able to recreate and make them better. Thanks! Ps. If this comment is not allowed (which I would understand) please copy down everything and delete it. I just want to show an example how I feel reports should be displayed graph and tablewise ![Screenshot 2023-08-11 192512](https://github.com/actualbudget/actual/assets/11566471/b4cffda9-1d06-467a-8686-5961d45ed8b1) ![Screenshot 2023-08-11 192630](https://github.com/actualbudget/actual/assets/11566471/750ac14d-b265-461b-be7b-a8eb697d3cb6) ![Screenshot 2023-08-11 192718](https://github.com/actualbudget/actual/assets/11566471/17e41a46-3e46-4327-a5c1-69590200f1f8)
Author
Owner

@kyrias commented on GitHub (Aug 12, 2023):

My opinion is essentially that if someone is willing to do the UI design and development work then I'd be happy to help actually implement the backend portion of it. But I'm not really willing or able to do any real UI work myself.

<!-- gh-comment-id:1675566801 --> @kyrias commented on GitHub (Aug 12, 2023): My opinion is essentially that if someone is willing to do the UI design and development work then I'd be happy to help actually implement the backend portion of it. But I'm not really willing or able to do any real UI work myself.
Author
Owner

@Crazypkr1099 commented on GitHub (Aug 12, 2023):

Do you mean images on how it should look? Or do you need someone to do the
front end coding portion. I might be able to help design it to fit into the
"actualbudget" look but I can't code unfortunately. I'm hoping to start
learning soon after 2 more exams of my actual job :)

On Fri., Aug. 11, 2023, 8:31 p.m. Johannes Löthberg, <
@.***> wrote:

My opinion is essentially that if someone is willing to do the UI design
and development work then I'd be happy to help actually implement the
backend portion of it. But I'm not really willing or able to do any real UI
work myself.


Reply to this email directly, view it on GitHub
https://github.com/actualbudget/actual/issues/1497#issuecomment-1675566801,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/ACYH3B6VYO6GXMRJENHKLE3XU3FENANCNFSM6AAAAAA3JSJJZE
.
You are receiving this because you commented.Message ID:
@.***>

<!-- gh-comment-id:1675570505 --> @Crazypkr1099 commented on GitHub (Aug 12, 2023): Do you mean images on how it should look? Or do you need someone to do the front end coding portion. I might be able to help design it to fit into the "actualbudget" look but I can't code unfortunately. I'm hoping to start learning soon after 2 more exams of my actual job :) On Fri., Aug. 11, 2023, 8:31 p.m. Johannes Löthberg, < ***@***.***> wrote: > My opinion is essentially that if someone is willing to do the UI design > and development work then I'd be happy to help actually implement the > backend portion of it. But I'm not really willing or able to do any real UI > work myself. > > — > Reply to this email directly, view it on GitHub > <https://github.com/actualbudget/actual/issues/1497#issuecomment-1675566801>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/ACYH3B6VYO6GXMRJENHKLE3XU3FENANCNFSM6AAAAAA3JSJJZE> > . > You are receiving this because you commented.Message ID: > ***@***.***> >
Author
Owner

@kyrias commented on GitHub (Aug 12, 2023):

The latter, I'm afraid. :)

<!-- gh-comment-id:1675948171 --> @kyrias commented on GitHub (Aug 12, 2023): The latter, I'm afraid. :)
Author
Owner

@MatissJanis commented on GitHub (Aug 26, 2023):

I think we can release the spending report in the next release. WDYT?

<!-- gh-comment-id:1694238710 --> @MatissJanis commented on GitHub (Aug 26, 2023): I think we can release the spending report in the next release. WDYT?
Author
Owner

@kyrias commented on GitHub (Aug 26, 2023):

I'm a bit conflicted. On the one hand it is useful as-is, but on the other hand the current Victory-based graphs leave a lot to be desired, like how the tooltip shows up in the middle of the top (or bottom) of the category segment and the bar widths being weird on differently-wide screens.

<!-- gh-comment-id:1694403262 --> @kyrias commented on GitHub (Aug 26, 2023): I'm a bit conflicted. On the one hand it _is_ useful as-is, but on the other hand the current Victory-based graphs leave a lot to be desired, like how the tooltip shows up in the middle of the _top_ (or _bottom_) of the category segment and the bar widths being weird on differently-wide screens.
Author
Owner

@MatissJanis commented on GitHub (Sep 5, 2023):

Are you @kyrias or anyone else working on those things?

Personally I don't like features being "experimental" for long periods of time. So either we cut the feature (if we feel like it's not in a suitable state and nobody is working on finishing it) or we release it (if we feel like it's in a stable state).

<!-- gh-comment-id:1707277739 --> @MatissJanis commented on GitHub (Sep 5, 2023): Are you @kyrias or anyone else working on those things? Personally I don't like features being "experimental" for long periods of time. So either we cut the feature (if we feel like it's not in a suitable state and nobody is working on finishing it) or we release it (if we feel like it's in a stable state).
Author
Owner

@kyrias commented on GitHub (Sep 5, 2023):

For the tooltip I've tried but have no idea of how to fix the issue. I've asked for assistance before, but no one else seemed to have any idea either. The bar widths thing we cannot do anything about since it's inherent to how Victory works.

Switching from Victory to something else I could probably do, if a decision was made on that.

<!-- gh-comment-id:1707305394 --> @kyrias commented on GitHub (Sep 5, 2023): For the tooltip I've tried but have no idea of how to fix the issue. I've asked for assistance before, but no one else seemed to have any idea either. The bar widths thing we cannot do anything about since it's inherent to how Victory works. Switching from Victory to something else I could probably do, if a decision was made on that.
Author
Owner

@MatissJanis commented on GitHub (Sep 6, 2023):

if a decision was made on that

That's quite a difficult one to make. Generally I do think our current charting solution is sub-optimal. A POC here would be ideal.

<!-- gh-comment-id:1708923667 --> @MatissJanis commented on GitHub (Sep 6, 2023): > if a decision was made on that That's quite a difficult one to make. Generally I do think our current charting solution is sub-optimal. A POC here would be ideal.
Author
Owner

@joel-jeremy commented on GitHub (Sep 9, 2023):

Hidden categories are currently appearing in the report. Should we exclude hidden categories from the report?

<!-- gh-comment-id:1712371632 --> @joel-jeremy commented on GitHub (Sep 9, 2023): Hidden categories are currently appearing in the report. Should we exclude hidden categories from the report?
Author
Owner

@Crazypkr1099 commented on GitHub (Sep 9, 2023):

Hidden categories are currently appearing in the report. Should we exclude hidden categories from the report?

What if we set the hidden reports as "off" and leave them to be available?

<!-- gh-comment-id:1712372000 --> @Crazypkr1099 commented on GitHub (Sep 9, 2023): > Hidden categories are currently appearing in the report. Should we exclude hidden categories from the report? What if we set the hidden reports as "off" and leave them to be available?
Author
Owner

@joel-jeremy commented on GitHub (Sep 9, 2023):

That works too! Having them unchecked by default. Another bug I noticed is that you cannot uncheck a group if it has no categories under it.

<!-- gh-comment-id:1712375449 --> @joel-jeremy commented on GitHub (Sep 9, 2023): That works too! Having them unchecked by default. Another bug I noticed is that you cannot uncheck a group if it has no categories under it.
Author
Owner

@youngcw commented on GitHub (Sep 13, 2023):

Hidden categories are currently appearing in the report. Should we exclude hidden categories from the report?

I think it would make more sense to have hidden categories and groups not show up unless its requested in some way. Unchecked by default is an ok compromise though.

<!-- gh-comment-id:1717958628 --> @youngcw commented on GitHub (Sep 13, 2023): > Hidden categories are currently appearing in the report. Should we exclude hidden categories from the report? I think it would make more sense to have hidden categories and groups not show up unless its requested in some way. Unchecked by default is an ok compromise though.
Author
Owner

@kyrias commented on GitHub (Sep 13, 2023):

Another bug I noticed is that you cannot uncheck a group if it has no categories under it.

That's a good point, I think we should probably just hide groups without any visible categories.

<!-- gh-comment-id:1718019606 --> @kyrias commented on GitHub (Sep 13, 2023): > Another bug I noticed is that you cannot uncheck a group if it has no categories under it. That's a good point, I think we should probably just hide groups without any visible categories.
Author
Owner

@mlindgren commented on GitHub (Sep 18, 2023):

I'd love to see a pie chart that breaks down spending by category as a percentage of total spending for the given period, e.g. within August I spent x% on rent/mortgage, y% on groceries, and so on. This is a pretty useful feature of services like Mint and Rocket Money. Unfortunately, I'm not a UI guy either, so I don't have much to contribute here. If I'm looking at the right page, though, it seems like Victory should support this: https://formidable.com/open-source/victory/gallery/custom-tooltip-labels

<!-- gh-comment-id:1724187839 --> @mlindgren commented on GitHub (Sep 18, 2023): I'd love to see a pie chart that breaks down spending by category as a percentage of total spending for the given period, e.g. within August I spent x% on rent/mortgage, y% on groceries, and so on. This is a pretty useful feature of services like Mint and Rocket Money. Unfortunately, I'm not a UI guy either, so I don't have much to contribute here. If I'm looking at the right page, though, it seems like Victory should support this: https://formidable.com/open-source/victory/gallery/custom-tooltip-labels
Author
Owner

@marijnkieboom commented on GitHub (Sep 19, 2023):

I don't know if this is actually expected behaviour or not, but when toggling the mode to blurr all numbers, the y-axis is still readable in the spending report. Wouldn't it be better if this were blurred as well?

<!-- gh-comment-id:1725361036 --> @marijnkieboom commented on GitHub (Sep 19, 2023): I don't know if this is actually expected behaviour or not, but when toggling the mode to blurr all numbers, the y-axis is still readable in the spending report. Wouldn't it be better if this were blurred as well?
Author
Owner

@Spalfnaganalf1 commented on GitHub (Oct 10, 2023):

Is there anywhere within this new reporting or somewhere in the existing app where i can see total spending against a category over a certain period of time? Like if i wanted to see how much i'd spent on groceries in the last 6 months as an example, without having to get out my calculator and add up the months?

<!-- gh-comment-id:1756395386 --> @Spalfnaganalf1 commented on GitHub (Oct 10, 2023): Is there anywhere within this new reporting or somewhere in the existing app where i can see total spending against a category over a certain period of time? Like if i wanted to see how much i'd spent on groceries in the last 6 months as an example, without having to get out my calculator and add up the months?
Author
Owner

@mlindgren commented on GitHub (Oct 11, 2023):

@Spalfnaganalf1 I don't believe the app supports this, but if you're comfortable with SQL you can download a backup of your data, and then use a tool like DB Browser for SQLite to load the database and execute SQL queries against it yourself. To see the total amount for each category over a given time frame, you'd do something like:

SELECT categories.name, SUM(amount)
FROM transactions
INNER JOIN categories ON categories.id == transactions.category
WHERE transactions.date > 20220000 AND transactions.date < 20230000
GROUP BY transactions.category

Would definitely be nice to have native support for this :)

<!-- gh-comment-id:1756863512 --> @mlindgren commented on GitHub (Oct 11, 2023): @Spalfnaganalf1 I don't believe the app supports this, but if you're comfortable with SQL you can download a backup of your data, and then use a tool like [DB Browser for SQLite](https://sqlitebrowser.org/) to load the database and execute SQL queries against it yourself. To see the total amount for each category over a given time frame, you'd do something like: ``` SELECT categories.name, SUM(amount) FROM transactions INNER JOIN categories ON categories.id == transactions.category WHERE transactions.date > 20220000 AND transactions.date < 20230000 GROUP BY transactions.category ``` Would definitely be nice to have native support for this :)
Author
Owner

@Crazypkr1099 commented on GitHub (Oct 13, 2023):

Is there anywhere within this new reporting or somewhere in the existing app where i can see total spending against a category over a certain period of time? Like if i wanted to see how much i'd spent on groceries in the last 6 months as an example, without having to get out my calculator and add up the months?

@mlindgren

We actually have a way to do this in app. If you select all accounts, you can type a filter in (for example groceries) and it will show everything labeled groceries. If you select the select all button, it gives you a running total

This is the best way to do this as of right now, but reports/charting is a work in progress.

<!-- gh-comment-id:1762159220 --> @Crazypkr1099 commented on GitHub (Oct 13, 2023): > Is there anywhere within this new reporting or somewhere in the existing app where i can see total spending against a category over a certain period of time? Like if i wanted to see how much i'd spent on groceries in the last 6 months as an example, without having to get out my calculator and add up the months? @mlindgren We actually have a way to do this in app. If you select all accounts, you can type a filter in (for example groceries) and it will show everything labeled groceries. If you select the select all button, it gives you a running total This is the best way to do this as of right now, but reports/charting is a work in progress.
Author
Owner

@MatissJanis commented on GitHub (Nov 13, 2023):

👋 What's the status with this experimental feature? Are we good to launch it as a first party feature?

<!-- gh-comment-id:1808951189 --> @MatissJanis commented on GitHub (Nov 13, 2023): 👋 What's the status with this experimental feature? Are we good to launch it as a first party feature?
Author
Owner

@kyrias commented on GitHub (Nov 14, 2023):

The status from my point of view is essentially that I think that this might end up being essentially just a subset of the custom reports feature, and so might not be worthwhile keeping once that's in, so I've been holding off until that's finished up.

<!-- gh-comment-id:1811358767 --> @kyrias commented on GitHub (Nov 14, 2023): The status from my point of view is essentially that I think that this might end up being essentially just a subset of the custom reports feature, and so might not be worthwhile keeping once that's in, so I've been holding off until that's finished up.
Author
Owner

@MatissJanis commented on GitHub (Nov 15, 2023):

That makes sense @kyrias ! Thanks for clarifying :)

<!-- gh-comment-id:1812008353 --> @MatissJanis commented on GitHub (Nov 15, 2023): That makes sense @kyrias ! Thanks for clarifying :)
Author
Owner

@MatissJanis commented on GitHub (Feb 6, 2024):

👋 Hey @kyrias !

Just wanted to touch-base with you about the spending reports. It's an amazing feature you developed, but it seems it hasn't gotten any activity in the past months.

We talked among the core-maintainers and we'd like to propose removing the spending report feature in favour of the custom reports that are currently being actively developed. Most of the spending report functionality should already be possible with custom reports and some of the missing features are coming soon.

Do you think this makes sense?

Lastly I'd like to say a big THANK YOU for kickstarting the reports page improvements. I think your work here inspired custom reports + gave it a good platform to build off of. So your work is very much appreciated! 🚀

<!-- gh-comment-id:1930876817 --> @MatissJanis commented on GitHub (Feb 6, 2024): 👋 Hey @kyrias ! Just wanted to touch-base with you about the spending reports. It's an amazing feature you developed, but it seems it hasn't gotten any activity in the past months. We talked among the core-maintainers and we'd like to propose removing the spending report feature in favour of the custom reports that are currently being actively developed. Most of the spending report functionality should already be possible with custom reports and some of the missing features are coming soon. Do you think this makes sense? Lastly I'd like to say a big THANK YOU for kickstarting the reports page improvements. I think your work here inspired custom reports + gave it a good platform to build off of. So your work is very much appreciated! 🚀
Author
Owner

@kyrias commented on GitHub (Feb 6, 2024):

@MatissJanis

I'd been planning on opening a PR removing it once the custom reports are finished up, but since they're both experimental features and the custom reports feature is mostly there I guess I don't have any problems with it being removed now. :)

<!-- gh-comment-id:1930922378 --> @kyrias commented on GitHub (Feb 6, 2024): @MatissJanis I'd been planning on opening a PR removing it once the custom reports are finished up, but since they're both experimental features and the custom reports feature is mostly there I guess I don't have any problems with it being removed now. :)
Author
Owner

@MatissJanis commented on GitHub (Feb 8, 2024):

Sounds great! Would you prefer to do the cleanup yourself? I am happy to do it on my end too. Up to you :)

Reason I'm trying to get this done sooner rather than later is that it will unblock removing victory dependency. A small win for the codebase :)

<!-- gh-comment-id:1933562706 --> @MatissJanis commented on GitHub (Feb 8, 2024): Sounds great! Would you prefer to do the cleanup yourself? I am happy to do it on my end too. Up to you :) Reason I'm trying to get this done sooner rather than later is that it will unblock removing `victory` dependency. A small win for the codebase :)
Author
Owner

@MatissJanis commented on GitHub (Feb 11, 2024):

Removed in https://github.com/actualbudget/actual/pull/2344

<!-- gh-comment-id:1937811045 --> @MatissJanis commented on GitHub (Feb 11, 2024): Removed in https://github.com/actualbudget/actual/pull/2344
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#7495