Import / Export

The application allows to import and export your data. So, you can:

• regularly save your data for creating backups;
• prepare some data in *.csv format to import it.

Importing data

To import data, follow next steps:

1. Prepare data you want to import:
   • Accounts in the *.csv file with the following format:

     type	group	name	balance	currency	open	close	description
     Cards	USA	Zak card USA	115.21	USD	2016-05-31 T21:00:00.000000Z	2018-01-01 T00:00:00.000000Z	Zak card for USA travel

     Click here to download the sample accounts file.

   • Categories in the *.csv file with the following format:

     type	group	name
     income		Bonus
     expense	Fees & Charges	Bank Fee

     Click here to download the sample categories file.

   • Securities in the *.csv file with the following format:

     type	group	name	symbol	currency	description
     Stocks	France	Amazon	AMZN	USD
     Stocks	USA	Facebook	FB	USD	for example

     Click here to download the sample categories file.

   • Transactions in the *.csv file with the following format:

     type	timestamp	credit account	credit amount	credit currency	debit account	debit amount	debit currency	quantity	price	description	tags
     income	2017-08-31 T21:21:00.000000Z	Paycheck	2387.17		France/ BNP Paribas	2387.17	EUR
     expense	2017-08-29 T07:27:44.000000Z	France/ BNP Paribas	25.35	EUR	Food/ Markets	25.35
     transfer	2017-09-07 T10:57:32.000000Z	France/ BNP Paribas	410	EUR	France/ Education loans	410	EUR			March 2017

     Click here to download the sample transactions file.

     Notes:

     • For importing multi-line transactions (see Create an Income transaction and Create an Expense transaction for more details) use the same timestamp value for every line.
     • If there are several rows with the same value in:
       • the field timestamp and
       • the field credit account for the Expense transaction or the field debit account for the Income transaction,

       the application will create one multi-line transaction for these rows.

2. Click on the Menu button:
3. On the Menu tab, click the Import / Export item:
4. In the Import/Export dialog:
   1. Select the Import option:
   2. Choose the type of data you want to import:
      • Accounts
      • Categories
      • Securities
      • Transactions
   3. Click the Import button and select the *.csv file that you want to import.

Exporting data

To export data, follow next steps:

1. Click on the Menu button:
2. On the Menu tab, click the Import / Export item:
3. In the Import/Export dialog, select the Export option:
4. Choose the type of data that you want to export:
   • Accounts
   • Categories
   • Securities
   • Transactions
5. Click the Export button.

   The application creates and saves to the default downloads path (see your local browser settings, by default, the Downloads folder) files with the following names:

   • accounts: YYYYMMDD-hhmmss.csv
   • categories: YYYYMMDD-hhmmss.csv
   • securities: YYYYMMDD-hhmmss.csv
   • transactions: YYYYMMDD-hhmmss.csv

     where:

     • YYYYMMDD – current date (YYYY – year, MM – month, DD – day)
     • hhmmss – current time (hh – hours, mm – minutes, ss - seconds)