Difference between revisions of "ChamberMaster Billing-View report of all assigned membership fee items"

From Support Wiki
Jump to navigation Jump to search
 
Line 1: Line 1:
<div xmlns="http://www.w3.org/1999/xhtml">
+
#Click Billing in the left-hand menu.  
  <div style="margin-left: 18pt;">
+
#Click the '''Reports'''  tab.  
    <table border="0" cellspacing="0" cellpadding="0" width="99%" summary="">
+
#Click '''Membership Renewals''' in the '''Sales''' section. The '''Membership Renewals''' filter options window will display.   
      <tr valign="baseline">
+
#Make the desired selections, click '''Refresh Report'''. '''Note''': to view all assigned membership fee items, set the filter options as displayed in Figure 2-6 below.  
        <td style="width: 18pt"><div style="font-family: Calibri; font-size: 11pt;">1. </div></td>
+
#:[[Image:ChamberMaster_Billing-View_report_of_all_assigned_membership_fee_items-CMBilling.1.024.2.jpg]]</span></div>
        <td><div style="font-family: Calibri; font-size: 11pt;"><span id="wwpID0E01PB0HA">Click </span><span style="font-weight: bold;">Billing</span> in the left-hand menu.</div></td>
+
 
      </tr>
+
Your report will display for viewing purposes.  Click '''Print Report''', '''Print PDF''', or '''Download Report''' to output the report.
    </table>
+
 
  </div>
+
 
  <div style="margin-left: 18pt;">
+
To sort the report on columns, click Download Report and open in Microsoft Excel.  Then use Excel commands to sort and organize.  Tip:  Make sure to select AutoFit Row Height and AutoFit Column Width so that you are viewing all the downloaded data.  In Excel 2007, these choices are on the Home tab in Cells group.  Click Format.  
    <table border="0" cellspacing="0" cellpadding="0" width="99%" summary="">
 
      <tr valign="baseline">
 
        <td style="width: 18pt"><div style="font-family: Calibri; font-size: 11pt;">2. </div></td>
 
        <td><div style="font-family: Calibri; font-size: 11pt;"><span id="wwpID0E0ZPB0HA">Click the </span><span style="font-weight: bold;">Reports</span> tab.</div></td>
 
      </tr>
 
    </table>
 
  </div>
 
  <div style="margin-left: 18pt;">
 
    <table border="0" cellspacing="0" cellpadding="0" width="99%" summary="">
 
      <tr valign="baseline">
 
        <td style="width: 18pt"><div style="font-family: Calibri; font-size: 11pt;">3. </div></td>
 
        <td><div style="font-family: Calibri; font-size: 11pt;"><span id="wwpID0E0YPB0HA">Click </span><span style="font-weight: bold;">Membership Renewals</span> in the <span style="font-weight: bold;">Executive</span> section.</div></td>
 
      </tr>
 
    </table>
 
  </div>
 
  <div style="font-family: Calibri; font-size: 11pt; margin-bottom: 12pt; margin-left: 54pt; text-align: justify;"><span id="wwpID0E0XPB0HA">[[Image:ChamberMaster_Billing-View_report_of_all_assigned_membership_fee_items-CMBilling.1.024.1.jpg]]</span></div>
 
  <div style="font-family: Calibri; font-size: 10pt; margin-bottom: 12pt; margin-left: 54pt; text-align: justify;"><span id="wwpID0E0WPB0HA">Figure 2-5 Billing Reports</span></div>
 
  <div style="margin-left: 18pt;">
 
    <table border="0" cellspacing="0" cellpadding="0" width="99%" summary="">
 
      <tr valign="baseline">
 
        <td style="width: 18pt"><div style="font-family: Calibri; font-size: 11pt;">4. </div></td>
 
        <td><div style="font-family: Calibri; font-size: 11pt;"><span id="wwpID0E0VPB0HA">The </span><span style="font-weight: bold;">Membership Renewals filter options</span> window will display.  Make the desired selections, click <span style="font-weight: bold;">Refresh Report</span>. Note: to view all assigned membership fee items, set the filter options as displayed in Figure 2-6 below.</div></td>
 
      </tr>
 
    </table>
 
  </div>
 
  <div style="font-family: Calibri; font-size: 11pt; margin-bottom: 12pt; margin-left: 36pt; text-align: justify;"><span id="wwpID0E0UPB0HA">[[Image:ChamberMaster_Billing-View_report_of_all_assigned_membership_fee_items-CMBilling.1.024.2.jpg]]</span></div>
 
  <div style="font-family: Calibri; font-size: 10pt; margin-bottom: 12pt; margin-left: 54pt; text-align: justify;"><span id="wwpID0E0TPB0HA">Figure 2-6 Filter options to view all assigned membership fees</span></div>
 
  <div style="margin-left: 18pt;">
 
    <table border="0" cellspacing="0" cellpadding="0" width="99%" summary="">
 
      <tr valign="baseline">
 
        <td style="width: 18pt"><div style="font-family: Calibri; font-size: 11pt;">5. </div></td>
 
        <td><div style="font-family: Calibri; font-size: 11pt;"><span id="wwpID0E0SPB0HA">Your report will display for viewing purposes.  Click </span><span style="font-weight: bold;">Print Report</span>, <span style="font-weight: bold;">Print PDF</span>, or <span style="font-weight: bold;">Download Report</span> for other output options of the same report.</div></td>
 
      </tr>
 
    </table>
 
  </div>
 
  <div style="color: #5F497A; font-family: Calibri; font-size: 9pt; margin-bottom: 12pt; margin-left: 36pt;"><span id="wwpID0E0RPB0HA"> </span></div>
 
  <div style="color: #5F497A; font-family: Calibri; font-size: 9pt; margin-bottom: 12pt; margin-left: 36pt;"><span id="wwpID0E0QPB0HA">To sort the report on columns, click Download Report and open in Microsoft Excel.  Then use Excel commands to sort and organize.  Tip:  Make sure to select AutoFit Row Height and AutoFit Column Width so that you are viewing all the downloaded data.  In Excel 2007, these choices are on the Home tab in Cells group.  Click Format. </span></div>
 
 
   <div style="font-family: Calibri; font-size: 11pt; margin-bottom: 12pt; margin-left: 36pt;"><span style="font-weight: bold;"><span id="wwpID0E0PPB0HA">Note:</span></span> if any of your members do not have a <span style="font-weight: bold;">Renewal Month</span> assigned on the <span style="font-weight: bold;">Account</span> tab of their record, your screen will display a selection similar to Figure 2-7.  Assign a Renewal Month to these members by clicking <span style="font-weight: bold;">View/Edit members with no renewal month</span>.</div>
 
   <div style="font-family: Calibri; font-size: 11pt; margin-bottom: 12pt; margin-left: 36pt;"><span style="font-weight: bold;"><span id="wwpID0E0PPB0HA">Note:</span></span> if any of your members do not have a <span style="font-weight: bold;">Renewal Month</span> assigned on the <span style="font-weight: bold;">Account</span> tab of their record, your screen will display a selection similar to Figure 2-7.  Assign a Renewal Month to these members by clicking <span style="font-weight: bold;">View/Edit members with no renewal month</span>.</div>
 
   <div style="font-family: Calibri; font-size: 11pt; margin-bottom: 12pt; margin-left: 36pt; text-align: justify;"><span id="wwpID0E0OPB0HA">[[Image:ChamberMaster_Billing-View_report_of_all_assigned_membership_fee_items-CMBilling.1.024.3.jpg]]</span></div>
 
   <div style="font-family: Calibri; font-size: 11pt; margin-bottom: 12pt; margin-left: 36pt; text-align: justify;"><span id="wwpID0E0OPB0HA">[[Image:ChamberMaster_Billing-View_report_of_all_assigned_membership_fee_items-CMBilling.1.024.3.jpg]]</span></div>
