The is a problem with date! Is it the date when the invoice was get (probably it i this one), or the date of payment. When it is invoice date, it is possible, that this invoice was payed before some other invoices with earlier invoice date - making all this balance calculation wrong.



But when in column S.NO. are not formulas, but values, I'd prefer for Balance calculations the formula (I use the syntax used when the table is Defined Table)
(This formula doesn't depend on order of rows in table! So you can sort the table in any way you want, and the calculated balances remain unchanged!)