Money · Community report
Reconcile a trading spreadsheet with broker records
@kukulobo reports that Muse reconciled a trading spreadsheet against their broker's records to within four cents and caught sales they had missed. The post is one line in a weekly roundup, so this page covers how to run a trading spreadsheet reconciliation and what to confirm yourself.
What you can get
- Prepare
Your trading spreadsheet
- Ask and review
Export the broker's records for the exact period your spreadsheet covers, and note the date range on both.
- Check the result
A reconciliation list showing where your spreadsheet and your broker's records agree and differ, with missed sales flagged; it is a bookkeeping check, not tax or investment advice.
The source case
@kukulobo reports that their agent Muse reconciled their trading spreadsheet against their broker's records "to within four cents" and caught sales they had missed. The sentence is part of a weekly roundup that also mentions selling an old e-reader and a supplement schedule, which this page does not cover. The post does not say which broker, how many transactions, which period, what the four-cent difference came from, or how the missed sales were confirmed.
A public report by someone outside this library. Not independently reproduced here.
From the source
Source excerpt
This week with my AI agent @muse musie: it reconciled my trading spreadsheet against my broker's records to within four cents, caught sales I'd missed, sold an old e-reader in four days, and built me a morning/night supplement schedule.
Quoted from the original posts. Not written by this guide, and not a result produced here.
Suggested prompt
Bring Your trading spreadsheet, Broker statements or exports for the same period, The accounting period and any rounding you accept. Source community report, checked 2026-10-12.
Written by this guide as a starting point, not quoted from the source. Your edits stay in this browser.
What you need
You supply
- Your trading spreadsheet
- Broker statements or exports for the same period
- The accounting period and any rounding you accept
How to try it
Editorial, not from the source
- Export the broker's records for the exact period your spreadsheet covers, and note the date range on both.
- Give the agent both files and ask for a comparison only, with edits to your spreadsheet left to you.
- Review the list of trades that appear in one source but not the other; these are where missed sales would show up.
- For each mismatch, open the broker statement and confirm the row yourself before changing your spreadsheet.
- Decide in advance what a small leftover difference means, for example fees, rounding or dividends, and ask the agent to name the likely cause rather than hide it.
- Save the corrected spreadsheet and the reconciliation list together so you can see later what was changed.
What the author reported
@kukulobo lists the reconciliation first in a weekly summary: the spreadsheet was matched against the broker's records "to within four cents", and the agent also "caught sales I'd missed". The same sentence moves on to an old e-reader that sold in four days, which is a separate task.
No file, screenshot or breakdown is attached in the captured post. The four cents and the missed sales are the author's summary, and the page treats them that way.
Reading a small leftover difference
In general practice, a reconciliation that lands a few cents off usually points to rounding, fees or how each side treats fractional shares and dividends. The useful habit is to make the agent name the row or rule behind the gap instead of letting it round the total away.
Missed sales deserve more suspicion than matched ones. For each, check the broker's own confirmation or statement line, because an agent can pair two unrelated rows that happen to share an amount.
Open Muse to try it. That is the product's own site; this guide is not part of it.
Limits and confirmation points
Limits to confirm
- The broker, period, transaction count and the cause of the four-cent gap are not stated.
- How the agent got the broker's records (export, statement, login) is not described.
- "Caught sales I'd missed" is the author's summary; no amounts or dates are given.
- This is a bookkeeping check only; it does not decide tax treatment, which can need a professional.
- This is an attributed community report, not reproduced by this guide. The suggested workflow and checks are editorial guidance, not a recovered conversation or guaranteed product capability.
If it goes wrong
Editorial, not from the source
- The totals match but individual rows do not
- Ask for the row-level differences; offsetting errors can cancel out in a total.
- The agent proposes corrections without a broker row to back them
- Ask it to attach the supporting broker row to each correction and drop any it cannot support.
Common questions
Can Muse reconcile a trading spreadsheet against broker records?
@kukulobo reports that it did, to within four cents, and found sales that had been missed. The post gives no files or figures, and this guide has not reproduced it.
Will it find every missed trade?
The post does not say how complete the check was. Confirm each reported mismatch against the broker's statement and spot-check a few matched rows too.
Is this tax advice?
No. The routine compares two records. How any gain or loss is treated for tax is a separate question for a qualified professional.
Next
Related to this task
More in Money
Get recurring task recommendations — ask your own agent to check for relevant updates.