Home → Suggestions →

Moneydance Extension: Extract Data - Transfers and Tags

• Edit

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

• Extract_Data_Parent_and_Split_Tags_Identify_whcih_Side.xlsx 11.6 KB

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

   

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

   • Edit

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

   

   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...

   • Edit

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

   

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

   • Edit

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

   

   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?

   • Edit

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

   

   @mike63492 ???

   • Edit

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

   

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

   • Edit

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

   

   ???

   • Edit

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

   

   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]

   • Edit

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

   

   👍 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.

   • Edit

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

    

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

    Thanks

    Mike W

    • Edit

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

    

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

    • Edit

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

    

    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

    • Edit

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

    

    Nothing attached / uploaded?

    • Edit

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

    

    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

    • Edit

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

    

    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)

    • Edit

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

    

    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

    • Personal_Finances_MWIilson_Parent_Child_extract_account_registers_20250215_111347.zip 11 KB
    • Personal_Finances_MWIilson_Parent_Child_extract_account_registers_20250215_111347.xlsx 13.1 KB
    • Edit

17. 17 Posted by Stuart Beesley ... on 18 Feb, 2025 08:30 AM

    

    I just tried to look at this and you have not uploaded the moneydance archive file?

    • Edit

18. 18 Posted by Stuart Beesley ... on 18 Feb, 2025 08:38 AM

    

    ... Given the complexity of your data, I will need the MD file... Use file/export backup and upload that (or zip it first) here. Please make sure it matches your extract too. Thanks

    • Edit

19. 19 Posted by mike63492 on 22 Feb, 2025 09:11 AM

    

    Hi Stuart
    Apologies, just seen your emails.

    I did upload a zip file of the archive (as it would not allow an unzipped version).

    I will try again.

    Mike W

    • Edit

20. 20 Posted by mike63492 on 22 Feb, 2025 09:15 AM

    

    Apologies
    Uploaded a zip of the xl extract by mistake.

    Please see zipped MD archive

    • Personal_Finances.2025-02-15-120104.zip 212 KB
    • Edit

21. System closed this discussion on 24 May, 2025 09:20 AM.

22. Stuart Beesley (Mr Toolbox) re-opened this discussion on 22 Jun, 2025 04:14 PM

23. 21 Posted by Stuart Beesley ... on 22 Jun, 2025 04:14 PM

    

    Reopening…

    • Edit

24. 22 Posted by Stuart Beesley ... on 22 Jun, 2025 04:33 PM

    

    Sorry for the delay in replying and thanks for the backup dataset. I will make comments, one post per reply.

    1. ColumnP: ParentTags - all show "[Split-Tag3]". You may not agree, but this is correct.
       ... when viewing a txn, the tags are from the 'other' side.. Thus when you look at the other side and view the split in the register, you are seeing the parent's tag... There can only be one parent, and thus this value repeats as the parenTag for all the records associated with this.. You can see this in right-click, show raw details:

    0.acctid: c008e7d3-5dc0-4876-854b-add8cd653f9a
    0.desc: Split line 1 - posting to category
    0.id: c7ab967f-3a1c-4b19-b688-d16d7979f053
    0.obj_type: 
    0.pamt: -10000
    0.samt: 10000
    0.stat:  
    0.tags: Parent-Tag-1
    1.acctid: 2359b48e-7219-4173-b916-db705c33c98b
    1.chknum: 
    1.desc: Split line 2 - transfer to acct in base currnecy
    1.id: d58d0d6e-a2ab-4e80-b987-e63c8db25eab
    1.obj_type: 
    1.pamt: -20000
    1.samt: 20000
    1.stat:  
    1.tags: Parent-Tag-2
    2.acctid: efbb6126-73a5-4198-8f8b-a697a2bce956
    2.chknum: 
    2.desc: Split line 3 - transfer to account in non-base currency
    2.id: 5ac4ceda-1bc2-471a-ba5e-0e600629f889
    2.obj_type: 
    2.pamt: -30000
    2.rate: 1.2
    2.samt: 36000
    2.stat:  
    2.tags: Parent-Tag-3
    acctid: 8d9cfc10-4ede-4303-b88d-8b9d018502a5
    chk: Parent-Ref-1
    desc: Split to Categoires and Transfers
    dt: 20250101
    dtentered: 1739570772631
    id: 6c5f5865-fe3f-4cbe-b509-606e7d171e71
    memo: Transaction parent memo
    obj_type: txn
    stat:  
    tags: Split-Tag-3
    td: 20250101
    ts: 1739571097001
    

    NOTE: "tags: Split-Tag-3" - the records without the 0/1/2 prefix are the parent record... Hence, extract_data is replicating this...

    • Edit

25. 23 Posted by Stuart Beesley ... on 22 Jun, 2025 04:41 PM

    

    Splits do not actually have a memo field (despite what the screen says). When viewing / editing the other side / split, you see:

    • The parent's description in the Split's description field
    • The split's Description in the "memo" field....

    Refer the text I pasted above. NOTE: how there's no 0.memo, only 0.desc (etc)

    However, extract_data knows this, and puts the Split's "description" into column L: Memo for you... This column is NOT supposed to be the parent's Memo (use the Description column for that)... But I can see how you could argue that l:Memo could be parent's memo (if we renamed it), but not sure that's necessary?

    • Edit

26. 24 Posted by Stuart Beesley ... on 22 Jun, 2025 04:42 PM

    

    I think this covers your questions? If there were more, please shout?

    Hope this makes sense?

    • Edit

27. 25 Posted by mike63492 on 28 Jun, 2025 10:37 AM

    

    Thanks Stuart, I can see the logic, though I find the Tag logic a bit quriky.

    M

    • Edit

28. mike63492 closed this discussion on 28 Jun, 2025 10:37 AM.