wish: support for transfer into split + QIF import

Bug #1726184 reported by cassowarry
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
HomeBank
Invalid
Undecided
Unassigned

Bug Description

When I try a to import a 1.6MB QIF file from Quicken 2002 the import succeeds and all accounts, categories and transactions are imported. But I have a lot of split transactions and they are not imported as split transactions. Instead the whole amount is booked into the first category.

For example the following QIF excerpt:

D7.27.17
U-219.65
T-219.65
CX
NUmrech
PCarId
M$246,01 Denso 210-0656 Lichtmaschine für Toyota RAV4
LFahrzeuge:Reparatur
SFahrzeuge:Reparatur
E$138,20 Denso 210-0656 Lichtma
$-123.39
SFahrzeuge:Reparatur
E$15,35 Standard Versand
$-13.71
SAuslagen
E$68,00 Pfand für alte Lichtmas
$-60.71
SAuslagen
E$24,46 Aufpreis für 2 Day Vers
$-21.84
^

creates one transaction of €219,65 with the category Fahrzeuge:Reparatur but the four split transactions are ignored. This causes all account balances to be completely messed up because a lot of my split transactions make transfers from one account to another account.

HomeBank version: 5.1.6
OS: Linux version 4.13.8-1-ARCH

Revision history for this message
Maxime DOYEN (mdoyen) wrote :

this is not supported, nor implemented (I mean the ability to split using a transfer)

the QIF documentation is all but clear, so any implementation might be incomplete (and mine is probably).
if the spec are correct S lines works the same than L lines, and so any account here should be in brackets, so a correct line would be
S[Auslagen]

so this means in your case the lines 'SAuslagen' refers to a transfer to another account (Auslagen) ?

summary: - Import of QIF file not complete
+ wish: support for transfer into split + QIF import
Changed in homebank:
importance: Undecided → Wishlist
Revision history for this message
cassowarry (cassowarry) wrote :

No, the above sample was only a split between categories. A sample with a split between a category an a transfer to another account looks like this:

D6.23.17
U-12.66
T-12.66
CX
NUmrech
PSafeway
M$14,18 Einkaufen
LWeltreise:Lebenshaltung
SWeltreise:Lebenshaltung
E$13,18 Einkaufen
$-11.77
S[Bargeld (Dollar)]
E$1,00 Erstattung
$-0.89
^

So you are completly right, accounts are placed between []. In this example -11.77 are booked into the category "Weltreise:Lebenshaltung" and -0.89 are transfered into the account "Bargeld (Dollar)".

I have kind of everything. Some splits are only into different categories, some are only into different accounts and some (like the above) are a mix of both.

Maxime DOYEN (mdoyen)
tags: added: data-structure
Revision history for this message
Maxime DOYEN (mdoyen) wrote :

your version is outdated and obsolete
tested with success with latest 5.2.3
=> uprade

Changed in homebank:
importance: Wishlist → Undecided
status: New → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.