Cash receipts export report

Use this report to match payments on account not paid by credit card to GL accounts.

Go to section

Custom Lists

General

Options

 

Name of Field

Type

Description

Custom Lists

Custom List

Dropdown list

Title of email recipient list, as selected from a predefined list.

 

Click the Preview/Edit List link to view or edit the custom lists of email recipients.

Show additional filter options

Checkbox

Option to select additional filters to the custom list to fine tune the email recipient list. See Report Filters.

 

Selecting the checkbox will display the various sections of filter criteria (Population, Registration, Facility, Membership, Daycare, Leagues, POS).

 

Click the More>>> link of a particular section to expand it, allowing you to add filter criteria.

 

Click the <<<Less link  to collapse the section.

 

Note: Adding filter criteria will limit the email recipient list to customers who meet all the selected criteria. For example, if an activity is added as a filter, only customers in the custom list who are registered in the activity will be included in the email recipient list.

General

G/L Accounts

Hyperlink

Option to filter the export to only include records attached to particular G/L accounts.

 

Click the link to open the G/L Account List page, where G/L accounts can be selected.

 

If no G/L accounts are selected, the export will include all G/L accounts.

 

To remove a G/L account from the list, select the G/L account, then click the Remove button.

Financial Departments

Hyperlink

Filter by only certain financial departments.

Revenue Site

Hyperlink

Filter by site(s) where the payments are counted for revenue.

Transaction Site

Hyperlink

Filter by site(s) where the transactions were actually processed.

System Users

Hyperlink

Option to filter the export to only include records processed by particular system users.

 

Click the link to open the System User List page, where a system user can be selected.

 

If no system users are selected, the export will include all system users.

 

To remove a system user from the list, select the system user, and then click the Remove button.

Payers

Hyperlink

Filter the export to only include records that are paid for by specific customers.

Transaction Date/Time
(From, To)

Date/Time

Range of dates and times of financial records to include in the export.  

 

Date entered in month, day, year format or by clicking the calendar icon and selecting a date from the pop-up calendar.

 

Time is entered in HH:MM AM/PM format.

Payment Types

Checkboxes

Option to only include records with particular payment types.

 

Select all checkboxes of payment types to include in the export.

Options

Note: You can produce either a Summary or Detailed report.

Summary Export Template

Dropdown list

  1. Select the export template to use for the summary export, from a predefined list of financial export templates.

  2. In the Summarize by dropdown list, select:

    • GL Account

    • Date and GL Account

    • Revenue Site and GL Account

    • Date, Revenue Site and GL Account

    • Transaction Site and GL Account

    • Date, Transaction Site and GL Account

Detail Export Template

Dropdown list

  1. Select the export template to use for the detailed export, from a predefined list of financial export templates.

  2. In the Sort by dropdown list, select one of the following:

    • GL Account

    • Receipt Number

    • Receipt Date

Payment Type

Checkboxes

Select one or more of the following payment types to include:
  • Cash

  • Check

  • Credit Card

  • Memo

  • Gift Card

  • ECP Payment

  • Journal Entry

  • Manual Deduction

  • Refund by Cash

  • Refund by Check

  • Refund to Credit Card

  • Refund to Account

  • Refund by Gift Card

Include Online Transactions?

Checkbox

Option to include data from transactions that were created on the customer (public access) site.

Note: This option is only visible to system users who do not have a multi-site user profile.

Output Type

Dropdown list

The output type or format of the export, as selected from either Comma Delimited, Tab Delimited, Fixed Length, or XML.

Include unexported data only?

Checkbox

Option to only include records that have not been previously exported.