How to Convert Danske Bank Statements to Excel

Danske Bank is the largest bank in Denmark and a major player across the Nordic region, with operations in Sweden, Norway, Finland, and Northern Ireland. With over 3.3 million personal customers and 200,000+ business clients, Danske Bank is a cornerstone of Nordic banking. If you need your Danske Bank transaction data in Excel for accounting, analysis, or tax purposes, this guide shows you how.

Whether you use Danske Bank in Denmark, Sweden (where it operates as Danske Bank Sverige), or any other Nordic market, our converter handles all Danske Bank PDF statement formats.

Why Convert Danske Bank Statements?

• Danish tax filing (SKAT): Sort and categorize transactions for your Danish tax return. Identify deductible expenses for fradrag and prepare documentation for SKAT easily.
• Business accounting: Import Danske Bank transactions into e-conomic, Dinero, Billy, or other popular Danish accounting software via CSV.
• Cross-border transactions: Danske Bank operates across the Nordics. Consolidate transactions from multiple countries in a single spreadsheet for multi-market businesses.
• MobilePay tracking: MobilePay transactions appear in Danske Bank statements. Extract and analyze mobile payment patterns in Excel.

Step-by-Step: Convert Your Danske Bank Statement

Danske Bank Statement Format

Danske Bank uses a clean, structured PDF format. Key characteristics include:

• Danish dates in DD.MM.YYYY format (or ISO format in Swedish statements)
• Danish number formatting with period as thousands separator and comma for decimals (e.g., 1.234,56)
• Transaction types clearly labeled: Dankort, overforsel, BetalingsService, MobilePay, etc.
• Running balance (saldo) shown for each transaction
• Multi-currency support for international accounts
• Business accounts include FI-number and invoice references

Our parser handles both the Danish-format and Swedish-format Danske Bank statements, including the slight differences in date formatting, number separators, and transaction type labels.

Common Use Cases

Import into e-conomic or Dinero

e-conomic and Dinero are the most popular accounting tools in Denmark. After converting your Danske Bank statement to CSV, import it for automated bank reconciliation (bankafstemning). In e-conomic, go to Bank → Import kontoudtog. In Dinero, use Bank → Upload banktransaktioner.

MobilePay transaction analysis

MobilePay is ubiquitous in Denmark, and every MobilePay transaction shows up in your Danske Bank statement. Convert to Excel and filter by "MobilePay" to see all mobile payments in one view -- useful for expense tracking and splitting shared costs.

Cross-border Nordic business

Companies operating across Denmark, Sweden, and Norway often have Danske Bank accounts in multiple countries. Convert statements from each country and combine them in a single workbook. Our parser preserves the original currency (DKK, SEK, NOK) for accurate multi-currency accounting.

Personal budget tracking

Convert your monthly Danske Bank kontoudtog to Excel and categorize spending using pivot tables. Track subscriptions, groceries, dining, and other categories to understand your spending patterns. The Excel format makes it easy to create monthly comparison charts.

Frequently Asked Questions