Reconciliation Report Forms

Below you will find the reconciliation report formats available for Puerto Rico in the Placetopay platform.

Available for:

Puerto Rico

This documentation describes in detail the structure of the different reconciliation files, such as Lockbox, LogFile and PDF, providing the exact definition of each field and section. These reports facilitate the tracking, reconciliation and analysis of successful transactions, ACH returns, and the daily summary of the different payment methods used by affiliated merchants.

Lockbox

• Successful Transactions and ACH Returns

Header

Field No.	Data Field Name	Type	Length	Definition
1	Record ID	Numerical	1	Value "1"
2	Settlement Cut-off Date	Numerical	8	YYYYMMDD
3	Tax ID	Alphanumerical	20	Tax ID #
4	Merchant Name	Alphanumerical	20	Merchant Name
5	Filler	Alphanumerical	31	Spaces

Batch Total

Field No.	Data Field Name	Type	Length	Definition
1	Record ID	Numérico	1	Value 5
2	Batch Description	Numérico	15	"Placetopay"
3	Settlement Cut-off Date	Numérico	8	YYYYMMDD
4	Batch Total Items	Alfanumérico	7
5	Batch Total Amount	Alfanumérico	12	9(10)V99
6	Filler	Alfanumérico	37	Spaces

Detail

Field No.	Data Field Name	Type	Length	Definition
1	Record ID	Numerical	1	Value "6"
2	Filler	Alphanumerical	5	Spaces
3	Authorization #	Alphanumerical	6
4	Type of Payment	Alphanumerical	1	A=ATH, V=Visa, M=MasterCard, X=AMEX, W=Personal checking, S=Personal Saving, C=Business Checking, T=TEL Checking, U=TEL Saving, Z=ATHM, D=Discover, Y=EBT
5	CustomerAccountNumber	Alphanumerical	20	Placetopay Additional Data. Fill with Zeros '0' to the left
6	Payment Amount	Numerical	10	9(8)v99
7	Remitter Name	Alphanumerical	37

Batch Total ACH Returns

Field No.	Data Field Name	Type	Length	Definition
1	Record ID	Numérico	1	Value 7
2	Batch Description	Alfanumérico	15	"ACH Returns"
3	Settlement Cut-off Date	Numérico	8	YYYYMMDD
4	Batch Total Items	Numérico	7
5	Batch Total Amount	Numérico	12	9(10)V99
6	Filler	Alfanumérico	37	Spaces

Detail ACH Returns

Field No.	Data Field Name	Type	Length	Definition
1	Record ID	Numerical	1	Value "8"
2	CustomerAccountNumber	Alphanumerical	20	Placetopay Additional Data. Fill with Zeros '0' to the left
3	Original Transaction Process Date	Numerical	8	YYYYMMDD
4	ACH Return NACHA Reason Code	Alphanumerical	3
5	ACH Return NACHA Reason Code Description	Alphanumerical	15	9(10)V99
6	Payment Amount	Numerical	10	The last two positions are decimals (without a decimal point)
7	Original ACH Transaction Authorization #	Numerical	6	Spaces
8	ACH Return Process Devolution Date	Numerical	8	YYYYMMDD
9	Type of Payment	Alphanumerical	1	W=Personal checking, S=Personal Saving, C=Business Checking
10	Filler	Alphanumerical	8	Spaces

Trailer

Field No.	Data Field Name	Type	Length	Definition
1	Record ID	Numérico	1	Value 9
2	Filler	Alfanumérico	6	Spaces
3	Total Items	Numérico	7
4	Total Amount	Numérico	12	9(10)V99
5	Filler	Alfanumérico	8	Spaces

LogFile

• Successful and Unsuccessful Transactions

Field No.	Data Field Name	Type	Length	Definition
1	MerchantId	Numerical	4
2	CustomerAccountNumber	Alphanumerical	20	Placetopay Additional Data. Fill with Zeros '0' to the left
3	CustomerName	Alphanumerical	40
4	Customer Email	Alphanumerical	40
5	Payment Amount	Numerical	10	The last two positions are decimals (without a decimal point)
6	Payment Type	Alphanumerical	1	A=ATH, V=Visa, M=MasterCard, X=AMEX, W=Personal checking, S=Personal Saving, C=Business Checking, T=TEL Checking - telephone payment with checking account, U=TEL Saving - telephone payment with savings account, Z=ATHM, D=Discover, Y=EBT
7	Description	Alphanumerical	50
8	Tip	Numerical	5	The last two positions are decimals (without a decimal point)
9	Date	Alphanumerical	10	MM/DD/YYYY
10	Time	Alphanumerical	8	HH:MM:SS
11	Authorization Number	Alphanumerical	6
12	Receipt	Alphanumerical	15	Fill with Zeros ‘0’ to the left
13	Reserved	Alphanumerical	5	Reserved for future use
14	Success?	Alphanumerical	1	1 = True; 0 = False
15	Tax1	Numerical	5	State Tax
16	Tax2	Numerical	5	Municipal Tax
17	Tax3	Numerical	5	Reduced Tax
18	MerchantUniqueId	Alphanumerical	5	The last two positions are decimals (without a decimal point)
19	Filler1	Alphanumerical	50	Placetopay Additional Data
20	Filler2	Alphanumerical	50	Placetopay Additional Data
21	Filler3	Alphanumerical	50	Placetopay Additional Data

PDF

• Successful transactions, failed transactions, and ACH returns.

Daily Summary Report

Report Date
Report Time
Batch Number
Merchant Name
Total (Each Payment Methods*) Payments
Total (Each Payment Methods*) Amount
Total ACH Payments
Total ACH Payment Amount
Total ACH Return Payments
Total ACH Return Payment Amount
Total Cash
Total Cash Amount
Total Cards Payments
Total Cards Amount
Note: Payment Methods: AMEX, VISA, MASTERCARD, DISCOVER, ATH, ATH MOVIL, ACH, EBT (Include All Available Payment Methods)

Successful Payments

Transaction Count #
Date
Time
CustomerAccountNumber
Authorization #
Last 4 Digits
Payment Type
Payment Description
Response
Amount ($)
Batch Number

Unsuccessful Payments

Transaction Count #
Date
Time
CustomerAccountNumber
Authorization #
Last 4 Digits
Payment Type
Payment Description
Response
Amount ($)
Batch Number

ACH Returns

Transaction Count #
Date
Time
CustomerAccountNumber
Reason Code (NACHA code)
Reason Code (NACHA code) Description
Payment Description
Authorization #
Last 4 Digits
Payment Type
Amount ($)
Batch Number

In the case of the PDF format, both rejected and approved transactions would also be included.