Is there a way to send reports (such as past due report) to a file? The purpose would be to import it into Excel so that we can sort the data.
No, not directly. The only report you can send to a CSV file would be a generic report (from the Scripts menu).