The transaction-history CSV is your portable copy of every buy and sell you've recorded in Gold Silver Ledger.
It's the file to reach for when you need your activity in a spreadsheet, in a backup folder, or in someone else's hands — an accountant, a partner, a tax preparer, or a future version of you who wants the raw data without opening the app.
Tier access
Transaction CSV export is available on Pro and Premium plans. Starter accounts can export holdings but not transactions — for that, see Exporting your holdings as CSV, and to unlock transaction exports as well, see Upgrading your subscription.
Generating the export
The button lives on the Transactions History page, alongside the import, sale, and purchase controls.
From the left nav, click Transactions → History.
In the portfolio selector at the top-left of the app, pick the portfolio you want to export. Choose All Portfolios to export every transaction across your account.
Click Export CSV in the top-right of the page.
The browser downloads the file to your default Downloads folder. There's no preview or confirmation step — the file generates and saves in one click.
What's in the file
One row per transaction line — meaning one row per product within a transaction. A buy of 35 American Gold Buffalos in a single purchase is a single row with quantity 35; a buy of one silver bar and one palladium bar on the same day is two rows sharing the same date and dealer.
The header row carries thirteen columns:
Date: The transaction date you entered, in ISO format (e.g. 2026-04-22).
Type: Buy or Sell.
Transaction Name: The optional label you can add to a transaction. Empty when not used.
Dealer: The optional dealer name from the transaction. Empty when not used.
Product: The catalog or custom product name (e.g. American Gold Buffalo 1 oz).
Metal: Gold, Silver, Platinum, or Palladium.
Form: Coin, Bar, Round, or Junk.
Quantity: Number of units in this transaction line.
Price Per Unit (USD): What you paid (or received) per unit on this line.
Spot at Time (USD): The spot price recorded at the moment you saved the transaction. Locked in for life — never recalculated against current spot.
Premium Per Unit (USD): Your over-spot amount per unit on the line. Can be negative on sales below spot.
Line Total (USD): Price Per Unit × Quantity for the line.
Shipping (USD): Any shipping or handling cost entered at the transaction level. Empty when not used.
There's no separate "transaction ID" column and no totals row — this is a flat per-line ledger, suitable for sorting, filtering, or pivoting in whatever tool you bring it into.
How rows are shaped
The flat-line structure matters most when you're trying to read a single transaction that contained multiple products.
One product, one line: A buy of one silver bar at one price is a single row.
Many of one product, one line: A buy of 35 Buffalos at a single price per unit is a single row with Quantity = 35 and Line Total = 35 × price.
Multiple products, multiple lines: A buy of one silver bar and one palladium bar in the same transaction is two rows — same Date, same Type, same Transaction Name and Dealer, different Product / Metal / Form / Price.
Sales follow the same pattern: a sale of three coins from a single sell transaction is one row with Quantity = 3 if the price per unit was uniform.
Each row is independent — the linkage between a sold item and the buy that originally created it isn't surfaced in this export. For that linkage, look at the Annual Report's per-item record instead. See How the Annual Report autofills your data.
Filename and naming
The file downloads with a date-stamped name: transactions-{YYYY-MM-DD}.csv — for example, transactions-2026-05-20.csv. The date is the day you generated the export, not anything to do with the transactions inside it.
If you run multiple exports on the same day, your browser will append a numeric suffix (transactions-2026-05-20 (1).csv, (2).csv, and so on) so nothing gets overwritten.
Currency in the export
Monetary values in the transaction CSV are always in USD, regardless of the display currency you have set on the app. The column headers say so explicitly — Price Per Unit (USD), Spot at Time (USD), and so on.
This is a deliberate exception to the rest of the app, where everything renders in your selected display currency. Transaction exports stay in USD so that:
The exported file is consistent across users on different display currencies.
Importing the same data back via the Bulk Import flow (Premium) doesn't require currency translation. See Bulk upload overview.
A user who changes their display currency between exports doesn't get two non-comparable files for the same data.
If you need the values in another currency for a downstream tool, the conversion is one column-formula away in your spreadsheet of choice — but the file itself ships USD-only.
Opening the CSV
CSV is plain text, so it opens in any spreadsheet or text editor.
Excel and Numbers: Double-clicking the file usually opens it directly with the header row promoted to column headers.
Google Sheets: Use File → Import and pick the CSV; Sheets walks you through column detection.
Accounting tools: Most platforms that accept transaction imports will map the columns directly, though field names may need a one-off translation in the import step.
If a date column lands as plain text in your spreadsheet of choice, format the column as a date and the values resolve. If a numeric column comes in without a $ sign, that's the CSV standard — the numbers themselves are correct.
What this export doesn't include
The transaction CSV captures activity, not inventory. It tells you what you bought and sold; it doesn't tell you what's currently sitting in your stack at the item level, with nicknames and references and per-item annotations.
It also doesn't carry tax classifications — short-term, long-term, gain or loss against each sell. The Annual Report is the right place for that view. See Generating your Annual Report.
Where to go next
Exporting your holdings as CSV: The current-inventory snapshot, available on every plan.
Generating your Annual Report: The Premium tax-ready view of sales activity.
How the Annual Report autofills your data: Where the report's per-item linkage comes from.
Bulk upload overview: Importing transactions back in from a CSV.
