QFX Export from Capital One Credit Card not importing "Error End Document Tag"

Question

I have successfully imported transactions from several banks and credit cards. However, Capital One credit cards are giving me an error 
 
 "Error End Document Tag" 
 
 Which means there is some kind of problem with the xml file. Anybody run into this and if so, did you find a way to fix it. It is probably a matter of editing the file and removing some unnecessary stuff.

Peter.Heinicke · Accepted Answer

I was able to overcome this by editing the OFX file with notepad and deleting extraneous XML tags so they more or less matched another, working OFX file. In principle, one could write a program and I got a quote from a programming house of a couple of hours to do this, but I didn't go ahead with it. Let me know if you are interested in such a program, anything thing like this can be done for a price. Step one - Get a good OFX file from another bank and its transactions. Change the account to match the Sage 300 bank info for CAP one. Step two - Copy just the transactions and not the header or footer from the Capital one ofx file and insert it between the header and footer. are the tags for transactions. Step Three - Using an editor like notepad or your favorite, remote any tags in the transactions area that start with , Step Four - Remove the and tags, but you can leave 9933 After all this editting, a valid transaction might look like this: DEBIT 20201219000000.000 20201217000000.000 -19.87 20201219941447 Eddie Gaedel Pub and Gril 9933 Eddie Gaedel Pub and Gril Step 5 Save it as an OFX and it should import ok.

Sage 300

QFX Export from Capital One Credit Card not importing "Error End Document Tag"

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING