Home > Announcements > Importing transfer and split transactions

Importing transfer and split transactions

December 10, 2014

aticon57 atficon57 By default, transactions are imported from a CSV file using a single row per transaction.

For transfers, you simply specify the “other” account in the details column in square brackets, and you control the direction with the amount (+ve or -ve). For example, to transfer 100.00 from your Current account to your Visa account, paid with cheque number 100001, use the row …

Current,10/12/2014,[Visa],Credit Card,Paid in full,100001,-100.00,Y

In version 4.5.1 onwards, I now support importing transfers from two separate rows. The above example can also be specified as

Current,10/12/2014,,Credit Card,Paid in full,100001,-100.00,Y
Visa,10/12/2014,,Credit Card,Paid in full,100001,100.00,Y

The rules are that the rows need to be adjacent, the accounts need to be different (clearly), the dates need to be the same, the details fields need to specify the other account in angle brackets, the category needs to be the same, the notes (if specified) need to be the same and the cheque number (if specified on both rows) needs to be the same.

If the accounts are in the same currency, the amounts also need to be the same (but clearly one must be +ve and the other -ve). If they are in different currencies, you can now specify the two amounts separately.

Finally you can specify the reconcile flag separately per account.

Prior to version 5.8, it was not possible to import split transactions, but this is now supported using one row per category.

The rules are that the rows need to be adjacent, the accounts, dates, details, notes (if specified), cheque number (if specified) and reconciled flag need to be the same. Only the category and amounts should be different.