Issue with transaction totals in the category reports section (using liabilities) #10789
Description
Support guidelines
- I've read the support guidelines
I've found a bug and checked that ...
- ... the documentation does not mention anything about my problem
- ... there are no open or closed issues that are related to my problem
- ... it's definitely a Firefly III issue, not me
Description
Hello James,
I hope you are well.
While reviewing the outstanding balances in liabilities through the category report, I found an error in the data summation, both for local currency and foreign currency.
That is, when there is a debt that is later paid or amortized, the credit amount is not displayed to be properly subtracted from the pending balance (I have attached some images below).
Note: This behavior occurs when transactions go through the liabilities module, as it works correctly when applied directly between accounts.
Debug information
Debug information generated at 2025-08-19 19:27:11 for Firefly III version v6.3.2.
| System information | |
|---|---|
| Item | Value |
| Firefly III | v6.3.2 / #26 (expects #26) |
| PHP version | 8.4.11 (64bits) / fpm-fcgi / Linux x86_64 |
| BCscale | 12 |
| Error reporting | Display: Off, reporting: ALL errors |
| Max upload | 104857600 (100 MB) |
| Database drivers | *mysql*, pgsql, sqlite, |
| Firefly III information | |
|---|---|
| Item | Value |
| Timezone | America/Caracas + America/Caracas |
| App environment | production, debug: false |
| Layout | v1 |
| Logging | notice, stack / (empty) |
| Cache driver, session driver | file, file |
| Default language and locale | en_US + equal |
| Trusted proxies | ** |
| Login provider & user guard | eloquent / web |
| Login headers | N/A + N/A |
| Stateful domains | |
| Last cron job | 2025-08-19 07:00:02 (16 hours ago) |
| Mailer | smtp |
| Exchange rates | Disabled, downloads disabled |
| RB-column | Disabled |
| User-specific information | |
|---|---|
| Item | Value |
| User | #1 of 2 |
| User flags | 💳 🐷 🔧 🕜 📑 📧 |
| Primary currency | EUR |
| Convert to primary currency? | Disabled |
| Session start | 2025-08-01 00:00:00 |
| Session end | 2025-08-31 00:00:00 |
| View range | 1M |
| User language | en_US |
| User locale | en_US |
| Locale(s) supported | en_US.utf8: ✅ en_US.UTF-8: ✅ |
| User agent | Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:128.0) Gecko/20100101 Firefox/128.0 |
Steps to reproduce
In the first example with local currency, it can be seen that on August 15th there was a liability with the dentist for 80 Euros using the category (Medical Assistance).
Then, on August 18th, I settled the pending debt of 80 Euros using a local currency account under the same category (Medical Assistance).
Technically, 80 - 80 = 0. In the liabilities section, everything is displayed perfectly.
In the second case, when I go to the category reports, I see that the debt of 80 euros is shown under 'Spent', but the amortization of the 80 euros does not appear under 'Earned'.
In case 3: The same behavior is reproduced using foreign currency.
Results in the category report using foreign currency.
Additional info
I truly appreciate your support in this amazing project