[GH-ISSUE #2703] [Bug]: Hide reconciled transactions - wrong balance shown #98488

Closed
opened 2026-05-29 10:07:49 -05:00 by GiteaMirror · 6 comments
Owner

Originally created by @ngocphamm on GitHub (May 4, 2024).
Original GitHub issue: https://github.com/actualbudget/actual/issues/2703

Verified issue does not already exist?

  • I have searched and found no existing issue
  • I will be providing steps how to reproduce the bug (in most cases this will also mean uploading a demo budget file)

What happened?

Balance on the account is shown differently when reconciled transactions are hidden.

Not hidden

CleanShot 2024-05-04 at 10 27 15

Hidden

CleanShot 2024-05-04 at 10 27 36

I think another person experienced this too https://github.com/actualbudget/actual/issues/2503#issuecomment-2094151378

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Firefox

Operating System

Mac OSX

Originally created by @ngocphamm on GitHub (May 4, 2024). Original GitHub issue: https://github.com/actualbudget/actual/issues/2703 ### Verified issue does not already exist? - [X] I have searched and found no existing issue - [X] I will be providing steps how to reproduce the bug (in most cases this will also mean uploading a demo budget file) ### What happened? Balance on the account is shown differently when reconciled transactions are hidden. Not hidden ![CleanShot 2024-05-04 at 10 27 15](https://github.com/actualbudget/actual/assets/395123/27d6b1ea-07ec-4f36-afe0-b8bc314b2a70) Hidden ![CleanShot 2024-05-04 at 10 27 36](https://github.com/actualbudget/actual/assets/395123/ffb55a0e-f495-409f-8fba-2ccddfbac7b2) I think another person experienced this too https://github.com/actualbudget/actual/issues/2503#issuecomment-2094151378 ### Where are you hosting Actual? Docker ### What browsers are you seeing the problem on? Firefox ### Operating System Mac OSX
GiteaMirror added the bugtransaction reconciliationtransactionsuser interface labels 2026-05-29 10:07:50 -05:00
Author
Owner

@ToniCipriani commented on GitHub (May 5, 2024):

Issue confirmed on Windows and Android PWA as well.

<!-- gh-comment-id:2094651479 --> @ToniCipriani commented on GitHub (May 5, 2024): Issue confirmed on Windows and Android PWA as well.
Author
Owner

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

👋 Would you mind providing a demo budget export so folks can reproduce the issue?
Thanks

<!-- gh-comment-id:2095565092 --> @MatissJanis commented on GitHub (May 6, 2024): 👋 Would you mind providing a demo budget export so folks can reproduce the issue? Thanks
Author
Owner

@ngocphamm commented on GitHub (May 6, 2024):

@MatissJanis Please use this one.

2024-05-06-My-Finances-2befb2e.zip

<!-- gh-comment-id:2096108680 --> @ngocphamm commented on GitHub (May 6, 2024): @MatissJanis Please use this one. [2024-05-06-My-Finances-2befb2e.zip](https://github.com/actualbudget/actual/files/15221673/2024-05-06-My-Finances-2befb2e.zip)
Author
Owner

@joel-jeremy commented on GitHub (May 14, 2024):

The issue occurs because the running balance calculation runs the calculations based on the queried transactions. In the case of hiding the reconciled transaction, the reconciled transaction are being excluded from the query hence the calculation is returning the wrong results.

I can think of two possible ways to fix this:

  1. Revert the query to fetch all transactions (including reconciled) but do not render the reconciled transactions.
  2. When toggling the reconciled transactions, recalculate the starting balance in which the running balance calculation will start from.
<!-- gh-comment-id:2110789328 --> @joel-jeremy commented on GitHub (May 14, 2024): The issue occurs because the running balance calculation runs the calculations based on the queried transactions. In the case of hiding the reconciled transaction, the reconciled transaction are being excluded from the query hence the calculation is returning the wrong results. I can think of two possible ways to fix this: 1. Revert the query to fetch all transactions (including reconciled) but do not render the reconciled transactions. 2. When toggling the reconciled transactions, recalculate the starting balance in which the running balance calculation will start from.
Author
Owner

@youngcw commented on GitHub (May 14, 2024):

The issue occurs because the running balance calculation runs the calculations based on the queried transactions. In the case of hiding the reconciled transaction, the reconciled transaction are being excluded from the query hence the calculation is returning the wrong results.

I can think of two possible ways to fix this:

  1. Revert the query to fetch all transactions (including reconciled) but do not render the reconciled transactions.
  2. When toggling the reconciled transactions, recalculate the starting balance in which the running balance calculation will start from.

I think either of those would work. The one small thing with option 1 is that the transactions may not be contiguous and that would make the running balance not align perfectly with the shown transactions. Option 2 would get around this, but could be annoying to users who would like both.

<!-- gh-comment-id:2110796620 --> @youngcw commented on GitHub (May 14, 2024): > The issue occurs because the running balance calculation runs the calculations based on the queried transactions. In the case of hiding the reconciled transaction, the reconciled transaction are being excluded from the query hence the calculation is returning the wrong results. > > I can think of two possible ways to fix this: > > 1. Revert the query to fetch all transactions (including reconciled) but do not render the reconciled transactions. > 2. When toggling the reconciled transactions, recalculate the starting balance in which the running balance calculation will start from. I think either of those would work. The one small thing with option 1 is that the transactions may not be contiguous and that would make the running balance not align perfectly with the shown transactions. Option 2 would get around this, but could be annoying to users who would like both.
Author
Owner

@alex-t-grey commented on GitHub (Jul 11, 2024):

I think either of those would work. The one small thing with option 1 is that the transactions may not be contiguous and that would make the running balance not align perfectly with the shown transactions. Option 2 would get around this, but could be annoying to users who would like both.

I think it's ok if the running balance is not contiguous, so long as it's accurate to what the balance was at time of the transaction. It sounds like option 1 would give this result.

<!-- gh-comment-id:2222904101 --> @alex-t-grey commented on GitHub (Jul 11, 2024): > I think either of those would work. The one small thing with option 1 is that the transactions may not be contiguous and that would make the running balance not align perfectly with the shown transactions. Option 2 would get around this, but could be annoying to users who would like both. I think it's ok if the running balance is not contiguous, so long as it's accurate to what the balance was at time of the transaction. It sounds like option 1 would give this result.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#98488