Export & Import

Table of contents

  1. Export Transactions
    1. Export Transactions via Command Line
    2. Export Transactions from desktop user interface
    3. Export Transactions from mobile user interface
  2. Import Transactions
    1. Import Transactions via Command Line
    2. Import Transactions from desktop user interface
    3. How to import Delimiter-separated Values (DSV) File or Data
    4. How to get GnuCash XML Database File
    5. How to get Firefly III Data Export File

Export Transactions

ezBookkeeping supports exporting transaction data as CSV (Comma-Separated Values) or TSV (Tab-Separated Values) files, via the command line or from the user interface.

Export Transactions via Command Line

See transaction-export

Export Transactions from desktop user interface

  1. Click “Data Management” in “User Settings” page
  2. Click the “Export Data” button and select the file type to export all transactions into the chosen file format

Export Transactions from mobile user interface

  1. Tap “Data Management” in “Settings” page
  2. Tap the “Export Data” button and select the file type to export all transactions into the chosen file format

Import Transactions

ezBookkeeping supports importing files exported by ezBookkeeping via the command line, as well as importing various types of transaction data files from the desktop user interface. The transaction data import tool in the desktop version allows you to preview the imported data and perform batch modifications.

Import Transactions via Command Line

See transaction-import

Import Transactions from desktop user interface

  1. Click “Import” in “Transaction Details” page
  2. Select the file type and the file you want to import, then click the “Next” button
  3. Check if the imported transactions are mapped to existing transaction categories, accounts, and tags. Invalid data will be highlighted in red. You can click the pen icon on the left side of each record to modify the transaction category, account or tag of this transaction. You can also click the menu in the upper right corner to batch replace transaction categories, accounts or tags. Finally, select the transactions you want to import by checking the box on the left side, then click the “Import” button.

The following table lists all supported file types and the data contents that can be imported:

File Type Income Transaction Expense Transaction Transfer Transaction Transfer Transaction With Different Currencies Split Transaction Category Name Account Name Tag Names Timezone Geographic Location Description
ezbookkeeping Data Export File √ √ √ √ - √ √ √ √ √ √
Delimiter-separated Values (DSV) File / Data √ √ √ √ - √ √ √ √ √ √
Open Financial Exchange (OFX) File √ √ √ - - - - - √ - √
Quicken Financial Exchange (QFX) File √ √ √ - - - - - √ - √
Quicken Interchange Format (QIF) File √ √ √ - × √ √ - - - √
Intuit Interchange Format (IIF) File √ √ √ - √ (*1) √ √ - - - √
GnuCash XML Database File √ √ √ √ × √ √ - √ - √
Firefly III Data Export File √ √ √ √ - √ √ √ √ - √
Beancount Data File √ √ √ √ × √ √ √ - - √
Feidee MyMoney (App) Data Export File √ √ √ √ - √ √ - - - √
Feidee MyMoney (Web) Data Export File √ √ √ - - √ √ - - - √
Feidee MyMoney (Elecloud) Data Export File √ √ √ - - √ √ - - - √
Alipay (App) Transaction Flow File √ √ √ - - √ √ - - - √
Alipay (Web) Transaction Flow File √ √ √ - - - √ - - - √
WeChat Pay Billing File √ √ √ - - √ √ - - - √
  • “√” means that the original file contains this data, and it can be imported
  • ”-“ means that the original file does not contain this data
  • “×” means that the original file contains this data, but it cannot be imported
  • *1: Split transactions will be converted into separate transactions

How to import Delimiter-separated Values (DSV) File or Data

ezBookkeeping supports importing custom data formatted with delimiters. You can separate your data using commas or tabs, then save it as a CSV or TSV file, or paste it directly into the text box.

  1. Click “Import” in “Transaction Details” page
  2. Select “Delimiter-separated Values (DSV) File” or “Delimiter-separated Values (DSV) Data” as the file type
    1. For “Delimiter-separated Values (DSV) File”, select the file encoding and select the file to import
    2. For “Delimiter-separated Values (DSV) Data”, paste the file content into the text box below
    3. Then, Select the format: “CSV (Comma-Separated Values) File” or “TSV (Tab-Separated Values) File” and click the “Next” button
  3. ezBookkeeping will display the data in a table. You can click the header of each column to set the corresponding mapping. The imported data must include at least three columns: “Transaction Time”, “Transaction Type” and “Amount”
    1. After setting the “Transaction Type” column, click “Transaction Type Mapping” to match each type with the corresponding transaction type in ezBookkeeping
    2. After setting the “Transaction Time” column, ezBookkeeping will automatically detects the transaction time format. If it shows as “Unknown”, click “Time Format” and select the correct format or modify the transaction time in the import file
    3. After setting the “Amount” column, ezBookkeeping will automatically detects the amount format. If it shows as “Unknown”, click “Amount Format” and select the correct format or modify the amount in the import file
    4. If you set “Transaction Timezone”, “Geographic Location”, or “Tags” column, you also need to specify the format for transaction timezone and the delimiters for geographic location and transaction tags
    5. Once all columns are set completely, click the “Next” button
  4. Check if the imported transactions are mapped to existing transaction categories, accounts, and tags. Invalid data will be highlighted in red. You can click the pen icon on the left side of each record to modify the transaction category, account or tag of this transaction. You can also click the menu in the upper right corner to batch replace transaction categories, accounts or tags. Finally, select the transactions you want to import by checking the box on the left side, then click the “Import” button

How to get GnuCash XML Database File

  1. Click the “File” menu and select “Save As”
  2. Select “xml” in “Data Format”, and save to export the GnuCash database in XML format

How to get Firefly III Data Export File

  1. Click “Export data” in the left navigation bar of Firefly III
  2. Click “Export all transactions” to export to a csv file