PAC - Parent Transactions Report
Parent Transactions Report Overview
This program enables you to generate a report for a single parent or group of parents containing:
- Opening balance (at a nominated date).
- A summary of charges, credits and receipts.
- A closing balance (at a nominated date).
Or
- Opening balance (at a nominated date).
- Detailed transactional records of charges, credits and receipts.
- A closing balance (at a nominated date).
It has an option that allows charges and/or credits for a nominated fee code(s) to be separated into an additional column, e.g. Separating tuition type charges from ancillary type charges.
Filtering is also available to enable the report to be run for:
- All parents.
- A particular parent type.
- Current or non-current parents.
- Parents with direct banking arrangements (with the ability to further filter by arrangement 'cycle').
- Parents with overdue arrangements (with the ability to further filter by 'frequency' and 'category').
This report/export has extensive options that can be activated via run-time settings. These settings can be saved as your own report 'Configuration' profiles. A report 'Configuration' that you create can't be accessed by another user and vice versa. This is because each 'Configuration' is dependent on the individual user's security permissions that determine the fields that can be included.
To use a previously saved report configuration, select it from the 'Use a Previously Saved Configuration' picklist and click 'Next'.
The 'Use a previously saved configuration' picklist will only be available if a saved configuration exists.
To create a new configuration, click the 'Next' button without selecting an option from the 'Use a Previously Saved Configuration' picklist.
Enter your runtime options for the program.
To save the runtime options that you have entered as a re-usable report configuration, enter a meaningful description into the 'Save this Configuration as' field on the 'Process' or 'Print' tab.
You can delete a report configuration by selecting it from the picklist, clicking the 'Next' button, and then clicking the 'Delete' option.
You can modify an existing configuration by selecting it, making the necessary changes to the run-time options, then clicking 'GO' on the 'Process' or 'Print' tab. You need to ensure the 'Save this Configuration as' field is populated with the report configuration name. This field is populated automatically when an existing configuration is selected.
General Tab
Search Criteria
Selection criteria can be entered in this section of the screen to filter the records that will be displayed on your report.
'Start Date' will become 'Open Balance' and 'End Date' will become 'Close Balance' on the report.
Additional Filtering
If you elect to run the report to only include parents who have a direct banking arrangement, you can filter the data further by nominating a 'Cycle'.
If you elect to run the report to only include parents who have an overdue arrangement, you can filter the data further by nominating an arrangement 'Frequency' and/or an arrangement 'Category.
Print Tab
Layout Options
Use this section of the screen to nominate if the report is to be produced in a summary or detailed format.
Sort By
Sort the order in which records are displayed by nominating your preference for 'Surname' or 'Parent Code'.
Separate Column Options
You can use these options to create a separate column on your report for charges and credits for a single or range of fee codes, e.g. Separating tuition type charges from ancillary type charges.
A drop-down list becomes available when you tick either the 'Charges column' or 'Credits column' box.
If you select a single fee code, the additional column that prints on the report will have the description of the fee code as a heading.
If you select multiple fee codes the description of the additional column will be 'Other'.
Formatting Options
Choose the 'destination' of the report. This can be to Adobe® PDF viewer, Microsoft Excel®, Microsoft Word® or a screen with hyperlinks.
The 'Screen with Hyperlinks' format is best if you need to 'drill-down' to further information.
You can also elect to exclude parents with no transactions or parents who have a zero closing balance.
Additional Fields
Select 'Additional Fields' to include in the listing by highlighting them with a mouse click.
Additional fields can be included in your report from the following areas:
- Parent Info.
- Direct Banking Fields.
- Overdue Arrangement Fields.
Holding down the 'Shift' key while clicking on your options permits a range selection, holding down the 'Ctrl' key enables selection of discrete (individual) criterion.
Report Title
This field can be used to enter an alternative name for your report.
Click 'GO' to generate your report.
Save this Configuration as
If this field is populated with a value and you click 'GO', the current report/export settings will be saved using the configuration name entered in this field.