Maddy on 10 Dec, 2019 02:05 PM
Thank you for the additional information, Paul!
Although version 1.0.2 is a very old version of OFX, it supports a lot more than banks usually use, including pending transactions.
May I ask why the pending transactions are a problem? Does Moneydance not show them properly? When the pending transaction goes through, the bank should send an update with the new status of the transaction.
on 10 Dec, 2019 03:13 PM
The problem seems to be that NatWest (actually processed by RBS) are including pending transactions and the corresponding balance is shown as £0.00 and there is no Descriptive field (NAME in OFX). If (as they always are) the transaction is the last one for that account in the file, it means that the corresponding last statement balance is £0.00 which means that automatic reconciliation is impossible.
I have been using OFX files for many years with Quicken (which my wife uses on Windows) and now Moneydance. They both worked perfectly until firstly last year (which they managed to sort out after lengthy negotiations!) and now recently which they (NatWest) don’t appear capable of dealing with. I have contacted the person who I was indirectly dealing with last year in RBS but I don’t know whether he will be able to help.
I hope a .png file is OK for you. I can do a pdf if you would prefer.
This starts just before the end of the previous file which I copied by hand.
It’s come up omn screen for me so I presume that’s OK - it’s a screen grab.
As you can see, the balances are £0.00
Hope this is OK for you.
As you can see there is no <NAME></NAME> field.
This is not the last part of the OFX file as there is more than 1 account. I do not seem to be getting any problems with the credit card accounts - just the Current/Checking accounts. nIf necessary, I could obtain an OFX file for one account but I would have to find an account that has pending transactions - it doesn’t, of course, happen every day. This extract is from yesterday(?).
Maddy on 12 Dec, 2019 11:34 AM
Unfortunately, the balance shown has nothing to do with pending transactions. It is simply the bank saying that there is a ".00" balance in the account, as of the end of the statement. There isn't really anything we can do about that, especially since the pending transactions are indistinguishable from regular transactions.
Please let me know if you have further questions or need any assistance.