[GNC] gnucash-user Digest, Vol 272, Issue 32

[Niranjan Rao]

[Apologies if message threading gets broken, I had subscribed to email 
digest and could not figure out how to reply to thread from digest. 
Copied relevant portions for the context]

Hi Sherlock,

Trying to understand what you are saying. You want me to implement a 
filter or it's feature that already exists either as ? Writing a filter 
is not a big deal as there are parser libraries available in Java, 
language of my choice and if I am going to preprocess the file, it will 
(should) not impact anything else.

  If you have any recommendations please share. I see there are parsers 
in python, but not comfortable in Python.

Regards,

Niranjan
On 11/16/25 09:00, gnucash-user-request at gnucash.org wrote:
> Hi Niranjan,
>
> You could implement a QFX file filter to be applied prior to import to
> resolve the issues you have raised:
>
> 1. Map the DTUSER field to the DTPOSTED field or remove the DTPOSTED
> field and the DTUSER field will be used.
>
> 2. Map the transactions to accounts for each card.
>
>
> Generally, we enter our transactions prior to import.  When we import,
> we're matching existing transactions.  When an imported transaction
> doesn't match an existing transaction, sometimes it is because the
> financial institution used a new FITID for a previously imported
> transaction.  In this case, we duplicate the existing transaction.
> delete the original, and import again.  When we reconcile against a
> statement, the only expected issue we have is with transactions dated
> prior to the close that cleared after the statement closed.  These are
> usually easy to identify as they don't appear in the statement.
>
>
> Regards,
>
> Sherlock
>
>
> On 11/15/25 4:19 PM, Niranjan Rao wrote:
>> 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