Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

ATM TLOG Cutoff Report (FPSDR146)

Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

ATM TLOG Cutoff Report (FPSDR146)

Previous pageReturn to chapter overviewNext page  Print this Topic

Availability

This report should run daily in the afterhours for all institutions that have an ATM processor.

 

Purpose

The purpose of this report is to show all ATM and Debit Card activity for a single day’s cutoff period based on your institution’s cutoff times (e.g. 4:00 p.m. to 4:00 p.m.). It displays both successful and rejected transactions, inquiries, and fees, with any applicable reason for the transaction being denied.

 

Report Column Information

See FPSDR146 Example for an example of this report.

 

Column Heading

Description

ISO#

This is the ISO/ANSI number of the card used for the transaction. It is also sometimes referred to as the Bank ID Number (BIN). This is always the first six digits of the full card number.

Card Number

This is the last 10 to 13 digits of the card number.

Account Number

This is the deposit account number to which the transaction was posted or attempted. It is formatted in the maximum GOLDPoint Systems account format length.

Typ

This is the transaction type mnemonic. The first two characters generally indicate the type of transaction. The last character generally indicates the type of deposit account used in the transaction.

If the second digit is an "X," then the transaction is a transfer. The first digit would then indicate the account the funds are coming from, and the third digit indicates the account the funds are going to. For example, SXK would be a transfer from savings to checking.

 

First Two Digits

Transaction

Description

BI

Balance

Inquiry

BN

Bank

Notification

DM

Deposit

Memo

DP

Deposit

FA

Funds

Available

MP

Mail/Phone

P3

3rd-party

Payment

PA

Purchase

Authorization

PD

Purchase

Deferred

PE

Payment

Enclosed

PU

Purchase

Update

QA

Quasi-cash

Authorization

QP

Script

Purchase

RA

Purchase

Return Authorization

RP

Purchase

Return

SP

Statement

Print

TA

Travelers

Check Authorization

TC

Travelers

Check Purchase

WA

Cash

Withdrawal Authorization

WD

Withdrawal

 

Third Digit

Account

Type

K

Checking

S

Savings

F

Funding

Account

A

Additional

Checking

B

Additional

Savings

G

Generic

 

Fourth Digit

Transaction

Description

R

Reversal or Correction

Exceptions to this coding scheme are:

CDM

Commercial

Deposit Memo

CDP

Commercial

Deposit

CKG

Check Guarantee

CKV

Check

Verification

Debit

This is the debit amount if the transaction was a debit or a debit purchase authorization. A single asterisk (*) following the amount indicates the transaction was rejected. A double asterisk following the amount indicates the transaction was an authorization or inquiry transaction. An "F" following the debit or credit amount means force post.

Credit

This is the credit amount if the transaction was a credit or a credit purchase authorization. A single asterisk following the amount indicates the transaction was rejected. A double asterisk following the amount indicates the transaction was an authorization or inquiry transaction. An "F" following the debit or credit amount means force post.

Fees

This is the fee assessed at the time of the transaction. If blank, no fee was assessed.

Trm Date/Time

This is the local terminal date and time. This information is passed from the ATM or point-of-sale device that originated the transaction.

FPS Date/Time

This is the date and time that the transaction was presented to GOLDPoint Systems.

ISS ID

This is the three character code identifying the ATM network through which the transaction was originated. Generally if this field is blank, the transaction was done at an ATM owned by the institution.

Terminal Number

This is the eight-character ATM or point-of-sale device number. This information is passed from the ATM or point-of-sale device where the transaction originated.

The terminal numbers for your institution's ATMs are set up on the Deposits > Definitions > ATM ID Numbers screen.

Sequence

This is the 12-digit transaction sequence number. It is used by ATM networks and switches to trace a specific transaction. This information is passed from the ATM or point-of-sale device that originated the transaction.

RJ

This is the reject code. This is a two-letter code that is useful for GOLDPoint Systems to track in which program or system a specific error occurred.

Descript

This is the reject description. This is an abbreviated description of the type of error that caused the transaction to be rejected. For example, "NSF" stands for non-sufficient funds.

ATM Address

This column contains up to two lines of either vendor/merchant name information, ATM location address information, city, state abbreviation, and/or ZIP code. This information is passed from the ATM or point-of-sale device that originated the transaction.

Running Balance

This column shows the difference between the ATM processor amounts and the Account History amounts.

Total Processed Difference

This is the total number of transactions run, the total debits, credits, and total amount of all transactions run over the cutoff date.

Accounts OK Difference

These are the total number of accounts that were not different.

Accounts in Err Difference

These are the total number of accounts that were different, and affected the difference amount.

 

Totals and Subtotals Provided

Totals are provided by the number of transaction for an institution for the following:

 

Total dollar amount of debits

Total dollar amount of credits

Total dollar amount of fees

Total number of credits

Total number of debits

Total number of rejected credits

Total number of rejected debits

Total number of inquiries

 

Sort Options Available

Any number of reports may run at the same time with varying sort options. The following are the possible sort options available:

 

80 GOLDPoint Systems date and time (default)

81 Card number

82 Account number

83 CIF household number

84 Reject code

85 Transaction type

86 Terminal number

©2021 GOLDPoint Systems. All rights reserved.