Do you want to capture the data that is present on the last day or just an image of the data? If you just need an image, you can likely achieve this through a subscription that's triggered to send out at the end of the month. If you want the data as well, you could also schedule a monthly extract job that would grab the data on the last day of the month. You would need to move that data before the job would run again but you'd have a whole month to do it. You may also be able to configure an incremental extract refresh to automatically append the data, but it may not work for your situation: Quick Start: Incremental Extract Updates
Hope this helps!