Google Sheet Calculation

hi, if anyone can provide me help in doing math thing in google sheet data that is inserted from our app. like if i insert some data from my app to google sheet. let say if i insert some value in few columns, first column is income, second column is expenditure, and i want auto generate the remaining balance in third column respectively as insert data every month. please help

You can find a lot of info on using google sheets if you use the search function on the community. It's the big looking glass on the top right of your screen.

Depending on how you insert data to your spreadsheet, you could use an arrayFormula in your spreadsheet to automatically calculate balances/totals of the data entered.

Some ideas here:

https://infoinspired.com/google-docs/spreadsheet/google-sheets-array-formula-example-and-usage/#:~:text=In%20Google%20Sheets%2C%20you%20can,the%20result%20to%20be%20expanded.