Line 55: Line 18:
 
   <div style="font-family: Calibri; font-size: 10pt; margin-bottom: 12pt; margin-left: 54pt; text-align: justify;"><span id="wwpID0E0IPB0HA">Figure 2-8 Member with multiple fees assigned</span></div>
 
   <div style="font-family: Calibri; font-size: 10pt; margin-bottom: 12pt; margin-left: 54pt; text-align: justify;"><span id="wwpID0E0IPB0HA">Figure 2-8 Member with multiple fees assigned</span></div>
 
   <div style="color: #5F497A; font-family: Calibri; font-size: 9pt; margin-bottom: 12pt; margin-left: 36pt;"><span id="wwpID0E0HPB0HA">Multiple fees may be assigned to a member but is highlighted here as an example in case this was not intended.</span></div>
 
   <div style="color: #5F497A; font-family: Calibri; font-size: 9pt; margin-bottom: 12pt; margin-left: 36pt;"><span id="wwpID0E0HPB0HA">Multiple fees may be assigned to a member but is highlighted here as an example in case this was not intended.</span></div>
</div>
 

Latest revision as of 20:15, 24 April 2018

  1. Click Billing in the left-hand menu.
  2. Click the Reports tab.
  3. Click Membership Renewals in the Sales section. The Membership Renewals filter options window will display.
  4. Make the desired selections, click Refresh Report. Note: to view all assigned membership fee items, set the filter options as displayed in Figure 2-6 below.
    ChamberMaster Billing-View report of all assigned membership fee items-CMBilling.1.024.2.jpg

Your report will display for viewing purposes. Click Print Report, Print PDF, or Download Report to output the report.


To sort the report on columns, click Download Report and open in Microsoft Excel. Then use Excel commands to sort and organize. Tip: Make sure to select AutoFit Row Height and AutoFit Column Width so that you are viewing all the downloaded data. In Excel 2007, these choices are on the Home tab in Cells group. Click Format.

Note: if any of your members do not have a Renewal Month assigned on the Account tab of their record, your screen will display a selection similar to Figure 2-7. Assign a Renewal Month to these members by clicking View/Edit members with no renewal month.
ChamberMaster Billing-View report of all assigned membership fee items-CMBilling.1.024.3.jpg
Figure 2-7 Members with no renewal month assigned
Example of members that do not have fee items assigned yet.
ChamberMaster Billing-View report of all assigned membership fee items-CMBilling.1.024.4.jpg
Example of member that has multiple fees assigned.
ChamberMaster Billing-View report of all assigned membership fee items-CMBilling.1.024.5.jpg
Figure 2-8 Member with multiple fees assigned
Multiple fees may be assigned to a member but is highlighted here as an example in case this was not intended.