Skip to content

Importing transfers

The first time you import data you may run into an issue where the CSV importer creates withdrawals and deposits instead of transfers. Your CSV file will contain transfers, deposits and expenses of them but somehow all you end up with expenses and deposits only. This is a common issue and is caused by the fact that Firefly III doesn't realise the opposing account is an asset account.

If Firefly III knows both accounts are asset accounts, it will create transfers. You must provide the right information and configuration.

Recognizing asset accounts

Firefly III determines the transaction type based on the source and destination account. Both must be recognized as asset accounts or liabilities (in some cases). If Firefly III doesn't recognize the accounts, it will create new expense/revenue accounts and create a withdrawal/deposit.

Info

If your CSV files container very little information on the opposing account (either the source or the destination) this will be difficult to do right.

Use any of the following strategies to make sure that accounts are properly recognized.

Default account

The default account should be an asset account. If this is correct, and your CSV file contains no information on the source account, you're halfway there.

Map data

The import has a mapping stage during which you can link accounts. Use column role Opposing account (x) and Asset account (x). Select the correct asset accounts during the mapping. If both accounts are recognized or mapped as an asset account, the transaction will become a transfer.

Asset account names and opposing account names

Very few banks provide meaningful opposing account names for your own bank accounts. But this is a worthwhile field to map, because you can also clean up other names.

IBAN and account numbers

If your file contains IBAN's or account numbers, definitely use them to link them to your asset accounts.

Store IBANs and account numbers

When you create new asset accounts in Firefly III, always store an IBAN or account number. This will improve the (auto) mapping and make sure that transactions are linked.

Test, test, test

Always try one or two transactions first. Keep an eye on the logs and turn on debug mode if necessary (see the search) so you can see why / how Firefly III and the CSV importer create the accounts they do.


Last update: 2021-04-13