Billing for membership fees

You can use your site to collect membership dues from both members and prospects:

  • For existing members who need to renew, just bill as usual:
    • Run the billing cycle to generate the invoices. See Running mass dues billing.
    • (accrual dues) Post the resulting batch.
    • When viewing their profile on your site, members are prompted to renew (as long as the invoice remains unpaid).
    • If they opt to renew, the billing item moves to their cart, for payment.
📘

Note

If a user has purchased a membership (joined) once, the user cannot purchase the same membership again. Even if there is a lapse in a membership, the user can only renew a membership (a staff user must intervene on behalf of the user to do this).

  • When guests check out, subscription records synchronized to the same membership term dates are created and the customer type changes to the customer type selected in the billing cycle. If customers choose to make a payment instead of using Bill Me, the paid thru status of the subscriptions will not be updated until the batch of payment transactions posts.
📘

Note

Join Now functionality is currently implemented for cash-based accounting only. Using Join Now with an accrual dues system will still work, but iMIS will treat the dues as cash. Future renewal billings will be treated as accrual dues.

Running mass dues billing

Mass billing enables you to process a billing cycle for all customers who match the parameters defined in the selected billing cycle. The system decides which customers to bill by comparing the Paid Thru dates to the renewal Effective date. iMIS also decides what and how much to bill based on your settings. (See Defining Special Pricing, Customer types, and Defining Product Codes).

iMIS searches the database for customers who match the billing cycle parameters. An initial billing is generated for all customers who have a Paid Thru date before 12/01/2015 (applies to anniversary only). iMIS runs first reminders for unpaid customers whose initial billing was sent between 7/01/2015 and 8/01/2015 and second reminders for those who were initially billed between 6/01/2015 and 7/01/2015.

📘 Note

Before initial billing is run, print a test-billing run and verify the results. If you would like to print renewal notices at the same time as billing, see Renewal notices.

Running initial mass dues billing

Do the following to run an initial mass dues billing:

  1. From the Advanced Accounting Console, go to Membership > Bill membership fees.
  2. Click New.
  3. Select the Renewals option under Billing Options. The default Effective Date automatically displays.
  4. Select a billing cycle to process that was previously created in the Set up billing cycles window.
  5. Select Printing Options.
  6. (optional) Override the Run Date.
  7. (optional) Override the Effective Date.
  8. (optional) Select the Additional Options.
  9. Click Run to process the billing run.
Rebilling to correct a mass dues billing

iMIS provides a Rebill feature that enables you to correct a previous mass billing. Rebill a mass run if:

  • The pricing table originally used for the renewal bill run was incorrect
  • The original dues billing did not include a line item

For example, rebill the sample initial dues bill discussed in To run initial mass dues billings.

📘 Note

A renewal billing can be combined with a rebilling.

  1. Correct the reason for the rebill.
    • If you need to add a product to the Billing Cycle, see Creating billing cycles.
    • If you need to change the pricing of a product, see Customer types, or Defining Special Pricing.
  2. From the Advanced Accounting Console, go to Membership > Bill membership fees.
  3. Click New.
  4. Select Rebill to change or correct a billing run generated previously.
  5. Select a billing cycle to process.
  6. Select the Printing Options.
  7. Enter the original Run Date range in the Begin Rebill Date and End Rebill Date fields.
  8. Click Run to process the billing run.
Renewal notices

Printing Renewal Notices at the same time as billing is recommended to ensure that the only items that print on the renewal notices are the items that get billed. To do this, select both the Renewals and Initial Bill options on the Bill membership fees window on the same billing run.

If you print the initial bill separately from billing, you must perform an ad hoc search to print only the items that were last billed. See Printing renewal notices separately for more information on performing an ad hoc search to verify bill date.

📘 Note

With accrual dues, the posting and finalization of mass billing data occurs after the renewal billing step, therefore, you need to print renewal notices (Initial Bill) independently after the batch posting is complete.

When you print Renewal Notices, the following field conditions are evaluated to determine if a Renewal Notice will print for a customer:

  • The Paid Thru date field on the Status tab contains a date that is earlier than the Renewed Thru field on the Financial tab located on the Manage customers window (from Customers, select Manage customers).
  • The Status field on the Manage customers window is not set to S (Suspended), I (Inactive), or D (Marked for deletion).
  • The balance for the dues product is greater than zero.
  • Subscriptions.REMINDER_COUNT is equal to zero.
