Skip to main content

BNY Mellon

Kayla avatar
Written by Kayla
Updated over 3 months ago

Format 1

Extractions:

  • Beginning Balance

  • TX: Deposits

  • TX: Withdrawals

  • Change in Value

  • Ending Balance

  • TX: Accrued

  • TX: Income

Equations

Gain/Loss

={change in value} - {tx: income}

The normal Transaction Detail guidelines will be followed and used for these statements

Table Name: Transaction Detail

Column Names: Date, Description, & Amount


Format 2

Extractions:

  • Beginning Balance

  • TX: Deposits

  • TX: Income

  • TX: Fees

  • Debits

  • Gain/Loss

  • Ending Balance

  • Accrued

Equations

TX: Withdrawals

={debits} - {tx: fees} - {other: taxes}

The normal Transaction Detail guidelines will be followed and used for these statements

Table Name: Transaction Detail

Column Names: Date, Description, & Amount

Did this answer your question?