Good Morning, Is it possible to create a balance sheet in JotForms?

I want to create a sheet where you input a grand total and then when portions of that total are distributed it shows the calculation and balance.  I also want to be able to add amounts to the current total and the date it was added.

Thanks,

You can try to add a Spreadsheet widget in your form: https://widgets.jotform.com/widget/spreadsheet. Using the Spreadsheet widget, you can perform calculation or add formula on each cell just like in Excel. You can check the demo of the widget here: https://form.jotform.com/61441655557965. 

You can also add a calculation field in your form using the Calculation Widget: https://widgets.jotform.com/widget/calculation. For more information about the calculation field, you can check this article: How to Perform Calculation in the Form.

Do let us know if you need further assistance.
Regards.