Bank Extract Format Maintenance

Menu Path: System Administration Images\bluerarw.gif Tools Images\bluerarw.gif Bank Extract Format Maintenance

Purpose

Set up and maintain bank extract formats.

Overview

Use Bank Extract Format Maintenance to create, edit, and delete bank extract formats, which are used to export direct deposit and direct debit information to banks. The formats you define should match the requirements provided by your bank. You can assign bank extract formats to banks in Bank Code Maintenance.

Creating Bank Extract Formats

To create a bank extract format:

  1. If your company uses consolidation ledgers, verify the ledger ID for which you want to create a bank extract format is entered in the Ledger ID field.

  2. Click the New button in the ribbon.

  3. If the bank extract format is for direct debits, select the Direct Debit radio button. Otherwise, leave the Direct Deposit radio button selected.

  4. Selected whether data will be exported with a delimiter separating each field (Delimited) or with fixed-width columns (Positional). For delimited bank extract formats, specify the delimiter character, and optionally an enclosing character.

  5. Select date and time formats for exported data.

  6. Select the file format for exported data.

  7. Select fields for the detail record of the bank extract format. You can select database fields from the Available Fields grid, or select the Static Value check box, and manually enter fields that are constant values (or blank spaces). Use the right-arrow button to select either type of field.

  8. If the bank extract format will have header and/or summary records (in addition to detail records), select the appropriate record type, and select fields for the record as you did for the detail record in step 7.

  9. Click the OK ribbon button. The bank extract format is created.

Ribbon Home Tab Buttons

Button

Description

Exit

Click this button to close the Bank Extract Format Maintenance window.

New

Click this button to create a new bank extract format.

Update

Click this button to update the selected bank extract format.

Delete

Click this button to delete the selected bank extract format.

OK

Click this button to accept an action. This button is only available after you click the New, Update, or Delete button in the ribbon.

Cancel

Click this button to cancel an action. This button is only available after you click the New, Update, or Delete button in the ribbon.

First

Click this button to display the first bank extract format.

Prev

Click this button to display the previous bank extract format.

Next

Click this button to display the next bank extract format.

Last

Click this button to display the last bank extract format.

Fields and Buttons

Field or Button

Description

Bank Extract Format

Enter a name for the bank extract format, or click the Lookup button to select a previously created bank extract format.

Extract Type

Select whether the bank extract format is used to transmit direct deposit or direct debit information. The Direct Deposit radio button is selected by default.

Ledger ID

Enter a ledger ID for the bank extract format, or click the Lookup button to select a ledger ID.

Note This field is only available if at least one consolidation ledger is set up.

Main Tab Fields and Buttons

Field or Button

Description

Format

Select whether data in the bank extract format is separated by a delimiter character or is in fixed-width columns. If you select Delimited, you must enter a delimiter character. If you select Positional, you must specify the length of each column. The Delimited radio button is selected by default.

Date Format

Click the Lookup button to select the date format for the bank extract format.

Save As Type

Click the Lookup button to select the file format for the bank extract format. You can select one of the following file formats:

  • CSV

  • DAT

  • TXT

  • Excel

Time Format

Click the Lookup button to select the time format for the bank extract format.

Delimiter

Enter a delimiter character used to separate data for the bank extract format. This field is only available if the Delimited radio button is selected, and a file format other than Excel is selected for the Save As Type field.

EXAMPLE If the bank requires commas between exported fields, enter a comma in this field.

Enclosing Character

If you want to use single or double quotation marks around data exported for the bank extract format, enter ' or " in this field. This field is only available if the Delimited radio button is selected, and a file format other than Excel is selected for the Save As Type field.

Field Value

Select this check box to add database fields to the selected record type of the bank extract format, then use the Available Fields grid to specify the fields.

Static Value

Select this check box if you want to add a constant value to the selected record type of the bank extract format, then enter the value in the field to the right of the check box, and click the right-arrow button.

NOTE You cannot include spaces at the end of static values. Do not include delimiter characters in static values.

Record Type

Click the Lookup button to select a record type (header, detail, or summary) for the bank extract format for which you want to specify or view fields. A bank extract format must have a detail record, but header and summary records are optional. This defaults to Detail.

Available Fields

This grid displays field that you can add to the selected record type of the bank extract format. This grid is only enabled if the Field Value check box is selected. To add a field to the selected record type, double-click it, or select it, and click the right-arrow button.

Click this button to add the selected field in the Available Fields grid or the entered field in the Static Value field to the Selected Fields grid (for the selected record type).

Click this button to remove the selected field in the Selected Fields grid.

Selected Fields

This grid displays fields selected for the selected record type of the bank extract format.

You can add information in the Description column to provide detailed information about the field.

If the bank extract format is positional, you can also modify the Position and Max Length columns to specify the position and length of each field. For the Position column, enter 1 for the first field, 2 for the second field, etc.

Click this button to move the selected field in the Selected Fields grid up one position in the bank extract format for the selected record type. This button is only enabled if the Delimited radio button is selected.

Click this button to move the selected field in the Selected Fields grid down one position in the bank extract format for the selected record type. This button is only enabled if the Delimited radio button is selected.