Every 2 weeks we run an Aged Debts report to monitor what each agent owe us and for what month.
The path to the Aged Debts report is the following:
Reports/Financial Reports/Debtor Trial Balance/Download CSV
Then you can sort the excel file as you wish