Offsetting Transactions

Offsetting transactions are transactions that credit your organization’s account for the money debited from the donor’s accounts. If, when you specify EFT file information on the Edit EFT file information screen in Treasury, you select Create offsetting transactions, this text string is generated as an entry detail record for the transaction. In each table, the Field Name column represents the name of the section that holds specific characters of the text string. The Position column lists the position of the section within the text string. The Contents column provides information about the characters entered in specific parts of the text string. For example, for an offsetting transaction, Record Type Code is at the beginning of the text string and is always the number “6.” The program always recognizes the number “6” in position “1” as the Record Type Code of an entry detail record.

Note: When you select Create offset transactions, the transmission file includes any offsetting transaction records. As some banks generate offsetting transactions themselves, you should check with your organization’s bank to find out whether to select this checkbox when you create EFT file information in Treasury.

Field Name

Position

Contents

Record Type Code

1

6 (The program automatically enters the number “6” into this field. The number “6” in the position “1” always designates the Record Type Code.)

Transaction Code

2-3

22, which designates an Automated Deposit.

Receiving Depository Financial Institution (DFI) ID

4-11

The transit/routing number of your organization’s bank. Your bank provides this information.

Check digit

12

When you first enter the bank’s routing number, the program automatically multiplies each digit of the bank’s routing number by the weighing factor, adds the products of the eight multiplications, subtracts the sum from the next highest multiple 10, and enters the result in this field.

DFI Account Number

13-29

Your organization’s account number. Your bank provides this information.

Amount

30-39

The total amount of all 6/27 (for a checking account) and/or 6/37 (for a savings account) lines in the transmission file.

Individual Identification Number

40-54

Company ID, as entered in the direct debit header file.

Individual Name

55-76

Organization name

Discretionary Data

77-78

Blank

Addenda Record Indicator

79

0 (The program automatically enters the number “0” into this field. The number “0” in the position “79” always designates the Addenda Record Indicator.)

Trace Number

80-94

The routing number of your organization’s bank, followed by the sequence number, continued from the other Type “6” records.