# 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
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:38:03
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. AUD FX/cost base not yet captured from broker confirmation/accountant-preferred FX source.


# 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.


