Financial export report

This page is used to run the export process for financial records.

Go to section

Custom Lists

General

Options

Location

Reports > Financial Reports > Financial Export

 

The following filters and options are available on the Financial Export page, with the option to Submit at the bottom of the page:

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.

Revenue Site  

Hyperlink

Option to filter for one or more sites by clicking the Revenue Site button and moving selected sites to the Filter box.

 

To remove a site from the list, select the site, then click the Remove button.

Transaction Site

Hyperlink

Option to filter for one or more sites by clicking the Transaction Site button and moving selected sites to the Filter box.

 

To remove a site from the list, select the site, then click the Remove button.

Workstations

Hyperlink

Filter for one or more workstations.

Workstation Groups

Hyperlink

Filter for one or more workstation groups.

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.

Auto Payment Customers

Hyperlink

Filter the export by specific customers and only show records that are paid by automatic payment plan.

Payers

Hyperlink

Filter the export to only show records that are paid by specific payers.

Unpaid Payment Plan Amounts Due Date

Date range

Export only records with unpaid payment plan amounts that are due within a specific date range.

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 that you want to use for the summary export, from a predefined list of financial export templates.

  2. In the Summarize by dropdown list, select:

    • GL Account OR

    • 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

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.

 

Click Submit to run the financial export.

 

After the export is completed, the Financial Export Summary Report page will be displayed with a summary list of the records exported.

 

Click the View/save the report data link to view or save the report data. If the results are satisfactory, click the mark the records as exported link to mark the records and go back to the Financial Export page.