If you keep investments in several accounts, your records can end up spread across broker apps, cash statements, and a spreadsheet. A combined view is useful, but it also needs to preserve the details: which account holds an asset, how much you paid, and where the cash went.
A manual investment ledger works by recording those details yourself. It takes ongoing maintenance, so start with a small, repeatable process rather than trying to reconstruct years of history in one sitting.
1. Decide what your ledger should answer.
Choose a first question, such as “What do I hold across my accounts?” or “Do my investment transactions and cash balances agree?” Your answer determines how much history you need to enter.
An opening snapshot establishes current holdings and cash. A transaction history explains how holdings and cost basis changed. Keep the date and method of your starting point clear so a current balance is not mistaken for a complete historical return record.
2. Keep each account identifiable.
Use a consistent account name for every holding and its related cash. For example, distinguish an individual brokerage account from a separate retirement account even when both contain the same ETF. That makes it easier to reconcile your ledger against the correct statement.
Record the account currency as well. Preserve original amounts when accounts use different currencies. A display currency helps with the overview; the original currency still matters when checking a transaction.
Example: The same ETF in two accounts
Suppose your individual brokerage statement shows 12 shares of an ETF and your IRA statement shows 8. Keep one position for each account and sum them to see your 20-share exposure. If you sell 3 shares from the brokerage account, record the sale and its proceeds there. Your next check should show 9 shares in that account and 8 in the IRA.
3. Give cash its own place.
Cash is part of the portfolio, including cash waiting to be invested. When you count sale proceeds in cash, also reduce the shares you hold. Otherwise you can accidentally count the same money twice.
Simple example: start with $10,000 cash. Buy 10 sample shares at $100 each, with no fees. The ledger now holds $9,000 cash and $1,000 of shares. The total is still $10,000.
In Allfolio, you can link a buy or sell to a cash account, so recording the transaction updates both sides. Choose the correct cash account and review the transaction details before saving.
4. Record events that change your balances.
- Purchases and sales: record the date, asset, share count, price, and any supported transaction costs.
- Cash dividends: record cash received without treating it as additional shares.
- Deposits, withdrawals, and transfers: distinguish money moving into or between accounts from investment gains.
Use completed transaction details from your brokerage records. Market prices and currency rates can change after a trade, so a current quote is not a substitute for the execution price.
5. Reconcile on a manageable schedule.
At the end of a week or month, compare each account's holdings and cash with its statement. Investigate missing trades, duplicate entries, fees, and dividends before changing an opening balance to force agreement.
Also check the overall total: holdings plus cash and any other assets you have chosen to track. A total that looks plausible can still hide an error inside one account, so check both levels.
Keep the process lightweight.
Allfolio brings asset records, transactions, cash accounts, and portfolio analysis into an iPhone app. You enter and maintain records, with optional screenshot recognition to help prepare transaction details for review. Core records are stored on your device, with optional sync to your own private iCloud database.
Begin with one account, reconcile it, and add the next account when the process feels manageable.
Continue with the worked example of a purchase, dividend, and sale, or try the sample ledger.
Try a cash check: use the free portfolio cash reconciliation calculator to compare the cash movements you recorded with your closing balance. No account required.
A clearer place for your records.
Explore Allfolio for iPhone. Subscription required; a 14-day free trial is available to eligible Apple Accounts. Current plans and prices appear in the app and App Store.
View Allfolio on the App Store ↗Examples are illustrative and omit fees. This guide explains recordkeeping; your brokerage statements remain the source for checking completed transactions.