[GNC] Transaction importing questions

[Kalpesh Patel]

There might be another, and possibly better way, is to import individually as a CSV formatted rather than as OFX/QFX formatted one. While OFX/QFX has higher fidelity than CSV one for data quality, you will be able to map these columns appropriately in CSV import in GNC itself, and then saving that mapping to recall back later when you import next set of transactions. This will give you better control -- such as sending data to two different accounts if wanted -- by permitting you to save the mapping along with its target account for import as many  times as you like,  and ability to select the profile during import; this is not possible with OFX/QFX import method.

With CSV, it is a lot easier to edit and so-fort as a simple text file, compared to OFX/QFX xml formatted one. 

I recall AmEx and Capital One at least behaves the way you described in the US.

-----Original Message-----
From: Sherlock <sh025622 at gmail.com> 
Sent: Sunday, November 16, 2025 3:19 AM
To: gnucash-user at lists.gnucash.org
Subject: Re: [GNC] Transaction importing questions

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