You could take a look here to see how a column total can be calculated. Then experiment with setting Softr filters to manage your data for the time periods you have mentioned.
I want to be able to select a customer and show what their total was any time period in that month
If it is only you needing to view this data, it is very easy to do this is Airtable natively.