QIF Credit Card import shows reverse Expense and Income

[Ton]

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)]

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)]

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

[Ton (profiler1234)]

@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)]

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 +/-)

[Ton (profiler1234)]

@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)]

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)]

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)]

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)]

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)]

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

[Ton (profiler1234)]

And this:
http://www.japersonalfinance.com/gsjapf/activities/page3.jsp?key=Activity4Page3

[Maxime DOYEN (mdoyen)]

@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 ?

[Ton (profiler1234)]

@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)]

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)]

Done.

[Nicholas Arthur (nickarthur94)]

This still seems to have the bugfix behaviour for me in version 5.4.3 on Windows 10. Have I understood correctly that HomeBank should automatically switch the signs for transactions in an imported QIF file to a credit card account?

[DS (djsuess)]

Severity: Medium-high

Yes, I'm having the issue as well on v5.4.3 (Win10) where my importing of CC bill via OFX file show the statement transaction as Income when Expense is expected. This defect makes the software unusable if I have to manually edit over 200 records manually. Does the system use an absolute value during import or something?

Example transaction (FITID masked as all zeros):
```xml
<STMTTRN>
  <TRNTYPE>CREDIT</TRNTYPE>
  <DTPOSTED>20201228120000</DTPOSTED>
  <DTUSER>20201228120000</DTUSER>
  <TRNAMT>-80.28</TRNAMT>
  <FITID>00000000000000000000000</FITID>
  <NAME>COSTCO WHSE #0999 CITY NAME</NAME>
</STMTTRN>
```

Reproduce:
1. File > Import
2. Select OFX file into Credit Card

Workaround:
* Manually update each entry line-by-line.

[bonzo (bonzo)]

Looks to be fixed by wish ticket: https://bugs.launchpad.net/homebank/+bug/1866456