Bank Statement Converter for Stock Market Income Documentation
Stock market income — dividends, realized capital gains, and brokerage transfers — moves between your brokerage account and your bank account in transactions that can be hard to trace at tax time or when qualifying for a loan. Converting your bank statements to Excel creates a clear log of every transfer from brokerage to bank.
Key Benefits
- Capture every brokerage ACH transfer or wire deposit into your checking account
- Document dividend payment deposits and interest income from money market sweeps
- Trace the timing of capital gain distributions relative to trades on your 1099-B
- Separate investment income deposits from personal income for loan qualification
- Produce an Excel file your CPA can reconcile against your brokerage statements
How It Works
- Step 1: Upload your personal bank statement PDFs — 12 months minimum
- Step 2: The converter extracts all transactions including brokerage transfers
- Step 3: Download Excel and filter for your brokerage firm's name to isolate investment deposits
- Step 4: Use the output to cross-reference your 1099-DIV and 1099-B at tax time
Frequently Asked Questions
- Can I use stock dividend income to qualify for a mortgage?
- Yes, if you have received the dividends for at least 2 years and they are likely to continue. Your bank statement shows the actual deposits. Combine it with 2 years of 1099-DIV forms and your brokerage statements to document continuity.
- I made a large gain from selling stock. Can that count as income for a home loan?
- One-time capital gains typically do not count as recurring qualifying income. They can help demonstrate assets or cover a down payment. Only recurring investment income — dividends, interest, scheduled distributions — qualifies as income for mortgage underwriting.
Convert a Statement Free