SWIFT MT942 Balance Report

This dataset provides detailed intraday balance and transaction reporting for bank accounts, enabling real-time cash management and liquidity monitoring. It includes account identifiers, balances, turnover figures, and report metadata, making it ideal for financial institutions and corporate treasury teams seeking granular visibility into account activity and liquidity positions.

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

Real-time liquidity monitoring for banks and corporates

Sample rows

preview · 8 of 800 rows · all 18 columns
report_idstringaccount_typestringtransaction_countintegeraccount_currencystringreport_datedatereport_timestringaccount_numberstringopening_balancefloatclosing_balancefloatavailable_balancefloatcredit_turnoverfloatdebit_turnoverfloattransaction_referencestringbank_namestringbranch_namestringaccount_holder_namestringreport_statusstringremarksstring
RPT20240610-2001checking3USD2024-06-1008:13:1254328910654587.924792.14772.1305.25101.07TRN942-101-ASunrise National BankDowntown Financial CenterLucas MorgancompleteSalary posted; one utility bill paid.
RPT20240610-2002savings2EUR2024-06-1009:27:4517266540981821.131885.551885.5569.425TRN942-102-BEuroTrust BankBerlin FriedrichstraßeFranziska BauercompleteInterest earned and grocery shopping.
RPT20240610-2003checking1GBP2024-06-1010:11:338143562097990985.2985.204.8TRN942-103-CBritannia FinancialManchester City BranchEmma LewiscompleteATM withdrawal processed.
RPT20240610-2004corporate5USD2024-06-1011:36:079924173065205000250500250000500004500TRN942-104-DSterling Commercial BankSilicon Valley OperationsQuantum Solutions Inc.completeMonthly payroll and bulk wire transfer.
RPT20240610-2005checking2INR2024-06-1012:22:534102789154120012751275805TRN942-105-EMumbai City BankAndheri West BranchVikram SinghcompleteSalary credited; mobile recharge.
RPT20240610-2006other0CAD2024-06-1013:14:1832579184020.010.010.0100blankMaple Leaf BankblankTest AccounterrorDormant account; no activity this period.
RPT20240610-2007savings2AUD2024-06-1014:07:598854031729145001440014350200300TRN942-106-FSouthern Cross BankSydney CBD BranchOlivia WhitepartialPartial reconciliation; one transaction pending.
RPT20240610-2008other0JPY2024-06-1015:23:20734928610535003500350000blankNippon Investment BankTokyo Chuo BranchblankcompleteZero activity; no new transactions.

What the 800 rows show

from the 800-row sample

Corporate (account type) stands out: mean transaction_count is 3.0, against 1.1 for the rest.

  • 1median transaction_count
  • 3report statuses
  • 2,139median opening_balance
  • 2,302median closing_balance
  • 2,298median available_balance
  • 0.0median credit_turnover
Mean transaction_count by account_type800 rows
0241.2checking409 rows1.3savings235 rows3.0corporate65 rows0.0other91 rows
transaction_count800 rows, in bands of 1
01753502033411914410422120510transaction_count →

Median 1, from 0 to 10.

account_currency800 rows · top 10 of 11 values
  1. USD515
  2. EUR68
  3. GBP40
  4. CHF32
  5. INR30
  6. SGD28
  7. CAD25
  8. AUD22
  9. JPY19
  10. ZAR15
18 columns by typefrom the column list below
  • string 11
  • integer 1
  • float 5
  • date 1

Columns

18 columns in three groups
blueprint · 18 columns
columntypedescriptionexample
Text 11 columns
report_idstringUnique identifier for each MT942 balance reportuniqueRPT20240610-2001
report_timestringTime at which the report is generated (HH:MM:SS, 24-hour format)08:13:12
account_numberstringBank account number for which the report is generated5432891065
account_currencystringISO 4217 currency code of the account (e.g., USD, EUR)11 currenciesUSD
transaction_referencestringReference number for the transaction batch or statementoptionalTRN942-101-A
bank_namestringName of the bank providing the reportSunrise National Bank
branch_namestringName of the bank branch (if applicable)optionalBerlin Friedrichstraße
account_holder_namestringName of the account holderoptionalLucas Morgan
account_typestringType of account (e.g., checking, savings, corporate)checking · savings · corporate · other · optionalchecking
report_statusstringStatus of the report (e.g., complete, partial, error)complete · partial · error · optionalcomplete
remarksstringAdditional remarks or notes related to the reportoptionalOnline purchase debited.
Numbers 6 columns
opening_balancefloatOpening balance of the account at the start of the reporting period4587.92
closing_balancefloatClosing balance of the account at the end of the reporting period4792.1
available_balancefloatAvailable balance for withdrawal at the time of reportoptional4772.1
credit_turnoverfloatTotal sum of credit transactions during the reporting period0 or more · optional305.25
debit_turnoverfloatTotal sum of debit transactions during the reporting period0 or more · optional101.07
transaction_countintegerNumber of transactions included in the report0 or more · optional3
Dates and times 1 column
report_datedateDate on which the balance report is generated2024-06-10

Use it for

  • median transac…1800 rowsmean transaction coun…1.2chec…1.3savi…3.0corp…0.0other

    A finance dashboard

    Transaction_count by account_type and a breakdown of account_currency. Excel, Power BI or Tableau.

  • Why do the 65 corporate rows have a mean transaction_count of 3.0?

    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 reports with report_date, report_time and account_number to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 18 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 dataset800 rows18 columns
Yours1,000 rows18 columnsbranch_name: UK only

blueprint · swift-mt942-balance-report

Behind this dataset

Same schema. As many rows as you need.

These 800 rows came out of a blueprint — 18 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 reference (field 20)
  • Account number (field 25)
  • Statement number (field 28C)
  • Floor limit indicator
  • Opening balance (field 60F)
  • Intermediate transactions (field 61)
  • Closing available balance (field 90D/C)
  • Multiple statements per day
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
swift-mt942-balance-report

More in Finance

Browse all
Also in FinanceSWIFT MT202 Financial Institution TransferAccounts Receivable and Aging AnalysisLoan Default Prediction DatasetAll 1,958 datasets

What should your data show?

Preview 20 rows free
No signup. No card.