Understanding Bank Statement Formats: Swiss, Israeli, and US Standards
Different banks and countries have dramatically different statement formats. Understanding these differences is key to efficient portfolio management.
Swiss Private Bank Formats
UBS Portfolio Statements
Structure:
- Multi-page document (typically 5-15 pages)
- Header: Account holder, account number, statement date
- Summary page: Total portfolio value by currency
- Holdings section: Detailed positions with ISIN codes
- Transaction history: Buys, sells, dividends, fees
Key Fields:
- Security name (often in German for Swiss securities)
- ISIN or Valor number
- Quantity, price, market value
- Currency (CHF, USD, EUR common)
- Accrued interest for bonds
Extraction Challenges:
- Multi-currency presentation
- German/English mixed language
- Complex fee structures
- Derivative positions (warrants, structured products)
Julius Baer Statements
Unique Features:
- Color-coded sections
- Graphical asset allocation charts
- Performance attribution details
- Tax document annexes
Format Notes:
- Often includes benchmark comparisons
- Private equity valuations marked as estimates
- Real estate holdings with appraisal dates
Credit Suisse (Now UBS)
Legacy Format Variations:
- Older CS statements differ from current UBS format
- May require special handling for historical data
- Transition period (2023-2025) created mixed formats
Israeli Bank Formats
Bank Hapoalim
Language Considerations:
- Hebrew text (right-to-left)
- Mixed Hebrew/English security names
- Date format: DD/MM/YYYY
Structure:
- Account summary in Hebrew
- Securities section: Both local (TASE) and foreign
- Currency exchange rate table
- Tax withholding details
OCR Challenges:
- Hebrew character recognition
- Mixed language in single fields
- Complex formatting in tables
Bank Leumi
Distinctive Features:
- Separate pages for different security types
- Pension/provident fund holdings
- Detailed tax reporting section
Common Issues:
- Security names may be abbreviated
- Foreign securities may have Hebrew translations
- Multiple account types in single statement
Mizrahi-Tefahot
Format Notes:
- Conservative layout, text-heavy
- Less graphical than European banks
- Detailed transaction descriptions
US Brokerage Formats
Interactive Brokers
Activity Statements:
- Extremely detailed (20-100+ pages common)
- Sections: Summary, Trades, Dividends, Fees, Positions
- Multiple account types (cash, margin, IRA) combined
- XML/CSV export options available
Extraction Tips:
- Focus on "Open Positions" section
- Watch for margin positions vs cash
- Multi-currency reporting options
- Options/futures may need special handling
Fidelity
Statement Structure:
- Clean, standardized format
- Account summary on page 1
- Holdings listed with cost basis
- Performance charts included
Advantages for Extraction:
- Consistent layout across accounts
- Clear field labels
- Ticker symbols prominently displayed
Charles Schwab
Format Characteristics:
- Professional, detailed layout
- Separate sections for different account types
- Realized gains/losses section
- Year-to-date summary
Format Comparison Matrix
| Bank Type | Pages | Language | Complexity | Extraction Accuracy |
|---|---|---|---|---|
| UBS | 5-15 | EN/DE | High | 98% |
| Julius Baer | 8-20 | EN/DE | High | 97% |
| Interactive Brokers | 20-100 | EN | Very High | 99% |
| Bank Hapoalim | 3-10 | HE/EN | Medium | 95% |
| Fidelity | 5-12 | EN | Low | 99% |
| Schwab | 6-15 | EN | Low | 99% |
Common Elements Across All Formats
Despite differences, most statements include:
- Account identification
- Statement period/date
- Holdings list (securities owned)
- Market values
- Transaction history
- Account summary/totals
Best Practices for Multi-Bank Portfolios
1. Standardize Data Fields
Map different bank formats to common fields:
- Security identifier → ISIN (preferred) or Ticker
- Position size → Quantity (standardize units)
- Value → Always convert to base currency
2. Handle Language Differences
- Use ISIN codes instead of security names when possible
- Maintain translation tables for common securities
- Flag untranslated items for manual review
3. Currency Normalization
- Choose one reporting currency (USD, EUR, CHF)
- Apply consistent FX rates across all holdings
- Track FX rate sources and dates
4. Automate with BOFFO
BOFFO is trained on all these formats:
- Bank-specific extraction rules
- Multi-language support (English, German, French, Hebrew)
- Automatic currency conversion
- Confidence scoring for review
Conclusion
Understanding bank statement formats is crucial for efficient portfolio management. While formats vary dramatically, modern AI-powered tools like BOFFO can handle the complexity automatically.