Managing Billing

From Support Wiki
Jump to navigation Jump to search

Contents

Billing - Day to Day Activities


Billing Day to Day Activities     View this video for an overview of the daily activity as it relates to billing: creating invoices, posting payments, issuing credits, running reports, etc. Includes information on what the difference is between a payment and a receipt as well as when to use credits, discounts and write-offs. (NOTE: this training is not intended for those using the legacy CQI integration) Length: ~15 minutes.

Create a Single One-Time Invoice


Creating a single invoice may be done within the Billing Center or on a member's Account tab.

  1. Click Billing in the left-hand menu.
  2. Click the Billing Center tab.
    Billing Center CP.JPG
  3. Click the desired member in the member list.
  4. Click the New Invoice button. The
    New Invoice CP.JPG
    Configure the following as necessary:
    • A/R Account: Select the A/R account your wish to use for this invoice. The default you selected under Billing Options & Settings will be displayed, but you may change this as needed.
    • Invoice Date: The invoice date will default to the current date, but you may change this as needed.
    • Invoice Number: The system will automatically generate the next invoice number for you.
    • P.O. Number: If you have a PO Number you may enter it here. If you receive the PO Number after you have sent the invoice, this field may be updated.
    • Date Due: The date due is calculated by the Payment Terms described below. If you wish to specify a date due, you may enter it in this field and it will override the payment terms.
    • Payment Terms: Select the payment terms for this invoice. The payments terms you set as default under Billing Options & Settings will be displayed, but you may change this as needed. Click the Payment Terms hyper-link to add or edit payment terms.
    • Message: Select a message to display on your invoice. The message you set as default under Billing Options & Settings will be displayed, but you may change this as needed. The drop-down list will contain all messages you created in the Billing Options & Settings. Click the Edit button if you wish to make changes to a message.
    • Sales Tax: If the items on this invoice are taxable, select Tax from the drop-down list. Modify the *Sales Tax sets under Setup->Define Sales Tax Rates.
    • Notes/Memo: Enter any notes/memos you wish for this invoice.
    • Item Name: Select the fee items that you wish to include on this invoice. The Description and Price Each will be populated with the defaults you configured when the fee item was created. You may change these if needed.
    • Qty: Enter the quantity of the fee item to be included on the invoice.
    • Sales Tax: If the fee items is taxable, select Tax from the drop-down list. The tax will be automatically calculated.
    • Amount: The system will automatically calculate the total amount for the sale.
    • If you wish to defer recognition of the revenue for this invoice, click the Edit Revenue Recognition, the # of Months Recg. column will be displayed. Enter the number of months over which you wish to recognize the revenue.
  5. If you wish to deliver the invoice immediately, click the delivery method: Save and Print or Save and Email
    OR
    If you simply wish to ready this invoice for delivery, select the appropriate delivery method Invoice is marked to be printed or Invoice is marked to be emailed. If you mark an invoice to be printed or emailed, you will be able to deliver the invoice by going to Billing > Reports > Receivables > Print/Email Invoices.
  6. (Optional): If the member has available credits, click the Apply Credits button.
  7. Click Save.
  8. Click Close.

Move an Invoice


If you have inadvertently created an invoice on the wrong member, you can easily move it to the correct member.

  1. Select the desired invoice.
    Move invoice.jpg
  2. In the Bill To: section, click the member name hyper-link.
Mem Lookup.jpg
  1. On the Member/Rep Look-up screen, choose the member to which you wish to move the invoice.
  2. Click Continue.
  3. Click Save.


The invoice is now assigned to the appropriate member.

Process Payments


When payment is received, you can enter a payment in one of three locations: the Billing Center tab or Payments tab in the Billing module, or the Account tab in the Members module.

Receive Payments


  1. Click Billing in the left-hand menu.
  2. Click the Billing Center tab.
    Billing Center CP.JPG
  3. Click the desired member in the member list.
  4. Click New Payment.
    New Payment CP.JPG
  5. Select the deposit account to which funds should be deposited from the Deposit To drop-down list. Click Here for more information on deposits.
  6. Complete the payment information fields including: Payment Amount, Payment Date, and Payment Method.
  7. Optional: Fill in the Reference number of Notes/Memo field as desired. Reference number may contain the check number or last 4 digits of credit card or other identifying information. Notes/Memo is available for miscellaneous notes displayed on the payment. If selecting Credit Card and then capturing the credit card payment right away, then the Reference number and Notes/Memo will automatically be filled in.
  8. If selecting Credit Card as the Payment Method, the Capture Payment button will appear. Click Capture Payment and complete the credit card information screen. The credit card will be processed with the amount specified in the Payment Amount field. The Capture Payment button is only available for Plus users that have Authorize.net, Beanstream, IPP, or PayPal Website Payment Pro processing. If you are using a 3rd party credit card processor, you will simply select Credit Card as the payment method. In this case, best practice is to enter the last four digits of the credit card in the Reference Number field.
    NOTE: When you apply a payment using a credit card, if the card is declined, do NOT save the payment screen that way it will not apply the payment to the invoice.
    Capture Payment CP.JPG
  9. To apply the payment to a particular invoice(s), click to select the checkbox in front of the invoice that this payment applies to. Deselect any invoices that do not apply, by default, the oldest invoice will be selected.
  10. Click Save.
  11. If desired, click Print or Email to print/email a payment receipt.

NOTE: If you wish to print a Paid Invoice, you can do this by reprinting the invoice to which this payment has been applied. The appropriate fields must be included in your invoice template.

Record Task List Mbr Payments

When a member pays in the MIC but does not select an invoice OR chooses to make an additional payment, the Mbr Payments in the Task List will be incremented by one. To process the payment:

  1. Click Mbr Payments in the Task List to view the incoming payment.
    Mbr Payments.JPG
  2. Click the Details link to view further details of the over-payment.
    MBR Pay Details.JPG
  3. Copy the PN Reference #.
  4. Click Billing in the left-hand navigation panel.
  5. On the Billing Center tab, select the member who made the payment.
  6. If the over-payment is to be applied to an open invoice, click the New Payment button.
    New Pay.JPG
  7. Enter the Payment Amount.
  8. Enter the PN Reference # copied from the details in the Reference # field.
  9. Select Credit Card as the Payment Method. NOTE: Do not Capture Payment, as the card has already been processed.
  10. Select the invoice(s) to which you wish to apply the payment.
  11. Click Save.
  12. Click Close.
  13. Click Mbr Payments in the Task List.
    Mbr Pay Complete.JPG
  14. Select Completed from the Status drop-down list for the payment you applied. The payment will be removed from the list, and from the Task List.
Un-apply a Payment

If you need to unapply a payment, for example, if you applied a payment to the wrong invoice, you may do this from the member's Account Tab or from the Billing Center.

  1. Click the Payment that you wish to unapply.
  2. Click Unapply Payment.
    Unapply Payment.JPG
  3. Click OK.

An un-applied payment will now be available to this member, and may be applied to a different invoice.

One Row.png

NOTE: If the payment has already been deposited, you will need to void the deposit prior to un-applying the payment.
Apply an Un-applied (Open) Payment to an Invoice

You can apply an un-applied payment from the member's Account Tab or from the Billing Center. Open Payments may be generated when a member adds an additional payment via the MIC, when a payment is un-applied, or when a membership application is paid for on-line.

  1. Select the member's Account tab.
    Apply un-applied payment.JPG
  2. In the transaction list, click the payment that you wish to apply.
    Apply payment1.JPG
  3. Click the Apply Payment button.
Apply credits and payments.JPG
  1. On the Apply Credits and Payments screen, select the invoice to which you wish to apply this payment. All open invoices for the member will be available for selection. By default, the oldest invoices will automatically be selected.
  2. Click Apply Payment.
Payment Applied to Correct Member/Wrong Invoice

In the event you have applied a payment to the wrong invoice, you can un-apply the payment, and re-apply to the correct invoice.

  1. From the Billing Center, or the member's Account tab, click the payment that you wish to un-apply.
  2. Click the unapply button next to the Payment Amount.
  3. Click OK
  4. Click Close.
  5. To apply the payment to the correct invoice, click the payment hyper-link.
  6. Click the Apply Payment button.
  7. Tick the check-box for invoice to which you wish to apply the payment.
  8. Click Apply Payment.
  9. Click Close.

One Row.png

NOTE: If the payment has already been deposited, you will need to void the deposit before you can un-apply the payment.
Payment Applied to Wrong Member

  1. On the incorrect member's Account tab, click the link for the desired payment.
  2. Click Unapply Payment. NOTE: If the payment has been deposited you will need to void the deposit before you will be able to un-apply the payment.
    Unapply payment 2020.jpg
  3. After un-applying the payment, click the name of the member in Received From box.
    Received from 2020.jpg
  4. Select the desired member to move the payment to.
  5. Click Apply Payment. Any open invoices for the member will be displayed, and you will be able to apply the payment.

Manage Payments Received through Additional Member Payments or Membership Application


The Mbr Payments item in the Task List will indicate payments that have been received that have not been tied to an invoice. This may be the result of a member making an additional payment in the MIC, a membership application submitted where either Fee has been set as the Fee Type, or the membership application has been paid by credit card and your system is not configured to automatically create an invoice.

View Mbr Payment.JPG

One Row.png

NOTE: Entries that have a status of "New Payment" have a payment transaction created.

Apply a Mbr Payment generated from the Membership Application submission


