Starting balance includes transactions that occur at 00:00 on the 1st of month

[jteez]

Just started using this project, and looks really good, but just wanted to explain what I've seen as I was thinking of raising bug but thought i'd discuss first just incase it is expected behaviour

[Bug] Inaccurate "Balance difference" on Accounts Overview with Date-Only Transactions (v6.2.21)
I've encountered a persistent discrepancy with the "Balance difference" displayed on the /accounts/asset overview page. Initially it was definitely partly my lack of understanding but after extensive debugging, I believe I've pinpointed the underlying behavior that causes it.

Firstly the UI doesn't show the time period (on the assets page) that the Balance difference referes to so it's difficult to figure it out especially given the behaviour descriped below.

Secondly (the main issue): It seems to me that monthly starting balances are calculated including transactions that occur on the first of the month @ 00:00 (e.g. imported from CSV with date only and no time).
This effectively means that the 'Balance Difference shown on the assets page is that from the 2nd of the month until now (if imported transactions don't have timestamps).

Example of logs
[2025-07-19 11:45:16] production.DEBUG: Updated entry [2025-07-16] {"balance":"xxxx.300000000000",...}
->This is the correct end-of-period balance).

[2025-07-19 11:45:16] production.DEBUG: Start balance for account #8 ("nnnn) is {"balance":"yyyy.260000000000",...}
-> The start balance calculated here includes transactions on the first of the month

Firefly III Version: v6.2.21
Firefly III Data Importer Version: v1.7.7
Hosting Method: Docker
Database: MariaDB LTS
Browser: Chrome

Thank you for your time and for maintaining such a valuable project! I'm happy to provide any further logs or information that might be helpful.

[jteez]

Perhaps something like this, but I'm not sure on the impact on the wider project....?

// app/Http/Controllers/Account/IndexController.php @line ~96

// ... (previous code) ...

// Define the start moment for the 'startBalances' calculation
// This ensures we get the balance before any transactions on the start day of the reporting period.
// If $start is 2025-07-01 00:00:00, we want balance as of 2025-06-30 23:59:59.
$startBalanceMomentForPeriod = $start->clone()->subSecond();

Log::debug(sprintf('inactive start: finalAccountsBalance("%s") (requested start)', $start->format('Y-m-d H:i:s')));
Log::debug(sprintf('inactive start: finalAccountsBalance("%s") (used for startBalances)', $startBalanceMomentForPeriod->format('Y-m-d H:i:s'))); // Add this for debugging
Log::debug(sprintf('inactive end: finalAccountsBalance("%s")', $end->format('Y-m-d H:i:s')));

// Change THIS LINE:
$startBalances = Steam::finalAccountsBalance($accounts, $startBalanceMomentForPeriod);

// Keep this line as is:
$endBalances = Steam::finalAccountsBalance($accounts, $end);

$activities = Steam::getLastActivities($ids);

// ... (rest of the code) ...

[JC5]

Secondly (the main issue): It seems to me that monthly starting balances are calculated including transactions that occur on the first of the month @ 00:00 (e.g. imported from CSV with date only and no time).

Yes, this is by design.

If I understand you correctly, you were expecting this behavior:

• 30-06-2025 23:59 part of June 2025
• 01-07-2025 00:00 part of June 2025
• 01-07-2025 00:01 part of July 2025

But instead, you see

• 30-06-2025 23:59 part of June 2025
• 01-07-2025 00:00 part of July 2025
• 01-07-2025 00:01 part of July 2025

Is that correct?

[jteez]

Thanks for the reply, I agree with your logic, but this was not quite the issue I was experiencing...

In the Assets (e.g. /accounts/asset) page it gives 'balance difference' on the far right for each account.
I understand that this is showing / calculating the change in balance of the current month (e.g. from the begining of the month)?

For me it's showing a value that is excluding transactions that happened on the 1st of the month (at 00:00), when I would expect it to include them.

So if balance is starting £0

Balance	Time	description	Amount
29 Jun 2025	00:00	1	10
1 July 2025	00:00	2	10
2 July 2025	00:00	3	10

The current balance is correct and shows £30, but the balance difference is showing £10 instead of £20 that I think it should be showing?

[JC5]

You're right, nicely spotted. I'll put a fix out right away!