Saventa

Importing & exporting data

Instead of typing history in by hand, you can import broker statements and account exports, and export your portfolios back out as files. Imports are started from the planner's import menu; exports live on the planner header, the portfolio card menus, and the portfolio detail page's Actions menu.

Supported import sources

The built-in importers understand statements from:

  • Trading 212
  • XTB
  • Tradeville
  • Binance (crypto — upload both exports from the Data Download Center: Asset History → Transaction History and Trade History → Spot, as CSV covering your full date range. Either order works. Stablecoin balances are treated as cash, so the portfolio is kept in USD; rewards and airdrops arrive without a price and are valued from stored market history)
  • Interactive Brokers (upload the Activity Statement as CSV, from Performance & Reports → Statements → Activity. No Flex Query setup needed — the standard statement carries trades, dividends, withholding tax, fees, interest and your deposits and withdrawals. Currency conversions between your own IBKR balances are skipped, and instruments the app does not model — options, futures, bonds — are listed in the preview rather than imported as shares)
  • eToro (upload the Account Statement workbook exactly as eToro gives it — Settings → Account Statement → XLS. No need to open it or convert a sheet to CSV first. Positions, dividends, fees, deposits and withdrawals all come from it; currency conversions between eToro's own wallets are skipped, since that money never left)
  • DEGIRO (upload Account.csv, the full account statement — DEGIRO also offers a Transactions.csv that holds trades only and will import nothing). Trades, dividends, withholding tax, fees, interest and your deposits and withdrawals all come from that one file. Transfers between DEGIRO's own accounts (the flatex sweep) are skipped, since that money never left
  • Coinbase (crypto — the transaction history CSV. Conversions are recorded as both halves, staking and reward payouts are summed into one entry per month, and stablecoin balances are treated as cash rather than as a position)
  • Kraken (crypto — export the ledgers CSV, not the trades one; only the ledgers file carries your deposits, withdrawals, staking and fees. A trade is stored there as two rows and is reassembled automatically, and staked balances are matched back to the coin they belong to)
  • Revolut — one source per product, because Revolut exports each separately and they belong in different categories: Revolut Invest (brokerage), Revolut Crypto (crypto), Revolut Funds (savings — the Flexible Cash Funds statement) and Revolut Savings (savings — the interest-account statement). Upload the CSV for one product at a time. Revolut posts staking rewards, fund returns and savings interest every day, so those are summed into one entry per month to keep your history readable; your own deposits, withdrawals and trades are always kept exactly as they happened. The Savings statement is exported in your Revolut app's language, and is read correctly in any of them
  • EstateGuru (lending — accepts the payments CSV, optionally together with the portfolio roster CSV; each loan becomes a tracked deposit with its status)
  • Lofty AI (properties)
  • Pilon 2 (Romanian Pillar II pension statements)
  • This app (export file) — files previously exported from the app, for a lossless round-trip
  • Any other spreadsheet or CSV via a custom import format you set up once (below)

How an import works

  1. Pick the source and upload the file(s). Multiple files are supported, and a single upload can contain several portfolios (each becomes its own portfolio).
  2. A preview shows what was parsed: number of entries, detected currency, and how many portfolios will be created — nothing is saved yet.
  3. Confirm to import. Large imports run in the background with a per-portfolio progress bar; you can keep using the app meanwhile.

Broker sources suggest a sensible category automatically (brokers including DEGIRO, eToro and Interactive Brokers → Brokerage, Binance, Coinbase, Kraken and Revolut Crypto → Crypto, Revolut Funds and Revolut Savings → Savings, EstateGuru → Lending, Lofty AI → Properties, Pilon 2 → Pension).

To bring an existing portfolio up to date with a newer statement, use Reimport from the portfolio detail page's Actions menu, or from the Holdings tab — the app diffs the file against what is already recorded instead of duplicating it. A reimport also fills in prices that were missing the first time round: crypto rewards imported before the coin's market history was available get their value backfilled rather than staying at zero.

Custom import formats

For anything the built-in importers don't cover, set up your own import format (Import → Custom, at /import/custom): pick the portfolio category it is for, upload the file, check the columns the app matched, and preview the result before importing into a new or existing portfolio. Formats are saved and reusable, so a statement you receive every month only needs setting up once.

The chosen category shapes what the file can be read as, so every kind of portfolio can be imported — not just entries:

  • Savings and Cash — dated contribution and withdrawal rows.
  • Brokerage, Crypto and fund pensions — buys, sells, dividends and stock splits, plus standalone cash rows like fees, interest, taxes, currency conversions and transfers.
  • Deposits & Bonds and Lending — one deposit or loan per row: principal, start/end date, term, interest rate, and for loans also status, country and outstanding amounts.
  • Properties, Other Assets and manually-valued pensions — dated value history points (the latest becomes the current value), and for properties also rent history.

An import always targets the format's category: creating a new portfolio uses it directly, and importing into an existing portfolio requires the categories to match.

The first mapping

Most files are one table with a header row, so the builder does the first pass for you: on upload it marks the table for you and matches the header names to fields — "Time" to the date, "Total" to the value, "No. of shares" to the quantity, and so on — then classifies the values in your action column ("Market buy" becomes a buy, "Interest on cash" becomes interest). English, Romanian and German headers are recognised. Everything it guessed is marked with a ✨, so you confirm the mapping instead of building it from scratch; anything it wasn't sure about is set to Ignore and flagged, and you can clear the whole guess and map by hand at any time.

The preview runs as you map. It lists any rows that would be skipped and why (an unreadable date, an empty amount, an action value that isn't in your mapping) with their row numbers, and shows the first rows exactly as they would be imported, with a breakdown that adds up to the headline number. If a mapping is wrong, this is where you see it — not weeks later when the totals look off.

You can save the format as soon as it has a name and a category; the portfolio currency is only needed when you actually import. Row, range and sheet settings are filled in from the file and tucked behind Rows, range & sheet — open it only if a table starts somewhere unexpected.

If your broker changes the file. A saved format remembers the header row it was built against. If a later export moves a column — because one was inserted, or the columns were reordered — the app finds it again by its name and re-points the mapping for you, telling you what moved so you can save the format with the new layout. Only a column that was renamed or removed can't be found that way; then the preview warns you rather than quietly importing the wrong values.

Exporting

  • One portfolio — CSV or Excel, from the portfolio detail page's Actions menu or the planner card menu.
  • Several or all portfolios — from the planner header or selection toolbar: a zip (one CSV per portfolio) or a single Excel workbook (one sheet per portfolio), with an optional summary sheet in a currency of your choice. Multi-portfolio exports run in the background with a progress bar.

Round-trip

Files exported from the app re-import losslessly via the This app (export file) source — no currency, category or name to pick, since the file describes itself. The round-trip restores income settings, deposit renewal chains, and goals (including net-worth goals in a full export), skipping duplicates, so it doubles as a backup format.