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.

  1. Les
    November 15, 2015 at 10:16 am

    Hi Graham,
    I am going through my accounts and importing transactions for each on a separate csv spreadsheet so am I correct in assuming that if I don’t want transfers to be duplicated, I would need to delete the specific rows from the csv upload that comes after one that has already created them?
    Thanks.

    • November 15, 2015 at 11:22 am

      Hi Les, if you convert the first account’s transfers so that the app imports them as transfers, then yes you would need to delete the other account’s transaction to avoid a duplicate. Or you could import multiple accounts at a time and use the technique in this post to import the transfers from two separate rows in the CSV file. You would have to make sure they were together though, for each transfer.

  1. No trackbacks yet.
Comments are closed.