If you have setup your membership application form to accept credit cards, but you are NOT auto-approving the applications, the credit card payment will show in the Task List under Mbr Payments. The In this scenario, you will need to create an invoice/receipt for the payment. Whether you create an invoice or receipt is dependent on your settings.

  1. Click the Mbr Payments link in the Task List. Payments received for on-line membership applications will be identified as New Membership Application in the Auth Code column.
    View Mbr Payment.JPG
  2. Click the Details link to view further information about the Mbr Payment if needed.
    MBr Paymnet Details.JPG
  3. If New Payment is displayed as the Status, the payment transaction has already been created. Copy the TXN Id.
  4. Click Mbr Signups in the Task List.
  5. Click Create Invoice for the desired applicant.
    • If the package selected was assigned Fee Items the invoice will automatically be populated with the fee items. If the package the applicant selected was assigned Fee you will need to select the fee items to add to the invoice.
  6. Click Save to save the invoice.
  7. Click Close.
  8. Click Mbr Signups in the Task List.
  9. Click Apply Payment for the desired applicant.
    Apply Credits and Payments.JPG
  10. Select the invoice to which you wish to apply the payment.
  11. Click Apply Payment.
  12. On the Member Application Requests screen, click Approve for the applicant.
  13. Click Mbr Payments in the Task List.
  14. For the applicant's payment, select Completed from the Status drop-down list.

Apply a Mbr Payment generated from an Additional Payment Entry in the MIC


When members enter additional payments via the MIC, you will need to either apply that payment to an existing invoice, or create a new invoice to which you will apply the payment.

Apply a Mbr Payment generated from an Additional Payment Entry to an Existing Invoice

If a member has entered an additional payment via the MIC, with the intent that the payment be applied to an existing invoice, use the following procedure:

  1. Click the Mbr Payments link in the Task List. Payments received from an additional payment made in the MIC will display the comments entered by the member in the Auth Code column.
    Filter options.JPG
  2. If needed, click the Details link in the Action column to view further information about the payment. Comments entered by the member will be displayed, and your staff may also add comments.
  3. Click the link in the Billing Txn column. This column will display the credit card type and the last four digits of the card.
    TXN ID.JPG
  4. Click the Apply Payment button.
    Apply Credits & Payments.JPG
  5. The Apply Credits & Payments screen will display a list of all open invoices. By default, the oldest invoice(s) will be selected. If you wish to select alternate invoices, deselect the default, and click the check-box(es) for the invoices to which you wish to apply the payment.
  6. Click Apply Payment.

On the member's Account tab, you will be able to see that the invoice(s) selected has been paid, and the payment transaction displays that it was applied to the invoice(s).

Apply a Mbr Payment generated from an Additional Payment Entry where Invoice does NOT exist

If a member has entered an additional payment via the MIC, with the intent that this payment go towards a future invoice, use the following procedure:

  1. Click the Mbr Payments link in the Task List. Payments received from an additional payment made in the MIC will display the comments entered by the member in the Auth Code column.
    Filter Options2.JPG
  2. If needed, click the Details link in the Action column to view further information about the payment. Comments entered by the member will be displayed, and your staff may also add comments.
  3. Click the name of the member in the Member column.
  4. On the member's Account tab, click New Invoice in the Transaction History section. Notice that a payment record has been created for the member's additional payment.
    Trans History.JPG
  5. Click New Invoice. Create the invoice as described in Create a Single One-Time Invoice, ensuring that you select the fee items that are appropriate for the payment.
  6. Once the invoice is created, click the payment Ref # for the payment you wish to apply.
    Apply payment2.JPG
  7. Click the Apply Payment button.
    Apply Credits Payments.JPG
  8. If the member has other open invoices, the Apply Credits & Payments screen will display a list of all open invoices. By default, the oldest invoice(s) will be selected. If needed, de-select the invoice selected, and select the check-box for the newly created invoice.
  9. Click Apply Payment.

Notice the Transaction History for the member will now display the newly created invoice with no balance, and the un-applied payment tied to that invoice.

Trans history complete.JPG


Process an NSF Check

It is inevitable that a check will be returned by the bank due to Non Sufficient Funds (NSF). So what is the best way to record this in your database?​ In essence, a NSF is handled almost the same as a Refund except that you are leaving an invoice open on the account after it is all said and done.

  1. From the Billing Center, or the member's Account tab, click the link for the payment that was returned for NSF
  2. Use the Refund Payment option to reverse that payment.
  3. Next you will need to create a new invoice for whatever that original payment was for. This re-opens the balance for that customer.
    Add any necessary NSF fees to this new invoice for the returned check.
  4. Now you need to export that refund to your accounting system. When you open the Journal Entry Export report the refund/NSF item that you recorded will not automatically appear until you check the option to include refunds
    Show Refunds Option

Alternatively you can go into your accounting software and record the returned check on the check register manually.

Payment Summary Report


The Payment Summary Report allows you to generate a list of all payments received in a selected date range, for a specific batch, payment method, item type, item basis, or class. This report can be useful in matching records in your accounting software, as well as identifying un-applied payments.

  1. Click Billing in the left-hand menu.
  2. Click the Reports tab.
  3. Click Payment Summary in the Transactions section.
    Payment Summary Report CP.JPG
  4. Enter the desired date range in the Date From and Through text boxes. Click the more... link to choose a pre-defined date range.
  5. (Optional) Select additional filtering criteria:
    • Show Active/Courtesy members only. - If you wish to see all payments, de-select this option.
    • Specific Batch - If you wish to view payment history for a specific batch, click Choose Batch.
    • Payment Method - If you wish to see a specific payment method, select an option from the list.
    • Item Type - If you wish to generate the report for a specific fee item type, for example Membership Dues, select an option from the list. NOTE: You may also select a Specific Fee Item. For Example: if you wish to see payments on specific event fee items, click Use Specific Fee Item and select the desired fee items.
    Use Specific Fee Items CP.JPG
    • Item Basis - If you wish to generate the report for a specific accounting basis (accrual vs. cash), select an option from the drop-down list.
  6. Click Refresh Report to generate the report.
Payment Summary Results CP.JPG

Processing Sales Receipts


A receipt is created when accepting money on a Cash Basis. If you are receiving money to pay off an invoice, make sure to receive a payment instead of creating a receipt so the invoice can be marked as paid. The Sales Receipt Summary report will display sales receipts transactions.

How to Create a Sales Receipt


One Row.png

NOTE: A Sales Receipt should ONLY be created when an invoice has not already been created. If you are given a payment towards an existing invoice, and your member requests a receipt, you should add a payment, then provide them with the payment documentation as the receipt or resend the invoice to them, which will show the payment. Adding a receipt, when an invoice has already been created, will result in a duplicate payment record.
  1. Click the Billing Center tab.
  2. Click the desired member in the member list.
  3. Click New Sales Receipt.
    New Sales Reciept CP.JPG
  4. Complete the sales receipt information fields as needed:
    • Sale Date defaults to the current date.
    • The Sale Number automatically displays the next available Sales Receipt Number.
    • (Optional) Enter a Payment Reference # that displays on this transaction, often the check number or some other unique identifier. If capturing a credit card payment, this will be filled in automatically after processing the card.
    • (Optional) Select a Message if desired.
    • (Optional)Sales Tax: Choose the desired Tax Set if necessary.
    • (Optional)Notes/Memo: is available for miscellaneous notes displayed on the credit. If capturing a credit card payment, this will be filled in automatically after processing the card.
    Note: If Transaction Classes have been created, a Receipt Class drop-down selection will appear on the screen. Select the desired Class for this transaction. If needed, select a different Class assignment on each line item.
    • Ensure that the Deposit To: drop-down selection is the desired account for funds to initially be deposited. Note: See “Selecting Payment and Receipt “Deposit To” Account” for more information.
  5. If selecting the “Credit Card” Payment Method, then you may actually process the card right now if you have credit card information. Click Capture Payment and complete the credit card information screen. The credit card will be processed with the total of the line items.
    Note: Capture Payment button is only available for Plus users that have Authorize.net, Beanstream, IPP or PayPal Website Payment Pro processing.
    • Select the desired items from the Item Name list. The system will populate the price you have initially configure for the fee item, you may over-ride this if necessary. The Quantity field will automatically default to 1, update as needed. Continue adding items as needed.
  6. Click Save and then click Close.

NOTE: If desired, click Print Now and follow prompt on-screen to print the sales receipt.

Sales Receipt Summary Report


  1. From the Reports tab in the Billing module, click Sales Receipt Summary in the Transactions section.
    Sales Receipt Report CP.JPG
  2. Enter the desired date range in the Date From and Through text boxes. Click the more... link to choose a pre-defined date range.
  3. (Optional) Select additional filtering criteria:
    • Show Active/Courtesy members only. - If you wish to see all payments, de-select this option.
    • Item Type - If you wish to generate the report for a specific fee item type, for example Membership Dues, select an option from the list. NOTE: You may also select a Specific Fee Item. For Example: if you wish to see payments on specific event fee items, click Use Specific Fee Item and select the desired fee items.
    Use Specific Fee Items CP.JPG
    • Item Basis - If you wish to generate the report for a specific accounting basis (accrual vs. cash), select an option from the drop-down list.
  4. Click Refresh Report to generate the report.
Sales Receipt Report Results CP.JPG

Process Credits


