generate report for paying affiliates