[GNC] Automatic account match doesn't work when import transactions

[Stephen M. Butler]

I volunteer for a non-profit that maintains a clinic in the 
Philippines.  The local treasurers send me a spreadsheet that I 
manipulate into a CSV file for importing their transactions into GnuCash.

The sequence of events for a CSV transaction import is different that 
for the OFX that I prefer for my personal CC/Bank company.  One 
advantage I have with the file from overseas is that they include a code 
for each type of expense.  I've told GnC to use that code as the "other" 
account (the base account is their "cash" asset account).  So if any new 
codes show up, GnC has me map them to the actual account (usually 
expense).  During that portion you can look at the other mappings and 
make any needed changes.  Then it shows you all the transactions that 
will be imported.  I have never tried to change the mappings at this stage.

For OFX/QFX, the import will allow you to click on a line (double click) 
and adjust the "other" account.  That is the way it learns how to make 
the mappings.  If you make a wrong entry and don't correct it, then 
future imports will go wrong until you have made enough corrections to 
override the initial mapping.  The new mappings are updated toward the 
end of the import.  If you see a line with a wrong mapping you must fix 
it before finishing the import.  Otherwise, that will strengthen the 
wrong mapping.

You can edit the mappings to remove wrong entries.  I think the only way 
to add entries is by making the corrections line-by-line during the 
import process.

--Steve


Stephen M Butler
Stephen.M.Butler51 at gmail.com
kg7je at arrl.net
253-350-0166
-------------------------------------------
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

On 2/5/24 13:06, Jediator wrote:
> Mostly CSV files, but other file formats as well.
>
> On 2/3/24 9:26 PM, Steve Butler wrote:
>> Which import?  CSV?
>>
>> On Sun, Feb 4, 2024, 13:04 Jediator <jediator at artemisspace.com> wrote:
>>
>>     I couldn't get the automatic account match to work when importing
>>     bank/credit card transactions to GC.  Is there anyway to manually
>>     create
>>     the matching rules?  Thanks!  -- JC
>>     _______________________________________________
>>     gnucash-user mailing list
>>     gnucash-user at gnucash.org
>>     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.
>>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> 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.