Wrong account balance

ERPNext Accounting
1

I am confused by this:

The GL shows the correct balance for this account

Selection_145
Selection_145868×360 39.2 KB

However, on the account tree I have this wrong balance. The utility function get_balance_on also shows the wrong balance

Selection_146
Selection_1461083×134 15.2 KB

The transactions are created programmatically from a Google Sheet so I may have messed up something but I have failed to figure out

2

Have you tried this Rubber duck debugging - Wikipedia

It beats trying to explain what you have done to your audience for someone to respond