TD Canada Trust CSV to Beancount
Convert an EasyWeb accountactivity.csv into balanced double-entry Beancount transactions — the file has no header row at all, and its separate withdrawal and deposit columns are already mapped.
Column mapping verified against a real TD Canada Trust export
How to export your TD Canada Trust transactions
- 1
Log in to EasyWeb, open the Accounts page and select the account you want to download.
- 2
On the Account Activity page, choose the period to cover — 30, 60, 90 or 120 days, or a single month under Search by Month.
- 3
Scroll to the bottom, pick “Spreadsheet (.CSV)” from the dropdown beside Download, then click Download. The file arrives named accountactivity.csv.
- 4
Paste the whole file below. There is no header line to look for and no banner row to delete.
No header row — and left to guess, a converter reads every deposit as spending
TD's EasyWeb export opens straight into data: five bare columns — date, description, money out, money in, running balance — with nothing naming them. A converter left to work it out picks the third column as the amount, which is the withdrawals column, so every withdrawal posts as money in and every deposit is reported as a missing amount; on a real 79-row export that is 33 deposits silently absent from the ledger. This preset assigns the columns by position and maps the withdrawal and deposit pair, so both directions land correctly. One more thing to know before you trust it: this is TD Canada Trust, the Canadian EasyWeb export in Canadian dollars — not TD Bank in the United States, whose export we have not verified.
Beancount output
TD Canada Trust export questions
Is this the same as TD Bank in the United States?
No. Every export this preset was built from is Canadian — balances in Canadian dollars, TD VISA and Interac e-Transfer descriptions — and it is the file EasyWeb calls accountactivity.csv. TD Bank in the United States is a different institution, and we have not verified what its download looks like. If your file has a header row, or a different number of columns, use the generic converter and map the columns yourself instead of trusting this page.
Why are my descriptions padded with spaces in the middle?
Because TD writes them that way. The description field is fixed-width, so a payee and its reference number are separated by however many spaces it takes to fill the field. The converter trims the trailing run and leaves the padding inside, which keeps each narration identical to the bank's own record — useful when you are reconciling against EasyWeb on screen. Collapse the runs of spaces with a search and replace afterwards if you prefer them tidy.
EasyWeb won't offer me a CSV for my credit card.
That is a TD limitation rather than a converter one: the spreadsheet download is offered on chequing and savings accounts, and several TD cards give you nothing but PDF statements. When there is no CSV to download there is nothing for this page to read. Either enter those card transactions by hand, or export the card from whatever tool you already use and map its columns on the generic converter.
Keep the ledger you just converted
Beancount.io hosts your plain-text ledger, imports future statements for you, and keeps every number auditable.
Start Free→