locked
CC download reversing debit and credits RRS feed

  • Question

  • My credit card is set up correctly, no opening balance. When I download the statement and import the transactions, the debits and credits are reversed. Is there a way to correct this. I have to manually change the credits to debits and vice versa.

    Thanks in advance


    Cindy

    Tuesday, September 29, 2015 1:38 PM

Answers

  • (Note EDIT at the bottom)

    I compared to my credit card OFX. Here is a purchase transaction and an autopay payment to the CC:

    <STMTTRN>
    <TRNTYPE>DEBIT
    <DTPOSTED>20150919180000.000
    <TRNAMT>-62.0
    <FITID>8674452640001
    <SIC>04899
    <NAME>xyz*BILL PAYMNT  
    </STMTTRN>
    <STMTTRN>
    <TRNTYPE>CREDIT
    <DTPOSTED>20150920180000.000
    <TRNAMT>788.11
    <FITID>8674452640002
    <SIC>00000
    <NAME>AUTOPAY 999990000007528RAUTOPAY
    </STMTTRN>

    The<TRNAMT>amount  has the same sense in both -- positive for CC payment and negative for purchase.

    My purchases are <TRNTYPE>DEBIT even though it is a credit card. Try making that change and read into a test file. If that does not solve it for you, I might try importing your OFX into a test file and see what happens.

    Just to make sure, purchases should show up in the Charge column of the register, and CC payments or returns should show in the Credit column. I presume your downloads reverse this based on your description.

    Edit: I did import this into a test file. With the Opening Balance of a credit card account, the purchases all show up in the Charge column and the 26.56 shows up in the Credit card. So I am thinking that changing PAYMENT to DEBIT is not going to have an effect.

    The balance column shows generally increasing positive numbers, and the You Owe at the bottom shows $775.82 in black.

    For your own test, when you create the new credit card amount, when it asks what you owe, answer that the amount  leave it blank if you can. Otherwise Money will create an Opening Balance value and a Bank Balance value.

    Tuesday, September 29, 2015 4:30 PM
    Moderator

