Hey guys

I got involved in a project yesterday and I'm having trouble thinking through the logic of how to handle some monthly billing.
Currently it is a cut and paste operation for about 450 members and it takes them a couple of days to output all the invoices.

I think this may be a case of I can't see the forest because of all the trees so I'm looking for some input how others might handle this situation.
I re-watched the Membership Database tonight and that helped. (Great video BTW @Richard)

This makes perfect sense to me on the regular billing but I'm having trouble on some unusual billing.

Issue 1  - Not all memberships are the same amount.  Old members are grandfathered in at a previous rate.
Newer members have a different rate. From what I can tell there are 4-5 different dues levels.  Fortunately while the amounts are different the way they are billed is similar.

Issue 2 - The fiscal year begins March 1 and concludes the following February of the next year.
Dues are "Annual" no matter what time of the year a person joins.  So if they join in September they automatically have to catch up to the current month.

The pattern of payments is the same regardless of the amount of the total annual dues.  Every month except April and August are the same.
The Apr. and Aug. dues are always the same amount.


Example:
   March       $50
   April       $250
   May       $50
   June       $50
   July       $50
   August      $250
   September   $50
   October     $50
   November    $50
   December    $50
   January     $50
   February    $50

Ideally the billing would be such that you don't have remember the month to know what rate to bill for the month. They would just generate and email the invoices.

I would appreciate any and all ideas on how you might handle this type of billing.  Not looking for the code to do it just the methodology.