Keeping Track of Client's Account Balance


We are using an AirTable form to have our client’s submit purchase requests. I would like to then subtract that data from their starting account balance and generate a report with their current balance.

I know how I would do this in excel, but I’m not sure where to go in AirTables.

Any ideas how I could do this?