The columns that matter
In short: the export contains Type, Product, Started Date, Completed Date, Description, Amount, Fee, Currency, State and Balance. You need four of them – Completed Date, Description, Amount and, if you want the full cost, Fee. Product tells you whether a row belongs to your current account or a savings pocket.
Because the delimiter is a comma, a double-click on a Swiss-configured PC often puts everything in column A. Open the file via «Data › From Text/CSV» and choose comma explicitly.
Started or completed – and the state column
«Started Date» is when you triggered a payment, «Completed Date» when it settled. Budget by the completed date; only then has the money really left. Both fields include a time stamp, so import them as date/time.
«State» shows whether a transaction is completed, pending or reverted. Count only completed rows – reverted payments would otherwise stay in your budget as spending although the money came back.
Fees, currencies and top-ups
«Amount» excludes the fee. For the real cost, compute Amount minus Fee per row. Card payments in CHF usually have no fee; weekend exchanges or cash withdrawals above the free limit may.
Top-ups from your Swiss bank account appear twice: as a debit on the bank statement and as a credit at Revolut. If you track both, mark the top-up on one side as a transfer between your own accounts. Currency exchanges inside Revolut are transfers too – your wealth does not change.
- Top-up from bank → transfer
- Exchange CHF to EUR → transfer
- Card payment → expense in its category
Foreign-currency spending in a CHF budget
A CHF budget may only sum francs. For payments made from a euro pocket, convert with the rate of the exchange you made, or keep holidays as one category with a total in CHF. Mixing euro and franc amounts in one sum produces numbers that look right and are not.
Revolut's own categories are a hint at best. They know nothing about Swiss items such as Serafe (CHF 312 per household from 2027), health insurance franchise or tax provisions – all of which you need for a realistic Swiss budget.
Shortcut: Revolut template or the app
In the household budget for Excel Revolut is a ready bank template: paste the export, comma and all, and the sheet reads date and signed amount; fees you add separately if you want them. Categories come from over 400 Swiss merchant rules. CHF 49 once, English included.
The BudgetHub app has a Revolut preset that reads the comma and the signed amount; top-ups and exchanges you mark as transfers during import.