Every sync also appends each new brokerage order (filled, canceled or still queued) to an append-only ledger workbook, newest first, with one sheet per account and summary tabs by security and by month.
When the tracking spreadsheet ever looks wrong, the ledger is the record to check it against, instead of reconstructing history from scratch.
captured later (2026-09-25) on made-up demo data, so it shows today's look rather than the look at the time.