Import Income & Expenses transactions in CSV format

Documentation •
In this article

This file format is used to export transactions data from an account or bank statement with the amounts in plus or minus.

Use in Import into accounting

You can import the file by using:

  • Menu Actions->Import into accounting
  • Import to Transaction table
  • The type of file to be used is a "Income & Expenses transactions".

Options

  • Import using clipboard data will use the content of the clipboard instead of the file
  • Autocomplete values: Some fields of the transactions are automatically completed (see "Importing transactions for multicurrency Double-entry accounting").
    Once the import is done, the contra account will have to be entered manually.
  • Unicode (utf-8) The content of the file is in Unicode utf-8 (it supports any character set).

Use as output for an Import Extension

An Extension that is used to import a bank account statements will return a string that contain the data in TSV format specified here.

The Extensions attributes should contains the following lines:

//@task = import.transaction
//@outputformat = transactions.simple

For more information see:

File format and Columns

The file has the firs

  • You can use any column name existing on the table
  • Columns with special meaning are
    • Date  of the transaction (2014-12-31)
    • Description a brief text
    • DocInvoice the invoice number.
    • Income: The amount in debit, if negative is considered in credit.
    • Expenses: The amount in credit
    • ContraAccount: the account number (debit/credit) or category.
      Enter square brackets [] to keep the field empty
    • Account: If the file contains the movements of multiple accounts, the account of the transaction
      Enter square brackets [] to keep the field empty
    • VatCode the vat code that should be used
    • IsDetail for composed transactions a "S" identifies a counterpart transaction and a "D" a detail transactions
  • Fields header in the first line of the file. Fields names are case sensitive and must correspond to the NameXml (English)
  • Fields and column name separator is to be tab separated "\t"
  • Each line (after a "\n") is a new record
  • The format for the Date fields is yyyy-mm-dd

Example file Income/Expenses format

In the example the values are written in an excel document.

Income and Expenses excel example

 

     

       

       

      Help us improve the documentation

      We welcome feedback on how to improve this page.

      Tell us what theme needs a better explanation or how to clarify a topic.

      Share this article: Twitter | Facebook | LinkedIn | Email