Export your Train at Home earnings to CSV: the subnera hub Earnings page

If you want a dated record of what your Macs have been paid for Train at Home, subnera hub has a page for it: Earnings. This guide walks through what that page shows, where its numbers come from, how the CSV and JSON files are built, and where it stops. For how rewards and payouts work on the network side, see the rewards and payouts guide; this one is about reading and exporting the record.

Where the figures come from

The Earnings page does not read anything from your Mac's log. subnera hub polls Macrocosmos's public API for each machine's hotkey and keeps its own copy of the payout history. A hotkey is checked about once an hour, and again shortly after the next payout time the API announces. Each payout is attributed to the machine that held that hotkey when the payout accrued, so a Mac that moved between pools is not double-counted.

These figures are subnera hub's reading of public data, not an official statement from anyone. subnera and subnera hub are unofficial and not affiliated with IOTA, Macrocosmos or Bittensor.

Earned, pending and next payout

On the fleet page, a rewards strip shows three values taken from the same public data: Earned, Pending and a Next payout countdown. A View earnings link in that strip opens the Earnings page for the pool (/pools/<id>/earnings). Every role in a pool can read it; see the pools and roles guide for what roles mean.

On the Earnings page itself, the Status filter switches between Paid and Paid + pending. By default only paid rows count. The summary cards show total earned in SN9, the value in USD, the value in your chosen currency, and the number of payouts.

Choosing a period and a grouping

The Period filter offers This year, Last year, Last 12 months or Custom with a start and end date. The Currency and Timezone filters apply to the page and to any file you download. The timezone decides which calendar day, month or year a payout belongs to, so a payout shortly after midnight UTC can land on a different local day.

The Totals table groups the same payouts by Month, Year or Machine. Day and quarter groupings exist in the hub's API for the totals file, but the page itself only shows those three buttons. Below the totals, the Payouts list shows one row per payout with date, machine, status, amount and notes.

If some payouts predate the moment subnera hub began tracking a machine's hotkey, a banner says so and excludes them. Include earlier earnings adds them back, in the totals, the list and the downloads.

How values are priced

Each payout is valued with a price snapshot: the daily price of SN9 on CoinGecko at 00:00 UTC on the payout's day, not a live rate. subnera hub stores the snapshot, so the same file regenerated later gives the same numbers. A payout whose day has no price yet is marked unpriced and is retried automatically. Totals that include such rows are labelled partial, so a half-priced month is not mistaken for a final figure.

Rows can carry other notes: shared_hotkey when a hotkey belongs to several of your machines, before_tracking for earlier earnings, upstream_conflict when a paid payout later changed upstream (the first recorded amount is kept), and ledger_incomplete when the history of a hotkey could not be fully verified.

Preferences and file formats

The Earnings preferences card on the Account page sets your defaults: currency, timezone and CSV format. You can still change them per export on the Earnings page. The CSV formats are:

• CSV: comma-separated, dot decimals, standard RFC 4180 quoting.
• CSV for Excel: the same, with a byte-order mark so Excel reads it as UTF-8.
• CSV for Excel, Europe: semicolon-separated with comma decimals, for Excel installs set to a European locale.

Text cells that a spreadsheet could read as a formula get a leading apostrophe.

Downloading

In the Download section, pick a file format and press Download CSV or Download JSON for one row per payout in the period. The file includes the accrual time in UTC, the local date, status, pool, machine, hotkey, amount in SN9, the USD and fiat prices and values, the price day and source, and notes. Download totals CSV gives one row per group plus a total, using the grouping you selected, and its figures add up to the same totals shown on screen. Files are named from the pool, dates and currency.

A range that would produce more than 200,000 payouts is refused with a request to narrow it.

What it is not

The export is a bookkeeping helper. It does not compute what you owe, and it is not tax or legal advice. As the page footer says, the values use CoinGecko's daily SN9 price at 00:00 UTC on the payout day and are data for your records. Check the rules that apply to you, and keep the files you rely on.

Checklist

1. Connect each Mac to subnera hub, so its hotkey is tracked.
2. Set currency, timezone and CSV format in Earnings preferences.
3. Open Earnings, choose a period, and check Paid versus Paid + pending.
4. Look for banners about earlier earnings, unpriced rows or an incomplete history.
5. Download the rows file, and a totals file grouped the way you need.

If a payout looks attributed to the wrong machine, see the troubleshooting guide.