A credit may be created for a member ahead of time or created when receiving the payment. Credits do not have to be associated with a particular invoice when created. In contrast, discounts must be associated with a particular invoice. The Credit Memo Summary report will display credit transactions. Credits can be done using any fee item that exists on your items list. Keep in mind that whichever fee is selected will decrease the income account that is assigned to that item. In some instances, you could select the item that is the reason for the credit needing to be created (i.e. A credit is being issued for a cancellation to the annual dinner. Create the credit and select the annual dinner fee item. This will decrease the amount of income reporting on the financial statements for that event). If you are unsure as to which item should be selected you will want to check with your accountant, as this will affect your financial statements.

Create a Credit


  1. For the desired member, click the Account tab.
  2. Click the New Credit button.
    New Credit CP.JPG
  3. Type the credit amount in the Credit Amount field. If there are outstanding invoices displayed, the credit amount will automatically be applied to an open invoice. If you do not wish to apply the credit to an open invoice, deselect the check-box next to the open invoice. NOTE: If there are no open invoices, you may simply create the credit, and it will be available for future use
  4. Complete the credit information fields if needed. Credit Date defaults to the current date and the Credit Number automatically displays the next available credit number. Optional: Enter a P.O. Number if applicable. Select a Message if desired. Notes: is available for miscellaneous notes displayed on the credit.
    Note: If Transaction Classes have been created, a Class drop-down selection will appear on the screen. Select the desired Class for this transaction.
  5. Select the Assigned Item for this credit. NOTE: The account associated to the fee item will be debited the amount of the credit immediately, not at the time that the credit is used.
  6. Click Save Credit.

Apply a credit before payment is received


If a member has an open invoice, you may apply a credit to that invoice prior to receipt of payment.

  1. Click Billing in the left-hand menu.
  2. Click the Invoices tab.
  3. Click the invoice to which the credit should be applied.
  4. Click the New Transaction drop-down arrow.
    Apply Credit CP.JPG
  5. Click Apply Credit.
    Apply Credit 1.JPG
  6. If multiple credits are available, select the desired credit from the Credit # drop down list.
  7. Click Apply Credit.

Apply a Credit When Payment is Received


  1. Click Billing in the left-hand menu.
  2. On the Billing Center tab, click the member from which you wish to receive payment and apply discount.
  3. Click the invoice number to be paid.
    Transaction History 1 CP.JPG
  4. On the invoice screen, click add/view payments.
    Add View Payments CP.JPG
  5. If credits are available, the Apply existing credits to this invoice radio button will be enabled and the amount of available credit will be displayed.
  6. Click Continue.
    Apply Credit 2 CP.JPG
  7. In the list of Open Invoices, ensure the correct Invoice Number is selected the list.
  8. Type the amount of credit to be applied in the Amount to Use field. The full amount of the credit will be populated if applicable.
  9. Click Apply Credit.
  10. On the Payment History screen, if a balance remains on the invoice, the Make a payment toward this invoice balance. radio button will be enabled. To make the payment click continue. Complete the Payment screen as desired and click Save Payment.

Process Deposits


Deposits are only available when payments and receipts have been deposited into the Undeposited Funds account. for more information on the undeposited funds account.

Make a Deposit


  1. Click Billing in the left-hand menu.
  2. Click the Deposits tab.
    Payments to Deposits CP.JPG
  3. Select the desired Deposit Account (typically your bank account)
  4. (Optional) Click Apply Filters to narrow the list by payment method.
  5. Select the payments to be deposited from the Select Payments to Deposit list. By default all payments will be selected, but you may deselect those that you do not wish to include in this deposit.
  6. (Optional) If Cash Back is desired:
    • Select a Cash Back Account from the drop-down list. If you wish to add a new account, click the Cash Back Account hyper-link.
    • (Optional) Enter a Cash Back Memo.
    • Enter the Cash Back Amount.
  7. (Optional) Click Print Listing, Download Listing, or Print Deposit to create desired output.
  8. Click Save Deposit. The payments you have selected will be included in this deposit.

Note: If planning to export your transactions to QuickBooks or other 3rd party billing software, making a deposit using Integrated Billing deposit options does not take away your option of being able to create a deposit in QuickBooks. The Integrated Billing deposit transaction can be excluded from your export, allowing you to also make the deposit in QuickBooks.

Deposit Summary Report


The Deposit Summary report will display deposit transactions.

  1. Click Billing in the left had navigation panel.
  2. On the Reports tab, click Deposit Summary in the Banking section. The report will generate for the default date range and all deposit accounts.
    Deposit Summary Report.JPG
  3. To generate the report for a different date range, enter the desired date range in the Date From and Through text boxes. Click the more... link to choose a pre-defined date range.
  4. (Optional) If you wish to view a specific deposit account, select an Account from the drop-down list.
  5. Click Refresh Report

Process a Write-off


If a member does not pay, it is possible to write-off a balance. You may wish to have an account in your Chart of Accounts where these amounts will be recorded. Write-offs can also be done when dropping members with the Mass Drop feature.

Entering a Single Write-off Transaction


  1. Click Billing in the left-hand menu.
  2. On the Billing Center tab, select the appropriate member.
  3. Click the invoice to be written off.
  4. Click the New Transaction drop-down arrow.
    Write Off CP.JPG
  5. Click Write-off balance. The Invoice Write-off screen will display.
    Write off 2 CP.JPG
  6. Complete the fields as desired:
    • The Writeoff Date will automatically be populated with the current date.
    • The Writeoff Amount will be populated with the full amount of the invoice, you may change this if you wish to do only a partial write-off.
    • Select the account you wish to use for this write off from the Expense Account drop-down list. If you wish to add a new account, click the Expense Account hyper-link.
    • (Optional) Enter Notes / Memo for internal use.
  7. Click Finish.

Note: If Transaction Classes have been created, a Billing Class drop-down selection will appear on the screen. Select the desired Billing Class for this transaction.

Recording mass write-off while performing a mass drop


Watch a video on the mass drop/mass write-off feature Vid.png

  1. Click Billing in the left-hand menu.
  2. Click the Reports tab.
  3. Click Past Due Members / Mass Drop in the executive section.
    Mass Drop CP.JPG
  4. Click Generate Report to see a list of all members with over-due member fees and dues.
  5. Select the members you’d like to drop by checking the box in front of their name.
  6. Ensure the correct drop date is listed above along with the desired Drop Reason and Drop Comments.
  7. If you’d like to write-off all the open invoices to their original accounts, check the Write-off member balance(s) check mark and enter the desired write-off date.
  8. Recommend: Select Disable rep(s) in group(s) so that reps will no longer be included in communication to the group.
  9. Click Drop Selected Members.

Mass Write-off Tips

Column Contents

  • Member Since = Join Date
  • Last Renewal = last paid invoice with Dues fees on it
  • Lifetime Membership Value = total of all payments and receipts
  • Last Payment Received = date of last payment of any fee type
  • Aging of Member Dues Owed = how many days overdue for the outstanding Member Fees and Dues
  • Total Amount Owed = Invoices total - payment total - credit total - writeoff total
  • Member Dues Owed = total of line items with a dues fee (does not include credits)

If Write-off Member Balance is Selected

  • a write-off date will be asked for to use on this transaction and may be back-dated if needed
  • all member invoices will be written off back to the original account that was billed.
  • the write-offs will appear in the Journal Entry Export
  • Members that have unapplied payments are marked with an * and will not be able to be included in the write-off. You should check out this member manually and see if these payments could be applied prior to dropping.

If Disable Rep in Group is Selected

  • all reps will be marked as Disabled in their groups which means that they will no longer receive communication to that group but staff can see them as "greyed out" when viewing that group which lets you know that they did belong to that group at one time.
  • if not selecting this checkmark, reps will remain in the groups unchanged but will display as inactive (red) due to dropping the member. They would still receive communication to any groups they belong to.
  • Regardless of this checkmark, these reps are marked as Inactive reps on the Members->Reps tab.

Voluntary fees will be written off back to their original account if you are currently set to export all voluntary fees (paid and unpaid). Contact customer support if you'd like to get to a point where you only export paid voluntary fees.

Manage Refunds


The process for creating a refund will vary, dependent on the processor used, and on whether the payment was received against an invoice or a receipt.

Create a Refund for Invoice Transactions


Create a Refund for a Cash/Check/BeanStream/PayPal/External Processor Payment Made towards an Invoice

If the payment received was cash/check, AND the payment was made towards an open invoice, use the following procedure:

  1. Click the link of the payment you wish to refund.
  2. Click the Refund Payment button.
  3. The refund will automatically be set to the full amount of the payment. You may issue a partial refund, by entering in the amount you wish to refund in the Price Each column. NOTE: Be sure to include the minus sign in front of the amount.
  4. Click Save.
  5. Click Close.

The refund will be displayed as a negative sales receipt in the list of transactions. You will now need to follow your business process for actually giving the money back to the contact.

Negative Receipt.JPG
Create a Refund for a GrowthZone Pay Payment Made towards an Invoice

One Row.png

IMPORTANT: When creating GrowthZone Pay refunds the following rules apply:
  • The credit card charge must have processed successfully
  • If the charge is too recent, the refund will be processed as a reversal
  • The charge must be less than 90 days old. If the charge is more than 90 days old, the Refund button will not display. You will need to process the refund as described in Create a Refund for a Cash/Check/Beanstream/PayPal/External Processor Made towards an Invoice for instructions.
  • The refund amount cannot exceed the amount of the payment

