Format 1
Extractions:
Beginning Balance
TX: Deposits
TX: Withdrawals
TX: Income
Gain/Loss
Ending Balance
TX: Accrued
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: Withdrawals
TX: Income
TX: Fees
Gain/loss
Ending Balance
TX: Accrued
There will be TWO types of transaction details for this format of JP Morgan. Both Debit/Credit and Normal Transaction Detail guidelines will be followed and used for these statements.
Although, Sweep Activity is normally skipped, it needs to be included for this provider, as when matching transactions to a value, the dividends and interest listed in this section are included.
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount