where we to doesn’t add new Entity Type. Instead ,we use the existing Entity Type, Customers.then Add a Custom Field called Member ID. This will be used to store the Member Card ID.
mailny the report should contain following:
Customer name,Member Card ID,Account balance