Automatically Generating Monthly Reports

Hi,

I am currently making a base to track when we receive publishing royalties. Is there a way to make Airtable automatically generate a report that lists the royalties we are expecting for the month or a report at the end of the month detailing which ones were not received?