Transaction Spreadsheet Generation Utilities - tsiemens/acb GitHub Wiki

Generating ACB-compatible CSV files can be tedious to do by hand, even with the aid of spreadsheet programs.

This repository provides a few tools that can help generate your spreadsheets more quickly.

tx-export-convert

This tool converts your institution's transaction export spreadsheet/format to the ACB CSV format.

It can also track your foreign currency exchanges (USD only currently. Each cent is counted as one share).

Currently supported platforms

  • Questrade — Excel/XLSX activity export files (.xlsx, .xls)
  • RBC Direct Investing — CSV activity export files (.csv)

The broker format is auto-detected from the file contents.

Features

  • Account filtering (regex-based)
  • Security/symbol filtering (regex-based)
  • FX transaction filtering (--no-fx)
  • USD exchange rate override
  • DRIP/REI transactions
  • Year-based filtering
  • Pretty/text output or CSV output

Questrade DRIP transactions

tx-export-convert supports Questrade dividend reinvestment (REI) rows by converting them to Buy transactions. When Questrade reports a zero price for the reinvestment, the converter derives the effective price from the absolute net amount divided by the share quantity.

Questrade may report DRIP rows with an internal symbol instead of the traded security symbol. In that case, the converter resolves the symbol from a matching security description in a BUY or SELL row from the same export. If no match is available, you can add a "Symbol Rename" from the internal symbol to the canonical symbol name in your configuration (acb-config.json), or include a matching trade row for that security in the export file.

Availability

  • Rust CLI binary (tx-export-convert)
  • Web UI ("Broker Activity Convert" tab)

etrade-plan-pdf-tx-extract

This is a tool for users who have employee stock plans with E*TRADE. It will generate ACB CSV files from a collection of E*TRADE stock plan PDFs and benefit history spreadsheets.

Supported input formats

  • E*TRADE Stock Plan PDFs — Release Confirmations, Exercise Confirmations, ESPP confirmations
  • E*TRADE Trade Confirmation PDFs — both pre-Microsoft and post-Microsoft Morgan Stanley formats
  • E*TRADE Benefit History Excel — XLSX files with "ESPP" or "Restricted Stock" sheets

Features

  • Extracts benefit entries (RSU releases, ESPP, restricted stock) and manual trades
  • Generates sell-to-cover transactions
  • Optional extract-only mode (raw data output)
  • FX transaction generation for manual trades
  • Date filtering by year

Availability

  • Rust CLI binary (etrade-plan-pdf-tx-extract)
  • Web UI ("Broker Activity Convert" tab)