SAP Cash Management provides an app Make Bank Transfer ( MBT) to make transfers between accounts.
Most of the time customers complain about the wrong balance in the account.Below is the logic to determine the total balance in an account after release S/4HANA 1605:
Balance in Make Bank Transfers = Opening Balance ( sum of all actual flows before today) + Overdue (sum of all other forecast flows before today ) + all flows on today.
This can be treated as the formula for calculating the balance.
Now i would also like to add here that the field FQM_FLOW-BANK_ACCOUNT_ID works as the key field for the flows to be considered.
So while comparing the sum of amount of cash flows in FQM_FLOW with the account balance in MBT app, do not add the balances from different BANK_ACCOUNT_ID as it is incorrect.
Best Regards,
Akash