Is it time to abandon MMEX due the evergreen balance issues?

[DaleVa]

For well over a year there has been an issue where you cannot reconcile against a bank statement due to incorrect balances, or balance values that belong on another line. This has traversed a number of versions, and much talk in the forum regarding SN sorting, balance sorting etc. In the most recent version, 1.9.2 there is a default setting under Settings|Transactions called Sort Date identically to Sequence Number (SN). But balances are still wrong. Sorting, resorting, optimizing database, etc., etc., etc..
Seems to me that every thread is closed because it's a known issue but several releases later the issue persists.
It's the beginning of a new year, for most a year end and a chance for a fresh start. MMEX now has worthy competition in the open source mutli-OS window.
If I'm missing something that fixes this issue please share.

DaleVa

[Renato]

Most of the discussion on this topic took place on GitHub.
See:
https://github.com/moneymanagerex/money ... ssues/8079

https://github.com/moneymanagerex/money ... ssues/7361

https://github.com/moneymanagerex/money ... ssues/7299

[frankieorabona]

For well over a year there has been an issue where you cannot reconcile against a bank statement due to incorrect balances, or balance values that belong on another line. This has traversed a number of versions, and much talk in the forum regarding SN sorting, balance sorting etc. In the most recent version, 1.9.2 there is a default setting under Settings|Transactions called Sort Date identically to Sequence Number (SN). But balances are still wrong. Sorting, resorting, optimizing database, etc., etc., etc..
Seems to me that every thread is closed because it's a known issue but several releases later the issue persists.
It's the beginning of a new year, for most a year end and a chance for a fresh start. MMEX now has worthy competition in the open source mutli-OS window.
If I'm missing something that fixes this issue please share.

DaleVa

Hi DaleVa,
the most explicit and up-to-date explanation about how balances work in MMEX is this one:
https://moneymanagerex.org/blog/how-to- ... nt-panels/

Since version 1.9.2, balances are only reliable when the transaction order matches the logical execution order. For this reason, there is a setting under Settings → Transactions called “Sort date identically to Sequence Number (SN)”. When this option is enabled, transactions must be ordered by SN or by Date (Date and SN effectively become equivalent).

If transactions are sorted using any other criteria (payee, amount, category, etc.), the running balance becomes unreliable and therefore is not shown correctly. This behavior is intentional and was introduced to avoid displaying misleading balances, which could happen in older versions when transactions were viewed out of sequence.

So this is not really an unresolved balance bug, but a design change starting from 1.9.2 to enforce consistency between transaction order and balance calculation. Once the setting is enabled and sorting is aligned with Date or SN, balances and reconciliation should behave as expected.