Brokers

ABN AMRO Zelf Beleggen portfolio tracker: benchmark your ABN AMRO Zelf Beleggen portfolio against the S&P 500

We read your ABN AMRO Zelf Beleggen transaction overview and rebuild it as a dated history of purchases, sales, dividends and charges. Investing at ABN AMRO sits inside a bank relationship: the securities have their own overview and the money for them moves through a linked account. That overview holds no time weighted return and no index comparison, and its headings are Dutch, so you point the columns out once and we remember the choice.

What the file contains

A transaction overview from a Dutch bank is a list of events with a date on every row. Expect a row for each order with the number of units and the price, a row for the money that left or entered the account for that order, and separate rows for dividends, for the tax withheld on them and for the charges the bank booked. The instrument is usually identified by its full name and by an ISIN rather than by a ticker.

That shape decides what can be computed. Purchases and sales in sequence give a cost basis; we work on average cost and keep charges as their own amounts so you can see what they took. Dividend rows and the withholding beside them give the income side. Deposits and withdrawals with their exact dates are what makes a like for like index comparison possible, because the comparison replays your own money on your own days.

How the import works for ABN AMRO Zelf Beleggen

ABN AMRO Zelf Beleggen goes through the column mapper. You point at the date, the type, the amount and the quantity column once, we save that mapping to your account, and later uploads from the same broker are read without a question.

We do not print a click path here, because menu names move between releases and a wrong one costs you more time than no one at all. Look for the transaction history or the account statement of your ABN AMRO Zelf Beleggen account and take the machine-readable version of it over the PDF.

The practical work is the range and the account. Take the period from your first order to today rather than the current year, because a purchase that falls outside the file leaves the position it belongs to without an origin. If you hold more than one securities account under the same customer number, export each one separately; two accounts merged from memory is how a ledger quietly stops matching. Keep the file exactly as the bank produced it, since spreadsheet software likes to reformat dates and trim long decimals while it opens.

What to watch for with ABN AMRO Zelf Beleggen files

Two sides of one order. A purchase can show up twice: once as a securities movement and once as the money leaving the account. Counted as two separate things it would double your outflow, so the cash row is tied to its order instead of being read as a fresh deposit.

Dutch dividend tax. Dividends from Dutch listed companies are normally credited after tax has been withheld at source. Where the gross amount and the deduction sit on separate rows, both belong in the file; only counting the net figure understates what the holding produced.

The value on a past date. A broker screen shows today. What a position was worth on a date two years ago comes out of the transaction history, which is what an import gives you.

Charges booked apart. Service fees and custody charges arrive as their own rows and are not folded into the price of an order. They belong in the upload, because a return that ignores them is not the return you actually had.

What you see after the upload

Your file becomes a verdict first: your time-weighted return next to the S&P 500 and the Nasdaq 100 over the same period, with your own deposits replayed into the index so both sides carry the same timing. Under it sit your positions with their cost basis, the dividends you received and the income your holdings are expected to pay, your allocation across positions and currencies, and a year report you can keep for your records.

Because ABN AMRO reports in euros, the dividend total is the first number worth checking, since income rows are the part a shortened export most often leaves behind.

You can look at all of that on the demo portfolio before you upload anything of your own. The first two weeks are free and no card is asked for.

Frequently asked questions

Which overview should I download? Take the overview that lists individual events with dates, not the position snapshot that shows what you hold today. A snapshot carries no history: no purchase prices, no dividends and no deposits, so no return can be derived from it. Where both a spreadsheet file and a PDF are offered, keep the spreadsheet, because a table can be recalculated and a document can only be read.

Do I have to give you my banking login? No. Nothing is connected to your bank. You download a file yourself and hand it over, which means the only thing that reaches us is the history you chose to share and no instruction can ever be sent back the other way. The trade off is that your figures are as recent as your last upload rather than live.

What usually goes wrong the first time? The date range. Bank interfaces tend to open on the current year, and an export that starts in January leaves earlier purchases out. Positions then appear with no origin and sales appear with no matching purchase, which makes the cost basis wrong without any warning at all. Set the start before your first order, and if the range is capped, export year by year and upload every part.

Will your figures match the bank's own performance number? Close, but not to the cent in every case. Banks differ on which cost basis method they apply and on whether charges sit inside the purchase price or beside it. We use average cost, keep fees as separate amounts and show the rows underneath, so a difference can be traced back to one transaction instead of staying a mystery.