How are you computing per-wallet SOL/SPL inflows and outflows over a fiscal year?

A user requires total SOL/SPL inflow and outflow data in USD for ~50 wallets over a fiscal year but faces limitations with Solscan's UI and paginated exports. They are using Helius with RPC calls but seek an indexed API to query transfers with pre-attached USD values for streamlined reporting.