Excel Receivables Dashboard Creation
Budget: ₹1,500 – ₹12,500 INR
I need assistance with Excel to create a comprehensive dashboard showcasing my receivables data. This will involve creating formulas and analyzing data to:
- Display the total outstanding balance
- Illustrate the aging of receivables
- Segregate the outstanding balances based on both O/S value and age.
I’m particularly interested in categorizations such as < $100, $100-$500, > $500 and < 30 days, 30-60 days, > 60 days. The ideal candidate will have strong Excel skills, experience in data analysis, and knowledge of financial principles, particularly in receivables management.
- Display the total outstanding balance
- Illustrate the aging of receivables
- Segregate the outstanding balances based on both O/S value and age.
I’m particularly interested in categorizations such as < $100, $100-$500, > $500 and < 30 days, 30-60 days, > 60 days. The ideal candidate will have strong Excel skills, experience in data analysis, and knowledge of financial principles, particularly in receivables management.