# import_batches

imported_at: 2026-05-21 22:38:03
source_path: source-documents/2026-05-21-amzn-buy/stake-amzn-buy-screenshot.jpg
source_sha256: 51885cdeec1a485c294de9aa046f4476a918a4a25be0a7e7ae1b5cae20bc2c58
notes:
Manual capture from Telegram screenshot supplied by Michael on 2026-05-22; AMZN Stake SMSF buy order.


# transactions

transaction_id: 2026-05-07-NDQ-BUY-001
status: executed
asset_class: equity
instrument_type: ETF
market: ASX
ticker: NDQ
name: BetaShares NASDAQ 100 ETF
side: buy
order_type: limit
trade_datetime: 2026-05-07 15:40
timezone: Australia/Sydney
trade_date: 2026-05-07
financial_year: 2025-26
quantity: 429
price_currency: AUD
price: 58.16
gross_currency: AUD
gross_amount: 24950.64
brokerage_currency: AUD
brokerage_and_gst: 3.00
total_currency: AUD
total_cash_amount: 24953.64
total_cash_amount_aud: 24953.64
broker: Stake
account: SMSF
source_document: ../source-documents/2026-05-07-ndq-buy/stake-ndq-buy-confirmation.jpg
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
First recorded actual SMSF investment transaction. Settlement date/contract note reference not yet captured.


transaction_id: 2026-05-07-GOOGL-BUY-001
status: executed
asset_class: equity
instrument_type: share
market: NASDAQ
ticker: GOOGL
name: Alphabet Inc Class A
side: buy
order_type: limit
trade_datetime: 2026-05-07 17:31
timezone: America/New_York
trade_date: 2026-05-07
financial_year: 2025-26
quantity: 12
price_currency: USD
price: 396.20
gross_currency: USD
gross_amount: 4754.40
brokerage_currency: USD
brokerage_and_gst: 3.00
total_currency: USD
total_cash_amount: 4757.40
total_cash_amount_aud: 6571.79
fx_rate_to_aud: 1.3813833726
broker: Stake
account: SMSF
source_document: ../source-documents/2026-05-08-us-buys/purchase-1.jpg
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Extracted from purchase screenshot; trade time shown as NY time. Definitive FX applied from Stake deposit confirmation: A$1 = US$0.723912 (US$1 = A$1.3813833726); AUD equivalent of total cash amount = A$6571.79. Source: ../source-documents/2026-05-08-us-fx/stake-fx-deposit-confirmation.jpg; see transactions/fx-rate-notes.md.


transaction_id: 2026-05-07-TSLA-BUY-001
status: executed
asset_class: equity
instrument_type: share
market: NASDAQ
ticker: TSLA
name: Tesla Inc
side: buy
order_type: limit
trade_datetime: 2026-05-07 17:44
timezone: America/New_York
trade_date: 2026-05-07
financial_year: 2025-26
quantity: 8
price_currency: USD
price: 408.00
gross_currency: USD
gross_amount: 3264.00
brokerage_currency: USD
brokerage_and_gst: 3.00
total_currency: USD
total_cash_amount: 3267.00
total_cash_amount_aud: 4512.98
fx_rate_to_aud: 1.3813833726
broker: Stake
account: SMSF
source_document: ../source-documents/2026-05-08-us-buys/purchase-2.jpg
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Extracted from purchase screenshot; trade time shown as NY time. Definitive FX applied from Stake deposit confirmation: A$1 = US$0.723912 (US$1 = A$1.3813833726); AUD equivalent of total cash amount = A$4512.98. Source: ../source-documents/2026-05-08-us-fx/stake-fx-deposit-confirmation.jpg; see transactions/fx-rate-notes.md.


transaction_id: 2026-05-07-NVDA-BUY-001
status: executed
asset_class: equity
instrument_type: share
market: NASDAQ
ticker: NVDA
name: NVIDIA Corp
side: buy
order_type: limit
trade_datetime: 2026-05-07 17:39
timezone: America/New_York
trade_date: 2026-05-07
financial_year: 2025-26
quantity: 22
price_currency: USD
price: 211.50
gross_currency: USD
gross_amount: 4653.00
brokerage_currency: USD
brokerage_and_gst: 3.00
total_currency: USD
total_cash_amount: 4656.00
total_cash_amount_aud: 6431.72
fx_rate_to_aud: 1.3813833726
broker: Stake
account: SMSF
source_document: ../source-documents/2026-05-08-us-buys/purchase-3.jpg
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Extracted from purchase screenshot; trade time shown as NY time. Definitive FX applied from Stake deposit confirmation: A$1 = US$0.723912 (US$1 = A$1.3813833726); AUD equivalent of total cash amount = A$6431.72. Source: ../source-documents/2026-05-08-us-fx/stake-fx-deposit-confirmation.jpg; see transactions/fx-rate-notes.md.


transaction_id: 2026-04-28-BTC-BUY-001
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-28 21:31
timezone: Australia/Sydney
trade_date: 2026-04-28
financial_year: 2025-26
quantity: 0.0208216575
price_currency: AUD
price: 106833.83383383384
gross_currency: AUD
gross_amount: 2222.23
brokerage_currency: AUD
brokerage_and_gst: 2.22
total_currency: AUD
total_cash_amount: 2224.46
total_cash_amount_aud: 2224.46
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$106727; fee 2.224457497499981 AUD incl GST; GST A$0.20. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-28-BTC-BUY-002
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-28 21:31
timezone: Australia/Sydney
trade_date: 2026-04-28
financial_year: 2025-26
quantity: 0.2131866
price_currency: AUD
price: 106833.83383383382
gross_currency: AUD
gross_amount: 22752.77
brokerage_currency: AUD
brokerage_and_gst: 22.78
total_currency: AUD
total_cash_amount: 22775.54
total_cash_amount_aud: 22775.54
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$106727; fee 22.775541800000266 AUD incl GST; GST A$2.07. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-27-BTC-BUY-003
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-27 08:43
timezone: Australia/Sydney
trade_date: 2026-04-27
financial_year: 2025-26
quantity: 0.15083224676999998
price_currency: AUD
price: 109849.84984984987
gross_currency: AUD
gross_amount: 16552.33
brokerage_currency: AUD
brokerage_and_gst: 16.57
total_currency: AUD
total_cash_amount: 16568.90
total_cash_amount_aud: 16568.90
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$109740; fee 16.568899660201367 AUD incl GST; GST A$1.51. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-27-BTC-BUY-004
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-27 08:43
timezone: Australia/Sydney
trade_date: 2026-04-27
financial_year: 2025-26
quantity: 0.00018126855
price_currency: AUD
price: 109849.58957303957
gross_currency: AUD
gross_amount: 19.89
brokerage_currency: AUD
brokerage_and_gst: 0.02
total_currency: AUD
total_cash_amount: 19.91
total_cash_amount_aud: 19.91
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$109739.74; fee 0.01991227582299942 AUD incl GST; GST A$0.00. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-27-BTC-BUY-005
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-27 08:41
timezone: Australia/Sydney
trade_date: 2026-04-27
financial_year: 2025-26
quantity: 0.01526480991
price_currency: AUD
price: 109796.27627606665
gross_currency: AUD
gross_amount: 1674.34
brokerage_currency: AUD
brokerage_and_gst: 1.68
total_currency: AUD
total_cash_amount: 1676.02
total_cash_amount_aud: 1676.02
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$109686.48; fee 1.6760192861831964 AUD incl GST; GST A$0.15. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-27-BTC-BUY-006
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-27 08:41
timezone: Australia/Sydney
trade_date: 2026-04-27
financial_year: 2025-26
quantity: 0.062069078789999996
price_currency: AUD
price: 109796.2762762634
gross_currency: AUD
gross_amount: 6808.14
brokerage_currency: AUD
brokerage_and_gst: 6.81
total_currency: AUD
total_cash_amount: 6814.95
total_cash_amount_aud: 6814.95
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$109686.48; fee 6.8149537230411825 AUD incl GST; GST A$0.62. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-26-BTC-BUY-007
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-26 09:04
timezone: Australia/Sydney
trade_date: 2026-04-26
financial_year: 2025-26
quantity: 0.018566075339999998
price_currency: AUD
price: 109313.0130129053
gross_currency: AUD
gross_amount: 2027.48
brokerage_currency: AUD
brokerage_and_gst: 2.03
total_currency: AUD
total_cash_amount: 2029.51
total_cash_amount_aud: 2029.51
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$109203.7; fee 2.0295136352421244 AUD incl GST; GST A$0.18. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-26-BTC-BUY-008
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-26 09:04
timezone: Australia/Sydney
trade_date: 2026-04-26
financial_year: 2025-26
quantity: 0.01648345005
price_currency: AUD
price: 109200.44041386833
gross_currency: AUD
gross_amount: 1798.20
brokerage_currency: AUD
brokerage_and_gst: 1.80
total_currency: AUD
total_cash_amount: 1800.00
total_cash_amount_aud: 1800.00
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$109091.24; fee 1.800000005437835 AUD incl GST; GST A$0.16. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-26-BTC-BUY-009
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-26 09:04
timezone: Australia/Sydney
trade_date: 2026-04-26
financial_year: 2025-26
quantity: 0.07342649999999999
price_currency: AUD
price: 109194.98041837757
gross_currency: AUD
gross_amount: 8009.79
brokerage_currency: AUD
brokerage_and_gst: 8.02
total_currency: AUD
total_cash_amount: 8017.81
total_cash_amount_aud: 8017.81
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$109085.785438; fee 8.01780522969345 AUD incl GST; GST A$0.73. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-26-BTC-BUY-010
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-26 09:04
timezone: Australia/Sydney
trade_date: 2026-04-26
financial_year: 2025-26
quantity: 0.02233872891
price_currency: AUD
price: 109109.10910910911
gross_currency: AUD
gross_amount: 2434.92
brokerage_currency: AUD
brokerage_and_gst: 2.44
total_currency: AUD
total_cash_amount: 2437.36
total_cash_amount_aud: 2437.36
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$109000; fee 2.437358809999894 AUD incl GST; GST A$0.22. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-26-BTC-BUY-011
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-26 09:04
timezone: Australia/Sydney
trade_date: 2026-04-26
financial_year: 2025-26
quantity: 0.07121314557
price_currency: AUD
price: 109108.1081081081
gross_currency: AUD
gross_amount: 7762.16
brokerage_currency: AUD
brokerage_and_gst: 7.77
total_currency: AUD
total_cash_amount: 7769.93
total_cash_amount_aud: 7769.93
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$108999; fee 7.769931585569862 AUD incl GST; GST A$0.71. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-26-BTC-BUY-012
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-26 09:02
timezone: Australia/Sydney
trade_date: 2026-04-26
financial_year: 2025-26
quantity: 0.0045953999999999995
price_currency: AUD
price: 109019.01901901903
gross_currency: AUD
gross_amount: 500.49
brokerage_currency: AUD
brokerage_and_gst: 0.50
total_currency: AUD
total_cash_amount: 500.99
total_cash_amount_aud: 500.99
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$108910; fee 0.5009860000000476 AUD incl GST; GST A$0.05. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-26-BTC-BUY-013
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-26 09:01
timezone: Australia/Sydney
trade_date: 2026-04-26
financial_year: 2025-26
quantity: 0.01723913361
price_currency: AUD
price: 108866.86686686688
gross_currency: AUD
gross_amount: 1874.89
brokerage_currency: AUD
brokerage_and_gst: 1.88
total_currency: AUD
total_cash_amount: 1876.77
total_cash_amount_aud: 1876.77
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$108758; fee 1.876770463620137 AUD incl GST; GST A$0.17. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-26-BTC-BUY-014
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-26 08:59
timezone: Australia/Sydney
trade_date: 2026-04-26
financial_year: 2025-26
quantity: 0.00439487073
price_currency: AUD
price: 108808.80880880881
gross_currency: AUD
gross_amount: 477.72
brokerage_currency: AUD
brokerage_and_gst: 0.48
total_currency: AUD
total_cash_amount: 478.20
total_cash_amount_aud: 478.20
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$108700; fee 0.4782006490000223 AUD incl GST; GST A$0.04. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-25-BTC-BUY-015
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-25 09:03
timezone: Australia/Sydney
trade_date: 2026-04-25
financial_year: 2025-26
quantity: 0.22547650778999997
price_currency: AUD
price: 108707.95795794688
gross_currency: AUD
gross_amount: 24486.58
brokerage_currency: AUD
brokerage_and_gst: 24.51
total_currency: AUD
total_cash_amount: 24511.09
total_cash_amount_aud: 24511.09
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$108599.25; fee 24.511090729343767 AUD incl GST; GST A$2.23. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-25-BTC-BUY-016
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-25 09:00
timezone: Australia/Sydney
trade_date: 2026-04-25
financial_year: 2025-26
quantity: 0.00450841707
price_currency: AUD
price: 108464.43443396862
gross_currency: AUD
gross_amount: 488.51
brokerage_currency: AUD
brokerage_and_gst: 0.49
total_currency: AUD
total_cash_amount: 489.00
total_cash_amount_aud: 489.00
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$108355.97; fee 0.4890029076920645 AUD incl GST; GST A$0.04. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-24-BTC-BUY-017
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-24 06:07
timezone: Australia/Sydney
trade_date: 2026-04-24
financial_year: 2025-26
quantity: 0.21681992304
price_currency: AUD
price: 109634.83483482561
gross_currency: AUD
gross_amount: 23747.25
brokerage_currency: AUD
brokerage_and_gst: 23.77
total_currency: AUD
total_cash_amount: 23771.02
total_cash_amount_aud: 23771.02
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$109525.2; fee 23.771016451391993 AUD incl GST; GST A$2.16. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-24-BTC-BUY-018
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-24 06:03
timezone: Australia/Sydney
trade_date: 2026-04-24
financial_year: 2025-26
quantity: 0.01122795081
price_currency: AUD
price: 109434.42442459366
gross_currency: AUD
gross_amount: 1227.50
brokerage_currency: AUD
brokerage_and_gst: 1.23
total_currency: AUD
total_cash_amount: 1228.72
total_cash_amount_aud: 1228.72
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$109324.99; fee 1.2287243343580785 AUD incl GST; GST A$0.11. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-23-BTC-BUY-019
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-23 17:24
timezone: Australia/Sydney
trade_date: 2026-04-23
financial_year: 2025-26
quantity: 0.22638313026
price_currency: AUD
price: 109549.54954954954
gross_currency: AUD
gross_amount: 24775.37
brokerage_currency: AUD
brokerage_and_gst: 24.80
total_currency: AUD
total_cash_amount: 24800.17
total_cash_amount_aud: 24800.17
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$109440; fee 24.800169945599393 AUD incl GST; GST A$2.25. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-04-23-BTC-BUY-020
status: executed
asset_class: crypto
instrument_type: cryptocurrency
market: BTC/AUD
ticker: BTC
name: Bitcoin
side: buy
order_type: market/order-history
trade_datetime: 2026-04-23 17:23
timezone: Australia/Sydney
trade_date: 2026-04-23
financial_year: 2025-26
quantity: 0.00182410407
price_currency: AUD
price: 109549.54954954954
gross_currency: AUD
gross_amount: 199.63
brokerage_currency: AUD
brokerage_and_gst: 0.20
total_currency: AUD
total_cash_amount: 199.83
total_cash_amount_aud: 199.83
broker: CoinSpot
account: SMSF
source_document: ../source-documents/2026-05-08-btc-orderhistory/orderhistory.csv
created_at: 2026-05-14 10:34:36
updated_at: 2026-05-14 10:34:36
notes:
Imported from BTC/AUD order history CSV. Rate ex fee A$109440; fee 0.19982977919999714 AUD incl GST; GST A$0.02. Broker/exchange confirmed by Michael as CoinSpot; bank transfer records captured separately for audit trail.


