Milk Collection Center Excel Format

It’s a milk Collection Center, there is 200+ members, The people will bring milk to the center every day morning and evening (all will not bring milk because if the cow is not giving milk means they won’t bring milk[~110 members will bring milk every day), The center will collect milk from them, the member have a member ID. The thing some of them will get advance money every day or frequently but not all,, some will get feeds from center in advance,, after 15 day they will be get paid… Need a Excel sheet for this purpose will all formulas..