How cash reconciliation works.
Expected closing cash = opening cash + deposits + sale proceeds + cash income − withdrawals − purchases − cash charges.
For the sample, 10,000 + 440 + 20 − 1,000 = 9,460. If your recorded cash says 10,460, it is 1,000 higher than these entries explain. A missing purchase is one thing to check; it is not the only possible explanation.
Reconcile a brokerage statement
- Find the beginning and ending cash balances on the same statement. Enter the beginning balance in Opening cash balance.
- Total the purchases, sales, deposits, withdrawals, cash income, and fees recorded in your ledger for that account and statement period.
- Enter the statement’s ending cash in Closing cash balance to check. If there’s a difference, compare the ledger entries with the statement’s activity section. Check trades near the statement cutoff, transfers, and fees first.
Keep the entries consistent.
- Check one account and one currency at a time. Do not add USD and EUR amounts together.
- Use one cash measure and date basis throughout. A settled-cash balance and a buying-power figure can differ. Match your statement’s treatment of unsettled trades.
- Include fees once. If your purchase totals or sale proceeds already include them, do not enter those fees again.
- Use dividends actually credited to cash. A reinvested dividend also has a corresponding purchase; include both if they appear as separate cash movements.
- Price changes in your holdings do not directly change cash. Transfers between accounts change the cash in each account, even if your combined net worth stays the same.
See how to track cash after a stock buy or sale, or learn how to track multiple brokerage accounts without linking them.
Keep the cash side connected on iPhone.
Allfolio lets you record investment transactions with a linked cash account, so your holdings and cash records update together. No brokerage login required.
View Allfolio on the App Store ↗This web calculator is free. The Allfolio app requires a subscription; eligible Apple Accounts can try 14 days.
Sharing copies only the public page URL, without your numbers. The calculator is a recordkeeping aid; compare the underlying entries with your account statement.