tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/76055-troubles-with-moneydanceInfinite Kind: Discussion 2022-04-13T12:20:20Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/495636262021-12-24T15:33:12Z2021-12-24T15:33:12ZTroubles with Moneydance+<div><p>Hi Rob,</p>
<p>We are sorry to hear about the problem you have encountered.</p>
<p>Please find my replies below:</p>
<p>1) <strong>The absolutely most annoying behavior is that Moneydance+ uses the wrong account balance for reconciliation. It downloads cleared transactions (which is correct) but it uses the pending transaction balance to reconcile against (which is incorrect). This creates a mismatch that I need to manually resolve by opening a web browser, login in to my bank, finding the correct balance and typing it in</strong>.</p>
<p>This shouldn't be happening.<br>
The reconciled balances in Moneydance are a calculated from:<br>
Initial Balance of the Account + Cleared Deposits - Cleared Payments<br>
To adjust the reconciled balance, you'll need to adjust one of these variables. If your reconciled balance changed, that must mean that one of the following happened:</p>
<p>1) Your account's starting balance changed<br>
2) One or more cleared transactions were either deleted, had their amount modified, or added<br>
3) One or more transactions were marked (or unmarked) as cleared</p>
<p>Any one of the above would affect the reconciled/cleared balance of an account and could have caused the difference. Moneydance does display an extra confirmation/warning window when you try to do either 1 or 2 in the account's register.<br>
Also, if you had the <em>Mark transactions as cleared when confirmed</em> enabled, in the Network section of the Preferences window, and you performed a download and confirmed transactions with that setting enabled, then those confirmed transactions would have been marked as cleared, affecting the reconciled balance.<br>
So, to correct the problem properly, you'd need to reverse the root cause of the change in reconciled balance.<br>
You could also get the reconciled balance back to the correct value by simply entering an adjustment, either to the account's starting balance or by entering an adjustment transaction and marking it as cleared.</p>
<p>2) <strong>Some accounts will randomly stop downloading transactions. No error is given, the sync date looks correct, eventually transactions start randomly coming through again maybe a week or two later. Specifically this occurs with American Express.</strong></p>
<p>Upgrading to <a href="https://infinitekind.com/preview">Moneydance 2022.3 (4063)</a> and recreating the connection as outlined <a href="https://infinitekind.tenderapp.com/kb/moneydance/connect-accounts-with-moneydance">here</a>.</p>
<p>3) <strong>Downloads do not work for investment accounts, even ones from the same bank as my checking accounts. This is a step backwards, as these used to function. Furthermore Moneydance+ makes it looks like it should work by allowing you to link the accounts, it just never actually does anything.</strong></p>
<p>Moneydance + doesn't currently support Investment Accounts as outlined in our <a href="https://infinitekind.com/blog/moneydance-2022">blog</a> and also in <a href="https://infinitekind.tenderapp.com/kb/moneydance/moneydance-overview">this article</a> of the Knowledge Base. We can notify you when Investment Accounts will be supported in the future.</p>
<p>4) <strong>One of the investment accounts above requires constant relinking. This is highly annoying, particularly because even when it is linked, it does nothing. So the logical thing to do would be for me to just remove that account from Moneydance+ so I could stop the incessant error pop ups. But...that does not appear possible. There is no delete button, no context menu, nothing that I can find to delete an account from Moneydance+.</strong></p>
<p>In order to achieve this navigate to Online menu->Moneydance+ Set up and where it reads "Connected" on the right, click and select disconnect in the popup.</p>
<p>I hope this information is helpful. Please let us know if you have further questions or need more assistance.</p>
<p>--<br>
Maddy, Infinite Kind Support</p></div>Maddytag:infinitekind.tenderapp.com,2009-01-14:Comment/495636262021-12-24T15:50:27Z2021-12-24T15:50:27ZTroubles with Moneydance+<div><p>1) I will try this next time I have new transactions.<br>
2) Upgraded, will monitor with the pre-release version you sent.<br>
3) OK, waiting.<br>
4) This does not work. At least not as smoothly as you describe. (1) The menu item is not available for an account that needs to be relinked. (2) So I relink the account, and refresh the list. This creates two entries in the list for the same bank, one that is linked and one that says it still needs to be relinked. (3) I click the menu to remove the connection for the linked account, there is still no option to remove the account that needs relinking., Pop ups telling me the account needs to be relinked continue to pop up, annoyingly. (4) Refresh the list again, still no change. (5) Close moneydance and re-open, error messages again, now there is a context menu to allow me to disconnect the account that says it needs to be relinked. I click it. (6) The bank is left in the list but now is named “no name”. (7) Refresh the list manually again and the bank is finally removed. I will re-iterate that this user interface has bugs and needs some work.</p></div>robtag:infinitekind.tenderapp.com,2009-01-14:Comment/495636262021-12-27T13:51:25Z2021-12-27T13:51:25ZTroubles with Moneydance+<div><p>On 4) Ever since deleting the account which needed to be relinked, I get a new annoying error message every time I start Moneydance. “Bank Name: Moneydance+ Error Code: 880012 Error type: INVALID_INPUT Error code: INVALID_ACCESS_TOKEN Message: could not find matching access token”</p>
<p>This message pops up repeatedly, and is extremely annoying.</p></div>robtag:infinitekind.tenderapp.com,2009-01-14:Comment/495636262021-12-28T09:31:58Z2021-12-28T09:31:58ZTroubles with Moneydance+<div><p>When you are returned Error code: INVALID_ACCESS_TOKEN, it means that Moneydance + is trying to refresh but Plaid is saying there is a problem. You should navigate to the Online>Setup Moneydance + menu again and look in the connections list.<br>
When you see "no name" listed, you should disconnect it.</p>
<p>--<br>
Maddy, Infinite Kind Support</p></div>Maddytag:infinitekind.tenderapp.com,2009-01-14:Comment/495636262021-12-28T12:39:07Z2021-12-28T12:39:07ZTroubles with Moneydance+<div><p>The only bank with no name was already removed, as I described in my previous response. This error persists despite all banks in the setup window appearing to be valid.</p>
<p>Again…Moneydance+ has bugs, help please.</p>
<p>Sent from my iPad</p></div>robtag:infinitekind.tenderapp.com,2009-01-14:Comment/495636262022-01-01T15:04:06Z2022-01-01T15:04:06ZTroubles with Moneydance+<div><p>I would like to give you an update on the reconciliation issue. I have confirmed that it is absolutely working incorrectly for one and only one account. When I choose to reconcile this account, the starting balance is correct, the “End Statement Balance” is puling from the ending balance that includes pending transactions, as opposed to the ending balance that only includes the posted and downloaded transactions. This balance that Moneydance is using matches the pending balance to the penny every single time. Moneydance should be using the posted transaction balance and not the pending transaction balance for the “End Statement Balance”.</p></div>robtag:infinitekind.tenderapp.com,2009-01-14:Comment/495636262022-01-01T17:40:58Z2022-01-01T17:40:58ZTroubles with Moneydance+<div><p>@rob, Since it only happens for one account, it would appear that it is an issue with Plaid giving the wrong number to MD for the account. Plaid is trying to deal with various weirdness of a lot of different banks and may have gotten this one wrong.</p>
<p>It is unfortunate of the new reality that this error has to go to IK who can possibly report it to plaid and then wait for the third party to get it fixed. It might help to have the console window open while attempting the reconciliation download and interaction with your bank. This detail could be sent to IK to help them isolate and document the error. If so, you probably want to make this conversation private when you post the info.<br>
(Not IK Support)</p></div>sthtag:infinitekind.tenderapp.com,2009-01-14:Comment/495636262022-01-03T10:29:16Z2022-01-03T10:29:16ZTroubles with Moneydance+<div><p>Could you send us the contents of your console log, from when you're trying to connect to American Express via Moneydance+?</p>
<p>In order to get the logs:</p>
<p>1) In Moneydance, select Help > Console Window. This will open the console messages window.<br>
2) While the Console Window is open, attempt to connect to your bank using Moneydance+. Any error messages should be recorded to the Console.<br>
3) Select all of the text in the Console and use the "Copy to Clipboard" button at the bottom to copy the text.<br>
4) Paste the text from the message window into a text file (preferably saved with a .txt extension) and attach that file to your response <a href="https://infinitekind.tenderapp.com/discussions/problems/76055-troubles-with-moneydance">here</a>.</p>
<p>The debugging logs that this produces may contain your account information. <strong>This conversation is now private</strong>. Just to be safe you can redact any account info in the debug logs. Just replace it with something like "ACCOUNT NUMBER HERE" and it will be fine.</p>
<p>Thank you</p>
<p>--<br>
Maddy, Infinite Kind Support</p></div>Maddytag:infinitekind.tenderapp.com,2009-01-14:Comment/495636262022-01-08T14:59:57Z2022-01-08T14:59:57ZTroubles with Moneydance+<div><p>I performed this today, but there are no error messages in the console log, only a list of matching transactions and nothing about the value to which to reconcile which is the problem at hand. Thus I prefer not to post. If it helps, it is Schwab Bank and Moneydance continues to attempt to reconcile to the pending balance as opposed to the actual posted balance.</p></div>robtag:infinitekind.tenderapp.com,2009-01-14:Comment/495636262022-01-10T10:33:30Z2022-01-10T10:33:30ZTroubles with Moneydance+<div><p>Thank you for the additional information Rob!</p>
<p>According to your statement in your initial post: "Some accounts will randomly stop downloading transactions. No error is given, the sync date looks correct, eventually transactions start randomly coming through again maybe a week or two later. Specifically this occurs with American Express." I was on the impression we were troubleshooting this. So, please let us know if this seems to work now or whether it is working sporadically, perhaps?</p>
<p>Also, please let me clarify that at this time, Moneydance+ does not support investment accounts as outlined in our <a href="https://infinitekind.com/blog/moneydance-2022">blog</a>.<br>
We are working with <a href="https://plaid.com/">Plaid</a> (the third-party aggregator that our Moneydance+ service uses) to enable this, but we can't speculate on when that will be released.</p>
<p>Unfortunately, Schwab OFX (Direct Connect) downloads are no longer available. Schwab has disconnected this service without a replacement. We are working to restore a connection through Moneydance+ which was recommended by Schwab as the only way forward due to security concerns on their side.<br>
In conclusion, using Moneydance+ in Moneydance 2022 you can download banking transactions from Schwab accounts, but investment accounts are not yet accessible.</p>
<hr>
<p>If the problem you are experiencing seems to be affecting a Schwab bank account (not investments) and you wish us to troubleshoot further, we would need to check the content of your Console from when you are connecting to Schwab in order to determine what might be causing an issue. Generally, we are not receiving other reports concerning an issue connecting with Schwab, so it would be good to narrow down what is affecting you account specifically.</p>
<p>Thank you</p>
<p>--<br>
Maddy, Infinite Kind Support</p></div>Maddytag:infinitekind.tenderapp.com,2009-01-14:Comment/495636262022-01-10T10:55:16Z2022-01-10T10:55:16ZTroubles with Moneydance+<div><p>For sporadic issues with American Express you offered the beta release. I have that installed and have not had the issue reoccur, it is a watch item because, it was sporadic.</p>
<p>Schwab BANK accounts are downloading just fine except you are using the PENDING account balance to reconcile against as opposed to the POSTED account balance. This is the issue we are troubleshooting, and nothing in the console log says anything about which field in the data your program is using as the reconciliation balance. To be clear, I am using Moneydance plus already, I know OFX is not working for Schwab any longer.</p>
<p>Sent from my iPad</p></div>robtag:infinitekind.tenderapp.com,2009-01-14:Comment/495636262022-01-10T12:27:31Z2022-01-10T12:27:31ZTroubles with Moneydance+<div><p>Please can you clarify what you mean by "you are using the PENDING account balance to reconcile against as opposed to the POSTED account balance."?</p>
<p>Could you send us a screenshot of what you're seeing, this might help.<br>
You can read instructions for taking a screenshot here:<br>
<a href="https://www.take-a-screenshot.org/">https://www.take-a-screenshot.org/</a></p>
<p>Thank you</p>
<p>--<br>
Maddy, Infinite Kind Support</p></div>Maddytag:infinitekind.tenderapp.com,2009-01-14:Comment/495636262022-01-12T03:28:48Z2022-01-12T03:28:48ZTroubles with Moneydance+<div><p>It is not something that you can easily explain with a single screenshot so let me give you a scenario.</p>
<p>1) You have a starting balance of $100. You have two posted transactions, one for $5.50 and one for $4.00. Your posted balance on the account is $90.50. You have another transaction for $4.43 that is pending, meaning the bank is aware of the charge but has not posted it to your account. The pending balance is therefore $86.07.</p>
<p>2) You download transactions for the account in Moneydance. Moneydance downloads the transactions for $5.50 and $4.00, but not the pending transaction. This is correct behavior and consistent with all other banks.</p>
<p>3) You choose to reconcile Moneydance to your online balance by choosing the Account > Reconcile menu option.</p>
<p>4) You are presented with a dialog which has your “Beginning Statement Balance” listed as $100.00, this is correct</p>
<p>5) The same dialog lists the “End Statement Balance” as $86.07” this is INCORRECT. Moneydance only downloaded two transactions but has downloaded and used the balance that includes the third pending transaction as the value to reconcile against.</p>
<p>6) You are forced to go out to the bank’s website, look up what the actual posted balance is, enter it in the dialog box and reconcile Moneydance as normal.</p>
<p>Bottomline, Moneydance should have pre-populated that dialog with $90.50 and not $86.07. The fact that it doesn’t download the transactions but perfectly matches what I am calling the pending balance every time says this is a bug, not a fluke.</p>
<p>Again, other banks that are not Schwab Bank appear to work correctly.</p></div>robtag:infinitekind.tenderapp.com,2009-01-14:Comment/495636262022-01-12T12:13:40Z2022-01-12T12:13:40ZTroubles with Moneydance+<div><p>Thank you for the excellent description of what seems to be the problem for your Schwab bank account. I suspect that if the issue is affecting this account specifically and not others, there might be a minor factor causing it.</p>
<p>Generally, the reconciled balances in Moneydance are a calculated from:<br>
Initial Balance of the Account + Cleared Deposits - Cleared Payments</p>
<p>To adjust the reconciled balance, you'll need to adjust <strong>one of these variables</strong>. Since your reconciled balance changed, that must mean that one of the following happened:</p>
<p>1) One or more cleared transactions were either deleted, had their amount modified, or added<br>
2) One or more transactions were marked (or unmarked) as cleared</p>
<p>Any one of the above would affect the reconciled/cleared balance of an account and could have caused the difference.</p>
<p>Also, if you had the <em>Mark transactions as cleared when confirmed</em> enabled, in the <em>Network</em> section of the <em>Preferences</em> window, you performed a download and confirmed transactions with that setting enabled, then those confirmed transactions would have been marked as cleared, affecting the reconciled balance.<br>
Please can you verify this?</p>
<p>So, to correct the problem properly, you'd need to reverse the root cause of the change in reconciled balance.</p>
<p>You could also get the reconciled balance back to the correct value by simply entering an adjustment, either to the account's starting balance or by entering an adjustment transaction and marking it as cleared.</p>
<p>I hope this information is helpful. Please let us know if you have further questions or need more assistance.</p>
<p>--<br>
Maddy, Infinite Kind Support</p></div>Maddytag:infinitekind.tenderapp.com,2009-01-14:Comment/495636262022-01-12T12:19:13Z2022-01-12T12:19:13ZTroubles with Moneydance+<div><p>I am highly confident that it is not working as you describe. Every week I enter the correct cleared balance, and every week Moneydance goes back to using the pending account balance, precisely to the penny. If it was an issue on my end, it would not match the pending balance to the penny, every, single, week.</p>
<p>There is an issue with your Schwab bank interface. This is getting to be exhausting.</p>
<p>Sent from my iPad</p></div>rob