Payment History

This dataset provides a detailed log of payment transactions, including payer and payee identifiers, transaction amounts, payment methods, fees, and reconciliation status. It is ideal for financial auditing, transaction monitoring, and reconciliation processes, supporting robust analysis and compliance reporting.

  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Financial auditing and compliance reporting

Sample rows

preview · 8 of 200 rows · all 13 columns
transaction_idstringpayment_methodstringamountfloatfee_currencystringpayer_idstringpayee_idstringcurrencystringpayment_datedatetimetransaction_feefloatreconciliation_statusstringreconciliation_datedatetimereference_numberstringdescriptionstring
TXN-000001credit_card34.75USDPAYER001PAYEE012USD2022-10-13T14:22:311.2reconciled2022-10-15T10:12:44CC-5830291Monthly subscription payment for digital service
TXN-000002cash0.01blankPAYER002PAYEE027HKD2023-01-01T09:02:110failedblankblankTest kiosk payment on New Year
TXN-000003bank_transfer15000EURPAYER003PAYEE011EUR2020-03-19T17:44:2222.5pendingblankSEPA-2901834Vendor settlement for March invoice
TXN-000004paypal235.99USDPAYER004PAYEE009USD2021-11-08T13:41:513.2reconciled2021-11-09T15:26:31PP-4735211Refund for returned merchandise
TXN-000005mobile_payment4.99JPYPAYER005PAYEE005JPY2022-02-03T07:52:090.07pendingblankMP-1283104Cab fare via mobile payment app
TXN-000006bank_transfer1000000USDPAYER006PAYEE002USD2023-05-28T16:18:471200pendingblankMEGA-1029302Cross-border mega transfer for business acquisition
TXN-000007debit_card55.5GBPPAYER007PAYEE017GBP2020-12-23T19:11:022.1disputedblankDC-2010380Retail clothing purchase disputed by payer
TXN-000008credit_card700CADPAYER008PAYEE021CAD2021-03-05T15:36:128.25reconciled2021-03-07T12:41:09CC-9382014Annual software license renewal

What the 200 rows show

from the 200-row sample

Bank_transfer (payment method) stands out: mean amount is 1,267,768, against 205.9 for the rest.

  • 48.5median amount
  • 4reconciliation statuses
  • 10currencies
  • 1.3median transaction_fee
Mean amount by payment_method200 rows
01M2M193.3cre…29 r…201.7deb…19 r…1.3Mban…38 r…100.7pay…19 r…0.65cash34 r…1,810che…12 r…7.2mob…29 r…2.4oth…20 r…
amount200 rows, in bands of 2M
01002001951101206M12Mamount →

Median 48.5, from 0.0 to 12,000,000.

fee_currency148 rows with a value · 52 left blank
  1. USD76
  2. GBP11
  3. EUR10
  4. INR10
  5. JPY9
  6. SGD9
  7. CAD8
  8. AUD7
  9. CNY4
  10. HKD4
13 columns by typefrom the column list below
  • string 9
  • float 2
  • datetime 2

Columns

13 columns in three groups
blueprint · 13 columns
columntypedescriptionexample
Text 9 columns
transaction_idstringUnique identifier for each payment transactionuniqueTXN-000001
payer_idstringUnique identifier for the individual or entity making the paymentPAYER001
payee_idstringUnique identifier for the individual or entity receiving the paymentPAYEE012
currencystringISO 4217 currency code for the payment (e.g., USD, EUR)10 currenciesUSD
payment_methodstringMethod used to make the payment8 valuescredit_card
fee_currencystringISO 4217 currency code for the transaction fee (if different from payment currency)10 currencies · optionalUSD
reconciliation_statusstringStatus indicating whether the transaction has been reconciledpending · reconciled · failed · disputedreconciled
reference_numberstringExternal reference number or code associated with the transaction (e.g., bank reference)optionalCC-5830291
descriptionstringAdditional notes or description about the transactionoptionalLegal settlement payment
Numbers 2 columns
amountfloatTotal amount paid in the transaction0 or more34.75
transaction_feefloatFee charged for processing the payment0 or more · optional1.2
Dates and times 2 columns
payment_datedatetimeDate and time when the payment was made2022-10-13T14:22:31
reconciliation_datedatetimeDate and time when the transaction was reconciled (if applicable)optional2022-10-15T10:12:44

Use it for

  • median amount48.5200 rowsmean amount by paymen…193.3cred…201.7debi…1.3Mbank…100.7payp…

    A finance dashboard

    Amount by payment_method and a breakdown of fee_currency. Excel, Power BI or Tableau.

  • Why do the 38 bank_transfer rows have a mean amount of 1,267,768?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable transactions with payer_id, payee_id and amount to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 13 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows13 columns
Yours1,000 rows13 columns

blueprint · payment-history

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 13 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Transaction ID unique per payment
  • Payment date on or after invoice date
  • Processing fees 1-5% of transaction amount
  • Payment status: pending, completed, failed
  • Refund flag links to original transaction
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
payment-history

More in Finance

Browse all
Also in FinanceSWIFT MT910 Credit ConfirmationBank Transaction Category ClassificationAccounts Receivable and Aging AnalysisAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.