There are 3 different formats of Charles Schwab
Format 1
Example 1
Example 2
Example 3
Extractions:
Beginning Balance
TX: Deposits
TX: Withdrawals
TX: income
TX: Transfers
Gain/Loss
TX: Fees
Ending Balance
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount
We will not include Bank Sweep for Benefit Plans Activity or Pending/Open Activity in the Transaction Detail.
Format 2
Extractions:
Beginning Balance
TX: Transfers
Gain/Loss
Ending Balance
TX: Accrued
TX: Reinvestments
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount
We will not include Bank Sweep or Pending Actions in the Transaction Detail.
Format 3
Extractions:
Beginning Balance
TX: Other
Gain/Loss
Ending Balance
TX: Reinvestments
The normal Transaction Detail guidelines will be followed and used for these statements
Table Name: Transaction Detail
Column Names: Date, Description, & Amount
We will not include Bank Sweep in the Transaction Detail.