Creating a GrowthZone Pay refund is a two step process: first you will refund the charge through the processor, then you will create the matching accounting transaction. Both steps are achieved as follows:

  1. In the Billing module, click the Reports tab.
    Billing Reports tab 2020.jpg
  2. Click Payment Processing Reports / Management Tools in the Banking section.
    Pay Processing 2020.jpg
  3. Enter any desired filtering criteria, such as date range. You can also click the Select a Member link to search for transactions for a specific member.
  4. Click Refresh Report.
    Pay Process 2020.jpg
  5. In the Actions column, click Refund for the desired transaction. IMPORTANT: The Refund option will not be available if you have previously created a refund, the charge is over 90 days old, or the charge did not process successfully.
    Refund GZ Pay 2020.jpg
  6. The full amount of the payment is displayed to refund, you can enter a partial amount if needed.
  7. Click OK.
    Confirm refund2 2020.jpg
  8. Click Yes to confirm that you do wish to process this refund. Caution: once processed, the refund can NOT be reversed.
    Create matching transaction 2020.jpg
  9. If you would like to create the matching accounting transaction, click Yes. NOTE: If the option to create the matching transaction is NOT displayed, follow the instructions in Create a Refund for Cash/Check/Beanstream/PayPal to create the matching transaction.
    Refund screen 2020.jpg
  10. The refund screen will display a negative amount for the refund. If you are processing a partial refund, change the amount in the Price Each column.
  11. Click Save.

The refund will display in the member's Transaction History as a Receipt.

Final negative amount 2020.jpg

Smallest.png

NOTE: With GrowthZone Pay a partial refund will appear on the person's statement a little differently than a full refund if the original charge has not yet fully processed. The credit won't appear as a separate line item on the bank statement. Instead, the original charge should post for a lower amount on the customer's statement. This will especially be an issue when a partial refund is issued shortly after the original charge was made. For example, a charge is made for $830.00. A partial refund is issued for $35.00 while the original charge was still listed as pending so the charge was updated to $795.00. There will not be a separate transaction for the refund issued. If the customer has questions on how this shows on their statement, they should contact their bank directly.
Create a Refund for an Authorize.Net DPM Payment Made towards an Invoice

If you are using Authorize.net AIM Integration, you can process refunds directly back to Authorize.net from the back office. This is a two step process, first you will refund the credit card, then you will create the matching accounting transaction.

One Row.png

IMPORTANT: When creating refunds for Authorize.Net the following rules apply:
  • You can only refund a transaction that has been previously authorized using the payment gateway.
  • The original transaction that you wish to refund must have a status of Settled Successfully. You cannot issue refunds against unsettled, voided, declined or errored transactions.
  • The refund transaction must be issued within 120 days of the date the original transaction was settled.
  • A refund transaction cannot exceed the amount of the original transaction.
  • The payment method provided in the refund transaction must match the payment method that was provided in the original transaction.
  1. Click Billing in the left-hand navigation panel.
  2. Click the Reports tab.
  3. Click Credit Card Listing in the Banking section.
    Cc listing auth.net 2020.jpg
  4. Locate the payment you wish to refund. You can click the Select Member link to choose a specific member, or you can enter a specific date range.
  5. For the desired payment, click the Refund link in the Actions column.
    REFUND AMOUNT2 2020.jpg
    NOTE: Unsettled may be displayed in the Action column instead of Refund. Unsettled indicates that this transaction is very new - typically less than 24 hours old. After about 24 hours, the credit card company will allow a refund to be processed.
  6. Click OK to process the refund. NOTE: You may also update the Refund Amount if you wish to only process a partial refund.
    Confirm refund 2020.jpg
  7. Click Yes to confirm you wish to process the refund.
    CC matching transaction 2020.jpg
  8. After the refund is process, click Yes to create the matching accounting transaction. NOTE: If the option to create the matching accounting transaction is NOT displayed, follow the steps described in Create a Refund for a Cash/Check/BeanStream-Bambora/PayPal Payment Made towards a Receipt to create the negative sales receipt.
    Final refund transaction 2020.jpg
  9. On the receipt screen, the line items that were paid with this credit card will be displayed. The total will be set to a negative value. If you are refunding the entire payment, click Save.If you are doing a partial refund, remove the negative sign from the items you are not refunding.
    Final refund transaction 2020.jpg
  10. Click Save.

The refund will display in the member's Transaction History as a Receipt.

Negative receipt 2020.jpg

Create a Refunds towards Receipts


Create a Refund for a Cash/Check/BeanStream-Bambora/PayPal Payment/External Processor Made towards a Receipt

  1. Click Billing in the left hand navigation panel.
  2. On the Billing Center tab, find the appropriate member.
  3. Click the Sales Receipt button.
  4. Select the same fee item used when creating the original sales receipt.
  5. In the Price Each column, enter a negative amount.
  6. Click Save.
  7. Click Close.

The refund will be displayed as a negative sales receipt in the list of transactions. You will now need to follow your business process for actually giving the money back to the contact.

Create a Refund for a GrowthZone Pay Payment Made towards a Receipt

See

Create a Refund for an Authorize.Net DPM Payment Made towards a Receipt

One Row.png

IMPORTANT: When creating refunds for Authorize.Net the following rules apply:
  • You can only refund a transaction that has been previously authorized using the payment gateway.
  • The original transaction that you wish to refund must have a status of Settled Successfully. You cannot issue refunds against unsettled, voided, declined or errored transactions.
  • The refund transaction must be issued within 120 days of the date the original transaction was settled.
  • A refund transaction cannot exceed the amount of the original transaction.
  • The payment method provided in the refund transaction must match the payment method that was provided in the original transaction.
  1. Click Billing in the left-hand navigation panel.
  2. Click the Reports tab.
  3. Click Credit Card Listing in the Banking section.
    Cc listing auth.net 2020.jpg
  4. Locate the payment you wish to refund. You can click the Select Member link to choose a specific member, or you can enter a specific date range.
  5. For the desired payment, click the Refund link in the Actions column. NOTE: Unsettled may be displayed in the Action column instead of Refund. Unsettled indicates that this transaction is very new - typically less than 24 hours old. After about 24 hours, the credit card company will allow a refund to be processed.
    REFUND AMOUNT2 2020.jpg
  6. Click OK to process the refund. NOTE: You may also update the Refund Amount if you wish to only process a partial refund.
  7. Click Yes to confirm you wish to process the refund through to the consumer.

The refund request has now been sent to Authorize.NET. To create the matching accounting transaction you will follow the steps described in Create a Refund for a Cash/Check/BeanStream-Bambora/PayPal Payment Made towards a Receipt to create the matching accounting transaction, but you do not need to process the refund through the Auhtorize.NET system, as this has been accomplished.

Process Discounts


A discount may be applied to a particular invoice at the time of payment or prior to payment received. A discount is associated with a specific invoice and may only be removed by accessing the assigned invoice. In contrast, Credits do not have to be assigned to a particular invoice. There are two types of discounts within the ChamberMaster/GrowthZone database. Event discounts and Invoice Discounts. This page contains information about Invoice Discounts. See Event Discount Options page for event discount information.

Apply Discount Before Payment is Received


  1. Click Billing in the left-hand menu.
  2. On the Billing Center tab, select the member from the member list.
  3. Click the invoice to which the discount is to be applied.
    Discount CP.JPG
  4. Click the New Transaction drop-down arrow.
    Discount 1 CP.JPG
  5. Click Add Discount.
    Invoice Discount.JPG
  6. Type the Discount Amount, Notes/Memo (if desired), and double-check the Discounted Item and Discount Account.
  7. Click Save Discount.

NOTE: If Transaction Classes have been created, a Class drop-down selection will appear on the screen. Select the desired Class for this transaction.

Assign a Discount when Payment is Received


If you receive a payment received is less than the total of the invoice, due to discounting, you can add the discount to the invoice either before or after you apply the payment.

  1. Click Billing in the left-hand menu.
  2. On the Billing Center tab, locate the member from whom you have received payment.
  3. Click the invoice number to which you want to add the discount.
  4. From the New Transaction drop-down list, select Add Discount.
    Add discount.jpg
    The Invoice Discount screen will display.
    Invoice Discount Screen.jpg
  5. Type the Discount Amount, Notes/Memo (if desired), and double-check the Discounted Item and Discount Account.
    Note: The Discount Account must be identified as an Income account in Setup->Chart of Accounts. In Figure 3-19 above, a special Income account titled “Membership Dues Discounts” has been created that will maintain a list of discounted membership dues specifically for keeping track of early payment discounts.
    If Transaction Classes have been created, a Class drop-down selection will appear on the screen. Select the desired Class for this transaction.
  6. Click Save Discount.

One Row.png

IMPORTANT: If you have applied a full payment to the invoice the Add Discount option is not available. You will need to either issue a credit to the member, or a refund for the amount you wish to discount.

Delete a Discount


Discounts are associated with a particular invoice and thus must be removed from the assigned invoice.

  1. Click Billing in the left-hand menu.
  2. Click the Invoices tab.
  3. Locate the desired invoice where a discount should be removed.
  4. Click Show Balance Summary (if not already selected).
  5. Click the Discount ID #.
    Selecting the Discount ID.jpg
  6. Click Delete Discount.
    Clicking Delete Discount.jpg

Deliver Invoices Marked to be Emailed


