<<   Overview Glossary   >>  

Import

There are three kinds of import files:
The data can be imported from a previously exported DAT Backup File, if you want to restore it after re-installing the app. If you check Delete All Data, then all existing data is deleted before importing the file and the balances of accounts are taken from the backup file instead of being recalculated. If you check Delete All Transactions, then only the transactions are deleted before importing and you must adjust the balances of accounts manually after finishing the import. Transactions are always inserted, while other items are only inserted if they do not exist.

Alternately you may import transactions from a CSV Text File that you created with a desktop computer program. It must have the same format as a CSV Text File that you exported, but the first line with the field names can be left off. The separator between fields is a comma and the character set is selectable, by default UTF-8.

You may import account lists, category lists and transactions from a QIF Text File exported from you desktop financial program. If you import transactions, then you must first select a Default Account and Default Class that will be used if the account or class is not specified. The currency of the default account is used for automatically created accounts.

For a QIF Import you may uncheck the option Payee Description as Reason if the payee description (text separated by a slash) should not be used for the reason, but kept in the payee name.

You must check Adjust Balance if the balance of the accounts should automatically be adjusted, otherwise you must adjust it manually after finishing the import by opening the list of accounts and editing the accounts.

Accounts, Classes, Categories, Subcategories, Payees and Reasons are automatically created if they do not exist.

Importing a big file may take several minutes, so please be patient and wait until it is finished before switching to another app, otherwise the import may be incomplete.

Fields of the CSV Text File

Date The date of the transaction. Must be an integer of the form yyyymmdd or yyyy-mm-dd.
Type The type 1 means expense, type 2 means income.
Account The name of an account.
Payee The name of a payee.
Reason The name of a reason.
Class The name of a class.
Category The name of a category.
Subcategory The name of a subcategory.
Amount The amount in the currency of the account. Must be zero for split items, if they have a header.
Expense The amount of an expense in the currency of the class. Must be zero for the header of split items.
Income The amount of an income in the currency of the class. Must be zero for the header of split items.
Notes If the notes contain commas or multiple lines, then they must be included in a pair of double quotes ("). You may separate the lines with a backslash or with a line feed character.





  <<   Overview Glossary   >>