BNY statements differ from retail bank accounts: they combine cash movements, trade vs settlement dates, asset custody fees, and multi-currency balances. Here is how to structure and audit them in Excel.
The Bank of New York Mellon (BNY) operates primarily as an institutional custodian, treasury manager, and wealth administrator. Unlike retail checking statements that show a single checking ledger, BNY statement PDFs often include specialized ledgers for cash balances, custody settlements, investment income, and liquidity sweeps.
Converting these documents into Excel requires extra care: trade dates must not be confused with cash settlement dates, multi-currency accounts must preserve their ISO codes, and fee schedules must be separated from operational cash flow. This guide explains how to convert BNY statements and audit the resulting spreadsheet data.
- Understand how BNY custody and treasury statements differ from retail checking
- Distinguish trade dates from cash value/settlement dates in transaction exports
- Preserve multi-currency indicators on global custody reports
- Reconcile cash sweeps, custody fees, and interest credits before spreadsheet export
How BNY Statements Differ by Portal and Product
Most consumer checking accounts follow a simple debit/credit ledger with a running balance. In contrast, BNY statements report specialized asset servicing activity across distinct client portals documented in the BNY Client Access directory.
Before converting, identify which specific portal and account statement contains the cash movements needed for your accounting ledger, as navigation paths and statement layouts differ significantly:
- NEXEN Portal: Institutional clients access treasury cash accounts (DDA/nostro), liquidity sweeps, custody settlement ledgers, and foreign currency balances.
- BNY Wealth Online: High-net-worth and private banking clients view private banking cash transactions, portfolio income distributions, and advisory fee deductions.
- NetXInvestor (Pershing): Brokerage and custodial accounts managed through BNY Pershing show trade executions, dividend sweeps, margin activity, and cash settlements.
Separating Trade Date from Settlement Date
In BNY custody and brokerage statements (including BNY Pershing NetXInvestor reports), each security transaction often lists two distinct dates: the trade date (when the order executed) and the settlement date (when cash actually moved).
For bank reconciliation and cash-flow accounting, the settlement date is the critical date because it corresponds to when funds cleared the account. When reviewing extracted Excel columns, ensure that the date column reflects the actual settlement date, and keep the trade date in a reference column if needed for audit records.
Handling Multi-Currency and Corporate Actions
BNY provides global custody services where balances and transactions may be held in multiple currencies within the same client entity. Fictional examples often use USD for illustration, but actual statements may reflect EUR, GBP, JPY, or other currencies.
When converting, instruct reviewers to preserve the currency printed on the actual statement rather than assuming all figures are USD. Do not sum amounts across mixed currencies in Excel without applying the appropriate historical foreign exchange conversion rates.
- Check currency headers for each sub-account section on multi-currency statements.
- Ensure dividend credits in foreign currencies are converted at the transaction FX rate.
- Flag corporate actions (stock splits, spin-offs) that adjust units rather than cash.
- Maintain separate Excel sheets or tabs for distinct currency ledgers.
Converting BNY Statement PDFs with Parse Statement
Convert this institution’s statements using available table extraction and AI fallback. Its statement layouts have not yet been verified with a dedicated parser. Review the extracted results against your PDF.
Upload your PDF to the converter at /convert-bny-bank-statement-pdf-to-excel. Parse Statement attempts to extract transaction tables, but because layouts vary widely across institutional treasury, custody, private wealth, and Pershing portals, always check whether your layout extracts cleanly and review column assignments before downloading.
If the PDF requires a document password, follow the instructions supplied with that file. Enter it when prompted so the application can unlock the document for processing.
Reconciling Converted Rows Against the PDF
Before handing the Excel file to your accounting team or importing into ERP software, perform a basic reconciliation. Sum total debits (disbursements and fees) and total credits (deposits, settlements, interest) and confirm that Opening Balance + Credits - Debits = Closing Balance.
Keep the original downloaded BNY statement PDF stored securely alongside your reviewed Excel workbook so that any audit query can be traced back to the authentic provider document.
- Verify that beginning and ending statement balances match the Excel summary.
- Confirm that interest credits match 1099 or institutional yield reports.
- Ensure custody management fees are categorized as operational expenses.
- Retain the original PDF in your audit archive alongside the exported spreadsheet.