If you have created an invoice and marked it to be emailed or have saved a batch of invoices, but not delivered:

  1. Click Billing in the left-hand menu.
  2. Click the Reports tab.
  3. Click Print/Email Invoices in the Receivables section. A list of all invoices that you have marked for email/print will be displayed.
  4. Click the Email Invoices radio button.
  5. Complete the following as needed:
    • Select the From address from the list.
    • Update the Subject Line if needed.
    • The Invoice Template will default to the template selected in your Billing Options & Setting, you may select an alternate template if needed.
    • The Cover Letter will default to the cover letter selected in your Billing Options & Setting, you may select an alternate cover letter if needed.
    • If you wish to CC or BCC others, enter the desired email address.
    • If your credit card processor is integrated with ChamberMaster/MemberZone, enable Add link to bottom of email to pay bills online if you wish to allow the invoice recipient to pay the invoice on-line.
    • Select to either Attach invoice as a PDF or Embed invoice in the email body. Embedding the invoice is recommended.
  6. From the list of invoices, tick mark the invoices that you wish to email. NOTE: If no email address is available, click the not set link in the Contact column to update the email address.
  7. Click Send Emails.

Deliver Invoices Marked to be Printed


If you have created an invoice and marked it to be printed or have saved a batch of invoices, but not yet printed them:

  1. Click the Reports tab.
  2. Click Print/Email Invoices in the Receivables section. A list of all invoices that you have marked for email/print will be displayed.
  3. Click the Print Invoices radio button.
  4. Complete the following as needed:
    • Click the Mark invoices as Delivered after printing radio button. This will remove the invoice from the list of invoices not yet printed.
    • If you wish a note made on the member's communications tab, that the invoice was printed, click the Save invoices to members communication log radio button.
    • Select PDF or HTML from the Print Style list.
    • The Invoice Template will default to the template selected in your Billing Options & Setting, you may select an alternate template if needed.
  5. From the list of invoices, tick mark the invoices that you wish to print. NOTE: If no address is available, click the not set link in the Contact column to update the address.
  6. Click the Print Invoices button.

Create Statements


  1. Click Billing in the left-hand menu.
  2. Click the Statements tab.
    CP CM Statements.JPG
  3. The Statement Date will default to the current date.
  4. Select Filter by Statement Period and enter desired dates. Only invoices created in the date range will be included in the statement, with Balance Forward carried over if applicable.
    OR click the Open Transactions as of Statement Date option. This option will include all open transactions in the statement. You may choose to Include only transactions X or more days past due and/or Include only transactions containing items of type (select the item type from the drop-down list).
    OR include transactions from a Specific Batch.
  5. Select Eligible Member Records: You may select All Members or filter by Specific Members.
  6. Select your Print Options:
    Output: Select Print, Email or Contact Preference.
    Message: Select the message you would like to include on the statement. You may click the edit button to make changes to the message. Note: Messages are configured under Setup > Billing > Customer Messages.
    • Include dunning messages for past due customers: A Dunning message may be displayed on invoices that meet the criteria. Dunning is the process of methodically communicating with customers to ensure the collection of accounts receivable. Selecting to include the Dunning Message for past due customers will place a message on their statement based on how overdue they are. Different messages are available for those with no overdue items, 30, 60, 90, and over 90 days overdue. These messages may be edited when clicking into view the dunning messages.
    CP Dunning Message.JPG
    • Show voluntary fees on statements: If this option is selected, invoice that include unpaid voluntary fees will be included on the statement.
    • Show invoice item details on statements: Select this option if you wish to display the individual invoices on the statement.
    • Show available credits on statements: Select this option if you would like to display open credits on the statement.
    • Show available payments on statements: Select this option if you would like to display un-applied payments on the statement.
    Select the options for statements that you do not wish to create:
    • with a $0.00 balance: Select this option if you do not wish to create statements for members with zero balances.
    • with a balance less than X: Select this option if you do not wish to create statements for members with a balance less than the dollar amount entered.
    • with no account activity: Select this option if you do not wish to create statements for members with no activity on their account.
    • with a member status other than Active: Select this option if you wish to only create statements for Active members. If you wish to print statement for all members, regardless of status, de-select this option.
  7. Click Print/Email Statements. The Deliver Statements window will appear. The Delivery Method of Print Statements is already selected. Those invoices with a complete mailing address will be selected.
    CP Deliver Statements.JPG
    NOTE: Those statements without a complete mailing address will not be able to be selected until a complete address is entered on the Billing Reps record. Return to the Members module, locate the desired member, click the Reps tab and edit the address for the rep marked as the Billing Rep.
  8. Complete the Delivery Method selections as desired.
  9. When ready, click Preview Statements or Print Statements..

If mailing labels are desired, click Print Mailing Labels in the Delivery Methodsection.

CP Print Mailing Labels.JPG
  1. If any statements need to be emailed, click Email Statementsin the Delivery Method section.
    NOTE: Those statements without a complete email address will not be able to be selected until a complete address is entered on the Billing Reps record. Return to the Members module, locate the desired member, click the Reps tab and edit the email address for the rep marked as the Billing Rep.
    CP Email Statements.JPG
  2. Make the desired selections. Those with a complete email address will be selected to be emailed.
  3. Click Send Emails.

Print/Email Thank You, Collections, and Notifications

Thank You Letters

A Thank You letter report may be generated for those members who have paid their invoices. Once generated, you will be able to easily send Thank You letters via email or print. Various filters are available to allow you to identify members. For example, you can filter the report by Membership Fees/Dues, and easily be able to thank your members for renewing.

Create/Customize your Thank You Letters

Templates may be created to customize your thank you letters, and make it efficient to send out the letters.

  1. Click Setup in the left-hand navigation panel.
    Billing Section.JPG
  2. Click Template Manager in the Billing Section.
    Layout Editor Thank You.JPG
  3. Select Thank You Letter from the Transaction Type drop-down list.
  4. Make desired edits to the default Thank You Letter
  5. Save your changes to the original template by clicking Save
    OR enter a name for the template in the Template Name text box, and click the Save As Button.

Print/Email Thank You Letters

  1. Click Billing in the left-hand menu.
  2. Click the Reports tab.
    Reports.JPG
  3. Click Thank you Letters in the Letters section.
    TY Letters.JPG
  4. Select the desired filtering:
    • Payment/Receipt Date From/Through: If you wish to identify paid invoices for a particular date range, enter the dates. OR click into the more... hyper-link to select a range (this month, this quarter, etc.) OR if you do not wish to filter by date range, click the more... hyper-link and select Do Not Filter.
    Select a Date Range.JPG
    • Include Sales Receipts. Select this check-box if you would like sales receipts included in the report output.
    • Show Active/Courtesy members only.: Clear this check-box if you would like to include Dropped/Inactive, Prospects and Non-members in the report output.
    • Specific Members: Click this radio button if you wish to generate the report for specific members. You can then click add by Company Name, add by Membership Status or add by Membership Status to select members.
    • Include voluntary fee items in balance.
    • Letter Template: Select the Thank You Letter template you wish to use. You may click the Letter Template hyper-link to edit the template.
    Output Option: Select the desired output option for the letters.
    • Sales Rep: If you wish to generate the report by Sales Rep, select the desired Sales Rep from the drop-down list. This would be used if you wish to generate the report and send personal letters from sales reps.
    • Item Type: If you wish to generate the report by a specific item type, select the type from the drop-down list. For example, if you wish to only include membership dues, select Membership Fees/Dues. Alternately, you can filter the report to specific fee items by selecting Use Specific Fee Item, then selecting the desired fee item(s).
    • Item Basis: If you wish to filter the report by Accrual or Cash, select the desired option.
    • Member Join Date From/Through: If you wish to filter the report to those who joined between certain dates, enter the desired dates.
  5. Click Refresh Listing. The report will be generated based on the filtering criteria you selected.
  6. Double-check the Output column to ensure the correct delivery method is selected for each member. If you do not wish to create letters for certain members, select None in the Output drop-down list.
  7. Click Create Letters.
    Create Letters.JPG
  8. Select the radio button for the desired Delivery method: Email or Print Letters. The list of recipients will be filtered to the output selected on the previous screen, you may remove recipients by deselecting them in the list.
    • If selecting Email, double-check the Email From address and Subject Line and then click Send Emails. NOTE: If you wish, first click Preview Emails.
    • If selecting Print Letters, choose the items you would like included in the letters. Include return address should be selected if you want your association return address be placed at the top of the printed output. To log the letter to the members' Communication tab, click the Create communication log entries check-box..
    • If needed, click Create Letters again and select Print Labels as the Delivery Method to print matching labels for the printed letters.

Collections Letters

Collection letters are intended for those that have not paid for their invoices. Select who should receive these letters and which letter they should receive by selecting the appropriate filter choices.

Print/Email Collection Letters

  1. Click Billing in the left-hand menu.
  2. Click the Reports tab.
    Collection Letter.jpg
  3. Click Collection Letters in the Letters section of the Reports tab.
    Collection Letters Filter.JPG
  4. Complete desired filters:
    • Aging: Select aging options if you want to filter the collections report to invoices that have aged beyond a certain number of days.
    • Show Active/Courtesy members only.: Clear this check-box if you would like to include Dropped/Inactive, Prospects and Non-members in the report output.
    • Specific Members: Click this radio button if you wish to generate the report for specific members. You can then click add by Company Name, add by Membership Status or add by Membership Status to select members.
    • Specific Batch: If you wish to filter the report on a specific batch, click the Choose a Batch (optional) hyper-link and select the desired batch.
    Invoice Batch Lookup.JPG
    • Letter Template: Select the Collections Letter template you wish to use. You may click the Letter Template hyper-link to edit the template.
    Output Option: Select the desired output option for the letters. Selecting Contact Preference will set the output to the preference configured on the Account tab for the member.
    • Sales Rep: If you wish to generate the report by Sales Rep, select the desired Sales Rep from the drop-down list. This would be used if you wish to generate the report and send personal letters from sales reps.
    • Item Type: If you wish to generate the report by a specific item type, select the type from the drop-down list. For example, if you wish to only include membership dues, select Membership Fees/Dues. Alternately, you can filter the report to specific fee items by selecting Use Specific Fee Item, then selecting the desired fee item(s).
    • Item Basis: If you wish to filter the report by Accrual or Cash, select the desired option.
  5. Click Refresh Listing.
    Collections Results.JPG
  6. Double-check the Output column to ensure the correct delivery method is selected for each member. If you do not wish to send the collection letter to certain member(s) set the output method to None.
  7. Click Create Letters.
    Deliver Collection Letters.JPG
  8. Select the desired Delivery method: Email or Print Letters.
    • If selecting Email, double-check the Email From address and Subject Line and then click Send Emails. NOTE: If you wish, first click Preview Emails.
    • If selecting Print Letters, choose the items you would like included in the letters. Include return address should be selected if you want your association return address be placed at the top of the printed output. To log the letter to the members' Communication tab, click the Create communication log entries check-box..
    • If needed, click Create Letters again and select Print Labels as the Delivery Method to print matching labels for the printed letters.

