← Allfolio home

FREE TOOL · NO ACCOUNT REQUIRED

Brokerage cash reconciliation calculator

Check your brokerage statement’s closing cash balance using stock trades, dividends, fees, and transfers.

Calculations stay in this page. Your inputs are not uploaded or saved.

One account. One currency.

Use the same statement period and currency for every number. Enter each movement as a positive amount. Blank movement fields count as zero.

Use up to two decimal places, for example 1250.50. A negative balance represents cash owed; this calculator does not assess borrowing or buying power.

YOUR CASH CHECK

Follow both sides
of every trade.

Start with your opening cash balance, or load the sample: 10,000 opening cash, a 1,000 purchase, 440 in sale proceeds and a 20 dividend.

This tool checks arithmetic from the entries you provide. It cannot detect an omitted or incorrect transaction on its own.

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

  1. Find the beginning and ending cash balances on the same statement. Enter the beginning balance in Opening cash balance.
  2. Total the purchases, sales, deposits, withdrawals, cash income, and fees recorded in your ledger for that account and statement period.
  3. 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.

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.