For people running a Freqtrade spot bot
Know what your bot actually kept, after fees.
Send a redacted trades export and get back a clear reconciliation report: realised profit and loss recomputed from your own trades and checked against Freqtrade's own figures, open positions kept separate from cash, and anything a trades file can't answer left honestly unresolved.
A manual service run with a local tool — not an automatic online platform. No API keys, no account access, no trading. It reconciles the file you send; it is not investment advice, tax advice, or an audit.
──────────────────────────────────────── BOT TRADE RECONCILIATION — spot ──────────────────────────────────────── Period 2026-09-01 → 09-14 USDT INPUT COVERAGE closed spot-long (used) 7 open spot-long 2 flagged (complex) 1 skipped / unresolved 1 / 1 RECONCILED vs Freqtrade profit_abs 7 checked mismatches 0 REALISED P&L (closed, net of fees) gross before fees 70.50 fees −15.50 realised (net) +55.00 USDT OPEN INVENTORY (not cash) BTC/USDT cost 310.31 mark 63000 → unrl +4.38 est ETH/USDT cost 756.76 mark 2480 → unrl −13.50 est FLAGGED 1 partial exit — platform figure shown, not recomputed. UNRESOLVED: cash · deposits · funding ────────────────────────────────────────
Who it's for
If you run a Freqtrade spot bot and want one period's numbers you can actually stand behind, this is for you.
Self-hosting operators
You have a trades export but want an independent recompute of realised P&L after fees, separate from open-position marks.
People comparing figures
Your dashboard, your spreadsheet, and your gut disagree. A like-for-like reconciliation on the same trades tells you where the difference is.
Anyone who wants the caveats
You'd rather see "unresolved" than a confident number built on data a trades file doesn't contain. Honesty over a tidy total.
What you receive
- A reconciliation report for one account, covering the export you supply (the tool reports the file's date span; it doesn't filter by date).
- Realised P&L for your simple closed spot trades, recomputed from
amount, rates and fees, and cross-checked against Freqtrade's own
profit_abs. - Open positions shown as inventory with cost basis — valued only if you supply a mark price and timestamp.
- Complex trades (partial exits, position adjustments) flagged, shown with the platform's own figure, not silently totalled.
- A short written walkthrough and a per-trade reconciliation table.
- A plain list of what's unresolved and why.
What it deliberately isn't
Not an audit, certification, or guarantee. Not investment or tax advice. Not connected to your exchange or wallet. It doesn't tell you what to trade, and it can't verify figures against your exchange unless you also send an exchange statement.
Testing so far uses synthetic fixtures and an authentic Freqtrade 2026.8 export produced in a test environment. Compatibility with your specific real export is confirmed during your trial, not assumed.
A sample report
Generated from a synthetic test file — the numbers below are made up to show the format, not a real account.
======================================================================
BOT TRADE RECONCILIATION REPORT (Freqtrade spot)
Reconciliation report — NOT investment advice, tax advice, or assurance.
======================================================================
Export coverage : 2026-09-01 08:00:00 -> 2026-09-14 06:00:00
(span of the SUPPLIED export; not date-filtered)
Accounting method: per-trade realised P&L, spot long only, currency USDT;
fees from Freqtrade fee_open/fee_close; Decimal arithmetic.
INPUT COVERAGE
total records : 12
closed spot-long (used) : 7 (simple single-entry/single-exit only)
open spot-long : 2
flagged (complex, NOT totaled): 1
skipped (not spot-long) : 1
unresolved records : 1
- trade 11 (row 10) SOL/USDT: missing field(s): close_rate
FLAGGED — COMPLEX TRADES (not independently reconciled; excluded
from the realised total). Handle manually or with exchange figures.
- trade 12 ETH/USDT (closed): partial exit [platform 18.00]
RECONCILIATION vs EXPORT'S OWN P&L (profit_abs)
trades checked : 7 mismatches (> 1e-6) : 0
REALISED P&L (SIMPLE closed spot trades only, after fees)
gross P&L before fees : 70.50 USDT
attributable fees : 15.50 (entry + exit; inside profit)
realised P&L (net) : 55.00 USDT
P&L / gross entry cost basis: 0.71%
NOT portfolio return: ignores reuse, timing, external flows.
fee-currency: assumes fees in the quote currency; if any were
paid in a third asset (e.g. BNB), these totals are approximate.
UNREALISED P&L / OPEN INVENTORY
BTC/USDT: 0.005 units, cost basis 310.31 USDT
mark 63000 @ 2026-09-14 (user-supplied, unverified)
est. value if sold now 314.68 -> unrealised +4.38
ETH/USDT: 0.300 units, cost basis 756.76 USDT
mark 2480 @ 2026-09-14 (user-supplied, unverified)
est. value if sold now 743.26 -> unrealised −13.50
NOT DERIVABLE FROM A TRADES EXPORT (reported UNRESOLVED)
absolute cash balance : UNRESOLVED
deposits / withdrawals / transfers: UNRESOLVED
total equity change : UNRESOLVED (needs balances)
perpetual funding : N/A (spot scope)
quote-vs-fill slippage : N/A (no pre-trade quote)
======================================================================
Supported formats & exclusions
Narrow on purpose. Anything outside this is flagged or left unresolved — never quietly folded into a total.
- Freqtrade spot trades export (JSON): a trade list,
{"trades":[…]}, or abacktest-result-*.jsonfile (extracted from the backtest.zip— never send the zip itself, it bundles your config). - Single-entry / single-exit spot long trades, open or closed.
- Entry and exit fees (counted once, as Freqtrade already does).
- Open inventory valued from a mark price + timestamp you provide.
- Verified against Freqtrade 2026.8 output in a test environment.
- Partial exits and position adjustments / DCA — flagged, not totalled.
- Perpetuals, margin, short or leveraged trades — skipped and counted.
- Fees paid in a third currency (e.g. BNB) — affected totals marked approximate; confirmed at intake.
- Date-range filtering — none; you export the period you want covered.
- Deposits, withdrawals, cash balance, total equity change — need statements; left unresolved.
- Mixing several quote currencies into one total — reported per currency instead.
- Tax, valuation for filing, or exchange-verified balances.
How it works
A manual service. You stay in control of your data; every step is something a person does, with a local tool.
Export & redact
You export your Freqtrade spot trades as JSON and remove anything sensitive. No keys, no config, no database file. From a backtest, send only the backtest-result-*.json inside the .zip — the zip also contains your config.json.
Send securely
You send the redacted file (for example, a password-protected zip by email). Setup details are confirmed before any trial.
Reconcile locally
The report is produced on a local machine with no network access during processing. Your file isn't uploaded anywhere.
Review & deliver
A human checks a sample of trades by hand and against your platform's figures, explains any differences, and sends the report.
Turnaround: up to 2 business days once complete, valid inputs are received. Incomplete data pauses the clock — you'll be told exactly what's missing.
Privacy & file handling
What happens to your file
- Reconciliation processing runs locally; the tool makes no network calls.
- If you email an attachment, it passes through your and the provider's email systems.
- Your file is not put into version control, this website, or any AI service.
- Copies under our control — your attachment, any working files, and the delivered report — are deleted within 14 days of receipt (or sooner on request). Your email provider and mine may keep their own copies on their own schedules; that's outside our control.
What we never ask for
- API keys or secrets (even read-only), passwords, 2FA codes, seed phrases, private keys.
- Access to your account, machine, or wallet; no signatures.
- Your bot's configuration file or database.
Using local files reduces exposure, but this isn't a claim of absolute privacy, regulatory compliance, or professional assurance.
Questions
Is this affiliated with Freqtrade?
Will it tell me if my bot is profitable?
Do you need my exchange login or API keys?
Why are some of my trades "flagged"?
Is my data uploaded to a website or an AI service?
What does it cost?
Free validation trial
Try it on your own export
I'm looking for one or two Freqtrade spot users to run the report on a real, redacted export and tell me whether it's correct and useful. Free, one-off, no obligation, your file deleted within the retention window. It's an early tool being validated.
To take part: send a short enquiry first — no attachments yet. Once we've agreed the scope (Freqtrade spot, one export, one currency), I'll reply with secure intake instructions for the redacted file.
Or write to walletbotx@proton.me — an enquiry first, please, with no attachments until we've agreed scope.
Real-user validation is still pending — no trials have been run yet. A paid one-off report is proposed at an introductory £30 — not available to purchase here, and unvalidated until the trials are done.