Monthly Analysis
Last updated: March 25, 2026
Delivery and Frequency: Delivered on first day of the following month.
Description: Includes all transactions from 00:00:01 first day of the month through 24:00:00 last day of month, regardless of FI cutoff times, but uses FI time zone
Format: <create date/time stamp yyyymmddhhmmss>_MONTHLY_ANALYSIS_for<start period yyyy-mm-dd>_<end period yyyy-mm-dd>.csv
Format Example: 20220131165042_MONTHLY_ANALYSIS_for_2022-01-01_2022-01-31.csv
This report is similar to the EOD Settlement, but simply all of the transactions that occurred during the month.
Sample Data is Attached Below
Data Dictionary
Column Name | Sample Data | Description |
companyName | Excelsior LLC |
|
chargeAccountNumber |
| If defined, the charge account that is designated for the online banking profile |
companyTaxId | 8675309 | If defined, the tax ID defined for the online banking profile |
originatorAccountNumber | USD0000B17F | Uses the online banking account number or a PayRecs designated ID for MCA (eg USD00001234, EUR00001234) |
originatorAccountName | USD Multi-Currency Account | Account name from online banking or the PayRecs designated name for MCA |
settlementAmount | 10 | The amount from the source |
settlementCurrency | USD | The currency from the source |
tradeAmount | 10 | The amount to the destination |
tradeCurrency | USD | The currency of the destination |
feeAmount | 0 | What fee was configured for this type of payment? |
feesCharged | 0 | What fee was actually charged (hard charge) |
feeCurrency | USD | Currency of the fee |
feeType | OUTBOUND_SAME_HOME_DOM | Fee type, as defined on companyFee for a specific payment scenario |
fiRevenue | 10 | How much revenue will the FI/Online Banking partner be expecting for this transaction |
contractRevenue | 1 | How much revenue generated for the processor (base contract rate) |
costAmount | 22 | What is the cost amount owed to PayRecs for this transaction? |
costCurrency | USD | The currency of the costAmount |
platformTransferredAmount | 123.12 | The amount that was transferred from the originating account to the settlement account (USD settlement transactions only) |
afexTradeId |
| Internal identifier |
tradeNumber | 10624995 | Internal identifier |
ingestCancelled | 0 | Was the settlement of this payment cancelled (Rare) |
paymentId | 276 | Internal, unique identifier for this payment. You can treat this as primary key |
companyId | 20807DF0AEB811AC13D60242AC110002 | Internal identifier |
srcId | 72120EA0B50611AC2FBB0242AC110002 | Internal identifier |
srcType | VOSTRO | Internal identifier |
dateCreated | 6/1/2022 21:08 |
|