[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, [email protected] 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
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
