Is anyone aware of an interesting way to visually show aging accounts receivables - Amounts of money owed which are broken up into time periods, such as (a) less than 30 days past due, (b) 30-60 days, (c) 60-90 days, (c) 90 days +, etc OR something similar?
I thought a single bar comprised of different colors representing the various periods with relative length of color determined by amount due. Pass over a color to learn total amount due and click on the color to open a window with a table of information including business name, invoice date, amount due, etc. Is this doable?
Responses/Conversation would be appreciated.
Additional Info: In this application, the user - a business owed money by numerous other business - would use the visual display to quickly see the status of amounts owed to him. Used over a period of time, the user would have a better understanding of cash flow trends - if the business is being paid timely.
The business owner would use the visual display to drill down on who owes what and for what period so the business owner can prioritize collection efforts.
The idea of a visual display is so the big picture of money owed can fit in the width of a smart phone.