Importing CSV transactions from credit union

dougbatchelder's Avatar

dougbatchelder

11 Apr, 2022 10:15 PM

ello,
My credit union is not among your institutions for which automatic downloads can occur, so I create a CSV file from my credit union and import it into Moneydance. However, though it imports the date, description, etc. properly, it imports all debits and credits as deposits in Moneydance -- which is of course not helpful. How can I make it properly import debits as "payments" and credits as "deposits?"
(My bank only offers CSV export.)

  1. 1 Posted by dwg on 11 Apr, 2022 10:41 PM

    dwg's Avatar

    Perhaps you can post a sample CSV file that shows the issue, that could help us determine if it is a file problem or an import settings problem.

  2. 2 Posted by dougbatchelder on 13 Apr, 2022 03:41 PM

    dougbatchelder's Avatar

    "Date","Type","Description","Debit","Credit","CheckNumber",
    "4/5/2022","Withdrawal","SHR DRAFT - SHARE DRAFT","-$50.00","","2625"
    "4/5/2022","Withdrawal","ACH TRANS - CHASE CARD SERV ;040522;ONLINE PMT","-$132.30","",""
    "4/5/2022","Withdrawal","ACH TRANS - GREATERVALLEYYMC;040522;PURCHASE","-$43.00","",""
    "4/3/2022","Deposit","TRANSFER - SELF SERVICE TRANSFER FROM DKBCONSULTINGSERVI SHARE 75","","$75.00",""

  3. 3 Posted by stashu.pub on 12 May, 2022 12:41 PM

    stashu.pub's Avatar

    if you are using the mdcsvimport extension, and you mean the -132.30 and +75.00 simply reverse what you call it -Payment- or -Deposit-
    it doesn't matter. They are just opposite sign of each other.

  4. System closed this discussion on 11 Aug, 2022 12:50 PM.

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