Hello everybody!

I’m creating a database to track all cash activities (inputs and outputs) from a cash box at the office.

I’d like to have a column where we keep track of the total remaining balance after each transaction, whether it was an input or output, on the same base.

A formula that I’d like to replicate is Remaining Balance = Previous Balance - Debit + Credit. How would you do that in Airtable?

Here’s a look at the base in question: Airtable - Grid view.

Thanks!