There does not appear to be any accommodation for the Cheque number in the OFX spec so it looks like banks to include it have to put it in what the spec calls the 'Memo' field, hence where it ends up. This is just a text string, it would not be easy for the software to determine with certainty if a Cheque number appears in the string in order to move it.
on 25 Dec, 2019 07:58 PM
Thanks for your response, dwg. I have done a little programing in my day (now retired) , and noting that it is just a text string, It seems like it would be easy to capture the number and place it the Check number column. Acknowledging that this function could be too specialized for universal usage; it would be advantageous to provide an extension that could match text in columns and store the text in another column. Is there an extension or instructions to provide a extension to perform this function? Thanks, Charlie
Yes the real problem is that banks are different, they do things in different ways, put numbers in different places and of course a number there may not be a cheque number, for instance it could be a reference number for some form of direct entry, so such a function could well be limited in when it could be used.
I am not aware of any extension that would do this, most extensions I have seen tend to be universal. I would expect that something could be written but I have no background in Java and Python.