How to organise multiple reference data to use in invoice template

Hi,

I am trying to simplify or learn a better process of organising my reference data based on 3 main criteria: payer, description and cost.

I am unsure how to describe so have included an example template of what I am currently doing. I am wondering if there is a better way of organising this data.

Thanks

Hi Glen, not all descriptions are available to all payers. It depends on the funding that the payer uses. There are 20 payers with exactly the same descriptors because it is the same funding source and same service. I have ~5 different funding sources.

The impetus for changing my model is I am adding a new service based on one funding source. There are ~20 descriptors and associated costs to add for each payer that use this funding source (this is due to different descriptors and codes based on time of service, and the category of service provision). That makes it a very long table!