Removing cleared records

Joe's Avatar


16 Jan, 2019 09:18 PM

How do I remove/delete cleared records without affecting the balances on accounts. I have records dating back two years that I have cleared but not removed from my data file. I would like to remove these to make the data file smaller. I know I can back up these records for future use.

  1. 1 Posted by dwg on 16 Jan, 2019 09:34 PM

    dwg's Avatar

    I'm a fellow user.

    The short answer is you cannot and even if you could it would have the opposite effect and make your data file larger.

    Moneydance writes data as a series of Additions, modifications, deletions.

    So it keeps everything, it does not have a single record of a transaction that it modifies or deletes but rather it records the changes over time as a set of discrete entries. ultimately this could facilitate a rollback facility where you could undo changes in the reverse order.

  2. Support Staff 2 Posted by Tom Freeman on 16 Jan, 2019 10:09 PM

    Tom Freeman's Avatar

    Is the size of your file causing functionality issues. If so then this may indicate another issue.

    If there is an issue with your file slowing down any money dance process then please give us the details and send me your errlog.txt file? If you're using Mac OS X, it should be located at one of these locations within your Home folder:

    ~/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance/errlog.txt


    ~/Library/Application Support/Moneydance/errlog.txt

    If you have any trouble finding your Home Library folder, open Finder and select Go -> Go to Folder and and copy and paste in the following:


    This should pull up your local Library folder.

    If you're using Windows, it should be located at:


    Tom Freeman
    Infinite Kind Support

  3. 3 Posted by mhoggie on 17 Jan, 2019 05:09 AM

    mhoggie's Avatar

    just a user,

    This is the 2nd time I've read that deleting transactions grows the file system so I tested this issue out. I took an old copy of my current data set with 8 years history, noted the file space used, and deleted all checking transactions prior to 2018. Rechecked the .moneydance file size and yes the file system grew. But the folder and file count stayed the same. So I suppose the MD database is like other databases I've used like Oracle and a deleted entry or field is simple marked deleted, but still remain. But with those databases there are tools to strip out old space when files space warrants. Not sure why the file space would grow on MD unless additional data is added to the database to mark the old elements as deleted. So it's true, deleting a large quantity of transactions increases the MD database size. I suppose if you wanted to discard the deleted database space, you would just do a backup export, create a new file name, and restore from backup. But didn't test that theory.

  4. 4 Posted by dwg on 17 Jan, 2019 05:45 AM

    dwg's Avatar

    A backup strips out syncing information but as far as I know nothing else.

    An export writes out a file, and of the options present you would probably want a QIF file, but that just has your raw transactions, yes I believe it consolidates all entries for a transaction into one but I understand you lose things like reminders, syncing information etc, If I recall correctly it also loses events like stock splits.

  5. System closed this discussion on 18 Apr, 2019 05:50 AM.

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

Keyboard shortcuts


? 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