Moneydance Extension: Extract Data - Transfers and Tags

mike63492's Avatar

mike63492

15 Jan, 2025 03:39 PM

Brilliant extension which I have started to use more, thank-you.

I have a challenge with transfers, around identifying which Tags apply to which side of the transfer.

In the extract, the SplitTags column shows the tags on the side of the transfer of the account used for posting; the ParentTags shows the Tags on the side of the transfer of the other account, no matter whether the transaction posted is a positive or negative amount.

Attached is an example of 2 transfers, one posted in account "CV3..:" to destination account "CV9....", and the other posted to destination account "CV9.." to account "CV3..."

Is there some kind of true/false flag indicating which account register was used to post the transaction that could be added to the extract?

And secondly, if the destination side of a transfer does not have a Cheque# of its own, is there any way of showing the Cheque# used on the posting side? (Can work-around this with vlookups for the moment to match the 2 sides of a transfer.)

My work-arounds for the moment are to add and additional Tag to indicate which account was used to post the transaction, or use part of the Cheque# to indicate the posting account: both of which I figured-out while writing this request!

Many thanks

Mike Wilson

  1. 1 Posted by Stuart Beesley ... on 15 Jan, 2025 05:06 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    It is a fantastic extension 😉... Thank you!

  2. 2 Posted by Stuart Beesley ... on 15 Jan, 2025 05:09 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    I sort of understand, but it is complex... Can you do the following for me please.

    • File/New and create a test dataset
    • Enter one or two transactions that demonstrate the problems you want to address
    • Use File/Export backup and create a testdataset.moneydancearchive file
    • Provide an extracted file from that file. Edit the file and insert columns indicating what data you would like to see, and colour them. Don't touch the original column's data.

    • upload both the archive and the excel file here...

  3. 3 Posted by Stuart Beesley ... on 15 Jan, 2025 05:25 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    actually, hold fire. I have managed to replicate your data...

  4. 4 Posted by Stuart Beesley ... on 15 Jan, 2025 06:32 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    ok, both sensible requests.. I have made the changes.. Please grab the latest build from here and confirm all is ok?

    https://github.com/yogi1967/MoneydancePythonScripts/raw/master/sign...

    download. make sure it's called extract_data.mxt. Then double click, or drag to the side bar, or use Extensions menu, install from file...

    Let me know how it goes?

  5. 5 Posted by Stuart Beesley ... on 17 Jan, 2025 12:29 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    @mike63492 ???

  6. 6 Posted by mike63492 on 17 Jan, 2025 07:15 AM

    mike63492's Avatar

    Thanks very much., Stuart... I will give it a go, today..

  7. 7 Posted by Stuart Beesley ... on 18 Jan, 2025 02:54 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    ???

  8. 8 Posted by mike63492 on 19 Jan, 2025 09:48 AM

    mike63492's Avatar

    Hi Stuart

    Apologies, I wanted to take enough time to look at it properly.

    It looks great.tried it with splits and non-splits and different
    combinations and cheque # changes on the child transaction.

    (One tiny detail just to show I am paying attention: in my warped brain,
    "ParentTags" and "SplitTags" should be the other way round, but it has no
    practical impact).

    Thanks so much for this. It really is a very useful extension.

    Mike Wilson

    From: Stuart Beesley (Mr Toolbox) <[email blocked]>
    Sent: 18 January 2025 15:54
    To: [email blocked]
    Subject: Re: Moneydance Extension: Extract Data - Transfers and Tags
    [Suggestions #16830]

  9. 9 Posted by Stuart Beesley ... on 19 Jan, 2025 11:19 AM

    Stuart Beesley (Mr Toolbox)'s Avatar

    👍 glad it works!!

    Can you clarify about the tags reversal? They are a tricky thing and if I remember rightly, they are actually stored the reverse of what you enter?

    Can you enter one new txn with tags on two splits and parent, then:
    - take a screenshot of the transaction on both sides (use CMD [ to get to other side) - right click on the the parent and then show raw details. Then send that. - run extract data and send the csv for that txn.

    Then I’ll double check the logic.

  10. 10 Posted by mike63492 on 20 Jan, 2025 10:27 AM

    mike63492's Avatar

    Thanks Stuart
    I will do. Am going on holiday, so it may be a couple of weeks.

    Thanks

    Mike W

  11. 11 Posted by Stuart Beesley ... on 28 Jan, 2025 05:50 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    This updated extension is now on the manage extensions page too...

  12. 12 Posted by mike63492 on 14 Feb, 2025 11:09 PM

    mike63492's Avatar

    Hi Stuart
    I set-up a test database and entered 1 split transaction with 3 lines (1
    posting to a catefory, 2 posting to other accounts).

    I have annotated the extract data extract, and also incliuded the
    MoneyDance archive so that you can see the transactions as they are rather
    than screenshots, if that's ok.There are some other things that look odd
    which are also shown in the notes in the extract concerning "Memo" (parent
    memo? on the child side of a transfer) and when the tags are changed on the
    child side of transfers within a split (I think this is an issue with
    MoneyDance applying the last split tag added/changed to all transactions in
    the split).

    Many thanks

    Mike W

  13. 13 Posted by Stuart Beesley ... on 14 Feb, 2025 11:42 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Nothing attached / uploaded?

  14. 14 Posted by mike63492 on 15 Feb, 2025 06:26 PM

    mike63492's Avatar

    Hi Stuart
    Not sure why the attachments did not arrive. Attaching again with shorter filenames.

    If this does not work, should I send them via the website as a private discussion?

    Thanks

    Mike Wilson

  15. 15 Posted by Stuart Beesley ... on 15 Feb, 2025 06:29 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Nope - not attached. Do NOT reply by email.... You have to click the link and upload files... else they get lost...

    by all means make this thread private.... (again click the link)

  16. 16 Posted by mike63492 on 15 Feb, 2025 06:49 PM

    mike63492's Avatar

    Hi Stuart

    I set-up a test database and entered 1 split transaction with 3 lines (1
    posting to a catefory, 2 posting to other accounts).

    I have annotated the extract data extract, and also incliuded the

    MoneyDance archive so that you can see the transactions as they are rather
    than screenshots, if that's ok.There are some other things that look odd
    which are also shown in the notes in the extract concerning "Memo" (parent
    memo? on the child side of a transfer) and when the tags are changed on the
    child side of transfers within a split (I think this is an issue with
    MoneyDance applying the last split tag added/changed to all transactions in
    the split).

    Many thanks

    Mike W

Reply to this discussion

Internal reply

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

Attaching KB article:

»

Already uploaded files

  • Extract_Data_Parent_and_Split_Tags_Identify_whcih_Side.xlsx 11.6 KB

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