12.3 Store Summary Reconciliation File

File Format

The file name format is according to transaction date, store_summary_YYYYMMDD.txt. The file consists of 2 parts,

First two rows are file header and subsequence rows are record details.

File Header

FieldTypeDescriptionSequence
MerchantIdNumber(9)Merchant's unique identifier1
MerchantNameString(100)Merchant name2
BusinessDateString(10)Format YYYY-MM-DD3
TotalCountNumber(9)Total number of records in this file.4

Record Detail

FieldTypeDescriptionSequence
ChannelIdNumber(9)Payment Channel1
BusinessDateString(10)Format YYYY-MM-DD2
CurrencyCodeString(3)Currency Code3
AmountDecimal(9,2)Transacted amount4
StoreIdString(20)Store Id5

Sample transaction reconciliation file: