AUDITEDTRADER / STATEMENT RECONSTRUCTION
Trading Cash Ledger Signs and Balance Reconciliation
Trace deposits, withdrawals, realised profit and charges without hiding a residual.
Write the identity before filling the numbers
A closed-balance reconciliation begins with an explicit accounting identity. Opening balance plus deposits, less withdrawals, plus internal transfers in, less transfers out, plus realised profit and income, less charges, should equal the reported closing balance under the declared convention. The names and signs matter more than a spreadsheet total that happens to agree.
This is a monetary identity, not an investment-return formula. The calculation can reveal a residual while leaving timing, valuation and source completeness unresolved. A deposit belongs in the capital movement field even if moving it into profit would make a headline percentage look more impressive.
Distinguish positive amounts from signed outcomes
In the educational bridge, deposits, withdrawals, transfers and charges are entered as nonnegative magnitudes. Realised profit, income adjustments, unrealised profit and balances can be signed under the stated convention. Subtracting a negative withdrawal would add capital twice, so the tool rejects it rather than guessing the intended sign.
An actual broker export can use another convention. Its original signed fields should remain intact in the source record. The transformation into this worksheet needs a documented mapping. Do not claim the broker issued the normalized worksheet merely because its rows were derived from that export.
Avoid double-counting net profit and fees
A realised-profit field may already be net of commission or financing. Subtracting the same expenses again understates closing balance. Conversely, treating a gross field as net can overstate economic profit. Read the source definitions before choosing the identity.
The authored cases define realised profit before the separately listed charges. That declaration is necessary for reproducing their arithmetic. It is not a statement about every broker. A source whose treatment remains unclear should carry an exception, not a balancing adjustment disguised as an estimated fee.
Keep income and non-trading adjustments visible
Interest, dividends, rebates, taxes and corrections can affect an account without representing trade-selection profit. Classify them separately when the source permits. A net income adjustment can be negative, but its reason should remain in the supporting register.
The balance tool includes a signed income-and-adjustments field only for a declared accounting exercise. It does not authenticate those movements or identify their tax treatment. A residual must not be resolved by entering an unexplained credit into that field. An exact number with an unsupported category is still an unresolved evidence problem.
Reconcile account by account
Offsetting residuals in two accounts can make their combined total appear correct. Calculate each account identity before aggregating. Preserve account identifiers and the common currency, date interval and transfer convention. Do not sum heterogeneous currencies or intervals because they happen to share one operator.
In the teaching packet, one June record has a ten-unit cash residual. The correct result is a visible exception. The neighbouring account cannot provide an undocumented offset. A paired internal transfer also needs matching counterpart records; the algebra alone does not establish the transfer occurred.
Interpret a zero residual carefully
Zero means the supplied amounts satisfy the declared identity at the calculation precision. It does not establish an authentic statement, a complete transaction population or a completed professional review. False inputs can reconcile perfectly. A reviewer still needs original records, continuity and a defensible measured object.
Publish the identity, the exact inputs and any unresolved categories with a monetary conclusion. Do not convert the cash difference into a verified percentage return without the required capital and timing method. The educational export therefore keeps source verification and assurance fields explicitly absent.
Original reference material
Checked 14 October 2026 for its identified technical or reporting scope. These references do not certify this publication, its teaching examples or any private account.
Inspect the corresponding complete records
The authored packet provides every monetary input and its expected output, individual movement categories and document states. Preserve the declared convention when reproducing it. Do not replace an unknown source or a missing interval with an assumed zero. Financial evidence and software fixture counts remain separate.
Complete teaching packet | Original ten-field source dossier