Printing renewal notices separately

When you print Renewal Notices separately from billing, you must perform an ad hoc search so that you don't print duplicate notices.

When you print an initial bill, the system looks for records with REMINDER_COUNT = 0 (renewal hasn't been printed). It is possible, however, that a record has a REMINDER_COUNT = 0 and you may not want to print the Renewal Notice, as in the following examples:

  • You generate a billing run by selecting the Rebill option on the Set up general options window. In this case the REMINDER_COUNT is reset to zero.
  • You manually print an individual Renewal Notice by clicking Create Invoice from the Billing tab. In this case, REMINDER_COUNT never increments.
  1. From the Advanced Accounting Console, go to Membership > Bill membership fees.
  2. Click New.
  3. 📘 Note

    Do not select either option in the Billing Options area.

  4. Select a billing cycle from Select a Cycle to Process.
  5. (optional) Override the Run Date.
  6. Select Initial Bill under Printing Options.
  7. Select Ad Hoc Search under Additional Options.
  8. Click Run. The Select Search Instructions window opens.
  9. Click New to display the Search Instructions window.
  10. Enter a Search Name.
  11. Enter the new search instructions.
  12. 📘 Note

    Press Ctrl + Z to expand the Comparison Value field.

  13. Click Save on the Search Instructions window.
  14. Click OK on the Select Search Instructions window.

If you print Renewal Notices to the screen prior to sending them to the printer, they may not be aligned exactly as they appear on the screen. To achieve the correct formatting, always print reports directly to the printer rather than from the screen.

Customizing the renewal notice formats

A variety of standard renewal notice options are available. Although the presentation of most billing-related data is predetermined, many aspects can be customized.

For many of the available formats, the enlarged, bold title that appears at the top of the notice is user-defined within the Billing and Reminder Notices window (From the Advanced Accounting Console, go to Settings > Billing > Billing Cycles, select a Cycle Name, and click Bills/Reminders). You can also define a limited size (notice-specific) text area.

In addition to the Billing and Reminder Notice title and text options, you can customize other aspects of the renewal notice by entering instructions on the Report Specifications window (on the menu bar, go to Utilities > Report Specs).

📘 Note

If changes are made on the Report Specifications window, you must make the changes on a cloned copy of the standard report. This step is required to make the changes permanent.

The types of changes that can be made on the Report Specifications window include the following:

  • The entry of larger user-defined text areas
  • The addition of merge fields from the customer/subscriber-specific data. Up to five merge fields can be included in the overlay text
  • 📘 Note

    There is no provision for merge fields in the Billing and Reminder Notices text.

  • The modification or addition of a few available printing options that affect the output
  • The modification of top and/or left margins, which may be required to align the printed output with an iMIS-authorized preprinted form.
  • 📘 Note

    Crystal Report parameters should not be deleted from a report as the majority of them are necessary to run the report. The preferred method for building reports is to clone your existing report specifications, which automatically copies the report parameters.

Generating a custom renewal notice

To enter user-defined overlay text, you may need to customize a renewal format to print merge fields from a customer's demographic data or to modify or add an available printing option. User-defined text that exceeds 255 alphanumeric characters must be specified here.

Follow these steps to generate a custom Renewal Notice for your organization:

  1. Select Utilities > Report Specs. The Report Specifications window opens.
  2. Select the Dues Renewal Notice to customize.
  3. 📘 Note

    If you are cloning one of the DUES-Renewal Notices-Std. Form ASI-### reports, you may need to adjust the top and left margins to print the renewal notice correctly on your printer. To change the margins, select Options > Margins.

  4. Click Clone.
  5. Tab to the Title field and enter a unique name.
  6. Click Parameters. The Detail Report Parameters window displays the current parameters for the report you cloned.
  7. Tab to the Options field and add or remove available options. Available options vary from format to format. The two primary renewal notice options include the following:
    • SUPPRESS_ZERO_ITEMS - Suppresses printing line items that have been paid off or that have a zero balance. This option suppresses individual zero balance line items when the grand total of the renewal notice is nonzero.
    • PRINT_CHECKBOX - Displays checkboxes on the renewal form stub in which a customer/subscriber can choose items to pay (an optional addition that is not part of the standard option set).
  8. Tab to the Parameters field and enter the text to be printed on the renewal notices. To print your organization's name and address, enter the name and address in the Parameters field. The organization name and address will not automatically print as they do on some invoices and bills from other iMIS modules.
  9. The entered text overlays the standard report elements. Therefore, add hard returns (by pressing Enter) to shift text down the page far enough to avoid the preset report elements on the form.

    In the following example, three additional merge fields [Temp.Item1], [Temp.Item2], and [Temp.Item3] have been included in the overlay text. Use the following instructions to define merge fields.

    Example of parameters changed on the customized renewal format
    1. Click Options and select Additional Fields to open the Additional Fields window.
    2. Enter a formula or field name that corresponds to the merge fields entered in the Parameters field on the Detail Report Parameters window. Tab to each Field Name row and continue entering the data that will be merged with the overlay text entered in the Parameters field. A field can reference data contained in the Name, Name_Fin, Subscriptions.BILL_DATE, or any user-defined table. You can enter up to five additional fields in the notice by selecting Options> Additional Fields. Field names must be entered in the Filename.FIELDNAME format. For example, Name.INFORMAL brings in the informal nickname from the Name file.
    3. 📘 Note

      The formula or field name entered in the first row must correspond to the [Temp.Item1] overlay text entered in the Parameters field on the Detail Report Parameters window. All calculations must be prefixed with @# where # represents the number of the field (1-5). Field names do not need to be prefixed. If you enter an SQL calculation for a field, you might be prompted: Invalid Omnis calculation: proceed anyhow? Click Yes and ignore the warning.

    4. Click OK to close the Additional Fields window.
    5. Click Save to close the Detail Report Parameters window.
    6. Click Save to close the Report Specifications window.
    7. Select the cloned report title from the Forms drop-down menu on the appropriate billing cycle.
    8. Test the renewal notice.

    A portion of the text entered in the Parameters area with merge data from the resulting renewal notice.

To add user-defined text to the Dues Renewal Notice

The Dues Renewal Notice is a standard laser printer renewal notice format that prints the line items in the upper right corner and at the bottom in the remittance stub area. The middle of the renewal format is reserved for user-defined text.

  1. Select Utilities > Reports Specs to display the Report Specifications window.
  2. Clone the format.
  3. Click Parameters.

The Detail Report Parameters window opens. User-defined text can be entered in the Parameters field.

📘 Note

The title, Renewal Notice, cannot be changed. Billing and reminder notices text, entered in the Set up billing cycles window, is ignored with this renewal notice format. 📘 Note

The standard options set in the Options field of the Detail Report Parameters window includes SUPPRESS_ZERO_ITEMS, but PRINT_CHECKBOX is an optional setting that is not included in the standard options set.

iMIS authorized Renewal Notice formats

The iMIS-authorized Dues Renewal Notice form allows you to generate renewal notices on either dot matrix (continuous) or laser printers. Several of the Standard Renewal Notice formats are designed to print on forms provided in the Authorized Forms Catalog included with iMIS. The Authorized Forms Catalog is a joint effort by ASI and Versient.

In the iMIS Authorized Forms Catalog, there are six preprinted forms (four laser and two continuous) available for printing Billing renewal notices.

📘 Note

For forms that include the credit card payment box (ASI-016, ASI-018, ASI-020-C), you must enter your list of available credit card choices in the Credit Card Types field on the AR/Cash Set up module window.

On certain preprinted forms, there may be optional choices for the iMIS report output (for example, the placement of the line items may be different, or one form could be used for a standard renewal notice or a list bill). The variations of all possible forms and iMIS output choices are represented in the following list of iMIS standard reports:

Click to view table
Dues Renewal Notice

Description

Std. Form ASI-016 - Line Items at Top

A laser-printer format that includes a bottom stub for payment and a credit card payment box. Line items are printed in the upper, right corner of the form.\

Clone the report specification entry to enter user text. Enter overlay text in the Parameters field of the Detail Report Parameters window (select Utilities> Report Specs, and click Parameters). Overlay text prints in the middle shaded area of the form.

Standard Options: SUPPRESS_ZERO_ITEMS, PRINT_CARD

Std. Form ASI-016 - Line Items in Middle

A laser-printer format that includes a bottom stub for payment and a credit card payment box. Line items are printed in the middle shaded area of the form.

Clone the report specification entry to enter user text. Enter overlay text in the Parameters field of the Detail Report Parameters window (select Utilities > Report Specs, and click Parameters). Overlay text prints on the left half of the middle shaded area of the form (for example, to the left of the line items).

Standard Options: SUPPRESS_ZERO_ITEMS, PRINT_CARD

Std. Form ASI-017 - Line Items at Top

Identical in form and output to Std. Form ASI-016 except line items are printed at the top of the form and the credit card payment box and string are omitted.

Standard Options: SUPPRESS_ZERO_ITEMS

Std. Form ASI-017 - Line Items in Middle

Identical in form and output to Std. Form ASI-016 except line items are printed in the middle of the form and the credit card payment box and string are omitted.

Standard Options: SUPPRESS_ZERO_ITEMS

Std. Form ASI-018 - Dbl Column List Bill

A laser-printer list-bill format designed to print a consolidated list of line items for multiple individuals and/or branches whose line items are to be billed to a single parent company or other Bill_To_ID. This particular format is designed with a tear-off stub along the right side of the form, which also contains a credit card payment box.

Enter overlay text in the Parameters field of the Detail Report Parameters window (select Utilities > Report Specs, and click Parameters). Text entered in the Billing and Reminder Notices window (from Billing, select Set up module > Billing cycles, select a Cycle Name, and click Bills/Reminders) is formatted to print immediately below the last line item printed, to the left of the tear-off stub. The first Additional Fields area, which can be modified, controls the printing of the individual or branch name. The default is set to print the full name for an individual or the company name for a branch.

Standard Options: SUPPRESS_ZERO_ITEMS, PRINT_CARD

Optional add on: PRINT_CHECKBOX

Std. Form ASI-019 - Dbl Column List Bill

Identical in form and output to Std. Form ASI-018 except it includes a double-column list bill and the credit card payment box and string are omitted.

Standard Options: SUPPRESS_ZERO_ITEMS

Optional add on: PRINT_CHECKBOX

Std. Form ASI-020-C - Full Page List Bill

A continuous-format (dot-matrix) form designed for printing list bills in which the line items for multiple individuals/branches are all listed and totaled on one continuous bill to the Bill_To_ID or main company. This list bill, with no stub on the right, provides full-page width to list the individual/branch names and line items. This form also contains a credit card payment box.

Enter overlay text in the Parameters field of the Detail Report Parameters window (select Utilities > Report Specs, and click Parameters). Text entered in the Billing and Reminder Notices window (from Billing, select Set up module > Billing cycles, select a Cycle Name, and click Bills/Reminders) is formatted to print immediately below the line items and totals. The first Additional Fields area, which can be modified, controls the printing of the individual or branch name. The default is set to print the full name for an individual or the company name for a branch.

Standard Options: SUPPRESS_ZERO_ITEMS, PRINT_CARD

Std. Form ASI-020-C - Full Page Standard

A continuous-format (dot matrix) form with line items listed in the body of the form (traditional invoice format). Enter overlay text in the Parameters field of the Detail Report Parameters window (select Utilities> Report Specs, and click Parameters).

Standard Options: SUPPRESS_ZERO_ITEMS, PRINT_CARD

Optional add on: DUESDAT appends the printing of the renewal period onto the end of the line item description for any billing type product lines. (For example, FOR 01/01/2016 THRU 12/31/2016.)

Std. Form ASI-021-C - Full Page List Bill

Identical in form and output to Std. Form ASI-020-C. Includes a full-page list bill. The credit card payment box and string are omitted.

Standard Options: SUPPRESS_ZERO_ITEMS

Std. Form ASI-021-C - Full Page Standard

Identical in form and output to Std. Form ASI-020-C except it includes a full-page standard billing and the credit card payment box and string are omitted.

Standard Options: SUPPRESS_ZERO_ITEMS