Notification Letters

Notification letters may be sent prior to the member billing month thanking them for their membership and notifying them that their membership dues will soon be billed.

Print/Email Notification Letters

  1. Click Billing in the left-hand menu.
  2. Click the Reports tab.
    Notification Letter.jpg
  3. Click Notification Letters in the Letters section.
  4. Complete the following Filter Options as desired:
    • Sales Month: Select the desired renewal month from the drop-down list.
    • Sales Rep: If you wish to generate the report by Sales Rep, select the desired Sales Rep from the drop-down list. This would be used if you wish to generate the report and send personal letters from sales reps.
    • Show Active/Courtesy members only.: Clear this check-box if you would like to include Dropped/Inactive, Prospects and Non-members in the report output.
    • Specific Members: Click this radio button if you wish to generate the report for specific members. You can then click add by Company Name, add by Membership Status or add by Membership Status to select members.
    • Include Monthly, ACH and One-Time Invoices.
    • Include voluntary fee items in amount.
    • Letter Template: Select the Notification Letter template you wish to use. You may click the Letter Template hyper-link to edit the template.
    Output Option: Select the desired output option for the letters. Selecting Contact Preference will set the output to the preference configured on the Account tab for the member.
    • Item Type: If you wish to generate the report by a specific item type, select the type from the drop-down list. For example, if you wish to only include membership dues, select Membership Fees/Dues. Alternately, you can filter the report to specific fee items by selecting Use Specific Fee Item, then selecting the desired fee item(s).
    • Item Basis: If you wish to filter the report by Accrual or Cash, select the desired option.
  5. Click Refresh Listing.
    Notification Letter Result.JPG
  6. Double-check the Output column to ensure the correct delivery method is selected for each member. If you do not wish to send the notification letter to certain members, select None.
  7. Click Create Letters.
    Deliver Notification Letters.JPG
  8. Select the desired Delivery method: Email or Print Letters.
    • If selecting Email, double-check the Email From address and Subject Line and then click Send Emails. NOTE: If you wish, first click Preview Emails.
    • If selecting Print Letters, choose the items you would like included in the letters. Include return address should be selected if you want your association return address be placed at the top of the printed output. To log the letter to the members' Communication tab, click the Create communication log entries check-box..
    • If needed, click Create Letters again and select Print Labels as the Delivery Method to print matching labels for the printed letters.

Group Billing

Fees may be assigned to a group or to certain individuals within the group. Groups may be created by you as desired to accommodate your billing needs or you may use groups that are already created.

Fees are created by selecting Group Fees as the Item Type. In the Groups module, fees are assigned to an entire group and then the amount may be modified per individual if desired. However, all group members will be billed using the same frequency.

To create invoices for a group that has been assigned a fee item with a One-Time Billing Cycle, Bill Group Now must be selected on the Group Fees tab.

Creating invoices for a group that has been assigned a fee item with a Billing Cycle of Annual, Semi-Annual, Quarterly, or Monthly, allows you to invoice from the Billing module by selecting the Group Batch Type and the appropriate Billing Month. These fees are treated as recurring fees and will be included automatically in Group billing batch.

If your group(s) should be billed on a regular basis, setting the Billing Cycle to Annual, Semi-Annual, Quarterly, or Monthly would be recommended, especially if billing multiple groups each month. To create the invoices only requires only a few simple selections in the Billing module each month.

Event Billing

Contains steps for setting up Event fees and creating event invoices.


Integrated Billing - Initial Setup

Setup Payment Terms


Add a Payment Term


  1. Click Setup in the left-hand menu.
  2. Click Payment Terms in the Billing area. The current list of Payment Terms will display.
  3. Click Add Payment Term. Type the name of the new term in the Name field (replacing –New Payment Term). Modify the Due Dates Offset if desired.
  4. Click Save Changes.

Remove a Payment Term


  1. Click Setup in the left-hand menu.
  2. Click Payment Terms in the Billing area. The current list of Payment Terms will display.
  3. Click the x at the end of the row of the desired Payment Term to be removed.
  4. Click Save Changes.

Rename a Payment Term


  1. Click Setup in the left-hand menu.
  2. Click Payment Terms in the Billing area. The current list of Payment Terms will display.
  3. Click within the Name or the Due Date Offset of the desired Payment Term. Make desired changes.
  4. Click Save Changes. Note: All previously recorded entries that used this Payment Term will now have the new Name and new Due Date Offset.

Manage Billing Templates


Default templates for them emails sent for invoices, statements, credit memos, receipts, payments, notification letters, thank you letters and collection letters are available in your database. You may use these templates as designed or customize them to meet your business needs.

View/Edit Invoice Templates


Within in your database, the Default with Logo invoice has been provided for use in creating your invoices. You can edit this template to meet your needs in needed.

  1. Select Setup in the left-hand navigation panel.
  2. Click Template Manager in the Billing section. By default the Transaction type will display Invoice. The loaded template lists the name of the template currently displayed.
  3. From the loaded template drop-down list, select the template you wish to view/modify.
  4. Edit the template as desired. Rich Text Editor functions are available to customize the template. See Rich Text Editor Functions for instructions.
  5. Insert the desired field by clicking Add Database Field, open the Billing Template Fields, scroll to and click the desired field.
  6. Type a new name for this edited template in the Template Name field and click Save As (so not to modify the original in case you need to return to the old template).
  7. Make sure to select this new template when creating your invoices.

One Row.png

NOTE: The database field titled [invoice_compact_lineitems] generates a unique output when used and is not commonly included on templates except in rare occasions. This database field will take all individual line items billed to the customer and compact them into a single item on the invoice that is displayed to the customer. The line item total will include the total of all individual line items. The line item description for the first item on the invoice is the only item that will display to the customer. In your software, you will still see all individual line items but the customer is kept from getting bogged down with all the items that make up that single item that you’d like to bill them.

View/Edit Statement Templates


  1. Select Setup in the left-hand navigation panel.
  2. Click Template Manager in the Billing section.
  3. Select Statement from the Transaction Type list.
  4. From the Loaded Template drop-down list, select the template you wish to view/modify.
  5. Edit the template as desired. Rich Text Editor functions are available to customize the template. See Rich Text Editor Functions for instructions.
  6. Type a new name for this edited template in the Template Name field.
  7. Click Save As (so not to modify the original in case you need to return to the old template).
  8. Click Close.

View/Edit Credit Memo Templates


  1. Select Setup in the left-hand navigation panel.
  2. Click Template Manager in the Billing section.
  3. Select Credit Memos from the Transaction Type list.
  4. From the Loaded Template drop-down list, select the template you wish to view/modify.
  5. Edit the template as desired. Rich Text Editor functions are available to customize the template. See
  6. Insert the desired field by clicking Add Database Field, open the Billing Template Fields, scroll to and click the desired field.
  7. Type a new name for this edited template in the Template Name field.
  8. Click Save As (so as not to modify the original in case you need to return to the old template).
  9. Click Close.

View/Edit Payment Templates


  1. Select Setup in the left-hand navigation panel.
  2. Click Template Manager in the Billing section.
  3. Select Payments from the Transaction Type list.
  4. From the Loaded Template drop-down list, select the template you wish to view/modify.
  5. Edit the template as desired. Rich Text Editor functions are available to customize the template. See Working with the Rich Text Editor for instructions.
  6. Insert the desired field by clicking Add Database Field, open the Billing Template Fields, scroll to and click the desired field.
  7. Type a new name for this edited template in the Template Name field.
  8. Click Save As (so as not to modify the original in case you need to return to the old template).
  9. Click Close.

View/Edit Collection Letter Templates


  1. Select Setup in the left-hand navigation panel.
  2. Click Template Manager in the Billing section.
  3. Select Collection Letter from the Transaction Type list.
  4. From the Loaded Template drop-down list, select the template you wish to view/modify.
  5. Edit the template as desired. Rich Text Editor functions are available to customize the template.
  6. Insert the desired field by clicking Add Database Field, open the Billing Template Fields, scroll to and click the desired field.
  7. Type a new name for this edited template in the Template Name field.
  8. Click Save As (so as not to modify the original in case you need to return to the old template).
  9. Click Close.

