Home > Announcements > Importing transfer transactions

Importing transfer 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,<Visa>,Credit Card,Paid in full,100001,-100.00,Y
Visa,10/12/2014,<Current>,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 specific the two amounts separately.

Finally you can specific the reconcile flag separately per account.