Greetings from Cairns Qld Australia,
I have my new accounts hierarchy data saved in a new file in the SQLite format.
I have read the concepts guide & help docs.
I have searched with our favourite search engine around the issue of imports
from CSV etc files, and matching, and how to sort out duplicates
I am somewhat aghast at the outcomes mentioned - deleting duplicates and/or
doing reversals.
I am therefore going to be more verbose than the mail list items questioners I
found, to set out my frustration.
---
I created a new file to do this test. I completely deleted all transactions
from a previous file, the account balances all read zero, and saved this as my
new test file.
In my accounts, I have an assets, savings acct. I have a csv file of savings
account transactions export from my bank.
In my accounts, I have a liabilities, credit card acct. I have a csv file of
credit card transactions export from my bank.
These are my first 2 imports.
I imported the credit card transactions first, from CSV.
In the matching stage, for payments into the credit card from the savings,
GnuCash did not offer any matches
I set the match to be the savings account.
Loaded, no errors, -
And it created transactions in the savings account (presumably the second split
of the credit card account transactions)
---
I then imported the savings account transactions from CSV.
In the matching stage, for payments from the savings into the credit card,
GnuCash did not offer any matches
I set the match to be the credit card account.
Loaded, no errors, -
And it created transactions in the credit card account (presumably the second
split of the savings account transactions)
NOW, - I have 2 versions of each of these transactions, - which are in fact the
same transaction, - in each of the savings, and, the credit card accounts!!
completely fouling up balances.
---
Have I done something wrong?
I don't want to be manually trying to delete some transaction splits, or trying
to delete or reverse some transactions -
. it would be just another manual tedious process
. I would likely do it wrong and break the transaction(s) completely.
---
If I don't provide manual matching, the transactions all end up listed in the
Imbalance acct.
---
If I were to import the credit card transactions - without providing manual
matching -
When I then import the savings account transactions -
How to I tell it that -
This transaction - x - being loaded into this savings account should be matched
to that existing transaction - y - in that credit card account
AND - remove that transaction - y - from the Imbalance acct
I find it quite frustrating that it appears that I have to match during both
imports, and then do more manual jiggery pokery to sort out the duplicates!
There has to be a better way.
---
I have not tried it - BUT -
Could I import the credit card transactions, with no matching - second splits
will be in Imbalance -
THEN, when I do savings import, - is it possible to do the matching to the
credit card second split in the imbalance account - and end up without
duplicates, and the transaction cleared from Imbalance??
Hoping for enlightenment
Leo Vaccaneo
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
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.
