The new AI2 Spreadsheet component uses Google Sheets.
Resolve the multiple simultaneous cash flows problem by keeping all transactions as rows in a detail sheet, doing an add row for each transaction as it occurs.
Never try to update a sum in the sheet(s), because those are susceptible to multi-user conflicts.
Instead, post =SUMIFS() formulae to a summary sheet, so the sums of the detail sheets will be available.