transaction_id: 2026-05-21-AMZN-BUY-001
status: executed
asset_class: equity
instrument_type: share
market: NASDAQ
ticker: AMZN
name: Amazon.com Inc
side: buy
order_type: limit
trade_datetime: 2026-05-21 06:25
timezone: America/New_York
trade_date: 2026-05-21
financial_year: 2025-26
quantity: 18
price_currency: USD
price: 265.50
gross_currency: USD
gross_amount: 4779.00
brokerage_currency: USD
brokerage_and_gst: 3.00
total_currency: USD
total_cash_amount: 4782.00
total_cash_amount_aud: 6605.78
fx_rate_to_aud: 1.3813833726
broker: Stake
account: SMSF
source_document: source-documents/2026-05-21-amzn-buy/stake-amzn-buy-screenshot.jpg
created_at: 2026-05-21 22:38:03
updated_at: 2026-05-21 22:41:52
notes:
Extracted from purchase screenshot supplied 2026-05-22; trade time shown as NY time. Regulatory fees shown as US$0.00. Trade confirmation noted as available T+1. Michael confirmed on 2026-05-22 that AMZN used leftover USD from the original Stake transfer into the trading account, so the same FX rate from the original Stake deposit confirmation is used for AUD cost base: A$1 = US$0.723912 / US$1 = A$1.3813833726. AUD equivalent total cash amount = A$6605.78.


