Gio,
The Gnucash import matching procedure searches for duplicate transactions in a
time window around the date of the
imported recorded set at +-42 days. A match score is then calculated based on
the differenes in dates and amounts and
the matching of tokenized data. It is generally very good at picking up
duplicates but will sometimes match repular
repeated payments. An imported transition which matches an existing one will
have the "C" ("R" in older GnuCash
versoions) checkbox checked if the match is very good but may have the "U+C"
("U+R" in older GnuCash versions)
chceckbox checked if it is not a very close match ( usually if descriptions and
memo fields are different. It will pay
to check all matches are actually valid. You can swap between viewing the
register(s) and the import matcher window.
The Help manual section on importing will help you with understanding the
significance of the background colours to the
rowsand the meaning of the checkboxes in the importer.
https://www.gnucash.org/docs/v3/C/gnucash-help/trans-import.html#:~:text=Navigate%20to%20the%20MT940%2C%20MT942,the%20transactions%20in%20the%20file
.
Even though you are specifying the transfer accounts the importer will ask to
to map the account name in the trnsfer
field to an internal GnuCash account each time it encounters an account name
for the first time in the import data.
David Cousens
On Tue, 2020-06-02 at 17:57 +0800, Gio Bacareza wrote:
> Hi GNUCash experts,
>
> I'm planning to consolidate all my statements into 1 big CSV. This CSV
> would naturally have an account field and a transfer field.
>
> Since all transactions are there, there will be instances where there will
> be duplicates. For example, a statement from bank1 could have a transfer
> from bank1 to bank2. So account = bank 1, transfer = bank 2, amount = -100
> for example. But, since I put in all together in 1 file, there will be
> another line where account = bank 2, transfer = bank1, amount = 100.
>
> When I import this big file containing all transactions from different
> statements, how will gnucash handle this? Can it automatically detect that
> this is one and the same transaction?
>
> The alternative is to import account by account but that is too time
> consuming for me.
>
> Is there a better way?
>
--
Dr David R Cousens
B.Sc, M.Prof. Acc., Ph.D., G.C.Ed
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
