Portfolio trackers usually fail in one of seven ways: prices go stale, cost and returns are worked out wrongly, the same holding gets counted twice, whole parts of your wealth (property, loans, pensions, insurance) are missing, foreign currency is converted badly, you cannot get your data out, or entering data is so tedious that you stop updating it. The good news is that you can test any tracker against all seven in about an hour, with a small sample of your own holdings, before you put your whole financial life into it.
This guide explains each failure, shows the exact test to run, and ends with a one-page checklist you can use on any app or spreadsheet, including ours.
Before you start: build a small test portfolio
Don't judge a tracker from its homepage or a demo with perfect sample data. Pick five to eight real holdings that cover the awkward cases in your life:
- one listed share or ETF you bought in at least two lots at different prices, and sold part of;
- one fund (a mutual fund, unit trust or index fund);
- one holding in a foreign currency;
- one thing without a market price (property, a private company stake, a fixed deposit or CD);
- one loan (a mortgage, car loan or credit card balance);
- one retirement account (401(k), workplace pension, CPF, EPF or similar).
Write down the correct figures for each from your statements first. Then enter or import them, and compare. Every test below uses this list.
1. Stale or wrong prices
What goes wrong: the tracker shows a price that is days or weeks old, or the price of a different share with a similar ticker on another exchange. Bonds, small funds and shares listed outside the US are the usual victims. Your net worth looks precise but is quietly wrong.
How to test it:
- Add a share listed on your home exchange and one listed abroad. Compare the price shown with the exchange's own website or your broker on the same day.
- Add a fund and compare with the fund house's published price (NAV) for the latest date.
- Check whether the app tells you how old a price is. A price with no date is a warning sign.
- For things without a market price, check that you can set the value yourself, and that the app does not invent one.
2. Wrong cost basis and misleading returns
What goes wrong: the tracker loses track of what you paid, especially after several purchases, a partial sale, a stock split or a fund switch. The gain it shows is then wrong, and so is any tax figure built on it. A second problem is the return percentage itself: a simple "gain divided by money put in" ignores when the money went in.
Worked example: cost basis. You buy 10 shares at 100, then 10 more at 120. You have spent 2,200 on 20 shares, an average cost of 110. You then sell 5 shares at 130.
- On an average cost basis, the 5 shares sold cost 550 (5 × 110), so the realised gain is 650 minus 550, which is 100. The remaining 15 shares cost 1,650.
- On a first in, first out (FIFO) basis, the 5 shares sold come from the first lot at 100, so they cost 500 and the realised gain is 150. The remaining 15 shares cost 1,700 (5 at 100 plus 10 at 120).
Neither is "wrong", but your tax rules decide which one you must use, and they differ by country. The US uses FIFO unless you identify the specific lots with your broker when you sell. The UK matches same-day and next-30-day purchases first, then uses an average-cost pool (the "section 104 holding"). India applies FIFO to shares held in a demat account. Singapore generally does not tax individuals on gains from personal investments, and the UAE has no personal income tax. A tracker should tell you which method it uses.
Worked example: returns. You put 1,000 into a fund on 1 January and another 1,000 on 1 December. On 31 December the holding is worth 2,100. The simple return is 100 on 2,000, or 5%. But the second 1,000 was invested for only one month, so the money-weighted annual return (XIRR) is about 9.2%. The two numbers answer different questions. A good tracker either shows the time-aware number or clearly labels which one it shows.
How to test it: enter the two-lot purchase and the partial sale from your test portfolio. Check that the remaining quantity, cost and realised gain match your own calculation, and that the app says which method it uses. Then look at how it labels returns: "total return", "annualised", "XIRR" or nothing at all.
For more on dated returns, see our guide to tracking net worth.
3. Double counting
What goes wrong: the same money appears twice. Common causes:
- importing a fund from a broker statement and again from a fund-house or consolidated statement;
- counting cash in a brokerage account both as cash and inside the account total;
- moving money between accounts and recording it as a new deposit at the other end;
- a joint account added separately by both partners in a family view.
How to test it: import the same statement twice on purpose and see whether the app warns you or creates duplicates. Record a transfer between two of your accounts and check that your net worth does not change. If it rises by the amount of the transfer, the app counts it twice.
4. Missing assets and missing debts
What goes wrong: many trackers are built around listed shares and funds, because those have prices to fetch. Your actual wealth often sits elsewhere: a home, a mortgage, a workplace pension, fixed deposits, gold, a private business, insurance policies. Leave them out and the picture is wrong in both directions.
Worked example. Someone has 150,000 in shares and funds, a flat worth 500,000 and a mortgage of 300,000. Their real net worth is 350,000 (150,000 plus 500,000 minus 300,000).
- A shares-only tracker shows 150,000, less than half the real figure.
- A tracker that lets you add the flat but not the loan shows 650,000, overstating net worth by 300,000.
Retirement planning, emergency cash and asset allocation are all wrong after that.
How to test it: add your property, your loan and your retirement account from the test list. Check that the loan reduces net worth, that you can set and update the property's value yourself, and that the pension shows up in your totals. If insurance matters to your family, check where policies, cover amounts and premium dates can be recorded.
5. Currency conversion errors
What goes wrong: the app adds up holdings in different currencies as if they were one currency, uses an old exchange rate, or converts the purchase cost at today's rate instead of the rate on the day you bought. Anyone with a foreign brokerage account, overseas property, or savings in two countries is affected.
Worked example. You live in Singapore and hold US shares bought for 10,000 US dollars when 1 US dollar was 1.40 Singapore dollars (cost 14,000 SGD). Today they are worth 10,500 US dollars and the rate is 1.30. In US dollars you are up 5%. In Singapore dollars the holding is worth 13,650 SGD, so you are down 2.5%. Both numbers are true. A tracker that shows only "+5%" in a Singapore dollar dashboard is telling you the wrong story.
How to test it: set your display currency, add your foreign holding with its real purchase date and cost, and check the converted value against a published rate for today (your central bank or a major data source). Then check that the gain in your home currency includes the currency move. Our exchange rates tool shows current rates if you need a reference.
6. Data you cannot get out
What goes wrong: after two years of careful entry, the app raises its price, changes direction or shuts down, and your history is stuck inside it. Some apps only export a summary, not the transactions behind it.
How to test it: on day one, export your test portfolio. Open the file. Check that it includes individual transactions with dates, not just today's totals, and that the format (CSV or Excel) opens in an ordinary spreadsheet. Also read how the company handles account deletion and what it does with your data.
7. Abandonment: data entry is too much work
What goes wrong: this is probably the most common failure of all, and it is a human one. A tracker that needs every dividend, fund purchase and bank interest payment typed by hand gets updated for a few weeks, then forgotten. A tracker that is six months out of date is worse than none, because it still looks official.
There are three ways trackers try to fix this, and each has trade-offs:
- Direct account linking through a data provider or open banking. Where it works, it removes most typing. Coverage depends heavily on your country and your institutions, and connections can break.
- Statement import: upload or forward the PDF, CSV or Excel statements your bank and broker already send you. It works across countries, but quality depends on how well the app reads messy statements, and you should be able to review before anything is saved.
- Manual entry, which works for everything but takes discipline. It is fine for things that rarely change, like property values.
How to test it: time yourself. Add your test portfolio using the app's fastest method, then update it a month later with a new statement. If the monthly update takes more than about fifteen minutes, ask honestly whether you will keep doing it for years. For more on statement-based updating, see auto-syncing bank and broker statements by email.
The buyer's checklist
| Check | Pass if |
|---|---|
| Listed prices | Home and foreign listings match the exchange or broker on the same day |
| Fund prices | Latest NAV matches the fund house |
| Unpriced assets | You can set and update the value yourself |
| Cost after two buys and a part sale | Quantity, cost and realised gain match your own sums; the method is stated |
| Return label | The app says whether the return is simple, annualised or money-weighted |
| Duplicate import | The app warns you or lets you merge, rather than doubling the holding |
| Transfer between accounts | Net worth does not change |
| Property and loan | Both can be added; the loan reduces net worth |
| Retirement account | Appears in totals |
| Foreign holding | Converted at a current published rate; home-currency gain includes the currency move |
| Export | CSV or Excel with dated transactions |
| Monthly update | Takes you 15 minutes or less |
Being fair about the options
There is no tracker that is best for everyone. A spreadsheet is free, private and fully under your control, and for a handful of holdings in one currency it may be all you need; it starts to strain with many lots, several currencies and family members. Apps that link directly to your accounts save the most time where your banks and brokers are supported. Broker apps are accurate for what they hold, but only show that one broker. Use the checklist rather than anyone's marketing, ours included. Our portfolio tracker comparison sets out how several tools differ.
How Agni Folio handles each test
So you can check us against the same list, here is what Agni Folio does today:
- Prices: prices for listed shares, ETFs and funds are fetched automatically and refreshed through the day. For property and other things without a market price, you set the value, and you can add a review date to the holding so the app reminds you to update it.
- Cost: you record buys and sells as transactions, and the app recalculates the average cost and keeps realised gains separate from unrealised ones.
- Duplicates: when the same holding ends up in more than one entry, you can merge them. Imported statements are shown for review, and nothing is saved until you confirm.
- Breadth: you can add property, gold, private holdings, fixed deposits, retirement accounts (401(k), CPF, EPF and others) and crypto. Loans, mortgages and credit card debt count as negative net worth. Insurance policies have their own section.
- Currency: each holding keeps its own currency and everything is converted to your one display currency on the server, using exchange rates refreshed daily. See how multi-currency works.
- Export: you can export holdings as Excel or CSV, or download everything as one ZIP file.
- Data entry: you can type entries, upload PDF, CSV or Excel statements, or forward the statements your bank and broker email you. Email import works on the free plan; Premium uses a more accurate AI reader for messy PDFs and scans. Crypto exchanges can be connected with read-only API keys.
You can try it on sample data without signing up in the public demo, then run the checklist on your own test portfolio.
Frequently asked questions
Why is my portfolio tracker showing the wrong value?
The usual causes are a stale price, a holding matched to the wrong exchange or ticker, a missing or duplicated transaction, or a foreign holding converted at the wrong rate. Compare one holding at a time against your statement to find which.
Why does my tracker's return differ from my broker's?
They are probably measuring different things. One may show a simple gain on money put in, the other an annualised or money-weighted return (XIRR) that accounts for when each payment went in. Cost method (average or FIFO) and whether dividends are included also change the figure.
Is a spreadsheet better than a portfolio tracker app?
For a few holdings in one currency, a spreadsheet can be perfectly good. It gets harder with many purchase lots, several currencies, prices to refresh and family members to include. The deciding question is whether you will keep it up to date.
Should a portfolio tracker include my house and mortgage?
If you want your real net worth, yes. Include both, or neither. Adding the house without the mortgage overstates your wealth by the full loan amount.
Is it safe to connect my accounts to a tracker?
Prefer read-only access wherever it is offered, and never give a tracker a key or password that can trade or move money. Check the company's privacy policy, where your data is stored, and how to delete it.
How often should I update my portfolio tracker?
Listed prices should update by themselves. For everything else, a monthly update from your statements and a yearly review of property and other unpriced assets is enough for most people.