Bernstein has 2 formats
Format 1
Format 1 of Bernstein statements will not reconcile.
Extractions:
Beginning Balance
Ending Balance
TX: Income
Format 2
Extractions:
Beginning Balance
Deposits & Withdrawals
TX: Income
TX: Other
Gain/Loss
Ending Balance
Equations:
TX: Deposits
={deposits & withdrawals} > 0 ? {deposits & withdrawals} : 0
TX: Withdrawals
={deposits & withdrawals} < 0 ? {deposits & withdrawals} : 0
The Transaction Detail D/C guidelines will be followed and used for these statements.
Table Name: Transaction Detail D/C
Column Names: Date, Description, Debit, & Credit
We will not include Unsettled Trades in the Transaction Detail.