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.butle...@gmail.com
kg...@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 <jedia...@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@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@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@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.