View/Edit Notification Letter Templates


  1. Select Setup in the left-hand navigation panel.
  2. Click Template Manager in the Billing section.
  3. Select Notification Letter from the Transaction Type list.
    NOTIFICATION LETTER 2020.jpg
  4. From the Loaded Template drop-down list, select the template you wish to view/modify.
  5. Edit the template as desired. Rich Text Editor functions are available to customize the template. See Working with the Rich Text Editor for instructions.
  6. Insert the desired field by clicking Add Database Field, open the Billing Template Fields, scroll to and click the desired field.
  7. Type a new name for this edited template in the Template Name field.
  8. Click Save As (so as not to modify the original in case you need to return to the old template).
  9. Click Close.

One Row.png

IMPORTANT Make sure not to modify the items in [] brackets. These items contain custom programming that will automatically populate with specific information from your member’s account. If you accidentally modify/delete these fields, do not save but close the window. If the accidental modification was already saved, click the Add Database field icon to replace the item and save your updates.

View/Edit Thank You Letter Templates


  1. Select Setup in the left-hand navigation panel.
  2. Click Template Manager in the Billing section.
  3. Select Thank You Letter from the Transaction Type list.
  4. From the Loaded Template drop-down list, select the template you wish to view/modify.
  5. Edit the template as desired. Rich Text Editor functions are available to customize the template. See
  6. Insert the desired field by clicking Add Database Field, open the Billing Template Fields, scroll to and click the desired field.
  7. Type a new name for this edited template in the Template Name field.
  8. Click Save As (so as not to modify the original in case you need to return to the old template).
  9. Click Close.

Manage Cover Letter Templates


Cover Letter Templates can be created to be included as the email sent along with your invoices. You may, for example, have a cover letter that is used when you initially send out your renewal invoices, and then a separate email template that is used when you send reminder invoices.

View/Edit Invoice Cover Letter Templates


To view/edit your invoice cover letter templates:

  1. Click Setup in the left-hand navigation panel.
  2. Click Template Manager - Cover Letters in the Billing Section. The Layout Editor screen will, by default, display Invoice cover letters, but this screen can be used for updating cover letters for statements, credits, receipts and payments.
  3. Select the cover letter that you wish to view and edit from the Loaded Cover Letter drop-down list.
    Cover Letters.JPG
  4. Edit the template as desired. Rich Text Editor functions are available to customize the template. See Working with the Rich Text Editor for instructions.
  5. To save the changes to an existing template, simply click Save OR To save the cover letter as a new template, enter the Cover Letter name and click Save As.
  6. If you wish to set this cover letter as your system default, click the Save as default check-box.
  7. Click Close

View/Edit Statement Cover Letter Templates


  1. Click Setup in the left-hand navigation panel.
  2. Click Template Manager - Cover Letters in the Billing Section.
  3. Select Statement Cover Letter (Statement attached as PDF) or Statement embedded in E-mail from the Cover Letter Type list. When sending out your statements, you will choose whether to attach the statement or embed, so be sure to select the cover letter type that matches your process.
  4. Select the cover letter that you wish to view and edit from the Loaded Cover Letter drop-down list.
  5. Edit the template as desired. Rich Text Editor functions are available to customize the template.
  6. To save the changes to an existing template, simply click Save OR to save the cover letter as a new template, enter the Cover Letter name and click Save As.
  7. If you wish to set this cover letter as your system default, click the Save as default check-box.
  8. Click Close.

View/Edit Credit Memo Cover Letter Templates


  1. Click Setup in the left-hand navigation panel.
  2. Click Template Manager - Cover Letters in the Billing Section.
    Credit cover letter 2020.jpg
  3. Select Credit Cover Letter (Credit Attached as PDF) or Credit Cover Letter (Credit embedded in email). Selection is based on your business process for delivering credits. Best Practice is to embed the credit memo in an email, vs. attaching as a PDF.
  4. Select the cover letter that you wish to view and edit from the Loaded Cover Letter drop-down list.
  5. Edit the template as desired. Rich Text Editor functions are available to customize the template.
  6. To save the changes to an existing template, simply click Save, or to save the cover letter as a new template, enter the Cover Letter name and click Save As.
  7. If you wish to set this cover letter as your system default, click the Save as default check-box.
  8. Click Close.

View/Edit Payment Cover Letter Templates


  1. Click Setup in the left-hand navigation panel.
  2. Click Template Manager - Cover Letters in the Billing Section.
    Payment receipt cover letter 2020.jpg
  3. Select Payment Receipt Cover Letter (Receipt Attached as PDF) or Payment Receipt Cover Letter (Receipt embedded in email) from the Cover Letter Type list. Selection is based on your business process for delivering payment receipts. Best Practice is to embed the payment receipt in an email, vs. attaching as a PDF.
  4. Select the cover letter that you wish to view and edit from the Loaded Cover Letter drop-down list.
  5. Edit the template as desired. Rich Text Editor functions are available to customize the template.
  6. To save the changes to an existing template, simply click Save, or to save the cover letter as a new template, enter the Cover Letter name and click Save As.
  7. If you wish to set this cover letter as your system default, click the Save as default check-box.
  8. Click Close.

View/Edit Sales Receipt Cover Letter Templates


  1. Click Setup in the left-hand navigation panel.
  2. Click Template Manager - Cover Letters in the Billing Section.
    Sales receipt cover letter 2020.jpg
  3. Select Sales Receipt Cover Letter (Receipt Attached as PDF) or Sales Receipt Cover Letter (Receipt embedded in email) from the Cover Letter Type list. Selection is based on your business process for delivering sales receipts. Best Practice is to embed the sales receipt in an email, vs. attaching as a PDF.
  4. Select the cover letter that you wish to view and edit from the Loaded Cover Letter drop-down list.
  5. Edit the template as desired. Rich Text Editor functions are available to customize the template.
  6. To save the changes to an existing template, simply click Save, or to save the cover letter as a new template, enter the Cover Letter name and click Save As.
  7. If you wish to set this cover letter as your system default, click the Save as default check-box.
  8. Click Close.

View/Edit Collection Letter Templates


  1. Select Setup in the left-hand navigation panel.
  2. Click Template Manager in the Billing section.
  3. Select Collection Letter from the Transaction Type list.
  4. From the Loaded Template drop-down list, select the template you wish to view/modify.
  5. Edit the template as desired. Rich Text Editor functions are available to customize the template. See Working with the Rich Text Editor for instructions.
  6. Insert the desired field by clicking Add Database Field, open the Billing Template Fields, scroll to and click the desired field.
  7. Type a new name for this edited template in the Template Name field.
  8. Click Save As (so as not to modify the original in case you need to return to the old template).
  9. Click Close.

Manage Customer Messages for Invoices


When sending out invoices, you can add a customized message on the invoice. You may create as many customer messages as you wish, then use them as appropriate. For Example, you may have one message that you use for membership invoices and another that you use for event invoices.

Create a Customer Message for Invoice


  1. Click Setup in the left-hand navigation panel.
  2. Click Customer Messages in the Billing section. A list of all messages you have previously be created will be displayed.
    Customer message 2020.jpg
  3. Click the Add New Message button. -New Message- will be displayed in the Message Name column.
  4. Type in the name of the message over -New Message-.
  5. Click the edit text button.
    Message edit 2020.jpg
  6. Enter your message. Use the Rich Text Editor icons to customize as needed.
  7. Click Continue.
  8. Click Close.

Smallest.png

Did you know...Customer messages may also be created "on the fly" when generating invoices.

Edit a Customer Message for Invoice


  1. Click Setup in the left-hand navigation panel.
  2. Click Customer Messages in the Billing section. A list of all messages you have previously be created will be displayed.
  3. Click the edit text button for the message that you wish to change.
  4. Change the message text as desired.
  5. Click Continue.

One Row.png

NOTE: Customer messages may also be edited "on the fly" when generating invoices.

Send Collections Letters


Unfortunate, but at times you may need to send collection letters to those that have not paid their invoices. In creating the collection letters, you will be able to select who should receive these letters and which letter they should receive by selecting the appropriate filter choices.

  1. In the Billing module, click the Reports tab.
  2. Click Collection Letters in the Letters section.
  3. Complete the filter as desired, making sure to select the desired Aging and/or specific Batch. If sending a reminder for membership dues only, you may wish to select an Item Type of Members Fees/Dues Only.
  4. Click Refresh Listing.
  5. Double-check the Output column to ensure the correct delivery method is selected for each member.
  6. Click Create Letters to use the existing, selected template. (or click Letter Template: to edit the current template)
  7. Select the desired Delivery method: Email or Print Letters.
  8. If selecting Email, double-check the Email From address and Subject Line and then click Send Emails. (or first click Preview Emails if desired)
  9. If selecting Print Letters, click Print Letters to view and print the letters.
  10. Note: Include return address should be selected if you desire that your association return address be placed at the top of the printed output.
  11. If needed, click Create Letters again and select Print Labels as the Delivery Method to print matching labels for the printed letters.

Billing Options & Setting


The Billing Options & Settings allow you to establish defaults for such things as number of days ahead of renewal month you wish the task list to notify you that invoices need to be created, default invoice & statement templates you wish to use, credit card processing/manual e-payment settings, etc.

  1. Click Setup in the navigation panel.
  2. Click Billing Options & Settings in the Billing Section.
Cm billing options and settings 2020.jpg

Define Default Contact to be Used for Non-Member Transactions


