Difference between revisions of "Billing"

From Online Support Wiki
Jump to navigation Jump to search
Line 931: Line 931:
  
 
[[File:Recog results.jpg|center]]
 
[[File:Recog results.jpg|center]]
 +
 +
You can perform the following actions with the report by clicking the down arrow on the '''Run Report''' button:
 +
 +
*'''Export as PDF'''
 +
*'''Export as Excel'''.
 +
*'''Export Summary as PDF'''
 +
*'''Export Summary as Excel'''
 +
*'''Email Report'''
 +
*'''Add to List''' - This option will allow you to add the members to an existing list, or create a new list (by clicking the '''+''' button on the Add Contacts to list screen'''). This can help you in sending emails to this group as necessary.
 +
[[File:Add Contracts to List.jpg|frame|center]]
 +
*'''Save as New Report''' - If you want to use this report with the same filtering options in the future, you can save the report.
 +
[[File:Save Report View.jpg|frame|center]]
 +
 +
::<div class='note'>'''NOTE:''' To make this report available to all users, do not select the '''Hide This Report From Other Users''' check-box. If selected, the report will only be available to you. </div>
 +
*'''Add as a Favorite Report''' - you may save the report as a favorite, then easily identify it when filtering reports in the '''Reports''' module. '''NOTE:''' This option will not be available if the report has already been saved as a favorite.
 +
 +
==Recurring Billing Report==
 +
 +
The '''Recurring Billing Report''' allows you to generate a list of all contacts for which a recurring billing schedule has been set up in the database.  This report may be useful in identifying upcoming membership renewals, or recurring donations. This report may also be used to view expected income for the upcoming renewals.
 +
 +
#Click '''Reports''' in the Navigation Panel
 +
#Select '''Recurring Billing Report'''.
 +
#:[[File:Recurring Billing Criteria.jpg|center]]
 +
#Select your search filtering criteria. For example, you may wish to view just a selected renewal month.
 +
#Optional - Enter a '''Search/Filter''' query. For example, if you wish to view recurring billing based on a particular sales person, select '''Sales Rep'''.
 +
#:[[File:Sales Rep Criteria.jpg|center]]
 +
#Select '''Display Options'''.  They system is setup with default fields to display in your report. You may add and/or remove fields by clicking on the '''Fields to Display''' drop-down arrow.
 +
#Select '''Summarize by''' criteria.  This optional field allows you to select how you wish report results grouped, for example, you may wish to group by sales rep.
 +
#Click '''Run Report'''.
 +
 +
[[File:Recurring Billing Results.jpg|center]]
  
 
You can perform the following actions with the report by clicking the down arrow on the '''Run Report''' button:
 
You can perform the following actions with the report by clicking the down arrow on the '''Run Report''' button:

Revision as of 15:04, 28 November 2017

Contents

Overview

With your GrowthZone software, we have integrated the entire invoicing process into the software to ensure no double entry and save you time. An Accounting Summary report allows you to post summary from GrowthZone to keep QuickBooks, PeachTree and other accounting systems in sync.

Initial Billing Setup

Setup Your Chart of Accounts

The Chart of Accounts ensures that your financial data is aligned to any existing accounting records and processes. On installation of the software, a sample chart of accounts is provided as a starting point. Edit and add to this list to ensure your database chart of accounts matches your current structure.

Edit Your Chart of Accounts

  1. Click Setup in the Navigation panel.
  2. Click Chart of Accounts in the Finance section. A list to the accounts currently configured in your system will be displayed.
  3. Click on the link for the account you wish to edit and make the desired edits.
  4. Click Done to save the changes.

Add New Account to Your Chart of Accounts

  1. Click Setup in the Navigation panel.
  2. Click Chart of Accounts in the Finance section. A list to the accounts currently configured in your system will be displayed.
  3. Click the Add button.
  4. Configure the following settings:
    a. Name - This is the name of the account. This name must match exactly the name of the account in your general accounting software.
    b. Number - This is the number associated with this account.
    c. Account Description - Enter a description of this account. This is for informational purposes only.
    d. Is Active - Select the check-box to activate this account. If the account is not activated, it will not be available for use within the software.
    e. Type - Select the type of account from the drop-down list.
    f. Chapter - If applicable, select the chapter associated with this account.
  5. Click Done to save the new account.

Set Up Your Payment Terms

By default, payment terms are set to Due on Receipt. You may modify and add additional payment terms to meet your business needs.

  1. Click Setup in the Navigation panel.
  2. Click Invoice Terms in the Finance section. A list of invoice terms currently configured in your system will be displayed.
  3. Click the Add button.
  4. On the Add/Edit Invoice Terms screen, configure the following:
    • Name - Enter a name for this invoice term. This name will be displayed in drop-down lists in the software.
    • Display Name - Enter the display name. This will be displayed on invoices.
    • Default Due Days - Enter the default due days for this invoice term configuration.
  5. Click Done.

Set Up Your Terms & Conditions

  1. Click Setup in the Navigation Panel.
  2. Click Terms/Conditions in the Services, Products and Commerce section.
  3. Click the Add button.
    Add Edit Term Condition.jpg
  4. Enter a Name that easily identifies this terms & condition set. You may create multiple terms & conditions as needed by your business processes.
  5. Description - Enter your terms & conditions. You may use the standard word-processing functions (bold, italics, etc.) as well as add links and images. If you choose, the terms & conditions may be displayed on the Membership Application Form.
  6. Click Done.

Set Up Your Payment Gateways

Integrated Payment Processing (IPP)

Integrated Payment Processing (IPP) allows your contacts to enter their credit card or bank account information into a secured page to pay invoices, event registration, donations, etc… online. By checking to save this account, users can apply this automatically to recurring fees (e.g. membership) or other one-time purchases. Creating your IPP gateway is a two step process

Step One

  1. Click Setup in the Navigation panel.
  2. Click Payment Gateways in the Finance section.
  3. Click the Add button.
  4. On the Add Payment Gateway screen, configure the following:
    • Type - Select Integrated Payment Processor from the drop-down list.
    • Default Gateway - Select this check-box if this will be used as your default gateway.
    • Internal Name - This name is the name you will see internally for this account. You may have multiple processing accounts, perhaps one for your memberships and one for fundraising. In this event, you would add additional IPP gateways for these. This is a way for you to internally recognize with account is used for which transaction.
    • Country - (Optional) Select your country from the drop-down list.
  5. Click Done to save the new IPP account.

Step Two

In step two, your business contact and account information is entered. This will also include personal information about the owner of the account. This information is necessary to verify the authenticity of the account holder.

  1. For the newly created gateway, click the pencil icon in the 'Actions column.
  2. On the Edit Payment Gateway screen, configure the following:
    • Name - this field will be populated with the name previously assigned to this gateway. You may modify it if needed.
    • Default Gateway - this field if populated with your previous choice. You may modify it if needed.
    • *Account Number - this field is automatically generated when the gateway is first created.
    • Business Name - this field is automatically populated with the name of your business.
    • Statement Descriptor (Maximum 22 characters) - The statement descriptor appear on purchasers statements so best practice is to enter a descriptor that allows the purchaser to easily identify your organization.
  3. Public Contact Info - Enter the contact information for your organization.
  4. Decline Charge On:
    • CVC Failure - If you select this check-box, charges will be declined if the CVC fails.
    • AVC Failure - If you select this check-box, charges will be declined if the AVC fails.
  5. Bank Accounts - Click the Add button to associate the organization's bank account with this gateway. This is the bank account to which the funds will be transferred. Once created, this bank account may not be deleted unless another one is added.
  6. Account Holder Information - Enter the required account holder information. Enter information about the holder of this account, i.e. the user/business receiving funds from this account. Select Individual or Business account. If selecting Business, the representative for the business is the individual who has been given authorization by their business to set up an account on behalf of the business. This individual is not responsible or liable for any activity that happens on the businesses' account but is required as part of "Know Your Customer" regulations.
  7. Additional Owners - In EU countries, we are required to collect and verify information about anybody that owns at least 25% of the company, in addition to the representative. The address of the additional owner(s) does not need to be in the same country as the account. Click the Add button to add additional owners to this account.
  8. Identity Document
  9. Click Done to save the account information.

Once the form is completed, an authorization process will take place. This is a very quick process, and you will be notified if any thing is missing or inaccurate on the form.

Setting Up Taxes

If any of your goods/services are taxable, to setup your taxes you will need to configure:

  1. Product Tax Categories
  2. Tax Regions
  3. Tax Rules
  4. Tax Rates
  5. Tax Sets

Setup Product Tax Categories

Under Product Tax Categories you will define the categories of products that are taxable. For example, if you are using the store module and are required to collect tax on certain products, you could set up the tax categories based on your store product categories (i.e. apparel, gifts, etc.).

  1. Click Setup
  2. Click Taxes in the Finance section.
    Product Tax Categories.jpg
  3. On the Product Tax Categories tab, click the Add button.
    Add Edit Product Tax Category.jpg
  4. Enter a Name for the category.
  5. Click Done

Setup Tax Regions

Tax regions are the region for which you must collect taxes. For example, if you must collect state taxes, you could name the region after the state.

  1. Click Setup
  2. Click Taxes in the Finance section.
    Tax Regions.jpg
  3. On the Tax Regions tab, click the Add button.
    Add Edit Tax Region.jpg
  4. Enter a Name for the new regions.
  5. Click the + button to associate the product categories that are taxable in this region.
    NOTE: When the product categories are added to the regions, these become the Tax Rules displayed on the Tax Rules tab.
    Add Edit Tax Region1.jpg
  6. Click Done.

Setup Tax Rates

In most cases, sales tax rates must be configured for the physical location that the chamber/association has a presence (nexus). If you operate in multiple states, you would need to enter the tax rates for each state.

NOTE: It is important to get in touch with your state’s taxing authority or an experienced accounting professional should you have questions about sales tax rates.
  1. Click Setup
  2. Click Taxes in the Finance section.
    Tax Rates.jpg
  3. On the Tax Rates tab, click the Add button.
    Add Edit Tax Item.jpg
  4. Enter a Name for the tax rate. For Example: Minnesota to identify a Minnesota tax rate.
  5. Enter an optional Description of the tax rate.
  6. Enter the rate in decimal format. For Example: 6.5% tax rate enter 0.065.
  7. If taxing is a Flat Amount enter the flat amount.
  8. Select the Payable Account that will be used for your taxes payable.
  9. Click Done.

Set Up Your Invoice Template

A standard invoice template is built into the software. You can use this default template, or modify it to meet your business needs. You may also add a logo to the invoice. Alternately, you may import your existing template into the database.

View/Modify Invoice Template (PC Instructions)

  1. Click Setup in the Navigation Panel.
  2. Click Document Generation Templates in the Document Generation section. A list of existing templates will be displayed.
  3. Click the copy icon Copy icon.jpg for the Invoice template.
  4. Click OK in the confirmation dialog box. A copy of the invoice template will be available in the list of templates.
  5. To view the template, click the pencil icon (Edit Template Document). The Open URL:Word Protocol dialog box will be displayed.
    Open URL.jpg
  6. Click Open URL:Word Protocol. You will be taken to the document editor login. Enter your GrowthZone user name and password to launch the document.
  7. Enable editing of the document.
  8. Complete your changes.
  9. Save your document.

Your changes will be saved. You can now choose this template where applicable.

Note: The default invoice template contains a system message. The message may be viewed and changed under Setup > Message Templates > System Invoice Message Template.

View/Modify Invoice Template (MAC Instructions)

  1. Click Setup in the Navigation Panel.
  2. Click Document Generation Templates in the Document Generation section. A list of existing templates will be displayed.
    Doc Gen Templates.jpg
  3. Click the copy icon Copy icon.jpg for the Invoice template.
  4. Click OK in the confirmation dialog box. A copy of the invoice template will be available in the list of templates.
  5. To edit the copy, click the download icon DL Icon 2.jpg in the Actions column.
  6. Open the downloaded file and make desired edits.
  7. Save the downloaded file.
  8. On the Document Generations Template screen, click the Add Orange Add button.jpg button.
    Add Edit Doc Template.jpg
  9. Enter a Name for the new template.
  10. Click Choose File to navigate to your saved copy and upload.
  11. Click Done. You will now be able to choose this template where applicable.

Configure Invoice & Statement Messages

Automatic messages may be included on your invoices and statements.

View Default Message Templates

  1. Click Setup in the Navigation Panel.
  2. Click Message Templates in the Finance section.
    Message Templates.jpg
  3. Click the hyper-link for the message you wish to view.
    Add Message Template.jpg


NOTE: You may edit an existing message template, however, if edited a duplicate message template will be created. If you wish to edit, best practice is to enter a new Name for the template to avoid confusion.

Configure Finance Defaults & Logo for Invoices & Statements

  1. Click Setup in the Navigation panel.
  2. Click General Settings in the Finance section.
  3. Click the pencil icon below Logo for Invoices and Statements.
    NOTE: the icon is visible when you dwell the mouse below Logo for Invoices and Statements.
  4. Click Upload to browse to the location of your logo.
  5. Click Open.
  6. Crop the image as needed, then click Crop & Save. The logo will now be displayed on all of your invoices and statements.
  7. For each of the listed accounts, select your default. This default will automatically be applied when you create goods & services, but you will be able to over-ride if needed.
  8. Select your Default Invoice Template. This is the template that will be used for all of your invoicing, but may be over-ridden. Refer to Setting Up Your Invoice Template for details on setting up a template.
  9. Select your Default Invoice Terms. Select the terms you wish to use by default.
  10. Transaction Deletion - This setting determines the number of days in which an invoice or payment may be deleted. Best practice is to limit the transaction window, as once an invoice is deleted, it is completed removed from your view which could cause issues with audits and/or reconciling. Additionally, there is risk that an invoice deleted from the database may already have been posted to your general accounting software. This would cause the two systems to become out of sync. The system provides a Void option that can be used instead of deleting. A void will create a counter entry.
  11. Automated Scheduled Billing - UNDER DEVELOPMENT The Lead Time Days setting allows you to configure the number of days ahead of the due date invoices for recurring fees (i.e. membership dues) are automatically generated. The lead time gives you time to review the invoices prior to them being emailed out.
    NOTE: At this time, you will still need to manually kick-off the actual email process.
  12. Use Automated Billing - UNDER DEVELOPMENT select this check-box if you wish to automatically charge those members who have stored payment profiles.
  13. My Association typically tracks and records information under the: This setting allows you to configure whether event registrations and billing should be tracked on the business (member) account tab, or the individual account tab.
  14. Click Save.

Set Up Goods/Services

Goods and Services allow you to define the “products” for the memberships, services and products you provide. Upon initial setup of the system you will add high level categories of the items that you offer. Additional good/services may be added as your business requires.

  1. Click Setup in the Navigation panel.
  2. Click Goods/Services in the Services, Products and Commerce section. A list of Goods/Services currently configured in your system will be displayed.
  3. Click the New button.
    Add Edit Good Service.jpg
  4. On the Add/Edit Good or Service screen, configure the following:
    • Name - Provide a name for the good/service. This will be displayed when you are selecting goods or services.
    • Good/Service Type - Select a type from the drop-down list. Type is used for filtering and reporting.
    • Product Category - Select a product category from the drop-down list. Product Category is used for filtering and reporting. You can select a previously configured product category from the list, or, to add a new product category, click the + sign.
    Add Edit Category Item.jpg
      • Enter a Name for the new product category.
      • Enter a Description of the new product category.
      • Select a Category List from the drop-down, or, to add a new category list, click the + sign.
      • Click Done.
    • Description - Enter a description of the good/service. This description is displayed in the Goods/Services list.
    • Product Description - The Product Description is displayed on the web when this good/service is used. The standard word processing for formatting your text (i.e. bolding, italiczing, etc.) are available. You may also add links and images to the description.
    • Price Period - Select how this good/service is billed. You may select: Annually, Monthly, One-time, Semi-annually, or Quarterly. An event good/service would be a one time fee.
    • Default Price - Enter a default price for this good/service. This price may be over-ridden when you are assigning the good/service.
    • Default Quantity - Enter the default quantity for this good/service. This would be used if a minimum purchase for this good/service is required, and may be overridden when you are assigning the good/service.
    • Accounting Type - Select either Cash or Accrual.
    • Revenue Recognition Type - Select how you will recognize the revenue for this good/service. For example, if this is an event related fee, and you wish to defer revenue recognition until the start date of the event, you would select Fully on Event Start Date.
    • Income Account - Select the income account for this good/service. The drop-down list will be populated with the income accounts currently configured in your Chart of Accounts. You may add a new account by clicking the + sign. If you are unsure as to which account should be selected you will want to check with your accountant, as this will affect your financial statements.
    • Receivables Account - Select the accounts receivable account for this good/service.The drop-down list will be populated with the receivables account configured in your Chart of Accounts.
    • Deferred Income Account - Select the deferred income account for this good/service. The drop-down list will be populated with the deferred income accounts configured in you Chart of Accounts. If you have chosen to defer the revenue for this event to a specific point in time, the revenue will be held in the deferred income account until that point in time.
    • Deposit Account - Select the deposit account for this good/service. The drop-down list will be populated with the deposit accounts configured in your Chart of Accounts.
    • Default Revenue Recognition Months - If the revenue for this good/service will be recognized over a period of time, enter the default number of months over which the revenue will be recognized.
    • Voluntary - Select this check-box if the fees for this good/service are voluntary. A voluntary fee may be displayed on an invoice, and the member may choose to or to not pay this fee. If they choose not to pay the fee, it will not be counted against them in any past due invoices reports. Voluntary fees are designed so that it is clear to your members when and if they are opting into the additional fee. For example on invoices, the amount of the invoice without voluntary fee will always be shown first, and if voluntary amounts are included, it will note that with a phrase (voluntary amount).
    Note: When creating a voluntary fee, you must select Membership as the Goods/Services type. Additionally, when the Voluntary check box is selected, the Accounting Type will automatically be set to Cash and the Revenue Recognition Type will be set to Fully on Paid Date.
    • Product Tax Category - If this good/service is taxable, select the appropriate product tax category. The drop-down list will be populated with tax categories currently configured in your system. If you wish to add a new product tax category, click the + button.
    • Tax Set - If this good/service is taxable, select the appropriate tax set.
    • Is Recurring Fee (vs. one-time) - Select this check-box if this is a recurring fee. Your membership dues, for example, are recurring fees.
    • Invoice Template - Select the invoice template to be used for this good/service.
    • Is Active - Select this check-box to activate this good/service. Only Active items may be billed and only active items will be displayed when you need to select a good/service.
  5. Click Done to save the new good/service.

Setting up Voluntary Fees

Voluntary fees may be added to your member invoices and membership applications. With a simple set up you can easily ask for, collect and track voluntary amounts. You may wish to use voluntary fees to ask for extra funds for special projects, such as technology improvements, or fundraising to support specific committee. A voluntary fee may be displayed on an invoice, and the member may choose to or to not pay this fee. If they choose not to pay the fee, it will not be counted against them in any past due invoices reports. Voluntary fees are designed so that it is clear to your members when and if they are opting into the additional fee. For example on invoices, shown below, the amount of the invoice without voluntary fee will always be shown first, and if voluntary amounts are included, it will note that with a phrase (voluntary amount).

Voluntary Fee Invoice.jpg
  1. Click Setup in the Navigation panel.
  2. Click Goods/Services in the Services, Products and Commerce section. A list of Goods/Services currently configured in your system will be displayed.
  3. Click the New button.
    Add Edit Good Service.jpg
  4. On the Add/Edit Good or Service screen, configure the following:
    • Name - Provide a name for the good/service. This will be displayed when you are selecting goods or services.
    • Good/Service Type - Select Membership as the Goods/Services type.
    • Product Category - Select a product category from the drop-down list. Product Category is used for filtering and reporting. You can select a previously configured product category from the list, or, to add a new product category, click the + sign.
    Add Edit Category Item.jpg
      • Enter a Name for the new product category.
      • Enter a Description of the new product category.
      • Select a Category List from the drop-down, or, to add a new category list, click the + sign.
      • Click Done.
    • Description - Enter a description of the good/service. This description is displayed in the Goods/Services list.
    • Product Description - The Product Description is displayed on the web when this good/service is used. The standard word processing for formatting your text (i.e. bolding, italiczing, etc.) are available. You may also add links and images to the description.
    • Price Period - Select how this good/service is billed. You may select: Annually, Monthly, One-time, Semi-annually, or Quarterly. An event good/service would be a one time fee.
    • Default Price - Enter a default price for this good/service. This price may be over-ridden when you are assigning the good/service.
    • Default Quantity - Enter the default quantity for this good/service. This would be used if a minimum purchase for this good/service is required, and may be overridden when you are assigning the good/service.
    • Voluntary - Select the Voluntary check box.
    • Accounting Type - Select Cash.
    • Revenue Recognition Type - Select Fully on Paid Date.
    • Income Account - Select the income account for this good/service. The drop-down list will be populated with the income accounts currently configured in your Chart of Accounts. You may add a new account by clicking the + sign. If you are unsure as to which account should be selected you will want to check with your accountant, as this will affect your financial statements.
    • Receivables Account - Select the accounts receivable account for this good/service.The drop-down list will be populated with the receivables account configured in your Chart of Accounts.
    • Deferred Income Account - Select the deferred income account for this good/service. The drop-down list will be populated with the deferred income accounts configured in you Chart of Accounts. If you have chosen to defer the revenue for this event to a specific point in time, the revenue will be held in the deferred income account until that point in time.
    • Deposit Account - Select the deposit account for this good/service. The drop-down list will be populated with the deposit accounts configured in your Chart of Accounts.
    • Default Revenue Recognition Months - Leave this set to 0.
    Note: When creating a voluntary fee, you must select Membership as the Goods/Services type. Additionally, when the Voluntary check box is selected, the Accounting Type will automatically be set to Cash and the Revenue Recognition Type will be set to Fully on Paid Date.
    • Product Tax Category - If this good/service is taxable, select the appropriate product tax category. The drop-down list will be populated with tax categories currently configured in your system. If you wish to add a new product tax category, click the + button.
    • Tax Set - If this good/service is taxable, select the appropriate tax set.
    • Is Recurring Fee (vs. one-time) - Select the recurring fee check box.
    • Invoice Template - Select the invoice template to be used for this good/service.
    • Is Active - Select this check-box to activate this good/service. Only Active items may be billed and only active items will be displayed when you need to select a good/service.
  5. Click Done to save the new voluntary good/service.

Voluntary fees can be easily tracked by running the Voluntary Payment Report. Click here for more details.

Billing Functions

The Billing module provides the functions to review invoices, view overdue invoices, accept payments, as well as review reports on accounts receivables, and generate the reports needed to reconcile to your general accounting software.

NOTE: The Billing Module allows you to manage billing for multiple members simultaneously. You may also perform many of these functions individually on a member's Billing tab.


Billing Module.jpg

The Billing module displays nine separate tabs to allow you to manage your billing processes:

  • Overview - This tab provides a summary view into the present status of your billing.
  • Pending Delivery - This tab will display a list of invoices that are currently waiting to be sent.
  • Payments - This tab displays a list of all payments you have received.
  • Invoices - This tab will display list of all invoices that have not yet been sent out.
  • Upcoming Billing - This tab displays a list of all future billing.
  • Upcoming Recognition - This tab will display a list of all revenue to be recognized in the future.
  • Deposits - This tab will display a list of all previous deposits.
  • Credit Memos - This tab will display a list of all previous credit memos.
  • Accounting Summary - This tab will display your accounting summary.

Deliver Invoices

The Pending Delivery tab in the Billing Module will provide a list of invoices that have not been sent out. These invoice would include invoice created when you run your recurring billing, or invoices created when a member requested to be invoice, for example for an event.

You may process and send out the invoices in the following manner:

  1. Select Billing in the Navigation Panel.
  2. Click the Pending Delivery tab. A list of all invoices that have not been sent will be displayed. When an invoice is created, you select whether the invoice is to be emailed, printed or both. This choice is displayed in the Delivery Method column. If the database does not have the information needed (address and/or email address) this will be noted by Yes in the Missing Info column. You may click the Yes hyper-link to add the missing information if available.

Deliver Invoices via E-mail

  1. To deliver the invoices via e-mail, click the Email Invoices button. A list of invoices to be emailed will be displayed.
    NOTE: If an email address is not available, the invoice will NOT be displayed in the list. Correct this as described previously.
    Invoices to Email.jpg
  2. Configure the following email settings:
    • File Format - Select either PDF or Word Format.
    • Invoice Template (Override). This option allows you to over-ride the invoice template that is associated to the fee items included in the invoices you are sending out. You may, for example, wish to select a different invoice template when sending out past due invoices.
    • From - Select the from email address.
    • Template - If you have created an email template to be used when sending invoices you may select it. If you are not using a template, you will simply be able to type your message.
    • Subject - Enter a subject for the email, and type your message into the text box, if you are not using a template.
    • Select the Invoices to Email. You may select invoices individually, or click the top check-box to select all invoices in the list. You can search for specific invoice by typing into the Search box.
  3. Click Done. Your selected invoices have now been emailed.

Print Invoices for Delivery

  1. To print invoices for delivery, click the drop-down arrow on the E-mail Invoices button, and select Print Invoices. The Invoices Print screen will display.
    NOTE: Only invoices for which you have address information will be displayed. Correct missing address information as previously described.
    Invoices to Print.jpg
  2. Select the File Format you wish to use.
  3. Invoice Template (Override). This option allows you to over-ride the invoice template that is associated to the fee items included in the invoices you are sending out. You may, for example, wish to select a different invoice template when sending out past due invoices.
  4. Select your Cover Letter Template (optional)
  5. Select the invoices you wish to print. You may select invoices individually, or click the top check-box to select all the invoices in the list.
  6. Click Done. The invoices will download and you may proceed with printing.

Re-deliver Past Due Invoices

You can view all invoices on the Sales/Invoices tab. To view only over-due invoices select Past Due Invoices from the Show Only drop-down list. The list of invoices will refresh displaying on your past due invoices.

Re-deliver Past Due Invoices via Email

  1. On the Sales/Invoices tab, filter the list to Past Due Invoices as described previously.
  2. Click the drop-down arrow on the New Invoice button.
  3. Click Email.
    Past Due Email.jpg
    • Select Invoice from the Deliver Type drop-down list.
    • Select the desired File Format from the drop-down list.
    • Select the desired invoice template from thehInvoice Template (Override) drop-down list.
    • Select a From address from the list.
    • Select a Cover Letter Template from the list.
    • Enter a Subject and type in your message if you have not selected a cover letter template.
    • Click the check-box for the invoices you want to email, or click the top-most check-box to select all invoices in the list.
  4. Click Done. The Past Due invoices have now been emailed.

Re-deliver Past Due Invoices via Print

  1. On the Sales/Invoices tab, filter the list to Past Due Invoices as described previously.
  2. Click the drop-down arrow on the New Invoice button.
  3. Click Print Invoices.
  4. Select the desired File Format from the list.
  5. Select the desired Invoice Template from the list.
  6. Select the desired Cover Letter Template from the list.
  7. Click the check-box for the invoices you want to print. Click the top-most check box to select all invoices in the list.
  8. Click Done to print the invoices.

Accept Payments

The Invoice tab will display all of your invoices, whether they have been paid or not. You can use this tab to analyze aging and make payments. The list may be filtered to just open invoices to make it easier to manage payments.

NOTE: You may also make payments on the Accounts tab of an individual member.

You can view the details of an invoice by clicking into the hyper-link for a particular invoice.

  1. Select Billing in the Navigation Panel.
  2. Click the Invoices tab. Customize the list to display only unpaid invoices to make it easier to locate the invoices for which you are accepting payment.
  3. Click the payment type in the Actions list. You may choose: check or credit card.

Accept a Check Payment

  1. Click the Enter Check icon in the Actions list.
    Enter Check Payment.jpg
  2. Payment From - This will display the member the invoice was sent to. You may change this if necessary.
  3. Payment Date This will display today's date. You may change this if necessary.
  4. Check Number - Enter the check number as a reference.
  5. Amount - The full amount of the invoice will be displayed by default. You may change this if necessary.
  6. Click Done.

Accept a Credit Card Payment

  1. Click the Enter Credit Card icon in the Actions list.
  2. Payment From - This will display the member the invoice was sent to. You may change this if necessary.
  3. Stored Payment Methods If a credit card has been stored for this member, you will be able to select this payment from the list.
  4. Card Information - Select the appropriate Payment Gateway.
  5. Enter Card Information - Enter the required credit card information fields.
  6. Store Payment Info For Future - if the member wishes you to do so, you may click this check-box to store this credit card number for future use.
  7. Amount - enter the amount to process in this transaction. The amount due on the invoice will be displayed by default, but you may change this.
  8. Click Done to process the credit card payment.

Void an Invoice

You may void an unpaid invoice by selecting it on the Billing module Invoices tab.

NOTE: The Void button will only be displayed if the invoice date is outside of the Allow Deletion for (days) window established in your finance settings. If the invoice date is within the window, a Delete button will be displayed. For auditing purposes, best practice is to void invoices versus deleting invoices. Refer to Configure Finance Defaults for further details.
  1. Select Billing in the Navigation Panel.
  2. Click the Invoices tab. A list of all invoices is displayed, whether open or paid. To easily find the invoice to be voided, filter the results to Open Invoices.
  3. Click the hyper-link in the Inv # column for the invoice you wish to void.
    Invoice.jpg
  4. Click the Void button.
  5. Click OK to confirm.

Refund a Payment

The Payments tab will display a list of all payments you have received. From this tab, you will be able to refund a payment.

  1. Select Billing in the Navigation Panel.
  2. Click the Payments tab.
    Refund Payment.jpg
  3. Click the Refund Payments icon in the Actions column.
    NOTE: If the icon is not displayed, this indicates that a refund has already been created for the item.
    Create Refund.jpg
  4. Refund Date - The date will default to today's date. You may change it if necessary.
  5. Enter Notes. This is a required field.
  6. In the Refund Items section, the full amount of the fee items will be displayed.
  7. Click Done.

You can run the Refund Report (Reports > Refund Report) to view a list of all refunds that have been performed. Click Here for information on the Refund Report.

Partial Refunds

The Payments tab will display a list of all payments you have received. From this tab, you will be able to do a partial refund.

  1. Select Billing in the Navigation Panel.
  2. Click the Payments tab.
    Refund Payment.jpg
  3. Click the Refund Payments icon in the Actions column for the payment to which you wish to apply a partial payment.
    NOTE: If the icon is not displayed, this indicates that a refund has already been created for the item.
    Create Refund.jpg
  4. Refund Date - The date will default to today's date. You may change it if necessary.
  5. Enter Notes. This is a required field.
  6. In the Refund Items section, the full amount of the fee items will be displayed. To issue a partial refund, enter the amount you wish to refund.
  7. Click Done.

Show Me!

NOTE: If a portion of the payment has been previously refunded, it will show on the Create Refund screen under Already Refunded as shown below.
Already Refunded.jpg

You can run the Refund Report (Reports > Refund Report) to view a list of all refunds that have been performed. Click Here for information on the Refund Report.

Create a Write Off

When needed, you may create a write-off on the Billing module Invoices tab.

  1. Select Billing in the Navigation Panel.
  2. Click the Invoices tab. Customize the list to display only unpaid invoices to make it easier to locate the invoice you wish to write-off.
  3. Click the Create Write Off icon in the Actions column.
    Create writeoff.jpg
  4. Configure the following as necessary:
    • Write Off Date - The date will default to the current date.
    • Notes - This field is for internal use and is a required field.
    • Purchase Details - This field displays the invoice details, and may not be edited.
    • Write Off Items - This field displays the fee items on the invoice, and the associated account. The Write Off Amount will be populated with the original amount on the invoice.
  5. Click Done to complete the write-off.

Add a Credit Memo

You may add a Credit Memo on the Credit Memos tab.

  1. Select Billing in the Navigation Panel.
  2. Click the Credit Memos tab. A list of current credit memos is displayed.
  3. Click the New Credit button.
    Add Credit.jpg
  4. Configure the following:
    • Issued To Contact - Type the name of the contact to which you are issuing the credit. Type ahead functionality will display options that match your input.
    • Issue Date - The date will default to the current date. You may change this if needed.
    • Notes (Visible to Recipient) - Enter notes describing the credit. These will be visible to the recipient in the Info Hub.
    • Items
      • Saleable Item - Select the type of goods/service to which this credit will be applied. You may click the + button to dynamically add additional saleable items.
      • Description - Enter a description.
      • Amount - Enter the dollar value for the credit.
      • Quantity - Enter the quantity (this is applied to the credit ammount).
  5. Click Done.
NOTE: The Credit Memo Report may be used to track all of your credit memos. Click Here to learn more about the report.

Void a Credit Memo

  1. Select Billing in the Navigation Panel.
  2. Click the Credit Memos tab. A list of current credit memos is displayed.
  3. Click the hyper-link for the Credit Memo you wish to void.
    View Credit.jpg
  4. Click the Void button.

Deleting an Invoice

The ability to delete an invoice is driven by the Transaction Deletion "Allow Deletion for (days)" window.

NOTE: The Delete button will not be displayed on an invoice that has a zero balance. If you wish to delete an invoice that has a zero balance, you would first need to delete the payment (as long as it hasn't been deposited), then the Delete button would be displayed.

Generating Invoices for Upcoming (Recurring) Billing

The Upcoming Billing tab displays a list of all recurring billing (i.e. recurring membership dues).

Upcoming Billing.jpg

To generate invoices for your recurring fees:

  1. On the Upcoming Billing tab click Run Upcoming Billing.
    Run Upcoming Billing.jpg
  2. Select the month for which you want to generate invoices. This step will process any upcoming billings with a due date in the month that you select.
  3. Click Done.

Invoices for the month selected will be created, and will be available for processing on the Pending Delivery tab.

Deposits

View Previous Deposits

You may view previous deposits, and the payments associated to those deposits on the Billing module Deposits tab.

  1. Select Billing in the Navigation Panel.
  2. Click the Deposits tab. A list of your previous deposits will be displayed.
  3. Click the hyper-link in the Count of Payments column to view the payments associated with the deposit.
    Deposit Payments.jpg


NOTE: The Deposit Summary Report can be used to generate a list of all deposits. Click Here for information on generating the report.

Prepare Deposits

The Overview tab in the Billing Module will display the quantity of un-deposited funds. Prepare your deposits by clicking the link on the Overview tab, or on the Deposits tab.

  1. Select Billing in the Navigation Panel.
  2. Click the Deposits tab. A list of your previous deposits will be displayed.
  3. Click the Create Deposit button.
    Add Edit Deposit.jpg
  4. Deposit Date - The date will default to the current date, and may be changed if needed.
  5. Notes - You may add optional notes as needed.
  6. Payments - Select the payments you wish to include in this deposit. You may select all by clicking the uppermost check-box, or click individual payments.
  7. Click Close.
NOTE: If needed, you can print the deposit before saving. It may be useful to have a printout to take to the bank when you make the actual deposit.

Billing Reporting

Your software provides a wide range of reports that can be used to monitor your billing and update your general accounting software.

Accounting Summary

The Accounting Summary tab in the Billing module provides you with a summary of the credits and debits to your accounts. This summary may be filtered in the way that you need to update your general accounting software.

Accounting Summary.jpg

You can view the itemized transactions for each account by clicking the hyper-link for that account.

Account Transactions.jpg

Best Practice is to reconcile the summary debits and credits for each account, rather than reconciling each individual transaction to the general accounting software.

Accounts Receivable Aging Summary

The Accounts Receivable Aging Summary provides a list of all invoices in specific aging ranges (Current, 1 - 30 days, 31 - 60 days, 61 - 90 days, 91 - 120 day, and 121+ days). You can use this report to filter to invoices that are most overdue. Report filtering criteria include Good/Service Type, Product Category, Income Account, and your customized search criteria.

  1. On the Billing module overview tab, click Accounts Receivable in the Reports section.
  2. Select any desired filtering criteria: Report Date, Good/Service Type, Income Account, or additional Criteria / Filters.
  3. Select any desired fields to display on the report from the Display Options. This option will allow you to limit the results to a specific date range, for example 120 days +.
  4. Click Run Report.
Results.jpg

You can perform the following actions with the report by clicking the down arrow on the Run Report button:

  • Export as PDF
  • Export as Excel.
  • Export Summary as PDF
  • Export Summary as Excel
  • Email Report
  • Add to List - This option will allow you to add the members to an existing list, or create a new list (by clicking the + button on the Add Contacts to list screeen). This can help you in sending emails to this group with reminders.
Add Contracts to List.jpg
  • Save as New Report - If you want to use this report with the same filtering options in the future, you can save the report.
Save Report View.jpg
NOTE: To make this report available to all users, do not select the Hide This Report From Other Users check-box. If selected, the report will only be available to you.
  • Add as a Favorite Report - you may save the report as a favorite, then easily identify it when filtering reports in the Reports module.

Accounts Receivable Aging Detail

This report lists unpaid customer invoices and credit balances in detail for all or selected date ranges, account(s), goods and services and product category(s). You made add additional search criteria to further refine your results. This report may be useful in identifying receivables that my need to be written off.

  1. Click Reports in the Navigation Panel
  2. Select Accounts Receivable Aging Detail.
    Aging Detail.jpg
  3. Select your search filtering criteria.
  4. Optional - Enter a Search/Filter query. For example, if you want to filter the report results to just receivable that are more than 90 days old, you would select Aging as filtering criteria.
  5. Select Display Options. They system is setup with default fields to display in your report. You may add or remove fields by clicking on the Fields to Display drop-down arrow.
  6. Select Summarize by criteria. This optional field allows you to select how you wish report results grouped. For example, you may choose to group results by contact or account type.
  7. Click Run Report.
Aging Detail Results.jpg

You can perform the following actions with the report by clicking the down arrow on the Run Report button:

  • Export as PDF
  • Export as Excel.
  • Export Summary as PDF
  • Export Summary as Excel
  • Email Report
  • Add to List - This option will allow you to add the members to an existing list, or create a new list (by clicking the + button on the Add Contacts to list screen). This can help you in sending emails to this group as necessary.
Add Contracts to List.jpg
  • Save as New Report - If you want to use this report with the same filtering options in the future, you can save the report.
Save Report View.jpg
NOTE: To make this report available to all users, do not select the Hide This Report From Other Users check-box. If selected, the report will only be available to you.
  • Add as a Favorite Report - you may save the report as a favorite, then easily identify it when filtering reports in the Reports module.

Deposit Summary Report

The Deposit Summary Report allows you to generate a list of all deposit created in the software, based on selected date range, account, and customized filter criteria.

  1. Click Reports in the Navigation Panel
  2. Select Deposit Summary Report.
    Deposit Summary Report.jpg
  3. Select your search filtering criteria.
  4. Optional - Enter a Search/Filter query.
  5. Select Display Options. They system is setup with default fields to display in your report. You may add or remove fields by clicking on the Fields to Display drop-down arrow. By default, the report will include account name, deposit amount, deposit date, notes, and total payments.
  6. Select Summarize by criteria. This optional field allows you to select how you wish report results grouped. For example, you may choose to group results by account name.
  7. Click Run Report.
Depost Summary Results.jpg

You can perform the following actions with the report by clicking the down arrow on the Run Report button:

  • Export as PDF
  • Export as Excel.
  • Export Summary as PDF
  • Export Summary as Excel
  • Email Report
  • Add to List - This option will allow you to add the members to an existing list, or create a new list (by clicking the + button on the Add Contacts to list screen). This can help you in sending emails to this group as necessary.
Add Contracts to List.jpg
  • Save as New Report - If you want to use this report with the same filtering options in the future, you can save the report.
Save Report View.jpg
NOTE: To make this report available to all users, do not select the Hide This Report From Other Users check-box. If selected, the report will only be available to you.
  • Add as a Favorite Report - you may save the report as a favorite, then easily identify it when filtering reports in the Reports module.

Integrated Processing Monthly Statement

The Integrated Processing Monthly Statement provides a monthly view of all integrated processing, including sales, refunds, disputes, dispute reversals, and transfers.

  1. On the Billing module overview tab, click Integrated Processing Monthly Statement in the Reports section. The report is automatically generated and will default to the current month.
  2. To change the filtering criteria, select desired filtering criteria: Payment Gateway, Month, Year.
  3. Click Refresh Report.
IPP Monthly.jpg

Integrated Processing Monthly Transfers

The Integrated Processing Monthly Transfers report provides a list of all transfers from a selected gateway, month and year.

  1. On the Billing module overview tab, click Integrated Processing Monthly Transfers in the Reports section. The report is automatically generated and will default to the current month.
  2. To change the filtering criteria, select desired filtering criteria: Payment Gateway, Month, Year.
  3. Click Refresh Report.
Monthly Transfers 2.jpg

Integrated Processing Transactions

Integrated Processing Disputes

Stored Payment Profiles Report

The Stored Payment Profiles Report provides a list of your contacts and their stored payment profiles. Built-in filters allow you to generate the report based on Payment Gateway Type, Payment Gateway, Last Successful Payment Date, and Profile Created Date.

  1. Click Reports in the Navigation Panel
  2. Select Stored Payment Profiles Report.
  3. Select your search filtering criteria.
  4. Click Run Report.
Store Payment Gateway Report.jpg

You can perform the following actions with the report by clicking the down arrow on the Run Report button:

  • Export as PDF
  • Export as Excel.
  • Export Summary as PDF
  • Export Summary as Excel
  • Email Report
  • Add to List - This option will allow you to add the members to an existing list, or create a new list (by clicking the + button on the Add Contacts to list screeen). This can help you in sending emails to this group with reminders.
Add Contracts to List.jpg
  • Save as New Report - If you want to use this report with the same filtering options in the future, you can save the report.
Save Report View.jpg
NOTE: To make this report available to all users, do not select the Hide This Report From Other Users check-box. If selected, the report will only be available to you.
  • Add as a Favorite Report - you may save the report as a favorite, then easily identify it when filtering reports in the Reports module.

Refund Report

The Refund Report will generate a report of all refunds you have performed over a given date range. You can generate the report to display specific Saleable Items (Goods/Services), Saleable Item Type, and/or apply additional filter criteria. By default the report will display: Amount of Refund, Contact, Date of Refund, Goods/Service and Reference #.

  1. Click Reports in the Navigation Panel
  2. Select Refund Report.
  3. Select your search filtering criteria.
  4. Click Run Report.
Refund Report.jpg

You can perform the following actions with the report by clicking the down arrow on the Run Report button:

  • Export as PDF
  • Export as Excel.
  • Export Summary as PDF
  • Export Summary as Excel
  • Email Report
  • Add to List - This option will allow you to add the members to an existing list, or create a new list (by clicking the + button on the Add Contacts to list screen). This can help you in sending emails to this group as necessary.
Add Contracts to List.jpg
  • Save as New Report - If you want to use this report with the same filtering options in the future, you can save the report.
Save Report View.jpg
NOTE: To make this report available to all users, do not select the Hide This Report From Other Users check-box. If selected, the report will only be available to you.
  • Add as a Favorite Report - you may save the report as a favorite, then easily identify it when filtering reports in the Reports module.

Credit Memo Report

The Credit Memo Report will show all credits for a business or an individual. The report may be filtered on the date the credit was issued, the date the credit was used, based on a specific Saleable Item (good/service), open credits.

  1. Click Reports in the Navigation Panel
  2. Select Credit Memo Report.
  3. Select your search filtering criteria.
  4. Click Run Report.
Credit Memo Report.jpg


You can perform the following actions with the report by clicking the down arrow on the Run Report button:

  • Export as PDF
  • Export as Excel.
  • Export Summary as PDF
  • Export Summary as Excel
  • Email Report
  • Add to List - This option will allow you to add the members to an existing list, or create a new list (by clicking the + button on the Add Contacts to list screen). This can help you in sending emails to this group as necessary.
Add Contracts to List.jpg
  • Save as New Report - If you want to use this report with the same filtering options in the future, you can save the report.
Save Report View.jpg
NOTE: To make this report available to all users, do not select the Hide This Report From Other Users check-box. If selected, the report will only be available to you.
  • Add as a Favorite Report - you may save the report as a favorite, then easily identify it when filtering reports in the Reports module.

Collections Report

The Collections Report will allow you to search for over-due invoices based on invoice date, invoice due date, membership type, product category, goods/service type, sales person,

Write-Off Report

The Write Off Report allows you to generate a list of all write-off based on date range, saleable (good/service) item, or item type.

  1. Click Reports in the Navigation Panel
  2. Select Write Off Report.
  3. Select your search filtering criteria.
  4. Click Run Report.
Write Off Report.jpg


You can perform the following actions with the report by clicking the down arrow on the Run Report button:

  • Export as PDF
  • Export as Excel.
  • Export Summary as PDF
  • Export Summary as Excel
  • Email Report
  • Add to List - This option will allow you to add the members to an existing list, or create a new list (by clicking the + button on the Add Contacts to list screen). This can help you in sending emails to this group as necessary.
Add Contracts to List.jpg
  • Save as New Report - If you want to use this report with the same filtering options in the future, you can save the report.
Save Report View.jpg
NOTE: To make this report available to all users, do not select the Hide This Report From Other Users check-box. If selected, the report will only be available to you.
  • Add as a Favorite Report - you may save the report as a favorite, then easily identify it when filtering reports in the Reports module.

Accounting Transaction Report

The Accounting Transaction Report will generate a report of all of your transactions, and may be filtered to specific transaction types, accounts, date range, membership type, goods/services (saleable items), or product category. This report can be used to view all of the transactions in a particular account, or for a specific goods/service.

  1. Click Reports in the Navigation Panel
  2. Select Accounting Transaction Report.
    Acct transaction criteria.jpg
  3. Select your search filtering criteria.
  4. Optional - Enter a Search/Filter query. For example, if you want to filter the report results to just an individual member, you would select Contact as filtering criteria.
  5. Select Display Options. They system is setup with default fields to display in your report. You may add or remove fields by clicking on the Fields to Display drop-down arrow.
  6. Select Summarize by criteria. This optional field allows you to select how you wish report results grouped. For example, you may choose to group results by contact or even account type.
  7. Click Run Report.
Transactions results.jpg

The above report is generated on specific accounts (Dinner Income and Training Income), specific contact (Nelson's Accounting) and summarized by Account type.

You can perform the following actions with the report by clicking the down arrow on the Run Report button:

  • Export as PDF
  • Export as Excel.
  • Export Summary as PDF
  • Export Summary as Excel
  • Email Report
  • Add to List - This option will allow you to add the members to an existing list, or create a new list (by clicking the + button on the Add Contacts to list screen). This can help you in sending emails to this group as necessary.
Add Contracts to List.jpg
  • Save as New Report - If you want to use this report with the same filtering options in the future, you can save the report.
Save Report View.jpg
NOTE: To make this report available to all users, do not select the Hide This Report From Other Users check-box. If selected, the report will only be available to you.
  • Add as a Favorite Report - you may save the report as a favorite, then easily identify it when filtering reports in the Reports module.

Voluntary Payment Report

The Voluntary Payment Report allows you to easily track how much you've collected from voluntary fees. The report will show you the amount of voluntary fees that were paid vs. those left unpaid during a certain period of time.

  1. Click Reports in the Navigation Panel.
  2. Click Voluntary Payment Report.
  3. Select your search filtering criteria.
  4. Click Run Report.
Voluntary Payment Report.jpg

You can perform the following actions with the report by clicking the down arrow on the Run Report button:

  • Export as PDF
  • Export as Excel.
  • Export Summary as PDF
  • Export Summary as Excel
  • Email Report
  • Add to List - This option will allow you to add the members to an existing list, or create a new list (by clicking the + button on the Add Contacts to list screen). This can help you in sending emails to this group as necessary.
Add Contracts to List.jpg
  • Save as New Report - If you want to use this report with the same filtering options in the future, you can save the report.
Save Report View.jpg
NOTE: To make this report available to all users, do not select the Hide This Report From Other Users check-box. If selected, the report will only be available to you.
  • Add as a Favorite Report - you may save the report as a favorite, then easily identify it when filtering reports in the Reports module.


Last Bill Date Report

The Last Bill Date Report provides a means to look for accounts that have a suspect date of their last billing to allow further investigation. This report may be run by Membership Type, Membership Status, Date Range, Billing Frequency, Renewal Month and/or Good/Service Type. The report identifies the last date that the customer was billed and the last billed amount.

  1. Click Reports in the Navigation Panel
  2. Select Last Bill Date Report.
    Last Bill Criteria.jpg
  3. Select your search filtering criteria.
  4. Optional - Enter a Search/Filter query.
  5. Select Display Options. They system is setup with default fields to display in your report. By default, the report will include customer name, last bill date and last bill amount.You may remove fields by clicking on the Fields to Display drop-down arrow.
  6. Select Summarize by criteria. This optional field allows you to select how you wish report results grouped.
  7. Click Run Report.
Last Bill Results.jpg

You can perform the following actions with the report by clicking the down arrow on the Run Report button:

  • Export as PDF
  • Export as Excel.
  • Export Summary as PDF
  • Export Summary as Excel
  • Email Report
  • Add to List - This option will allow you to add the members to an existing list, or create a new list (by clicking the + button on the Add Contacts to list screen). This can help you in sending emails to this group as necessary.
Add Contracts to List.jpg
  • Save as New Report - If you want to use this report with the same filtering options in the future, you can save the report.
Save Report View.jpg
NOTE: To make this report available to all users, do not select the Hide This Report From Other Users check-box. If selected, the report will only be available to you.
  • Add as a Favorite Report - you may save the report as a favorite, then easily identify it when filtering reports in the Reports module. NOTE: This option will not be available if the report has already been saved as a favorite.

Open Invoices Report

The Open Invoices Report allows you to generate a list of all open invoices, based on a certain date in time, saleable item (goods/service), and customized filter criteria.

  1. Click Reports in the Navigation Panel
  2. Select Open Invoices Report.
    Open Invoices Report Criteria.jpg
  3. Select your search filtering criteria.
  4. Optional - Enter a Search/Filter query. For example, if you wish to view only open invoices where the balance is over a certain amount, select Invoice Balance.
    Inv Balance.jpg
  5. Select Display Options. They system is setup with default fields to display in your report. You may add and/or remove fields by clicking on the Fields to Display drop-down arrow.
  6. Select Summarize by criteria. This optional field allows you to select how you wish report results grouped, for example, you may wish to group by contact name.
  7. Click Run Report.
Open Results.jpg

You can perform the following actions with the report by clicking the down arrow on the Run Report button:

  • Export as PDF
  • Export as Excel.
  • Export Summary as PDF
  • Export Summary as Excel
  • Email Report
  • Add to List - This option will allow you to add the members to an existing list, or create a new list (by clicking the + button on the Add Contacts to list screen). This can help you in sending emails to this group as necessary.
Add Contracts to List.jpg
  • Save as New Report - If you want to use this report with the same filtering options in the future, you can save the report.
Save Report View.jpg
NOTE: To make this report available to all users, do not select the Hide This Report From Other Users check-box. If selected, the report will only be available to you.
  • Add as a Favorite Report - you may save the report as a favorite, then easily identify it when filtering reports in the Reports module. NOTE: This option will not be available if the report has already been saved as a favorite.

Recognized Income Report

The Recognized Income Report allows you to generate a report displaying income that has been recognized and income remaining to be recognized for a selected month.

  1. Click Reports in the Navigation Panel
  2. Select Recognized Income Report.
    Rec Income Filters.jpg
  3. Select your search filtering criteria.
  4. Optional - Enter a Search/Filter query. For example, if you wish to view only those with an annual cycle (cycle is the number of recognition months).
    Cycle rec.jpg
  5. Select Display Options. They system is setup with default fields to display in your report. You may add and/or remove fields by clicking on the Fields to Display drop-down arrow.
  6. Select Summarize by criteria. This optional field allows you to select how you wish report results grouped, for example, you may wish to group by contact name.
  7. Click Run Report.
Recog results.jpg

You can perform the following actions with the report by clicking the down arrow on the Run Report button:

  • Export as PDF
  • Export as Excel.
  • Export Summary as PDF
  • Export Summary as Excel
  • Email Report
  • Add to List - This option will allow you to add the members to an existing list, or create a new list (by clicking the + button on the Add Contacts to list screen). This can help you in sending emails to this group as necessary.
Add Contracts to List.jpg
  • Save as New Report - If you want to use this report with the same filtering options in the future, you can save the report.
Save Report View.jpg
NOTE: To make this report available to all users, do not select the Hide This Report From Other Users check-box. If selected, the report will only be available to you.
  • Add as a Favorite Report - you may save the report as a favorite, then easily identify it when filtering reports in the Reports module. NOTE: This option will not be available if the report has already been saved as a favorite.

Recurring Billing Report

The Recurring Billing Report allows you to generate a list of all contacts for which a recurring billing schedule has been set up in the database. This report may be useful in identifying upcoming membership renewals, or recurring donations. This report may also be used to view expected income for the upcoming renewals.

  1. Click Reports in the Navigation Panel
  2. Select Recurring Billing Report.
    Recurring Billing Criteria.jpg
  3. Select your search filtering criteria. For example, you may wish to view just a selected renewal month.
  4. Optional - Enter a Search/Filter query. For example, if you wish to view recurring billing based on a particular sales person, select Sales Rep.
    Sales Rep Criteria.jpg
  5. Select Display Options. They system is setup with default fields to display in your report. You may add and/or remove fields by clicking on the Fields to Display drop-down arrow.
  6. Select Summarize by criteria. This optional field allows you to select how you wish report results grouped, for example, you may wish to group by sales rep.
  7. Click Run Report.
Recurring Billing Results.jpg

You can perform the following actions with the report by clicking the down arrow on the Run Report button:

  • Export as PDF
  • Export as Excel.
  • Export Summary as PDF
  • Export Summary as Excel
  • Email Report
  • Add to List - This option will allow you to add the members to an existing list, or create a new list (by clicking the + button on the Add Contacts to list screen). This can help you in sending emails to this group as necessary.
Add Contracts to List.jpg
  • Save as New Report - If you want to use this report with the same filtering options in the future, you can save the report.
Save Report View.jpg
NOTE: To make this report available to all users, do not select the Hide This Report From Other Users check-box. If selected, the report will only be available to you.
  • Add as a Favorite Report - you may save the report as a favorite, then easily identify it when filtering reports in the Reports module. NOTE: This option will not be available if the report has already been saved as a favorite.

FAQ's

How do I change a members preferred invoice delivery method?

You may change a members preferred invoice delivery method on the members Billing tab. Click the membership link, under Billing Fees and Schedule and make the desired change.

Show Me!

How can I change the invoice template after an invoice has already been created?

  1. Click into the hyper-link for the invoice.
  2. Select the desired template from the Invoice Template drop-down.
  3. Click Save.

Show Me!