Skip to content

Reporting Overview

PayWithMyBank offers 2 reports for your consumption:

  1. Transaction Records File. This report echos any transactions that were created or updated during the reporting period.
  2. Settlement Funding File. This report provides an overview of transactions that make up any batch settlements or withdrawals to your settlement bank account.

Report Availability

Reports are available daily by 10am Eastern Time.

Report Delivery

Reports can either be delivered to a SFTP site hosted by Trustly, or downloaded from our Merchant Portal.

Settlement Funding File

The Settlement Funding File reports the funds transferred into (positive net settlement) or from (negative net settlement) the merchant bank account on the period since the last report. It correlates all transactions that are part of a net settlement and the bank funding activity.

Item records without funding trace id are to report status changes that affects future settlements and will be reported with amount as zero as they are not part of a settlement.

File Format

Each line in the Funding File is prefixed with a Record Type Indicator that dictates the type of information it is conveying.

Field Name Max Length Format Required Sample Data Notes
Record Type Indicator 1 H Yes H Always H
Magic 7 P11KFUN Yes P11KFUN Magic number
Version 11 Alphanumeric Yes 1.0.0 File version
Start Date 24 UTC Date Time in ISO 8601 format Yes 2017-01-21T12:00:00Z Report start date
End Date 24 UTC Date Time in ISO 8601 format Yes 2017-01-22T12:00:00Z Report end date
Merchant ID 50 Numeric Yes 10000000234 Merchant identifier
Sequence 10 NNNNofNNNN Yes 0001of0002 File sequence. A report can be broken into multiple files

Funding Record

Field Name Max Length Format Required Sample Data Notes
Record Type Indicator 1 F Yes F Always F
Processor 50 Alphanumeric Yes ProfitStars Payment processor
Reserved 0 No Reserved for future use
Funding Trace ID 50 Alphanumeric Yes A12341234 Funding trace identifier. Link between funding record and item record
Amount Currency 3 Alphanumeric Yes USD Amount currency
Amount 18 Decimal String Yes -100.00 Amount
Funding Date 24 UTC Date Time in ISO 8601 format Yes 2017-01-21T13:42:03Z Funding date and time

Item Record

Field Name Max Length Format Required Sample Data Notes
Record Type Indicator 1 I Yes I Always I
Transaction ID 50 Alphanumeric Yes 100000234235 Transaction identifier
Transaction Created At 24 UTC Date Time in ISO 8601 format Yes 2017-01-21T13:42:03Z Transaction create date and time
Parent Transaction ID 50 Alphanumeric Yes 100000234234 Parent Transaction identifier
Merchant ID 50 Numeric Yes 10000000234 Merchant identifier
Payment Type 20 Alphanumeric Yes Instant Payment type
Payment Provider Type 20 Numeric Yes 1 Payment provider type
Payment Provider ID 9 Alphanumeric Yes 023456737 Payment provider identifier
Payment Account 4 Numeric Yes 1234 Last 4 digits of the payment account
Merchant Reference 90 Alphanumeric No MREF122344 Merchant reference
Transaction Type 30 Alphanumeric Yes Refund Transaction type
Transaction Status 30 Alphanumeric Yes Authorized Transaction status
Transaction Updated At 24 UTC Date Time in ISO 8601 format Yes 2017-01-21T23:42:03Z Transaction last update date and time
Transaction Processed At 24 UTC Date Time in ISO 8601 format Yes 2017-01-21T23:42:03Z Transaction processed date and time
Amount Currency 3 Alphanumeric Yes USD Amount currency
Amount 18 Decimal String Yes -100.00 Amount
Funding Trace ID 50 Alphanumeric No A12341234 Funding trace identifier
Payment Provider Transaction Status 5 Alphanumeric No R03 Payment provide transaction status. For returned items it is the return reason code
Batch ID 50 Alphanumeric No 3424 Batch id representing a group of transactions
Settlement Type 3 Alphanumeric No 20 Internal
Parent Merchant Reference 90 Alphanumeric No MREF122 Merchant reference of the parent transaction
Payment Provider Transaction ID 40 Alphanumeric No ptx-5sq8ku8smVrss6Pc7-cOVBbI- Payment Provider Transaction ID. Sent as ID to the ACH processor.

Trail

Field Name Max Length Format Required Sample Data Notes
Record Type Indicator 1 L Yes L Always L
Num Item Records 9 Numeric Yes 300 Total count of the item records
Total Items Amount 18 Decimal String Yes 100.00 Total sum of the transaction records amount
Total Funding Records 9 Numeric Yes 300 Total count of the funding records
Total Funding Amount 18 Decimal String Yes 100.00 Total sum of the funding records amount