When non-members purchase such things as event registrations, invoices/payments/receipts must be logged in the database. This setting allows you to designate a contact. When purchases are made, the appropriate billing transactions will be logged on this contact's Account tab.

  1. Click Setup in the navigation panel.
  2. Click Billing Options & Settings in the Billing Section.
    Con member transactions 2020.jpg
  3. Select the Default member record where non-member invoices/receipts will be assigned for purchases: Select the member record to which invoices for non-members will be attached. For example, if a non-member registers for an event, the system needs a place to store these invoices/payments/receipts. A default contact Non Member Transactions has been setup for this. If you have setup an alternate contact, click the hyper-link to choose the contact.
  4. Click Save.

Set Look Ahead for Task List Invoices


Based on your business processes, you can define the number of months the system will look ahead for recurring fees for which invoices need to be generated. The task list will use this look ahead to notify you.

  1. Click Setup in the navigation panel.
  2. Click Billing Options & Settings in the Billing Section.
    Look ahead 2020.jpg
  3. In the # of months to look ahead for task list invoice count text-box, enter the number of months in advance that you prepare your membership renewal invoices. This setting will then trigger the task list to display the invoices pending for that period.
  4. Click Save.

Set the Default Tax Rate for Your Organization


  1. Click Setup in the navigation panel.
  2. Click Billing Options & Settings in the Billing Section.
    Tax rate 2020.jpg
  3. In the Sales Tax Rate: select the default sales tax rate to be used.
  4. Click Save.

Set Default Deposit/Bank Accounts


Your system will make the appropriate entries for payments and deposits. You can define which accounts, by default, should be used for undeposited fund and the bank account for deposits. These accounts should first be created under your Chart of Accounts.

  1. Click Setup in the navigation panel.
  2. Click Billing Options & Settings in the Billing Section.
    Deposti Accounts 2020.jpg
    • Payment Deposit Account: Select the default deposit account to be used when receiving payments or processing sales receipts.
    • Bank Deposit Account: Select the default deposit account to be used when depositing funds.
  3. Click Save.

Connect to QuickBooks On-line


If you are using QuickBooks On-line, you will first need to establish a connection to your QuickBooks software.

  1. Click Setup in the navigation panel.
  2. Click Billing Options & Settings in the Billing Section.
    Qb Connection 2020.jpg
  3. Click on the QuickBooks Online Connection button.
    Connect QB Online 2020.jpg
  4. Enter your QuickBooks online login information and say yes to the connections.
  5. Click Save. The screen should indicate that you are now connected to QuickBooks on-line.

Configure Default A/R Account used when Invoicing


In the Appearance section of Billing Options & Settings you will be able to define default A/R account to be used when generating invoices. If you have multiple A/R accounts, best practice is to choose the account that is used the majority of the time. The A/R account must have been created in your Chart of Accounts.

  1. Click Setup in the navigation panel.
  2. Click Billing Options & Settings in the Billing Section.
    Default AR account.jpg
  3. Select theA/R Account: to be used by default. You may edit (or add new accounts) by clicking the Edit Account button.
  4. Click Save.

Define Default Payment Terms used when Invoicing


By setting default Payment terms, this term will be applied to all invoices you generate. If needed, you will have the opportunity over-ride the terms when invoices are created.

  1. Click Setup in the navigation panel.
  2. Click Billing Options & Settings in the Billing Section.
    Payment terms 2020.jpg
  3. Select the Payment Terms that you wish to use by default. You will be able to over-ride these terms as needed when creating an invoice, best practice is to select the terms that you use the most frequently. You can add or edit terms by clicking the Edit Payment Terms button.
  4. Click Save.

Define Customer Message included on Invoices


When sending invoices you have the opportunity to include a customer message. You can define a default, one you wish to use the majority of the time, under Billing Options & Settings.

  1. Click Setup in the navigation panel.
  2. Click Billing Options & Settings in the Billing Section.
    Customer message default 2020.jpg
  3. Select the Customer Message that will be included on your invoices by default. When you are creating invoices, you will be able to select the message you wish to apply from a drop-down list.
  4. Click Save.

One Row.png

NOTE: You will also be able to edit the Customer Message on the fly, when generating your invoices.

Define Default Delivery Method for Invoices


  1. Click Setup in the navigation panel.
  2. Click Billing Options & Settings in the Billing Section.
    Default delivery method 2020.jpg
  3. Select your preferred Delivery Method for invoices. You will have the ability to over-ride this option when delivering invoices. Best practice is to select the method that you use the majority of the time.
  4. Click Save.

Choose Discount Memo Display Options


You have the option to include a discount memo on invoices.

  1. Click Setup in the navigation panel.
  2. Click Billing Options & Settings in the Billing Section.
    Discount memo.jpg
  3. Enable Display the Invoice Discount Memo as the line item description for Invoice Discounts on member Bill Pay screens and invoices/statements. When this setting is enabled, the Memo field (your custom message) will be displayed to members when they view a Discount line item on their invoices, statements, on their Bill Pay screen or in their Transaction History. When this setting is off, Discount line items will display the word "Discount" in member-facing locations. NOTE: The Memo field is available when creating/editing an Invoice Discount. For instance, when editing an Invoice that has a remaining balance, click Add a Discount. The next window has a Memo field where you can make comments or notes about the purpose and reason for a discount.
  4. Click Save.

Define Default Templates for Invoices, Cover Letters & Statements


Under Billing Options & Settings you can set the invoice template, statement template, etc. for your accounting transactions.

  1. Click Setup in the navigation panel.
  2. Click Billing Options & Settings in the Billing Section.
  3. Expand the Appearance section if needed.
    Default templates 2020.jpg
  4. Select the Default Template you want the system to use by default.You will have the ability to override the template when creating invoices as needed. Best practice is to select the template that you use most frequently.
  5. Select the Email Cover Letter that you wish to use, by default, in delivering your invoices (email). You will have the ability to override the cover letter when delivering invoices. Best Practice is to select the cover letter that you use the most frequently. If needed, click the Edit Cover Letter button to make changes or choose a different letter.
  6. In Statement Defaults, select the Default Template to be used when generating statements. You can preview or edit the statement template. You will have the ability to over-ride this default when generating your invoices.
  7. Click Save.

Setup Credit Card Processing


With your ChamberMaster/MemberZone software you can automate credit card processing. GrowthZone will assist you with the initial setup. Additional settings for credit card processing can be configured under Billing Options & Settings.

    • Add link to bottom of email to pay bills online" selected by default when emailing invoices: Select this option to make it easy for your members to access their bills and pay on-line. NOTE: The rep to whom the invoice is sent must have a login to the MIC, and must have permissions set to read write for on-line bill payment.
Configure Staff Member to Receive Notification of On-line Credit Card Payments

When payments are received on-line, one of your staff members can be setup to receive notifications. Under Billing Options & Settings you can set the invoice template, statement template, etc. for your accounting transactions.

  1. Click Setup in the navigation panel.
  2. Click Billing Options & Settings in the Billing Section.
  3. Expand the Credit Card section if needed.
    Cc payment notifications 2020.jpg
  4. In the Send an automatic notification email to the Chamber, enter the name of the staff person that should receive an email message when a credit card payment is made on line. At this time only one email address can be selected.
  5. Click Save.
Select the Credit Cards you Accept

Under Billing Options & Settings you can set the invoice template, statement template, etc. for your accounting transactions.

  1. Click Setup in the navigation panel.
  2. Click Billing Options & Settings in the Billing Section.
  3. Expand the Credit Card section if needed.
    Cc accepted 2020.jpg
  4. Select the credit cards that you will accept: Visa, MasterCard, American Express, Discover.
  5. Click Save.
    • Add Credit Card Billing Address as required field: Enable this check-box if you require billing address for credit card transactions.
    • Add Credit Card Security Code as required field: Enable this check-box to require the credit card security code.
Define Billing Transactions to be created for Credit Card Charges

Under Billing Options & Settings you can set the invoice template, statement template, etc. for your accounting transactions.

  1. Click Setup in the navigation panel.
  2. Click Billing Options & Settings in the Billing Section.
  3. Expand the Credit Card section if needed.
    Cc transactions 2020.jpg
  4. Select Automatically create a paid invoice for credit card payments if you want an invoice created for each credit card transaction. If selected, you will have both an invoice and a payment record for the sale.
    OR
  5. Select Automatically create a receipt for credit card payments if you want only a receipt to be created for each credit card transaction.
  6. Click Save.

Include Terms & Conditions on Check-out


If you wish to display your terms & agreements will appear in the checkout cart (which includes member payments from the Member Information Center, purchases of jobs and deals and event registration), you can enable this option under Billing Options & Settings. Typical agreement statements include privacy policy info, website disclaimers and other items as recommended by your legal counsel. Under Billing Options & Settings you can set the invoice template, statement template, etc. for your accounting transactions.

  1. Click Setup in the navigation panel.
  2. Click Billing Options & Settings in the Billing Section.
  3. Expand the Credit Card section if needed.
    Terms and conditions 2020.jpg
  4. Select Display Terms and Conditions agreement in checkout cart. When selected, you will be able to add a check-out statement, and your actual terms and conditions.
    Terms and conditions 2020.jpg
  5. Click Save.

Add "This charge will appear as.." on Credit Card Purchase Receipts


To avoid potential credit card disputes, you can add an additional message to credit card purchases. This will allow you to tell purchasers how the charge will be displayed on their credit card statement.

  1. Click Setup in the navigation panel.
  2. Click Billing Options & Settings in the Billing Section.
  3. Expand the Credit Card section if needed.
    Merchant store 2020.jpg
  4. Enter the Merchant or Store Name [Optional]. This will be used to generate an additional message on Credit Card Purchase Receipts that will read: Important: This charge will appear as [Your Merchant or Store Name] on your Credit Card statement.
  5. Click Save.