Moneydance Extension: Extract Data - Transfers and Tags
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
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
1 Posted by Stuart Beesley ... on 15 Jan, 2025 05:06 PM
It is a fantastic extension 😉... Thank you!
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.
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 Posted by Stuart Beesley ... on 15 Jan, 2025 05:25 PM
actually, hold fire. I have managed to replicate your data...
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?
5 Posted by Stuart Beesley ... on 17 Jan, 2025 12:29 AM
@mike63492 ???
6 Posted by mike63492 on 17 Jan, 2025 07:15 AM
Thanks very much., Stuart... I will give it a go, today..
7 Posted by Stuart Beesley ... on 18 Jan, 2025 02:54 PM
???
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]
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.
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
11 Posted by Stuart Beesley ... on 28 Jan, 2025 05:50 PM
This updated extension is now on the manage extensions page too...
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
13 Posted by Stuart Beesley ... on 14 Feb, 2025 11:42 PM
Nothing attached / uploaded?
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
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)
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