[Bug]: Net * Report Types Not Calculating Correctly #2818

Closed
opened 2026-02-28 20:29:27 -06:00 by GiteaMirror · 0 comments
Owner

Originally created by @CrazyKidJack on GitHub (Jan 14, 2026).

Verified issue does not already exist?

  • I have searched and found no existing issue

What happened?

Expectation

I expect a custom report with type=net deposit show only the positive values from an equivalent type=net report.
I expect a custom report with type=net payment show only the negative values from an equivalent type=net report.
This would imply that with mode=total and split=interval, any particular period could ONLY HAVE ONE OF "net payment" or "not deposit" by non-zero.

More specifically, I expect this behavior

youngcw — 11:13
net payment = min(deposit - payment,0) then make it a max for net deposit

Observation

Under the given conditions, BOTH "net payment" AND "net deposit" can be non-0 for the same filter in the same time period. Additionally, neither of the "net *" types matches what the "net" report shows for that time period.

Investigation

I asked in the discord about this, and youngcw seems to think it is a bug.

youngcw — 11:37
Ok, it does look like it is removing data too early. Open a bug report for this
May just be the bar graph, but it would be good to check the other report types to see if they do the same thing

CrazyKidJack — 11:39
So it's not because somehow net * types take into account the category?
Rather, it's because it's a bug?
Or at least that's your hunch right now?
If you add a $100 deposit with category=bills and date=2026-01-01... then both net * reports are still non-0... but at least the net payments report value goes down. That's why I thought it had something to do with categories

youngcw — 11:50
It looks like a bug

How can we reproduce the issue?

  1. Open the attached example budget file
  2. Go to the "Reports" page
  3. Go to the "Test" account ledger to see the example transactions (there's only a couple)
  4. Observe that the values list in the various reports on Jan 1 do not match expectation

2026-01-14-My Finances 1.zip

Where are you hosting Actual?

Desktop App (Electron)

What browsers are you seeing the problem on?

Desktop App (Electron)

Operating System

Windows 11

Originally created by @CrazyKidJack on GitHub (Jan 14, 2026). ### Verified issue does not already exist? - [x] I have searched and found no existing issue ### What happened? ### Expectation I expect a custom report with `type=net deposit` show only the positive values from an equivalent `type=net` report. I expect a custom report with `type=net payment` show only the negative values from an equivalent `type=net` report. This would imply that with `mode=total` and `split=interval`, any particular period could ONLY HAVE ONE OF "net payment" or "not deposit" by non-zero. More specifically, I expect this behavior > youngcw — 11:13 net payment = min(deposit - payment,0) then make it a max for net deposit ### Observation Under the given conditions, BOTH "net payment" AND "net deposit" can be non-0 for the same filter in the same time period. Additionally, neither of the "net *" types matches what the "net" report shows for that time period. ### Investigation I asked in the discord about this, and youngcw seems to think it is a bug. > youngcw — 11:37 Ok, it does look like it is removing data too early. Open a bug report for this May just be the bar graph, but it would be good to check the other report types to see if they do the same thing > CrazyKidJack — 11:39 So it's not because somehow net * types take into account the category? Rather, it's because it's a bug? Or at least that's your hunch right now? If you add a $100 deposit with category=bills and date=2026-01-01... then both net * reports are still non-0... but at least the net payments report value goes down. That's why I thought it had something to do with categories > youngcw — 11:50 It looks like a bug ### How can we reproduce the issue? 1. Open the attached example budget file 2. Go to the "Reports" page 3. Go to the "Test" account ledger to see the example transactions (there's only a couple) 4. Observe that the values list in the various reports on Jan 1 do not match expectation [2026-01-14-My Finances 1.zip](https://github.com/user-attachments/files/24622269/2026-01-14-My.Finances.1.zip) ### Where are you hosting Actual? Desktop App (Electron) ### What browsers are you seeing the problem on? Desktop App (Electron) ### Operating System Windows 11
GiteaMirror added the reportsbug labels 2026-02-28 20:29:27 -06:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#2818