How to use Rebalancing Calculator
Rebalancing Calculator
Work out the trades that bring a portfolio back to your target allocation: full rebalance, new cash only, or a withdrawal, across several accounts.
Bought Rebalancing Calculator? Sign in with the email you bought it with to download the latest version or ask me a question.
On this page
A calculator for your own numbers, not financial advice. You type the holdings, prices and targets. The app doesn’t fetch prices, connect to a broker or place trades.
Install
Rebalancing Calculator requires macOS 14 Sonoma or later, on Apple silicon or Intel. Download the ZIP from the order page or your Creem receipt. Unzip it and move the app to Applications.
The app checks for updates once a day. When a new version is ready, click Install and Relaunch. To check anytime, choose Rebalancing Calculator → Check for Updates….
Make a portfolio
The start screen has three buttons. New Portfolio makes an empty one. Import CSV… reads a positions file. Try the Sample adds a made-up three-fund portfolio across a Brokerage and an IRA account, to look around.
In the portfolio, click the name to rename it. The header has Cash in the accounts (cash already there, uninvested), the Drift band (± points) that decides when a holding shows in orange, Targets: Per holding / Per group, and the Currency of the portfolio.
Add one row per fund in each account with Add Holding (Shift-Command-H). The same fund in two accounts is two rows. Each row has ticker, name, asset class, account, shares, price, the Price as of date, and the target %. The value, the current percentage and the drift fill in as you type. Changes are saved as you type.
The ··· menu on a row has:
- Keep As Is: the holding counts in the totals but is never bought or sold.
- Priced in Another Currency…: its currency and an exchange rate you type.
- Delete Holding.
In Accounts, mark each account Taxable or Tax-advantaged. The app guesses from the name (IRA, 401k, Roth, HSA, ISA, SIPP, TFSA, RRSP, pension and similar are tax-advantaged). It’s only used by Don’t sell in taxable accounts.
With Per group targets you set a target for each asset class. The app splits it among the holdings in the group by their current value, or equally when the group is empty.
Import from a CSV or a spreadsheet
Import CSV… (File › Import Holdings from CSV…, Command-I) opens a sheet with a column picker for each field: ticker, name, asset class, account, account type, shares, price, value, price date, target %, currency and exchange rate. The app guesses each one from the header, and shows a sample value next to each choice. Uncheck The first row is the header if the file has none.
The preview lists the holdings it will import, and a sentence for each skipped row, like a total line or a cash line without shares. Rows without an account get the one you type in Account for rows without one. When there’s no price column, the price is worked out from value ÷ shares. Targets written as fractions (0.35) become percentages.
Paste from Spreadsheet… (File › Paste Holdings from a Spreadsheet…, Shift-Command-V) does the same with rows you copied from Numbers, Excel or Google Sheets.
The import doesn’t change the file. No particular broker’s export has been tested, so check the preview.
Calculate the trades
The Rebalance card has three modes:
- Full rebalance: holdings above target are sold down to it and the money buys the holdings below target. Targets apply to the invested value plus cash plus any deposit, minus the cash you keep.
- New cash only: never sells. The amount goes to the holdings furthest below target first, raising them together until it runs out.
- Withdraw: works out what to sell to take an amount out. Holdings with a 0% target go first, then the ones furthest above target.
Then:
- Whole or Fractional shares. Whole rounds buys down and sales up. Fractional uses 4 decimal places.
- Minimum trade: smaller trades are left out and listed in a note.
- Keep as cash: an amount that stays uninvested.
- Don’t sell in taxable accounts: in a full rebalance, a taxable holding above target keeps its value, and its excess comes off the other holdings in its asset class, so sales go to tax-advantaged accounts. In a withdrawal, only tax-advantaged holdings are sold when they hold enough.
These options are saved with the portfolio. Click Calculate Trades (Command-Return). If something is missing, the sentence next to the button and the orange banner at the top say what: a price of 0, a missing exchange rate, or targets that don’t add up to 100%.
Read the result
The result starts with a summary sentence, then:
- Trades: sales first, with action, ticker, account, shares, price and amount.
- By account: sales, buys and net per account. Cash is one pool, so a negative net means that account needs a deposit, cash already there, or a transfer.
- Allocation before and after: a chart and a table with each holding’s value and percentage before, the target, and after. Orange is outside your drift band.
- Cash: before, after, kept on purpose and left over.
- Notes: rounding leftovers, trades dropped by the minimum, the taxable rule, holdings new cash can’t fix, and the date of the prices.

Copy as Text (Shift-Command-C) copies the plan. Export CSV… (Command-E) saves the trade list and never replaces an existing file. Back to Holdings (Command-[) returns to the portfolio. Nothing in the portfolio changes until you update the shares after you trade. Plan › Set Every Price Date to Today marks all the prices as current after you update them.
Your data
Portfolios are saved in ~/Library/Application Support/Rebalancing Calculator/portfolios.json. Plan › Show the Portfolios File shows it in the Finder. The app uses the internet only to check for and download updates.
The plan doesn’t account for tax lots, cost basis, gains, wash sales or fees.
Rebalancing Calculator is $19, a one-time purchase.