VISA downloads and imports but does not display in register
I recently installed "beta" updates from you - see Investments #294 and correspondence from your Mr. dwg on and around Aug 19th on an unrelated problem....could that update have caused this issue??
I just downloaded 91 VISA transactions and the file is in my downloads file ok. I did file import and the transactions screen reported "successfully imported" or similar in the message bar at the bottom of the register. I saved and went to "reconcile". The new transactions ARE in the reconcile list, but the reconcile totals were off so I went back to the register. The new downloaded transactions do NOT show on the register and are not reflected in the register balance.
I tried file import a second time. Again I got the "successful import" or similar message, but the number of transactions total imported is now DOUBLED (I think). None of the newly downloaded transactions show in the register but all of the new transactions now show TWICE (duplicated) in the reconcile list.
Clearly the import function is working ok but it is not posting to the register.
Due to our prior exercises I have pretty good Time Machine history and even a thumb drive export, so I can probably back this off and start again. I will wait for instructions from you before doing that.
Please put this on high priority. I have other transactions to do and I will hold that in case we have to Time Machine this data.
Thanks
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 Ian L on 26 Aug, 2015 03:08 PM
Hi Bob,
Could you send me a screenshot or your register with the missing transactions? You can read instructions for taking a screenshot from here:
http://www.take-a-screenshot.org/
Ian
Infinite Kind Support
2 Posted by Robert Hovey on 26 Aug, 2015 07:34 PM
Ian thanks for your help. I have attached two screen shots. One is the register where the most recent import should be posted. Note the top two entries are journals I put in for VISA bills in process but not yet cleared - these will merge or be deleted when the import posts. Note the 182 unconfirmed transactions note at the bottom of the register…reflecting two attempts to import. The register is seeing them somewhere, but they don’t show on the register.
The second shot is one page of reconcile. The data is good with the register to 7/26 when I did an interim import weeks ago. After that date the entries are duplicated…. not necessarily right behind each other but if you look 2-5 transactions around you will see them. This is because I tried a second import on hopes that it would hit the register and I could delete any extras. It did not post to the register either.
Bob Hovey
[removed by support staff] cell
Support Staff 3 Posted by Ethan on 27 Aug, 2015 01:00 PM
It looks like you've enabled the split register mode, which separates out your unconfirmed from your confirmed transactions, but your display size has been reduced to not display the unconfirmed transactions at all. You have two options. One would be to click and drag up the bar at the bottom of your register that says "182 Unconfirmed Transactions," which will reveal your unconfirmed transactions under this bar. Your other option would be to exit the split register view so that your unconfirmed and confirmed transactions will appear in the same register together. You can toggle this view by clicking of the icon that looks like a box just to the right of the New Transaction button at the upper right of the register.
If you have imported your transactions twice, it may be easier to resolve this by selecting all of the unconfirmed transactions from these imports and deleting them all, and then just import the file once again. You should then have only one set of these transactions, and you can go ahead with the confirmation process.
Please let me know if I can be of further assistance,
Ethan
Moneydance Support
4 Posted by Robert Hovey on 27 Aug, 2015 05:26 PM
Ethan you were correct. I didn’t know that screen view button was there. Must have dinged it running the slider on the right side.
So far I have:
Toggled the display button back to traditional register view.
Deleted all the problem transactions in the register using a date range and shift click to select them.
Imported again from the original download file. All seem to have posted correctly and do show in the register.
Opened account reconcile.
All transactions in the reconcile list match my bill through 8/18 by actual matchup with one exception.
One small credit remains uncleared in the time span that did not show on the printed statement (no big deal, I’ll clean it up)
Remaining issue:
the balance forward on the reconcile page is not correct.
It is the same as it was on the screen grab I sent you previously (with the problem transactions) so when I deleted the transactions it appears that it did not roll back the “balance forward” field???
I can’t get the balance forward box on reconcile setup to take the correct balance forward, but if I could enter the correct balance forward the account would reconcile.
Please help me change this balance forward amount in reconcile.
Bob
Bob Hovey
--------------------
5 Posted by Ian L on 29 Aug, 2015 12:08 PM
It looks like you may have marked some of the duplicated transactions as cleared already, so they are being included in the beginning balance. Please check your register to make sure that there are not cleared transactions that should be marked as uncleared or reconciling.
Ian
Infinite Kind Support
6 Posted by Robert Hovey on 29 Aug, 2015 06:59 PM
Hi Sir
The yellow diamond reconciling expenses in the register and in the reconcile box, and the one credit, match the paper statement ok. The total of those reconciling entries shown on the bottom of the reconcile box is equal to the “purchases” on the paper statement. The one credit matches also..
Before involving y’all, I imported twice before going back and deleting the troubled transactions, so I may have doubled up somehow there. When deleting all the duplicate transactions, I took out both copies, both the original transaction and the duplicate transaction, selected by date range in the register, with a single delete command. I then did a clean import from the original downloaded file.
To fix this, I have now entered an offsetting journal entry in the register, and reconciled it, to complete reconciling the account. I created a new “expense” account for the event, which I will just have to un-highlight when running reports for this period.
I now show a good beginning balance for the next month.
Next time I will contact you before trying to fix things like this. Likely my duplicate import is the root of the problem.
As usual, thanks for your help and responsiveness. You are what makes MD special.
Bob
Bob Hovey
Support Staff 7 Posted by Ethan on 30 Aug, 2015 01:33 PM
Hello Bob,
I'm glad to hear that things have been sorted out! Please let us know if we can be of further assistance,
Ethan
Moneydance Support
Ethan closed this discussion on 30 Aug, 2015 01:33 PM.