![]() We also adjust "credit" transactions which have a minus sign in the amount to be positive, but only for credit card accounts (which is the only place we've seen these errors). That's why when we encounter a "debit" transaction without a negative sign, we add one, but then that is subject to the type of account (bank, credit card, etc). There have been major financial institutions that indicated whether a transaction was a payment or deposit solely based on the transaction type field. I wouldn't have done that unless it were absolutely necessary. In the past I have added code to Moneydance to override the sign of the amount based on the transaction type field in the QFX data. Curiously, Quicken 2017 for Mac wouldn't import the sample files at all, claiming that the bank wasn't supported! When we tried importing those same files into Quicken for Windows we saw the same behaviour, which isn't surprising because in those specific files there was no possible way to differentiate between transactions that were supposed to be negative or positive based on either the sign of the amount or the debit/credit/payment/etc transaction type. The reason that I hadn't already changed this was because some of the sample Capital One QFX files that I was seeing would have incorrect signs for some of the transactions, regardless of how moneydance processed them. ![]() These are all great points, and I'm glad to see the great conversation about this problem. Transaction Type | Amount Sign | Should be interpreted as (select between addition to account or subtraction from account)įor vast majority of accounts the default options will suffice, but some may require users to set it up as needed.ĭisclaimer: I am a fellow Moneydance user, and have multiple Capital One accounts, including affected Money Market accounts. This setup could be as simple as enumerating possible combinations, here is one example: With that in mind, it seems like the solution would be to have an option for a "special handling" setup for each account in "setup online banking" and/or account properties. Instead what it does is it imposes the pain on Moneydance users. Making a posture and saying "we are right and they are wrong" is not going to force banks to change. Capital One Ing Direct-migrated accounts vs. I think the Moneydance dev team should look at it as a fact of life: there is a variance in how QFX/OFX are being produced, even within realm of a single financial institution (i.e. It may feel good though - I understand that. I can assure you that a few dozen Moneydance users giving up on Capital One is not even a blip for the bank. The simple fact is that the so-called specifications are loose enough to drive a truck through (which is common for almost any spec), and there is no market pressure for the industry to coalesce to a set of acceptable patterns of implementation. QFX is an extension of OFX and it explains in the OFX spec where extensions can be made and how they should be done. Taking Capital One's apparent interpretation there could be a transaction type of Check it has a positive amount and you therefore interpret it as a Deposit. The spec indicates those transaction where the sign is the only consideration, it does say however that the sign should indicate the effect on net worth, and gives the example that a Debit should be negative, I therefore take it that a Credit should be positive, thus I would interpret the specs as saying the transaction type and the sign should match except where it explicitly states that the transaction is completely generic and the sign is the indicator e.g. If the sign is the only consideration then having both Debit & Credit as Transaction types does not make sense, nor does having both Direct Debit and Direct Deposit. ![]() Sections 3.2.9.2 & 11.4.4.3 are the most relevant here.Īt best I believe Capital One have been selective in their reading and interpretation. The OFX spec is publicly available and is also open spec to allow any organisation to implement it. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |