unconfirmed transactions duplicating
This is the third time I have had to open a ticked because when I download the .ofx from my bank I get a FULL list of EVERY (over 2000) transaction that have already been confirmed, showing up and unconfirmed. I need to fix this and the .py scripts you sent before are not helping. Please help me and I would also like to know why this keeps happening every few months.
Thank you,
Bob
Comments are currently closed for this discussion. You can start a new one.
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 parr on 13 Nov, 2024 04:39 PM
Any help?
Bob
------ Original Message ------
From: "Infinite Kind" <[email blocked]>
To: [email blocked]
Sent: 11/9/2024 3:20:41 PM
Subject: Your support request has been received by The Infinite Kind
>The Infinite Kind
><https://infinitekind.com> The Infinite Kind technical support:
>infinitekind.com/help <https://infinitekind.com/help>
> email: [email blocked]
>Hello parr!
>
>This is an automated response to let you know that we've received your
>request:
>
>unconfirmed transactions duplicating
>
>and will respond as quickly as possible. Answers to many common
>questions can be found in our knowledge base
><https://infinitekind.tenderapp.com/kb> and user guide
><https://infinitekind.tenderapp.com/kb/user-guides/moneydance-2015-user-guide>.
>
>Based on your support request, we think you may find the following
>articles from our FAQ helpful:
>
>Recognise Downloaded Data
><https://infinitekind.tenderapp.com/kb/online-banking-and-bill-pay/recognise-downloaded-data>
>Confirm Downloaded Data
><https://infinitekind.tenderapp.com/kb/online-banking-and-bill-pay/confirm-downloaded-data>
>Sort and Filter the Register
><https://infinitekind.tenderapp.com/kb/register-and-transactions/sort-and-filter-the-register>
>We'll send an email to you (at [email blocked]) when we update your
>support request. Alternatively, you can keep track of this conversation
>online
><https://infinitekind.tenderapp.com/discussions/online-banking/1249963-unconfirmed-transactions-duplicating>.
>
>Thanks again!
>
>Sincerely,
>The Infinite Kind
>
> Be a part of the Community: Blog
><https://infinitekind.com/blog> |
>Twitter
><https://twitter.com/theinfinitekind> |
>Facebook
><https://facebook.com/MoneydanceApp>
>
>You have been sent this message because you recently opened a help
>request with The Infinite Kind.
>
Support Staff 2 Posted by Maddy on 13 Nov, 2024 05:43 PM
Hi,
We are sorry to hear about the problem you have encountered.
In order to determine what might be causing the problem, could you provide the information below:
Which version and build of Moneydance are you using?
To check, open Moneydance and select Help --> About Moneydance
Which bank/s are you downloading your data from?
Are you able to select the time period you want to download data for from the bank's website?
Thank you
--
Maddy, Infinite Kind Support
3 Posted by parr on 13 Nov, 2024 06:07 PM
Version: 2020.2 (1929)
Bank is Texas Trust Credit Union
I am not able to select a date for the download.
I know you have helped me with this before. This time I am also trying
to find out if this is being caused by Moneydance or my bank. If it is
them, I want to tell them what they are doing wrong.
Bob
4 Posted by parr on 18 Nov, 2024 04:52 PM
Since I hadn't heard back from you I tried using two if the .py scripts
you had sent me... remove_ofx_account_bindings.py and
delete_intermediate_downloaded_transaction_caches.py. I also made sure
to back up before running them and then rebooted after they ran.
This cleaned it up a WHOLE bunch, but there are two confirmations that
still keep showing up even though they have been confirmed.
Much easier to deal with than over 2000 but still an issue.
Let me know what if anything you need from me.
Bob
Support Staff 5 Posted by Maddy on 18 Nov, 2024 05:04 PM
Usually when you navigate to the bank's website and log into your account, you should see a downwards arrow (or similar) next to 'Statement Period', are you able to select custom dates for a specific time period?
If not would you be able to send me a screenshot of what you see before downloading the .ofx file?
If required, you can read instructions for taking a screenshot here:
https://www.take-a-screenshot.org/
To add it as an attachment to this discussion, please click on "Browse" below your next post.
Thank you
--
Maddy, Infinite Kind Support
6 Posted by parr on 19 Nov, 2024 03:07 PM
Okay, I took a closer look and I can select a date range. By default my bank downloads 30 days... though when I had over 2000, that was stuff going several months back.
Anyway, the two in question are withing that 30 days but if I specify a date range that excludes them, they don't show up.
This is seeming to become a common occurrence. Is there anything I can do from my end rather then keep putting in tickets? I am a systems administrator at my company so I am very computer literate and can even write/modify python scripts. I have looked at the ones you sent, but don't know enough about what I am seeing to know how to change when needed.
Bob
Support Staff 7 Posted by Maddy on 19 Nov, 2024 03:45 PM
I'm truly sorry to hear about the issues you have encountered but please allow me to clarify the following:
1) For manual downloads, if you customize the dates, the download should include only data within the time period you have requested. Moneydance will import the data provided by the bank as it is.
2) You shouldn't need to run the script at every download.
OFX and QFX files contain unique transaction identifiers. If you were to accidentally download the same transaction to Moneydance more than once, the ID would be recognised. Moneydance would then ignore the duplicate transactions and not download them again.
Unfortunately QIF files don't contain these same ID's.
If you haven't already, I'd recommend taking a look at this article from the knowledge base that details recognising and confirming your recently downloaded data.
When transactions have been recently downloaded, they'll be 'unconfirmed' which is signified by a blue dot in the register.
To begin the confirmation process, select the first transaction in the register with a 'blue dot'. A panel will appear on the right of your screen which shows the 'Current Transaction' details. You can amend the category within this panel, then select 'Confirm'. You'll see the solid blue dot change to a blue circle. Moneydance will then move to the next unconfirmed transaction in the register.
As you go through this process it will become quicker and easier. Moneydance will begin to recognise the information you have previously confirmed, and start to suggest the correct categories within 'Similar Payees' in the panel on the right.
The next time you download from the bank many of the correct categories will automatically be assigned, and this will improve and you confirm more transactions.
4)You may want to consider upgrading the software.
A new update was released on 17 October 2024 .
Moneydance 2024.2 (5172) is available to download from this page. If you wish to go ahead, you can enter your current license key into the 'Upgrading?' box on this page to redeem a cospicuous discount. After purchasing, you'll be sent a new license key via email within 24 hours.
For a full list of improvements in the preview version, please refer to this page.
Please keep us posted on your progress, Thank you!
--
Maddy, Infinite Kind Support
8 Posted by parr on 19 Nov, 2024 04:06 PM
I do understand all that you mentioned. I know how to confirm transactions, I have been doing this for years. The issue is that from time to time, all of a sudden, I get like 2000 unconfirmed items, but they have all already been confirmed. I ran the scripts you sent in the past and now I still get 2 that are already confirmed. I confirm them again, and download again and these two keep showing up.
Support Staff 9 Posted by Maddy on 19 Nov, 2024 04:32 PM
You could navigate File-> Preferences-> Network and choose the option:
"Only match downloaded transactions when they are at most X days apart" as outlined here. Change the N to 7 or less.
The easiest solution, in similar situations to the one you've described earlier is to restore from a backup of your data from before the 'merge', you can restore and then go through the merging process again.
Alternatively, you could try to delete all newly downloaded transactions and download them again from your bank.
--
Maddy, Infinite Kind Support
10 Posted by parr on 19 Nov, 2024 05:55 PM
Okay, I tried as low as 1 day and as high as 30 days These transactions came in on 10/28 but the date in the register for MoneyDance is 9/6 and 10/25. My Dr has a habit of holding onto checks for months at a time. lol
I don't know what you mean by 'merge'.
Bob
Support Staff 11 Posted by Maddy on 20 Nov, 2024 10:13 AM
Please refer to this article about "Merging Downloaded Transactions".
Side note: You may also want to check the following (just in case):
When viewing the account register, you could simply click in the 'Date' column header. Click again to toggle between ascending and descending order. Alternatively, you should 'right click' (or press Ctrl and click) on any transaction to view the context menu then choose Choose Sort By > Date Entered. Close and restart Moneydance to retain the change.
Finally, you can refer to this article of the Knowledge Base.
--
Maddy, Infinite Kind Support
12 Posted by parr on 20 Nov, 2024 01:51 PM
Not sure why you are telling me this. I know how to sort my transactions. The issue I have is that I have two transactions that show as unconfirmed every time I download my transactions in .osf even though the transactions have been confirmed, multiple times.
13 Posted by parr on 25 Nov, 2024 08:41 PM
What are my next steps? It has never taken this long to get resolution.
Bob
Support Staff 14 Posted by Maddy on 26 Nov, 2024 09:52 AM
Once the desired transactions are highlighted, right-click on any of them and from the resulting context menu, select Mark as cleared. Finally you can delete them.
--
Maddy, Infinite Kind Support
15 Posted by parr on 26 Nov, 2024 11:57 AM
That doesn't help. These two transactions keep coming back. I have confirmed them, I have marked them as cleared, nothing is working.
16 Posted by dtd on 27 Nov, 2024 01:05 AM
The hidden fitid value is what determines if MD decides the transaction is a duplicate or a new transaction. This is important since some items can/do come in with duplicate spends, etc.
First, always do set a date range for the bank. If you don't do that, you indeed can get older information. AND, unfortunately, since this should not happen, the bank will sometimes change the fitid value, which implies the transaction is different.
Take the two transactions in question, and compare them to the transactions already there. Right click each one and pick "Show raw details" at the bottom. Look for these two fields for all four items:
"fi_id" = "ofx:Citigroup:249,,,,.
"fitxnid" = "08852432.....
They should be identical, for each transaction pair. That's what allows MD to determine if they are duplicates. If not identical, then your bank has changed them (when it should not).
If they are not identical, this issue is something your bank is doing.
Also, given the 2000 issue, this is where the date range choice comes in, as MD will only act upon what is downloaded, and if you get all 2000, maybe all of their fitids have changed (i.e. if one changes, it's likely a different server at that bank providing the info and changing all the fitids.)
Finally, with the keep coming back/cleared - you probably also delete one. Do you delete the original or the new one?
17 Posted by parr on 27 Nov, 2024 05:18 PM
Thank you for more information. I did check and both the previously confirmed transactions and the transactions that keep showing up as unconfirmed, in both cases, have identical fitxnid, but none of them have an fi_id field.
I ended up deleting all 4 versions. Re downloading and confirming the transactions, closed, re-opened and finally they are not showing confirmed anymore.
Thank you for your help and the additional info. You can close this issue.
Bob
Maddy closed this discussion on 27 Nov, 2024 05:24 PM.