Online Banking Payments dates are wrong in Register
When I create online bill payment with a future date, the transaction in the register is different from the specified bill payment date.
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 Scott Meehan on 16 Jun, 2015 04:39 PM
Hi Cfox570,
The payment date method has changed to use the date that your financial institution's server replies to Moneydance about when the transaction will be registered with them. With many banks, this will most likely be the date that the funds are debited from your account, though all financial institutions have different preferences and restrictions for when they enter the transaction into their system (like financial institutions that don't support payments on weekends or holidays, for example).
Based on the feedback we've received on this issue, we're going to add an option in the next release of Moneydance that allows you to select which date is used. In the meantime, you can manually change the date in the register in Moneydance to your preferred date.
Please let us know if we can be of further assistance!
Scott Meehan
Infinite Kind Support
Scott Meehan closed this discussion on 16 Jun, 2015 04:39 PM.
cfox570 re-opened this discussion on 16 Jun, 2015 09:19 PM
2 Posted by cfox570 on 16 Jun, 2015 09:19 PM
There are two dates shown in Moneydance that are different.
1. When I go to online->bill payment-> outbox, I see the correct date.
2. When I go to my register, I see a different date.
I would assume that the date shown in the outbox comes from the bank. Why is this date not entered into the register? Your explanation below does not address my issue. Note I have used Quicken for 25 years and I am fully aware of the fact that the bank payment date will change based upon the banks response. In the case of Moneydance, the register date is being set to a more recent date. For instance I said pay on June 26. The register shows June 22! Also note that I have confirmed my bank withdrew funds on the same day as shown in the OUTBOX.
Creating the transaction in the register is where the bug occurs.
Craig Fox
[email blocked]
3 Posted by Ben Spencer on 20 Jun, 2015 12:06 AM
Hi Craig
I agree it is confusing for the date shown in the outbox to be the user requested date and the date shown on the transaction in the register to be the date the bank responded with. It would be clearer if they were the same. I'll file a suggestion ticket with the developers to make these tow the same.
However I think that they should both be the date that the bank says it will process the transaction on, not the date that the user requests. It seems that in this case the bank might be making an error with the date it is responding with. It might be worth contacting them and asking them why the are setting the "DTDUE" field in their response so early.
Ben Spencer
Infinite Kind Support
4 Posted by cfox570 on 20 Jun, 2015 02:52 AM
For the record the date in the outbox is the date the transaction actually occurred. In order to speak with the bank I will need a copy of the transaction file sent by the bank. How would I find that?
Craig
5 Posted by cfox570 on 27 Jun, 2015 01:46 PM
How do I retrieve a copy of the transaction file sent from the bank so I can prove to the bank that they are sending me the wrong date. It is very difficult to deal with the bank's customer service without clear proof that they are sending the wrong date.
Please respond promptly. There has been no update to this thread since June 19th.
6 Posted by avp2 on 29 Jun, 2015 12:26 AM
If you are using MD 2015, open the console window under the help menu, clear the window using the bottom of window button/tab and do a download for the account you are interested in. You will see the text of the OFX TX/RX and can copy/paste it.
If you are using an earlier MD, a debugging extension that used to be available from MD does the same thing.
Before passing on any of the data you get, be sure to remove what you consider confidential (like logon credentials).
7 Posted by Brent Billock on 16 Nov, 2015 10:02 PM
I don't accept the answer you've given here that it is the bank's fault. I just upgraded from Moneydance 2012, and its register always displayed the payment date that I requested, not some earlier date. My online banking settings were exactly the same in that version of the software.
When you get paid monthly and your register suggests that your mortgage will be paid a full week before your paycheck, that's truly terrifying. You need to fix this.
8 Posted by cfox570 on 17 Nov, 2015 06:43 PM
Ben,
Despite your claim that my bank is sending incorrect data, they are sending correct data. As you suggested I captured the transaction from the bank for a payment made today. The date I selected in the payment dialog form is 11/24/2015. The date shown in the Online Bill Payment Outbox is 11/24/2015. The date shown in the check register is 11/18/2015. The date returned by my bank as documented below in the DTDUE field is <DTDUE>20151124120000. Note the date 11/18/2015 appears nowhere in the transaction file below!
Sir, there is a bug in the Moneydance software. Version: 2015.5 (1225)
Craig
_____________________________________________________________________
Here is the snippet from the console window for the transaction.
<PMTRS>
<SRVRTID>8PGGSE4OMK
<PAYEELSTID>000000000205
<CURDEF>USD
<PMTINFO>
<BANKACCTFROM>
<BANKID>??????????
<ACCTID>??????????
<ACCTTYPE>CHECKING
</BANKACCTFROM>
<TRNAMT>1307.54
<PAYEE>
<NAME>Keystone Health Plan East
<ADDR1>PO Box 11855
<CITY>Newark
<STATE>NJ
<POSTALCODE>071010019
<PHONE>8888794891
</PAYEE>
<PAYEELSTID>000000000205
<PAYACCT>?????????????
<DTDUE>20151124120000
<MEMO>December premium
</PMTINFO>
<CHECKNUM>6640
<PMTPRCSTS>
<PMTPRCCODE>WILLPROCESSON
<DTPMTPRC>20151120120000
</PMTPRCSTS>
</PMTRS>
9 Posted by Ben Spencer on 17 Nov, 2015 07:58 PM
Could you show me a screenshot of the corresponding transaction in the Moneydance register.
Ben Spencer
Infinite Kind Support
10 Posted by cfox570 on 17 Nov, 2015 08:17 PM
I cannot show you now since I corrected the date.
11 Posted by Ben Spencer on 17 Nov, 2015 08:45 PM
Are you certain the date on the transaction in the register was not 2015/11/20? Since that is the date the bank says they will process the transactions. WILLPROCESSON
20151120120000
Ben Spencer
Infinite Kind Support
12 Posted by cfox570 on 17 Nov, 2015 09:42 PM
Yes the date was not 20151120. They may process early but the withdrawal date is Nov 24.
Craig
13 Posted by avp2 on 18 Nov, 2015 05:20 PM
I am using build 1228. With Wells Fargo online bill pay, my register shows a date that is 7 days ahead of the one I choose as the "due" date when entering an online payment. Wells will not accept a due date that would result in less than 7 days for processing. After entry, the online window says "will process" until the time the payment "clears" the bank, i.e. check cashed or ACH transfer occurs. At that point, the online bill pay window shows "processed". At the next download I do, processed payments show in my register as "uncleared" payments. There are then two transactions in the register for each payment- the scheduled one and the "processed" one. After "merging" processed payments with scheduled payments, only one remains and its date is that of the downloaded/processed one (this is a MD preference which I have set to "use bank's").
This is just what I would expect - bank sends payment in time for it to get to payee by my due date, MD register shows earliest date payment might be sent, after merging, MD register updates to show fund removal date.
14 Posted by cfox570 on 18 Nov, 2015 11:07 PM
avp2,
You did not mention what date is shown in the online window. The date shown in MD is the correct date due whether the status is will process or processed. For my "money", I don't care about the interim process. Most of my payments are transferred the same day. What I care about is knowing when my balance goes below zero. My bank agree to withdraw funds on the due date. That is that. I want to see that date in the register just as I see it in the online window.
15 Posted by Brent Billock on 18 Nov, 2015 11:09 PM
I'm with AV on this. If the money disappears from my account on the due date, that's the date I want to see in the register. Not some arbitrary processing date.
16 Posted by cfox570 on 18 Nov, 2015 11:10 PM
avp2,
I also confirmed that the online window is the date the check withdrawn and sent as a physical check. The settled/download date in my MD register is the date deposited by the merchant.
17 Posted by cfox570 on 18 Nov, 2015 11:11 PM
Note that Moneydance 4 worked correctly.
18 Posted by avp2 on 19 Nov, 2015 01:43 AM
Sorry about not being clear on the online window dates. In my online window, the "will process" date is the date WF plans to "send" the payment. When the window shows "processed", the payment is posted by my bank internally to my account as a debit, the payment is sent to the payee and the amount I have available for withdrawal is (according to WF) supposed to be reduced by that amount.
I have seen, however, processed payments that are shown on the website as debited, but do not reduce the available amount shown by MD (click balance at bottom of MD register) and WF - though I would not count on its "processed" amount actually being available.
System closed this discussion on 19 Mar, 2016 04:55 AM.