# trade_lots

transaction_id: 2026-05-21-AMZN-BUY-001
lot_id: LOT-2026-05-21-AMZN-BUY-001
asset_class: equity
ticker: AMZN
name: Amazon.com Inc
acquisition_date: 2026-05-21
quantity_acquired: 18
quantity_remaining: 18
native_currency: USD
native_cost_base: 4782.00
aud_cost_base: 6605.78
broker: Stake
account: SMSF
notes:
AUD cost base uses the original Stake USD transfer FX per Michael confirmation on 2026-05-22; US$4782.00 × 1.3813833726 = A$6605.78.


# fx_rates

fx_id: 2026-05-08-STAKE-USD-AUD-ORIGINAL-TRANSFER
rate_date: 2026-05-08
from_currency: USD
to_currency: AUD
rate: 1.3813833726
source: Stake deposit confirmation / Michael confirmation
source_document: source-documents/2026-05-08-us-fx/stake-fx-deposit-confirmation.jpg
notes:
Reused for AMZN 2026-05-21 purchase because Michael confirmed funds were leftover USD from the same original transfer into Stake.


# source_documents

path: source-documents/2026-05-21-amzn-buy/stake-amzn-buy-screenshot.jpg
doc_type: screenshot/image
sha256: 51885cdeec1a485c294de9aa046f4476a918a4a25be0a7e7ae1b5cae20bc2c58
captured_date: 2026-05-22
description: Stake AMZN buy execution screenshot supplied by Michael
notes: Original inbound Telegram image preserved as audit evidence.
created_at: 2026-05-21 22:38:03
ocr_text:
AMZN; -US$4,782.00; Order type: Limit buy; Executed at: 21 May 2026, 6:25am NY; Executed quantity: 18; Limit price: $265.50; Effective price: $265.50; Trade value: $4,779.00; Brokerage: $3.00; Regulatory fees: $0.00; Total value: $4,782.00; Trade confirmation available T+1.


