automate manual reporting

See here for PBI Sample for loan consolidation.