Export Formats
Choose the format that works best for your workflow. Every conversion includes all detected transactions with dates, descriptions, amounts, and running balances.
All formats available from the same upload. Convert once, download in any format.
Microsoft Excel format -- best for analysis and reporting
What you get
- Transactions sheet: Date, Description, Amount, Balance -- one row per transaction
- Summary sheet: Account number, bank name, period, total credits, total debits, closing balance
- Formatted columns: Dates as Excel dates, amounts as numbers with 2 decimal places
- Auto-width columns: Columns sized to fit content for immediate readability
Example output
| Date | Description | Amount | Balance |
|---|---|---|---|
| 2026-01-02 | Salary Payment | 32,500.00 | 45,237.50 |
| 2026-01-03 | Rent Payment | -12,000.00 | 33,237.50 |
| 2026-01-04 | ICA Maxi Groceries | -847.30 | 32,390.20 |
Best for: Financial analysis, pivot tables, charts, sharing with accountants. Compatible with Excel 2007+, Google Sheets, LibreOffice Calc.
Comma-separated values -- universal compatibility
Format details
Example output
Date,Description,Amount,Balance 2026-01-02,Salary Payment,32500.00,45237.50 2026-01-03,Rent Payment,-12000.00,33237.50 2026-01-04,ICA Maxi Groceries,-847.30,32390.20
Best for: Importing into accounting software, databases, Google Sheets, custom scripts. Works with any spreadsheet application.
Fortnox-compatible format -- direct import into Swedish accounting
Why a separate Fortnox format?
Fortnox requires specific formatting: semicolon delimiters, Swedish decimal format (comma instead of period), UTF-8 BOM encoding, and specific field names. Our Fortnox CSV is ready to import directly -- no manual formatting needed.
Format details
Fortnox field mapping
| Fortnox Field | Source | Example |
|---|---|---|
| Datum | Transaction date | 2026-01-02 |
| Text | Description | Hyra kontor |
| Belopp | Amount (Swedish decimals) | -12000,00 |
| Saldo | Running balance | 33237,50 |
Example output
Datum;Text;Belopp;Saldo 2026-01-02;Lon inbetalning;32500,00;45237,50 2026-01-03;Hyra kontor;-12000,00;33237,50 2026-01-04;ICA Maxi;-847,30;32390,20
Structured data -- ideal for developers and integrations
Structure
- metadata: Bank name, account number, statement period, conversion date
- summary: Total credits, total debits, opening balance, closing balance, transaction count
- transactions: Array of objects with date, description, amount, balance, and type fields
Example output
{
"metadata": {
"bank": "Handelsbanken",
"account": "512 642 591",
"period": "2026-01-01 to 2026-01-31",
"converted_at": "2026-01-15T14:30:00Z"
},
"summary": {
"total_credits": 32500.00,
"total_debits": -12847.30,
"opening_balance": 12737.50,
"closing_balance": 32390.20,
"transaction_count": 3
},
"transactions": [
{
"date": "2026-01-02",
"description": "Salary Payment",
"amount": 32500.00,
"balance": 45237.50,
"type": "credit"
},
{
"date": "2026-01-03",
"description": "Rent Payment",
"amount": -12000.00,
"balance": 33237.50,
"type": "debit"
}
]
}Best for: API integrations, custom dashboards, data pipelines, programmatic access to transaction data.
Format Comparison
| Feature | Excel | CSV | Fortnox CSV | JSON |
|---|---|---|---|---|
| Transactions | Yes | Yes | Yes | Yes |
| Summary sheet | Yes | No | No | Yes |
| Formatted numbers | Yes | Basic | Swedish | Yes |
| Metadata included | Yes | No | No | Yes |
| Fortnox compatible | No | No | Yes | No |
| Plan required | Free | Free | Pro | Free |