# decisions

decision_date: 2026-05-14
topic: SMSF record keeping
source: Telegram discussion
notes: No original files deleted or moved.
decision:
Create SQLite database as canonical structured ledger while preserving existing CSV/Markdown/source documents.


decision_date: 2026-05-08
topic: US trade FX rate
source: transactions/fx-rate-notes.md
decision:
Use Stake deposit confirmation rate A$1 = US$0.723912 / US$1 = A$1.3813833726 for initial US purchases unless accountant advises otherwise.


# audit_log

event_time: 2026-05-21 22:38:03
event_type: insert
entity_type: transaction
entity_id: 2026-05-21-AMZN-BUY-001
details:
Added AMZN US share purchase from Michael Telegram screenshot; backup created at backups/pre-amzn-buy-20260522-083803.sqlite


event_time: 2026-05-21 22:39:04
event_type: update
entity_type: view
entity_id: v_holdings/v_financial_year_summary
details:
Adjusted AUD rollups so non-AUD transactions with pending FX remain NULL rather than coalescing native currency into AUD.


event_time: 2026-05-21 22:39:13
event_type: update
entity_type: view
entity_id: v_financial_year_summary
details:
AUD summary now returns NULL for a grouped AUD total when any non-AUD transaction in the group is still missing FX.


event_time: 2026-05-21 22:41:52
event_type: update
entity_type: transaction
entity_id: 2026-05-21-AMZN-BUY-001
details:
Applied original Stake transfer FX rate 1.3813833726; total AUD cost base 6605.78; backup backups/pre-amzn-fx-update-20260522-084152.sqlite


