Customer account transaction reporting app - looking for design concepts

Currently have a React database app in development. Running off a NodeJS/Mongo backend.

The database transactions or pushed in from an external source using our API in NodeJS.

The transactions consist of customer accounts with a transaction amount field.

I am looking for ideas of how to handle the reporting of the account activity. I am currently using material-table which seems to be working well. However, the sticking point is when a report is run for a certain date range of transactions. (for example: a current year/quarter/month or any range offering I decide), how can I determine the beginning balance on the account prior to the beginning date of report so I can show a running balance and total at the end of the report.

Thoughts/ideas are welcome.

Thanks