I used Microsoft PowerPoint to overview the outstanding claims from last week. I also inserted a graph to illustrate the flow of the claims.

I used Microsoft PowerPoint to illustrate the aging days of the claims as of 15 to 91 days, as well as their total claims and amount.

I used Microsoft Excel to consolidate the dealers claims, payments, aging, and status.

I used Microsoft Excel to consolidate the dealers claims, payments, aging, status, pendings, and receivable amounts.