title: Database designing help for billing system
body: <p>I am developing a Electronic Bill Payment System for a bank which has more than 100 customers subscribing for Electronic Bill Payment.</p>
  
  <p>I have a table in which I am creating profile for customer like the following.</p>
  
  <h2>Customer Table</h2>
  
  <p>Customer_ID  (Primary key)
  Customer_Name
  Address
  Phone</p>
  
  <h2>Bill_Master</h2>
  
  <ol>
  <li>Customer_ID</li>
  <li>Enrollment_Date</li>
  <li>UtilityCompany_ID</li>
  <li>Bill_Generation_Date (lets say 18th of every month)</li>
  <li>Bill_Due_Date (lets say 27th of every month)</li>
  <li>Our_CutOff_Date (when the bank will generate the bill for payment)</li>
  </ol>
  
  <p>I have created the customer along with clue that which utility company's bill generates on which date and what will be the due date of EVERY MONTH.</p>
  
  <p>I want to create an interface where the user will see the entries of all the customers whoz date is due for bill generation and after that user will click on the particular entry and generate the bill manually by entering the amount and other details so for this I am clueless how to find out which customer's utility company bill is due for generation..</p>
  
  <p>Any help how should I design it and query of it? or would be a automatic procedure like job or something which will do it.</p>
  
  <p>thanks</p>