Documentation

Transactions

Add, edit, filter, summarize, batch-edit, and export the gold and silver ledger.

The transaction ledger is the record behind every portfolio value and weight. Each row is a buy or sell of gold or silver, with its own weight, purity, price, currency, vault, and optional lot.

Add a transaction

Open Transactions and choose New transaction.

  1. Select the metal, purity, and gross weight.
  2. Choose Grams or Troy Oz for the entry unit.
  3. Check the calculated Net Weight (g).
  4. Set the date and time and choose Buy or Sell.
  5. Choose the currency and enter the total paid. For a sale, enter the total received.
  6. Enter the commission or premium, if any.
  7. Choose the vault and add an optional location and lot ID.
  8. Review the net-rate preview and save.

The preview shows net weight, net rate per gram, and purity. The net rate is the total paid minus commission, divided by net weight.

Net weight is gross weight multiplied by the purity factor and rounded to the nearest gram.

Purity options

Gold:

  • 24k (.999 fine)
  • 22k (.916 fine)
  • 18k (.750 fine)
  • 14k (.583 fine)

Silver:

  • .9999 fine
  • .999 fine
  • .995 fine
  • .925 sterling

Vaults and lots

The vault list covers common storage options, including Physical, Bank Locker, BullionVault, and several professional vault providers. Pick the closest match; imported or older rows can use a custom value.

Location is free text, such as a shelf or drawer. Lot ID is an optional label for grouping related purchases. You can set or clear lot IDs later in bulk.

Edit or delete a transaction

  • Choose the pencil icon in a row to open it in the same form. Save changes with Save Changes.
  • To delete, select one or more rows and use Delete Selected. A confirmation is required.
  • Deleting a row recalculates holdings, charts, and summaries immediately.

Editing a transaction changes its stored values, not just its display. The transaction remains encrypted on the server.

Filter the ledger

The filter card shows how many rows match out of the full ledger.

Date

Use 1W, MTD, 30D, or YTD for a quick range, or drag the two handles on the date slider. The slider has one stop per year before the current year and one stop per month in the current year.

Metal

Use the Gold and Silver checkboxes to include or exclude each metal.

By Lot

Enter a regular expression to match lot IDs. Matching is case-insensitive.

  • LOT-A|LOT-B matches either lot.
  • GOLD-\d+ matches lot IDs such as GOLD-12.
  • Clicking a lot link in the table or a lot card adds or removes that exact lot from the pattern.
  • An invalid expression shows Invalid regular expression and matches nothing.

Location

Enter a regular expression to match the free-text location field, for example London|Zurich.

Vault

Use the vault checkboxes to include specific vaults. Choose All to clear the vault selection.

Reset

Reset restores the full date range, both metals, no lot or location pattern, and all vaults. It does not change the sort order or selected rows.

Read the filtered totals

The Filtered totals panel summarizes only the rows that match the current filters.

For each metal with activity, it shows:

  • Net weight and the bought/sold split.
  • Total premium in your display currency.
  • Average net cost per gram and per troy ounce in USD.
  • For silver, average net cost per kilogram in your display currency.
  • Average premium per gram or kilogram.
  • Buy and sell transaction counts.

The USD per troy ounce figures are useful for comparing purchases made in different currencies. Other money values use your display currency.

Vault and lot breakdowns

Two collapsible sections group the filtered ledger by custody and by lot.

  • Vault breakdown opens by default. It groups by metal and vault.
  • Lot breakdown starts collapsed. It groups by lot ID and can show mixed-metal lots.

Each card shows net weight, value at spot, net cost, profit, and buy/sell statistics. Net cost here means buys minus sells, and profit means value at spot minus that net cost. It is a simple cash comparison, not a realised-gain or tax calculation.

Click a lot card or a lot link to add it to the By Lot filter; click again to remove it.

Work with the table

The ledger table shows:

  • Date, vault, metal, type, net weight in grams and troy ounces, purity, premium, premium percentage, total paid, net amount, and net rate.
  • Calculated columns in your display currency and USD per troy ounce.
  • Lot and location.
  • Row numbers that continue across pages.

Click a sortable column header to sort; click again to reverse the direction. Change Rows to show 50 or 100 entries per page.

Batch actions

Select rows with the checkboxes. The header checkbox selects every row that matches the current filters, not just the visible page.

The batch bar can:

  • Set the same Lot ID on all selected rows.
  • Clear Lot Id from all selected rows.
  • Delete Selected after confirmation.
  • Cancel the selection.

Export to CSV

The download icon exports the current filtered rows to a CSV file. The file is named from your email address and the export date.

The export uses the same columns as the generic CSV import:

date,type,weight,metal,total_cost,currency,premium_paid,purity,vault,location

That makes it re-importable, with two intentional omissions:

  • Lot ID is not included.
  • BullionVault deal ID is not included, so exported BullionVault rows lose deal-level duplicate protection if re-imported.

The export contains only the rows matching the filters, so clear filters first if you want the whole ledger.

What the ledger does not do

The ledger shows weight, value at spot, and simple cost comparisons. It does not produce realised-gain reports, tax reports, or average-cost/FIFO tax-lot accounting.

← All guides