All replies

  • Note that in the numbers on the Account List, the amount you owe is
    shown as negative, and a credit balance would be shown as positive.
    But in the account register, things are the other way around.

    If this is the opposite of what is happening, how are you downloading? Is that an OFX file from your credit card's website, a QIF file, PocketSense, or what?

    In the account settings,details, what is the Account Type?

    Running Microsoft Money Deluxe Sunset?

    Tuesday, September 29, 2015 2:04 PM
    Moderator
  • Cal,

    Understand the positive and negative aspect, the statement will download a payment as a charge and a charge as a payment. Right now I have a credit balance on the card of $50.00 due to a store return. But the "Bank Balance" is showing (50.00) and the "You Owe" at the bottom as (50.00). I have to change every downloaded charge and credit to the correct column. I am not sure if it helps but this is a Younkers Store Card. The statement is being download as a OFX, this is the only download option available.

    Thanks again


    Cindy

    Tuesday, September 29, 2015 2:49 PM
  • I think that you are misunderstanding what Cal said and how Money works with credit accounts,

    First, look at the Account List.  Your Yonkers credit card account should be listed as a Credit Account.  And the balance there should be positive $50 because they owe you $50.  You could request that they send you that amount so it's an asset of yours that happens to be in a credit account.

    Then, go to the Yonkers account register.  There, because it is a credit account, your purchases will show up a positive amounts and your payments (i.e credits to the account) as negative amounts.  So when you buy something, the balance increases (becomes more positive) and when you make a payment, the balance decreases.

    Your return of an item resulted in a credit to the account of $50.   This is a decrease in what you owe so it is entered in the credit account register as negative amount.  It's decreasing the amount that you owe.  And since you have no other charges, the net amount owed is now negative, - i.e. they own you $50.

    I hope this helps!


    Bill Becker

    Tuesday, September 29, 2015 3:32 PM
  • Bill,

    Thanks for the info, I understand the accounting side of my accounts. Account is set up correctly. Here is a copy of the OFX that is being downloaded. Where do I make corrections in the OFX to correct the debits and credits being reversed?

    OFXHEADER:100
    DATA:OFXSGML
    VERSION:102
    SECURITY:NONE
    ENCODING:USASCII
    CHARSET:1252
    COMPRESSION:NONE
    OLDFILEUID:NONE
    NEWFILEUID:NONE
    <OFX>
    <SIGNONMSGSRSV1>
        <SONRS>
            <STATUS>
                <CODE>0
                <SEVERITY>INFO
            </STATUS>
            <DTSERVER>20150929120000[0:GMT]
            <LANGUAGE>ENG
        </SONRS>
    </SIGNONMSGSRSV1>
    <CREDITCARDMSGSRSV1>
    <CCSTMTTRNRS>
        <TRNUID>1
        <STATUS>
            <CODE>0
            <SEVERITY>INFO
            <MESSAGE>Success
        </STATUS>
    <CCSTMTRS>
        <CURDEF>USD
        <CCACCTFROM>
            <ACCTID>0954
        </CCACCTFROM>
        <BANKTRANLIST>
        <DTSTART>20141027120000[0:GMT]
        <DTEND>20150920120000[0:GMT]
            <STMTTRN>
                <TRNTYPE>PAYMENT
                <DTPOSTED>20150920120000[0:GMT]
                <TRNAMT>-130.48
                <FITID>120150920201509201
                <CORRECTFITID>120150920201509201
                <CORRECTACTION>REPLACE
                <NAME>PAYMENT - THANK YOU
            </STMTTRN>
            <STMTTRN>
                <TRNTYPE>PAYMENT
                <DTPOSTED>20150915120000[0:GMT]
                <TRNAMT>-50.0
                <FITID>120150915201509151
                <CORRECTFITID>120150915201509151
                <CORRECTACTION>REPLACE
                <NAME>PAYMENT - THANK YOU
            </STMTTRN>
            <STMTTRN>
                <TRNTYPE>PAYMENT
                <DTPOSTED>20150825120000[0:GMT]
                <TRNAMT>-3.28
                <FITID>120150825201508253
                <CORRECTFITID>120150825201508253
                <CORRECTACTION>REPLACE
                <NAME>FINANCE CHARGE
            </STMTTRN>
            <STMTTRN>
                <TRNTYPE>PAYMENT
                <DTPOSTED>20150811120000[0:GMT]
                <TRNAMT>-50.0
                <FITID>120150811201508111
                <CORRECTFITID>120150811201508111
                <CORRECTACTION>REPLACE
                <NAME>PAYMENT - THANK YOU
            </STMTTRN>
            <STMTTRN>
                <TRNTYPE>PAYMENT
                <DTPOSTED>20150719120000[0:GMT]
                <TRNAMT>-26.56
                <FITID>120150719201507191
                <CORRECTFITID>120150719201507191
                <CORRECTACTION>REPLACE
                <NAME>BERGNER'S PURCHASE
            </STMTTRN>
            <STMTTRN>
                <TRNTYPE>PAYMENT
                <DTPOSTED>20150718120000[0:GMT]
                <TRNAMT>-51.36
                <FITID>120150718201507181
                <CORRECTFITID>120150718201507181
                <CORRECTACTION>REPLACE
                <NAME>YOUNKERS PURCHASE
            </STMTTRN>
            <STMTTRN>
                <TRNTYPE>PAYMENT
                <DTPOSTED>20150718120000[0:GMT]
                <TRNAMT>-64.18
                <FITID>120150718201507182
                <CORRECTFITID>120150718201507182
                <CORRECTACTION>REPLACE
                <NAME>YOUNKERS PURCHASE
            </STMTTRN>
            <STMTTRN>
                <TRNTYPE>CREDIT
                <DTPOSTED>20150718120000[0:GMT]
                <TRNAMT>26.56
                <FITID>120150718201507183
                <CORRECTFITID>120150718201507183
                <CORRECTACTION>REPLACE
                <NAME>YOUNKERS RETURN
            </STMTTRN>
            <STMTTRN>
                <TRNTYPE>PAYMENT
                <DTPOSTED>20150714120000[0:GMT]
                <TRNAMT>-35.1
                <FITID>120150714201507141
                <CORRECTFITID>120150714201507141
                <CORRECTACTION>REPLACE
                <NAME>BON TON PURCHASE
            </STMTTRN>
            <STMTTRN>
                <TRNTYPE>PAYMENT
                <DTPOSTED>20150711120000[0:GMT]
                <TRNAMT>-26.56
                <FITID>120150711201507111
                <CORRECTFITID>120150711201507111
                <CORRECTACTION>REPLACE
                <NAME>YOUNKERS PURCHASE
            </STMTTRN>
            <STMTTRN>
                <TRNTYPE>PAYMENT
                <DTPOSTED>20150511120000[0:GMT]
                <TRNAMT>-75.73
                <FITID>120150511201505111
                <CORRECTFITID>120150511201505111
                <CORRECTACTION>REPLACE
                <NAME>PAYMENT - THANK YOU
            </STMTTRN>
            <STMTTRN>
                <TRNTYPE>PAYMENT
                <DTPOSTED>20150421120000[0:GMT]
                <TRNAMT>-50.0
                <FITID>120150421201504211
                <CORRECTFITID>120150421201504211
                <CORRECTACTION>REPLACE
                <NAME>PAYMENT - THANK YOU
            </STMTTRN>
            <STMTTRN>
                <TRNTYPE>PAYMENT
                <DTPOSTED>20150406120000[0:GMT]
                <TRNAMT>-63.67
                <FITID>120150406201504061
                <CORRECTFITID>120150406201504061
                <CORRECTACTION>REPLACE
                <NAME>YOUNKERS PURCHASE
            </STMTTRN>
            <STMTTRN>
                <TRNTYPE>PAYMENT
                <DTPOSTED>20150403120000[0:GMT]
                <TRNAMT>-62.06
                <FITID>120150403201504031
                <CORRECTFITID>120150403201504031
                <CORRECTACTION>REPLACE
                <NAME>YOUNKERS PURCHASE
            </STMTTRN>
            <STMTTRN>
                <TRNTYPE>PAYMENT
                <DTPOSTED>20141114120000[0:GMT]
                <TRNAMT>-56.7
                <FITID>120141114201411141
                <CORRECTFITID>120141114201411141
                <CORRECTACTION>REPLACE
                <NAME>PAYMENT - THANK YOU
            </STMTTRN>
            <STMTTRN>
                <TRNTYPE>PAYMENT
                <DTPOSTED>20141027120000[0:GMT]
                <TRNAMT>-56.7
                <FITID>120141027201410271
                <CORRECTFITID>120141027201410271
                <CORRECTACTION>REPLACE
                <NAME>YOUNKERS PURCHASE
            </STMTTRN>
        </BANKTRANLIST>
        <LEDGERBAL>
            <BALAMT>-50.0
            <DTASOF>20150929120000[0:GMT]
        </LEDGERBAL>
    </CCSTMTRS>
    </CCSTMTTRNRS>
    </CREDITCARDMSGSRSV1>
    </OFX>


    Cindy

    Tuesday, September 29, 2015 4:07 PM
  • (Note EDIT at the bottom)

    I compared to my credit card OFX. Here is a purchase transaction and an autopay payment to the CC:

    <STMTTRN>
    <TRNTYPE>DEBIT
    <DTPOSTED>20150919180000.000
    <TRNAMT>-62.0
    <FITID>8674452640001
    <SIC>04899
    <NAME>xyz*BILL PAYMNT  
    </STMTTRN>
    <STMTTRN>
    <TRNTYPE>CREDIT
    <DTPOSTED>20150920180000.000
    <TRNAMT>788.11
    <FITID>8674452640002
    <SIC>00000
    <NAME>AUTOPAY 999990000007528RAUTOPAY
    </STMTTRN>

    The<TRNAMT>amount  has the same sense in both -- positive for CC payment and negative for purchase.

    My purchases are <TRNTYPE>DEBIT even though it is a credit card. Try making that change and read into a test file. If that does not solve it for you, I might try importing your OFX into a test file and see what happens.

    Just to make sure, purchases should show up in the Charge column of the register, and CC payments or returns should show in the Credit column. I presume your downloads reverse this based on your description.

    Edit: I did import this into a test file. With the Opening Balance of a credit card account, the purchases all show up in the Charge column and the 26.56 shows up in the Credit card. So I am thinking that changing PAYMENT to DEBIT is not going to have an effect.

    The balance column shows generally increasing positive numbers, and the You Owe at the bottom shows $775.82 in black.

    For your own test, when you create the new credit card amount, when it asks what you owe, answer that the amount  leave it blank if you can. Otherwise Money will create an Opening Balance value and a Bank Balance value.

    Tuesday, September 29, 2015 4:30 PM
    Moderator
  • Cindy,

    I'm no expert on OFX files, but, as Cal says a normal statement just has <DEBIT> and <CREDIT> entries.  Those transactions with <CORRECTACTION> seem to be replacements of previous transactions.  Did a lot of transactions from a previous statement get reversed?

    In any event, I would call Yonkers support to ask why the transactions are downloading like that.


    Bill Becker

    Tuesday, September 29, 2015 4:43 PM
  • Note that was one statement OFX that I looked at. I think there is more than one correct way to make the OFX. Note my test of Cindy's file worked as it should.

    Tuesday, September 29, 2015 4:54 PM
    Moderator
  • Bill, All transactions from this account are reserved. I only started downloading this account when I updated to Windows 10 and did the ddl fix

    Cindy

    Tuesday, September 29, 2015 4:56 PM
  • Do you have another credit card account that downloads as you expect?

    Bill Becker


    • Edited by Bill Becker Tuesday, September 29, 2015 5:05 PM revise
    Tuesday, September 29, 2015 5:05 PM
  • Bill, all my other accounts download perfectly. :)

    Cindy

    Tuesday, September 29, 2015 5:24 PM
  • Um, just to be sure, do you download other credit card accounts?  And they work as you expect?

    The really odd thing here is that when Cal imported the OFX file that you posted, it behaved just as he expected and as I have described above.


    Bill Becker

    Tuesday, September 29, 2015 5:28 PM
  • If importing the OFX file into a File->New->NewFile test file works as expected, I think I would try making a repaired version of the Money file with a Standard level 2 repair.

    While I don't know that that would help, it is easy.

    If that does not work, I would be considering loose QIF Export from the problem account. Delete the old account. Import what you can with OFX. Edit the QIF to keep transactions that did not come in with the OFX, and import that. The QIF file will be in date order, which makes it easier to keep just the oldest transactions.

    Of course you know to keep extra backups or copies of your *.mny file (meaningfully renamed) in case you want to undo something or otherwise revert.

    Cindy, I did not look at your whole user name until now. I recognize that you are a very experienced and able Money user and that you were a great contributor to microsoft.public.money.

    Tuesday, September 29, 2015 5:36 PM
    Moderator
  • I got the statement to download correctly by making adjustments. I did notice that all transactions are listed as payments wether they are credits or charges. I will contact the Younkers to see if they will fix their mess.

    EDIT: I had to delete the "-" from in front of the payments for them to download correctly

    thanks for all your help!!!


    Cindy


    • Edited by cjconover Tuesday, September 29, 2015 9:29 PM added info
    Tuesday, September 29, 2015 6:25 PM
  • The repair function is not working on my sunset version of Money, it is just crashing the file. I will try the Export and keep you updated

    Cindy

    Tuesday, September 29, 2015 6:55 PM
  • Cal,

    Thanks for the kudos. But you were the one that I turned to when I could not figure things out. Its funny when I was telling my sister about the dll fix, she didn't want to do the download until I told her Cal said its ok. You are one of the most trusted Money user I have come across and I never doubt a word you say. :)

    Anyways, Deleted account and re-downloaded all transactions. Charges came thru correctly. Only one payment came thru as an actual payment the rest came thru as a charge. That's ok I can deal with that. Curious, Cal when you tested the file, did any payments show up, or just one on 7/18? 


    Cindy

    Tuesday, September 29, 2015 9:14 PM
  • Only 7/18 came through as a credit.

    I will be surprised if you can get them to fix their OFX transactions. Let's hope.

    With some work you could parse the transactions with maybe Python and based on if NAME has the word PURCHASE in it, leave the minus sign. Otherwise remove the minus. Lots of work if you have not been playing with the Python REGEX stuff lately. I have to re-study each time I try something like that.

    Tuesday, September 29, 2015 11:12 PM
    Moderator