Help · Concept

Settling a reconcile difference

From RangefinderInvest's built-in help · applies to version 0.53.0

Reconcile is one sheet, a typical balance: type the date your statement or your broker's positions page covers, its cash figure, and its share count for each holding, and RangefinderInvest answers with its own figures as of that date and the differences. The date is never in the future.

Accepting a difference posts a record dated on the as-of date, never today unless today is the date you typed: a cash difference posts the existing dated cash-reconciliation adjustment, and a share difference posts a transfer of shares in or out, noted as a reconciliation.

Both records are stored as reconciliation adjustments: the ledger keeps that fact in its own right, rather than the app guessing later from the note on the row. It matters when you settle two holdings on the same date. Accepting a shortfall on one fund and a surplus of the same size on another looks exactly like a fund reorganisation, where shares of one fund become shares of another and the original cost basis travels with them. A reconciliation is not that, and because each record says so, no cost basis moves between your two holdings. The note is there for you; nothing in the app reads it.

That share record is never a buy or a sell. It carries no price, because nobody stated one, so it adds no realized or unrealized gain of its own and starts a fresh $0 cost basis on the shares it adds, the same basis a genuinely external transfer-in keeps. Shares removed leave at the position's average cost, so what stays behind is what you actually paid for it. Time-weighted return books it as a flow valued at that day's close rather than as growth, so shares that simply appeared read as money moving in, not as the account having earned them. A shortfall the sheet cannot explain is better recorded with an opening position or found in the account's own history than settled here as if it were ordinary activity.

On a snapshot-tracked account, saving the sheet instead records the typed figures as a new statement on that date; a holding left blank keeps the count the latest statement already shows, and no transaction is posted.

How it reads afterward

Once posted, the record shows in the register as Reconciliation, under Opening positions & adjustments, whether it settled cash or a share count. It never reads Deposit, Withdrawal, Transfer in or Transfer out, and its row details say Reconcile posted it to match your broker as of that date. The fact lives in the row itself, never in the note you typed.

Opening such a row shows the ordinary form for its own shape, under one line naming what it is. What un-marks the row is its shape, not any single field: giving it a price, any type but the two transfers, or a field its own kind doesn't carry (a share count on the cash adjustment, or an amount on the share adjustment) turns it into an ordinary transaction. Flipping a share adjustment between transfer in and transfer out, moving it to another security, or flipping a cash adjustment's type and sign together all keep the row a reconciliation adjustment, because the shape survives each of them. A cash adjustment's amount is part of its shape, not something that breaks it: correcting the dollar figure to another value that still matches the day's direction keeps the row a reconciliation adjustment, the same way correcting a share adjustment's share count does.