You shouldn't have to design one like that. It should be called 'insurance aging' report. I'm not sure exactly how to find it on Medisoft, but look for one showing insurance aging. They usually sort by payer and list name, id, dos, amts billed.
Michele