download to split

rowlandd's Avatar

rowlandd

13 May, 2015 04:14 AM

I just tried for the first time to download and import a QIF file from my credit card provider. The import spread the transactions throughout my register. But I write one check for the lot, so I would like the import to go into one transaction with split entries. Is there a way to do this?

  1. 1 Posted by dwg on 13 May, 2015 05:47 AM

    dwg's Avatar

    All of the transactions on your credit card have no relationship to other transactions, thus the card provider treats them as individual transactions posted on the day they receive the charge. So no great surprise they download the way they do.

    From the point of view of a QIF file the record for a split transaction is very specific and there is no simple way to go from individual transactions to a split transaction.

    FWIW A Salary Split looks like:

    ^ D16/07/1999
    U3600.52
    T3600.52
    NDEP
    PXYZ Corp
    LSalary:Salary & wages
    SSalary:Salary & wages
    $5639.42 STax:Salary & wages
    $-1968.40 SInsurance:Health
    $-70.50 ^ You can see it looks like a single transaction but has embedded splits, also there is a single date.

    Showing the purchases as individual transactions and the repayment as one is what you would expect to see on your credit card statement as well.

    Des

  2. 2 Posted by Ben Spencer on 13 May, 2015 11:59 AM

    Ben Spencer's Avatar

    Hi David

    You should create an account of type credit card in Moneydance and then import your credit card QIF file into that account. Then when you pay your credit card you should enter a transfer from your checking account to your credit card.

    Ben Spencer
    Infinite Kind Support

  3. System closed this discussion on 19 Mar, 2016 04:55 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac