Downloading transactions

sgermain1966's Avatar

sgermain1966

22 Aug, 2019 02:31 AM

If I download transactions into money dance that have already been downloaded, so then being a duplicate, will I have to manually review all of them and delete them one by one, or will the system recognize them and scared them automatically.
My bank changed website and I am not able, or at least don't know how, to lowland transactions for a particular date.

Thank you much

  1. 1 Posted by derekkent23 on 22 Aug, 2019 06:35 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    It depends, what file formats does your bank provide, OFX, QFX, OFC, QIF or CSV?
    What version and build of Moneydance are you running 2019.4(1888)?

  2. 2 Posted by sgermain1966 on 22 Aug, 2019 05:20 PM

    sgermain1966's Avatar

    The file is OFX.Version is 2019.3 (1880)
    Thanks

  3. 3 Posted by derekkent23 on 22 Aug, 2019 06:36 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    The OFX files should contain a "Unique Transaction ID" (FITID) for each transaction. Moneydance uses this ID to prevent duplicates.

    The following is an extract of one transaction from my credit card downloaded OFX file. Note the FITID number.

    <TRNTYPE>DEBIT</TRNTYPE>
    
    <DTPOSTED>20190806000000</DTPOSTED>
    
    <TRNAMT>-2.90</TRNAMT>
    
    <FITID>20190806000000001</FITID>
    
    <NAME>Southend On Sea Boroug, Southend</NAME>
    
    <CARD>Visa</CARD>
    
    <MEMO>On S XXXX/2.90 POUND STERLING GREAT BRITAIN</MEMO>
    

    I am running Moneydance 2019.4(1884). It does not matter how many times I import this file the transaction only appears once.

    Worth opening your OFX file from your bank in a text editor to make sure they have included for each transaction a FITID.

    Also, if you right click on a transaction imported via an OFX file and select “Show transaction details” it should include the FITID

    Hope this helps.

  4. 4 Posted by sgermain1966 on 26 Aug, 2019 02:42 PM

    sgermain1966's Avatar

    it worked. Thank you much

    I am having to reconcile every transaction and I was wondering if there is
    a way for money dance to recognize transactions from the same vendor and
    categorize them automatically
    thanks

  5. Support Staff 5 Posted by Maddy on 26 Aug, 2019 02:50 PM

    Maddy's Avatar

    Hi Stephan,

    The automatic assignment of categories relates to the 'confirmation process'. This is detailed in this article from the Knowledge Base.

    When transactions have been downloaded from the bank, they'll be 'unconfirmed' which is signified by a blue dot in the account register.
    To begin the confirmation process, select the first transaction in the register with a 'blue dot'. A panel will appear on the right of your screen which shows the 'Current Transaction' details. You should amend the category within this panel, then select 'Confirm'.
    You'll see the solid blue dot change to a blue circle. Moneydance will then move to the next unconfirmed transaction in the register.
    As you go through this process it will become quicker and easier. Moneydance will begin to recognise the information you have previously confirmed, and start to suggest the correct categories within 'Similar Payees' in the panel on the right.
    The next time you download from the bank many of the correct categories will automatically be assigned, and this will improve and you confirm more transactions.

    I hope this information is helpful. Please let me know if you have further questions or need any assistance.

    --
    Maddy, Infinite Kind Support

  6. 6 Posted by sgermain1966 on 26 Aug, 2019 07:36 PM

    sgermain1966's Avatar

    Thank you very much

  7. 7 Posted by sgermain1966 on 31 Aug, 2019 02:09 PM

    sgermain1966's Avatar

    Hello again,
    I want to manage my credit cards accounts with Moneydance as well.
    American Express only gives me options to download as Quicken, Quickbooks
    or CSV. Those options do not seem to be available with Money dance
    please advise
    Thank you
    SG

  8. 8 Posted by derekkent23 on 31 Aug, 2019 02:20 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi stephan

    If you download the the file described as Quicken does it turn a to be a QFX file, it not what is its file type.
    Moneydance can import QFX files.

    As a last best option Moneydance can import CSV files if they are correctly formatted using its own importer or there is a third party importer that more flexible.

    Hope this helps.

  9. 9 Posted by sgermain1966 on 31 Aug, 2019 03:43 PM

    sgermain1966's Avatar

    it did, thank you very much

    new question, how do i enter credit card payments from my bank account ?
    I am having problems doing this as it doubles transactions on the receiving
    account

    hope this makes sense

  10. 10 Posted by derekkent23 on 31 Aug, 2019 04:39 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    If you are making a payment from your bank account to your credit card to reduce the credit card debt all you need to do is in the bank account register set the category to your credit card account and enter the payment value in the payment box.

    I assume one you import the QFX file you are following the Confirm process see https://infinitekind.tenderapp.com/kb/online-banking-and-bill-pay/c... to merge duplicate transactions.

    Hope this help.

  11. System closed this discussion on 30 Nov, 2019 04:40 PM.

  12. sgermain1966 re-opened this discussion on 08 Mar, 2020 02:44 PM

  13. 11 Posted by sgermain1966 on 08 Mar, 2020 02:44 PM

    sgermain1966's Avatar

    my dowloaded transactions appear 3 times on the ledger
    Please help
    I have tried all extensions available from Chase bank.

  14. 12 Posted by derekkent23 on 08 Mar, 2020 04:37 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi sgermain1966

    Again its not a good idea to ask the same question twice or more
    See https://infinitekind.tenderapp.com/discussions/online-banking/15507...

    Hope this helps.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

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