Why Colombia makes net worth tracking uniquely hard
In most countries, tracking your net worth is arithmetic: add up what you own, subtract what you owe. In Colombia, the arithmetic keeps changing under you, because your money almost never lives in a single currency. A typical picture looks like this: a Bancolombia account and a couple of CDTs in pesos, an apartment valued in COP, a brokerage account at IBKR holding ETFs in dollars, maybe some crypto, and a pension quietly growing at an AFP.
The first problem is the exchange rate. USD/COP has swung between roughly 3,800 and 5,100 in just a few years. If you keep a spreadsheet in pesos, your net worth “jumps” by tens of millions when the dollar rallies — even if you didn’t earn, save or invest a single peso. Keep it in dollars and the opposite happens: your apartment appears to lose value every time the peso weakens. Either way, the spreadsheet is telling you a story about the exchange rate, not about your money.
Then there are the local quirks. The 4x1000 tax (the GMF) takes 0.4% of most transfers out of your accounts, which quietly punishes moving money around — you can estimate its bite with our 4x1000 calculator. Informal lending is everywhere: the money you lent a cousin or a friend is real wealth, but it never appears on any statement. And your largest asset, finca raíz, appreciates in pesos while your investments compound in dollars — so a naive total is really two different stories glued together.
What a proper multi-currency setup looks like
The fix is not to pick the “right” currency. It’s to stop converting by hand entirely. A setup that works in Colombia has three properties:
Every asset in its native currency. The apartment is worth COP, the ETFs are worth USD, the bitcoin is worth BTC. You record each value once, in the currency it actually trades in, and never touch a conversion rate manually.
Daily conversion to one display currency. The total you look at — COP or USD, your choice — is computed fresh every day at real exchange rates. Switching the display currency changes the lens, never the data.
A way to separate three forces. When your net worth changes, one of three things happened: the market moved, the exchange rate moved, or you added or spent money. Only the third one is fully under your control, and only the first and third are real progress. Guaca’s Back in Time view does exactly this decomposition — scrub to any past date and see how much of the change came from markets, how much from FX, and how much from your own contributions. It’s the difference between “the dollar went up” and “I actually got wealthier.”
If you want a quick baseline before setting anything up, our free net worth calculator gives you the number in a couple of minutes.
What to track: the Colombian checklist
A net worth number is only as honest as its inputs. For someone living in Colombia, the full list usually looks like this:
Bank accounts
Checking and savings at Bancolombia, Davivienda, BBVA, Nequi or Lulo — each balance lives in COP and updates your total daily.
CDTs
Fixed-term deposits are a Colombian staple. Track the principal, the rate and the maturity date so the interest actually shows up in your wealth.
Fiducias
Fiducuentas and collective investment funds (FICs) sit somewhere between cash and investments. Value them at their current unit price, not what you put in.
Pension (AFP)
Your balance at Porvenir, Protección or Colpensiones is real wealth, even if you can't touch it yet. Most people forget to count it.
Real estate
Finca raíz is usually the biggest line item, valued in COP. Revalue it once or twice a year — the avalúo catastral is a floor, not a market price.
Vehicles
Cars and motorcycles depreciate, but they still count. The Fasecolda guide gives you a defensible COP value to update yearly.
USD brokers
IBKR, Schwab or any US brokerage holds ETFs and stocks in dollars. These positions move with the market and with the exchange rate — track both effects.
Crypto
Bitcoin and other coins priced live, whether they sit on Binance or in your own wallet. Volatile, but part of the picture.
Debts and loans
Credit cards, libranza deductions, your mortgage — and money you've lent to family or friends, which is an asset almost nobody writes down.
If CDTs are a big part of your savings, it’s worth checking what they actually yield after tax and inflation — our CDT calculator does that math for current Colombian rates.
Colombian specifics worth knowing
Tracking your net worth in Colombia isn’t just a good habit — parts of the tax system quietly assume you already do it.
The annual declaración de renta asks for your patrimonio: what you owned and what you owed as of December 31. If you’ve been tracking all year, that section takes minutes instead of an afternoon of digging through statements. For high net worth individuals there’s also a wealth tax (impuesto al patrimonio) with thresholds that make knowing your exact number more than a curiosity — crossing one changes what you owe.
And the 4x1000 keeps nibbling in the background. Because it charges 0.4% on most outbound movements, consolidating accounts, paying down debt or rebalancing between banks all carry a small hidden cost. Seen once, it’s trivial; seen as a category in your yearly spending, it’s often a surprisingly large line. A tracker makes these things visible instead of theoretical. (None of this is tax advice — for filings, talk to a Colombian accountant.)
Where Guaca fits in
Guaca was built with first-class Colombian support rather than Colombia as an afterthought. COP is a native currency, not a conversion: every account, CDT, fiducia and property holds its value in pesos, your USD broker and crypto hold theirs in dollars and coins, and everything converts at daily FX rates into whichever display currency you pick.
Statements from Colombian banks import directly — upload the PDF or CSV your bank already sends you, and transactions arrive extracted, categorized and de-duplicated. IBKR and crypto exchanges and wallets sync automatically, so your dollar-side positions stay current without manual updates. Back in Time answers the question this whole guide is about: on any date, how much of the change was market, how much was the exchange rate, and how much was you.
There’s also a retirement planner built specifically for Colombia, with UVT income tax brackets, wealth tax, social security and SMMLV pension rules baked into the projections — you can try the free version at our retirement calculator for Colombia. And because Guaca is local-first, your data lives on your device and syncs encrypted across iPhone, iPad, Mac and the web — no bank passwords to hand over, nothing sold, nothing used for ads.
Frequently asked questions
Should I track my net worth in COP or USD?
Track each asset in its own currency and pick one display currency for the total. Most people in Colombia check the total in COP for day-to-day decisions and flip to USD to judge long-term progress, since the peso's inflation and FX swings can flatter or hide real growth. The important part is that switching the display currency should never change the underlying data.
How do I handle the USD/COP exchange rate?
Use a daily rate (the TRM or a market rate) applied automatically, and never store converted values by hand. A good tracker separates the FX effect from real changes: if your total in COP jumped 3% but the dollar rose 3% against the peso, your wealth didn't actually grow — the rate just moved. Guaca converts everything at daily rates and its Back in Time view splits changes into market moves, FX moves and your own contributions.
Does Guaca work with Colombian banks?
Yes. Colombian banks don't offer open-banking connections for personal apps, so Guaca imports the statements banks already give you: upload a PDF or CSV statement from Bancolombia, Davivienda and other banks, and transactions are extracted, categorized and de-duplicated automatically. Balances, CDTs and fiducias are tracked natively in COP.
What is the 4x1000?
The 4x1000, formally the Gravamen a los Movimientos Financieros (GMF), is a Colombian tax of 0.4% charged on most withdrawals and transfers out of your financial accounts. One account per person can be marked exempt up to a monthly limit. It looks tiny, but if you move money often it quietly adds up — tracking it as its own expense category shows you the real cost.
Is my data private?
Guaca is local-first: your financial data lives on your device and syncs encrypted across iPhone, iPad, Mac and the web. It is visible only to you, is never sold, and is never used for advertising. There are no bank credentials to hand over, since statement imports work from files you already have.
