QIF Credit Card import shows reverse Expense and Income

Bug #773282 reported by Ton on 2011-04-29
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
HomeBank
Low
Maxime DOYEN

Bug Description

Bug created from Question #154348
Checked with several bank-files on Homebank 4.3 (Ubuntu 10.10)

@Andrew
importing my check acc data into HomeBank via QIF with no hassel.
When I import my Credit card data it is reflecting the Expense as Income and vice versa.

If i look at the raw data on the bank statement they reflect a purchase as a POSITIVE amount and a payment into the credit card as NEGATIVE.

Ton (profiler1234) wrote :

Inquiring into Credit Card accounts, showed me that Banks stating the CC spending (Credit) as the the amount available, so positive.
The payment into this CC account is seen as a reduction, so negative.
Homebank does not recognize this. However it can recognize it because this CC-account was created as a 'Credit card account' in the first place.

Maxime DOYEN (mdoyen) wrote :

So you mean that for a credit card account, HomeBank should negate data imported via qif (and ofx?) ?

Changed in homebank:
assignee: nobody → Maxime Doyen (mdoyen)
importance: Undecided → Low
milestone: none → 4.4.1
Ton (profiler1234) wrote :

@Maxime
Yes. Based on the file-types I could lay my hands on (4 different Banks: ofx, csv, swift-MT940) , this seems to be independent of export-file-format. With all these banks the CC-account credit and debit are negated.

Maxime DOYEN (mdoyen) wrote :

I don't know exactly how a CC account works, as such thing do no exist here in France !
We only have debit card, that work the logical way, a credit is + and a debit is -.

So a CC account is a kind of billing but owned by the bank, and there is some fee if you overbuy or cross a limit.
So every purchase is +, from the cc account point of view, and so when you have a statement, you must bill the bank and then it is -.
Am I right ? (thus I don't understand the advantage of inverting +/-)

Changed in homebank:
status: New → Incomplete
Ton (profiler1234) wrote :

@Maxime
I agree about it being not logical, but there must be a reason why the banks do this, so I will investigate further ...

Maxime DOYEN (mdoyen) on 2011-06-09
Changed in homebank:
milestone: 4.4.1 → 4.5
Maxime DOYEN (mdoyen) wrote :

Something still bothers me about this.
Can you check in your QIF file that the amount have the correct sign ?
HomeBank import amount taking into consideration the sign, so
T34,45 will be +34,45
T-56,22 will be -56,22

Maxime DOYEN (mdoyen) on 2011-11-19
Changed in homebank:
milestone: 4.5 → none
Maxime DOYEN (mdoyen) on 2011-11-20
Changed in homebank:
importance: Low → Undecided
Maxime DOYEN (mdoyen) on 2012-04-04
Changed in homebank:
milestone: none → 4.5
Maxime DOYEN (mdoyen) on 2012-04-04
Changed in homebank:
importance: Undecided → Low
Maxime DOYEN (mdoyen) wrote :

Something still bothers me about this.
Can you check in your QIF file that the amount have the correct sign ?
HomeBank import amount taking into consideration the sign, so
T34,45 will be +34,45
T-56,22 will be -56,22

Joel Makarov (siblingcreature) wrote :

Credit Card accounts are not the same as regular bank accounts.

Bank account statements show how much money you have deposited, so credits are + and outbound payments (purchases) are -

With a Credit Card, when you make a purchase the CC company pays for the item, and adds the price to your account.
When you then make a payment you are covering the debt.
Credit card statements show how much you *owe* so purchases are + and "payments" (Credits to the CC account) are -

Maxime DOYEN (mdoyen) on 2012-05-01
Changed in homebank:
status: Incomplete → In Progress
Maxime DOYEN (mdoyen) wrote :
Maxime DOYEN (mdoyen) wrote :

Can someone review this sample file I get from somewhere in the internet.
What I want to understand is why the qif file do not supply maybe the correct sign for amount.

Any small sample file is welcome for me to decide how to fix this bug.

The main question is a normal qif file is still:
T34,45 will be +34,45 into homebank
T-56,22 will be -56,22 into homebank

Is it the software, detecting it is a CCard file that need to negate all tra,saction from the qif file and so:
T34,45 will be -34,45 into homebank
T-56,22 will be +56,22 into homebank

Let me know !

Ton (profiler1234) wrote :

To help you on the way , maybe this can convince you.

Maxime DOYEN (mdoyen) wrote :

@Ton:
I am conviced Ton, be sure of this, I just want to last verify what I'm going to code.
The statement you give shows purchase as credit and payment to the bank as debit, as like as the file at #9.
So with the sample file provided at #9, when you import into homebank, is it correct ?

Maxime DOYEN (mdoyen) on 2012-09-01
Changed in homebank:
milestone: 4.5 → 4.6
Maxime DOYEN (mdoyen) on 2012-10-27
Changed in homebank:
status: In Progress → Confirmed
Maxime DOYEN (mdoyen) on 2012-10-28
tags: added: file-import-export
Ton (profiler1234) wrote :

@Maxim:
Sorry for the long wait. I have been working abroad for couple of month.
But I have tested file at #9 now and it all looks the way it should. CC-card Expense and Income are shown in the right columns.

Charles Brunet (cbrunet) wrote :

On the QIF I get from my credit card, signs aren't reversed... Expenses are - and payments are +. Maybe should it be an option in the account settings.

Maxime DOYEN (mdoyen) on 2013-12-01
Changed in homebank:
milestone: none → 4.6
Maxime DOYEN (mdoyen) on 2014-01-21
Changed in homebank:
milestone: 5.0 → 4.5.5
Maxime DOYEN (mdoyen) wrote :

Done.

Changed in homebank:
status: Confirmed → Fix Committed
Maxime DOYEN (mdoyen) on 2014-01-27
Changed in homebank:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Related questions