Automated Schwab Transaction Reconciliation
Every night, WebRun signs in to Schwab, reads the day's transaction history across your accounts, matches each trade, transfer, dividend and fee against your books, opens a Trello card for every entry that does not reconcile, and sends the exception count to WhatsApp.
How do I reconcile Schwab brokerage transactions against my books?
Every night WebRun signs in to Schwab, reads the day's transaction history across your accounts, and matches each trade, transfer, dividend and fee against your books. It opens a Trello card for every entry that does not match and sends the exception count to WhatsApp.
- Month end starts from a short exception list, not a full re-key
- A mismatched trade or fee is caught the night it posts
- Clean nights are confirmed in one WhatsApp line with no cards created
Built for bookkeepers · family offices · accounting firms · finance teams
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
www.schwab.comin a real browser with your saved login - no setup, no API keys. -
1
Charles Schwab - read the day's transactions
schwab.com
WebRun opens Charles Schwab to read the day's transactions. - Sign in to Schwab and open transaction history for each account you reconcile
- Capture every entry posted today: trades, transfers, dividends, interest and fees
- Record the date, account, description, quantity and amount for each line
- Read only. Never place, cancel or amend an order, and never move money between accounts
Done when Every transaction posted today is captured with its account, date and amount.
-
2
Trello - file each unmatched entry
trello.com
WebRun opens Trello to file each unmatched entry. - Match each captured line against the corresponding entry in your books by date, amount and account
- Open a card on the reconciliation board for anything unmatched, or matched at a different amount
- Put the date, account, description and both amounts on the card so it can be cleared without reopening Schwab
- Move cards resolved since the last run into Done and leave everything that reconciled off the board
Done when Every unmatched or mismatched entry has a card, and clean entries create nothing.
-
3
WhatsApp - send the exception count
whatsapp.com
WebRun opens WhatsApp to send the exception count. - Send the finance group tonight's totals: entries read, entries matched and exceptions raised
- List the largest unmatched amounts first with the account they sit in
- Say clearly when everything reconciled so a quiet night is confirmed rather than assumed
Done when The finance group knows tonight's exception count and the largest items on it.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Can it trade or move money?
No. WebRun only reads transaction history in Schwab. It never places or cancels an order, never transfers funds, and never changes a position. Every correction is a Trello card for a person.
What happens on a night when everything matches?
No cards are created and the WhatsApp message says the run reconciled cleanly, so a quiet night is confirmed rather than left ambiguous.
Does it handle several accounts?
Yes. List the accounts during setup and each run walks all of them, tagging every exception card with the account it came from so the board stays sortable.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.