downloading too many transactions

Pepe's Avatar

Pepe

23 Jul, 2020 09:31 AM

I have started with Moneydance and I do not want to rebuild years of financial history but wish to start relatively fresh. I am using MD 2019.3 (1880) on windows and I am downloading from Chase. I am receiving transactions from as far back and 2018. I simply do not need all this information. Therefore each download I subsequently delete the old records.

Is there a cleaner or simpler way to handle this?

  1. 1 Posted by dwg on 23 Jul, 2020 10:33 AM

    dwg's Avatar

    I'm a fellow user.

    I'm assuming you are using Direct Connect to download transactions from Chase. With Direct Connect Moneydance will download all available transactions that are not recorded in the software. If Chase offers manual OFX downloads banks often provide the ability to date limit the downloads, but you have to handle the download and import manually, this may be a worthwhile compromise until the data catches up with what Chase provide via automatic downloads.

    The other approach is to accept that your Chase account(s) may go back further than what you would like and allow the downloads determine where to start the data in Moneydance from, or even to the point of have different start dates for different accounts.

  2. Support Staff 2 Posted by Ethan on 23 Jul, 2020 12:46 PM

    Ethan's Avatar

    I would also add that if you are taking the suggested route of keeping the older transactions, you can simply filter them out of the active view by using the options at the top of the register (This Year, for example), and similarly adjust the date ranges in reports.

    Ethan
    Infinite Kind Support

  3. 3 Posted by Pepe on 23 Jul, 2020 07:53 PM

    Pepe's Avatar

    Thanks for the answers but to correct one assumption I am only using the manual download function. One of my early downloads included the full data set which I did realize would go back so far.
    However, it seems the only solution is accept the 4908 transactions and then offset the initial balance to a reasonable beginning balance. And then hide this mess from view by only considering the past 30 days or so?

  4. 4 Posted by Pepe on 23 Jul, 2020 07:55 PM

    Pepe's Avatar

    sorry typo "I did (not) realize (it) would go back so far."

  5. 5 Posted by dwg on 23 Jul, 2020 09:13 PM

    dwg's Avatar

    The answer is still much the same, the only difference is that often Banks with manual downloads provide things like date filters that can limit the amount of data downloaded.

    It really does not matter what date, you will generally need to have an initial balance to set the account balance to be the correct amount prior to the first transaction in Moneydance.

  6. 6 Posted by Pepe on 24 Jul, 2020 10:20 AM

    Pepe's Avatar

    This is a remarkably bad situation. Restricting the download file still requires resolving all these erroneous entries. I am now confirming all transactions and putting a massive balance adjustment to offset this mess.

    Now I have no intelligible view. Restricting the view to one month seems to obscure most of my upcoming transactions. I am simply trying to manage cash flow and future payments but now I will always need to look at thousands of meaningless historical entries or I will not see the upcoming 40+ days of transactions that I want to focus on.

    Clearly they needs to be a better solution.

  7. 7 Posted by dwg on 24 Jul, 2020 10:39 AM

    dwg's Avatar

    I do not understand how if you restrict the data downloaded to only include data from a certain date how you would get historical data you do not want.

  8. 8 Posted by Pepe on 24 Jul, 2020 11:22 PM

    Pepe's Avatar

    I agree. The issue, I am guessing is that downloading once with all the data has written this data somewhere on my hard drive or to MD's database. It is this data that I am continually reloading every time I do a download which is constrained to only the past few days.

    Is there no ability to archive this so that it is not part of my file?

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