One QFX File Multiple Accounts

phillipdhall

Does Quicken support multiple accounts from a single institution in a single QFX file?

markus1957

Yes, BMO Harris used to conveniently package all accounts in one QFX but they changed their website and now you get one at a time. So yes, Quicken will process a multi-account QFX but it is the FI that determines how they get packaged.

phillipdhall

I am packaging my own. @markus1957, do you happen to have a sample file with multiple still? You can open it with a text editor and remove all the transactions and any sensitive info, I just need to see the tag structure.

markus1957

Sorry, but I don't have one.

QWinUser

@phillipdhall - Wells Fargo Advisors uses one QFX file for all accounts. The only difference I see right away is the use of an account identifier <ACCTID> to separate a group of transactions from one account to another.

Chris_QPW

I assume you are talking about a non-investment account:

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<LANGUAGE>ENG
<FI>
<ORG>ImportQIF
<FID>123456
</FI>
<INTU.BID>123456
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<DTSERVER>20230810204156
</SONRS>
</SIGNONMSGSRSV1>
<BANKMSGSRSV1>
<STMTTRNRS>
<STMTRS>
<CURDEF>USD
<BANKTRANLIST>
<DTSTART>20230810000000
<STMTTRN>
<NAME>Payee1
<DTPOSTED>20230810
<FITID>N+zxdqwQ0oXS6f0j6nbGBg
<TRNAMT>12.34
<TRNTYPE>CREDIT
</STMTTRN>
<STMTTRN>
<NAME>Payee3
<TRNTYPE>CREDIT
<TRNAMT>343.30
<DTPOSTED>20230810
<FITID>eMzy8D4h9WIBquVNxkSdDA
</STMTTRN>
<DTEND>20230810204201
</BANKTRANLIST>
<LEDGERBAL>
<DTASOF>20230810000000
<BALAMT>355.64
</LEDGERBAL>
<BANKACCTFROM>
<BANKID>1234567
<ACCTID>Account1
<ACCTTYPE>CHECKING
</BANKACCTFROM>
</STMTRS>
<TRNUID>0
<STATUS>
<SEVERITY>INFO
<CODE>0
</STATUS>
</STMTTRNRS>
<STMTTRNRS>
<TRNUID>1
<STMTRS>
<CURDEF>USD
<LEDGERBAL>
<DTASOF>20230810000000
<BALAMT>164.53
</LEDGERBAL>
<BANKTRANLIST>
<DTSTART>20230810000000
<DTEND>20230810204203
<STMTTRN>
<NAME>Payee2
<TRNAMT>132.20
<TRNTYPE>CREDIT
<DTPOSTED>20230810
<FITID>PXJUD7PHyr2gn9vvzPCq8A
</STMTTRN>
<STMTTRN>
<FITID>XOeoyYur9w+0YJwlU6wIdQ
<DTPOSTED>20230810
<TRNTYPE>CREDIT
<TRNAMT>32.33
<NAME>Payee4
</STMTTRN>
</BANKTRANLIST>
<BANKACCTFROM>
<ACCTID>Account2
<BANKID>1234567
<ACCTTYPE>CHECKING
</BANKACCTFROM>
</STMTRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
</STMTTRNRS>
</BANKMSGSRSV1>
</OFX>

phillipdhall

Thanks all! I was able to tinker until I got it working. Butting multiple BANKACCTFROM and BANKTRANLIST sections together (as @Chris_QPW) wasn't working for me - Quicken seemed to only read the last account data. But I found that joining multiple STMTTRNRS sections worked great. And if mixing banking and credit card, I followed the end of BANKMSGSRSV1
with a separate CREDITCARDMSGSRSV1 section.

Chris_QPW

Change FID and INTU.BID to 10898 (Chase) and the above will import into two accounts just fine.

For what it is worth my program ImportQIF created that file from an Excel spreadsheet (with better formatting that this forum editor wipes out).

Selected Link to an existing account: (Account1, that I had already created)

Selected Link to an existing account: (Account2, that I had already created)

Chris_QPW

I just notice something really strange in Quicken's QFX importing. Those payees are actually Payee1, Payee2, Payee3, and Payee4.

But with zero matching renaming rules Quicken turned them all into "Payee".

I then tried with different payee names:

phillipdhall

Thanks all! I was able to tinker until I got it working. Butting multiple <BANKACCTFROM> and <BANKTRANLIST> sections together (as @Chris_QPW) wasn't working for me - Quicken seemed to only read the last account data. But I found that joining multiple <STMTTRNRS> sections worked great. And if mixing banking and credit card, I followed the end of <BANKMSGSRSV1>
with a separate <CREDITCARDMSGSRSV1> section.