How to programmatically extract account balances

Here is my scenario:

I need to get balances from certain accounts, say the Sales account, for a particulary day, and send it via an API to an external app.

How can I achieve this?

@rmehta are you able to assist?

You can able to get an account balance for a particular day, a particular party and many more filters are there using this whitelist method.