Finance manager / account statements moudle in appsheets

[Team]

Hi
I am in the process of planing an app for my business , which would gather all sales, inventory movements, and money transactions.
I am looking around to see if AppSheet / PowerApps is the solution for me .
i have not found or saw any example or something similar that can show me that it can be done with Appsheet .
My main concern is the database structure , how to handle each transaction in 2 tables .
For example :
Customer1 pays for hes order to the bank account.
I need to update the customer table , to reflect hes balance, and on the same time , I need to update this transaction on the bank account table to reflect the balance.

So my question is , is it something AppSheet would be able to perform in a smooth / efficient way ?
And maybe someone can show me a similar module so I can know how to plan it correctly ?

Thanks

[LeventK]

@Team
That can be done with many ways:

1. Thru Actions
2. Thru Data Change Workflow
3. Thru Webhook Workflow

The method totally relies on your business process flowchart. There are many documentation and community posts available.

[LOKMAN]

I am looking for the same topic .. Is it possible to explain the application of this idea