[GNC] Transaction importing questions

[Niranjan Rao]

Greetings,

GnuCash version : 5.5 On Ubuntu 24.04

Long time user, thank you for the great tool, finally decided to act on 
the some of the challenges I face.

I'm wondering if there some options while importing qfx files that will 
allow me to use less naughty words while reconciling the accounts. I 
usually face two challenges while reconciling the accounts.


1. Transaction date vs posting date. Id a look at qfx file. It has two 
fields DTPOSTED and DTUSER or according my credit card statement, 
posting date and transaction date. For whatever reason, few transactions 
get posted later, but statement is sorted by transaction dates. If 
transaction gets posted later, it creates confusion, duplicate 
transactions. Information seems to be there in qfx file, just wondering 
if I can convince gnucash to use the transaction date from qfx file

2. Like many married couples, we have a shared credit card account. We 
have two credit cards his and hers. Statement lists the transactions by 
credit card, like his expenses and then her expenses as two different 
sections. However importing transactions orders by transaction dates. 
This causes either duplicate transactions or other headaches.   There is 
one bill for both transactions.  Imported file has an element called 
CCACCTNO which might be helpful in this scenario. Since its shared 
account, I get to export only one qfx file which has both account 
entries. Can GnuCash add account number to transaction description or 
import transactions in two different accounts - may be child accounts of 
parent account and allow me to reconcile both accounts?


Relevant transaction example from qfx file. Please note nine days 
difference between two days and acctid field that I want to use if 
possible while importing transactions.

<STMTTRN>
     <TRNTYPE>DEBIT</TRNTYPE>
     <DTPOSTED>20251027000000.000</DTPOSTED>
     <DTUSER>20251018000000.000</DTUSER>
     <TRNAMT>-33.65</TRNAMT>
     <FITID>202510271135583</FITID>
     <NAME>SQ *WOK A HOLIC</NAME>
     <CCACCTTO>
         <ACCTID><redacted></ACCTID>
     </CCACCTTO>
     <MEMO>SQ *WOK A HOLIC</MEMO>
</STMTTRN>


Regards,

Niranjan