[Bug]: Incorrect "uncleared total"

[DenizUgur]

What happened?

I have selected all of my transactions as cleared but all accounts summary shows that there is 7$ of uncleared total. I have seen this issue on some of my accounts as well and fixing it was possible through unclearing a locked transaction and clearing it again. But it's random, and I couldn't find which transactions are in fact not cleared but shows as cleared. I'm okay with one off clearing all my transactions if there's a way to do it.

How can we reproduce the issue?

I want to give step-by-step reproduction steps but I have no idea how this happened. I've imported my transactions, verified them and I think what caused this issue was clearing multiple transactions at once. Individually clearing them was fine.

Again it's hard to say what caused but clearing multiple transactions at once seems to trigger this.

Where are you hosting Actual?

Desktop App (Electron)

What browsers are you seeing the problem on?

Desktop App (Electron)

Operating System

Mac OSX

[db-src]

May be related to split transactions, as I think there are a couple issues indicating those have their own flags that might get out of sync in some cases - you could look for ones whose total or individual line(s) add up to the culprit amount

[matt-fidd]

Try running the "repair transactions" feature in the advanced settings menu

[DenizUgur]

I've ran repair transactions multiple times but no luck. I also don't have any split transactions so I don't think that's the issue.

I'm open to debugging this but not sure what to look for. Could we verify database is consistent and has all entries marked as "cleared"?

[youngcw]

Try isolating the bad transaction. My guess is that one of your splits is broken. You can also filter for that amount to see if its a single transaction that was marked as reconciled but not cleared somehow.

[DenizUgur]

Does splits include transfers? Otherwise there's no split transactions in my budget.