Ah, PBCK. I should have read the docs before posting: https://code.gnucash.org/docs/C/gnucash-help/trans-import.html#trans-import-matcher
Specifically: "If there is a lower quality match to an existing transaction, the imported transaction may be flagged for updating of non-matching information in the GnuCash record of the matching transaction. These decisions can be overridden by the user." Apologies for the noise. David On Wed, 15 Mar 2023 at 07:48, david whiting <[email protected]> wrote: > OS: Linux (NixOS) > Gnucash: 4.12 Build ID: 4.12+(2022-09-24) > Backend: sqlite > > This is a weird one, and I can't work out if it's me or gnucash. I import > transactions from a cvs export from my bank. I check the date of the last > transaction that I have imported and truncate the csv file so that I'm only > importing new transactions. > > After the import, usually, but not always, I check to make sure that the > ending balance on the bank account matches that in gnucash. A couple of > times I have found that it isn't and I check through each date to see where > I have missed a transaction. When this has happened I have assumed that I > truncated the import file incorrectly. I then manually add the missing > transaction(s). > > I'm using gnucash for a local football club. At the moment we are taking > payments for a tournament that we are organising and for these transactions > I have been writing a number in the num column. Each number is unique and > identifies the team that has registered (it has the row number from the > separate registration database and the age group). When I did an import > today, I found that some transactions were missing again and so I started > to enter them; then I noticed that some of the new transactions that I had > imported already had numbers in the num column, but the numbers related to > the teams where the transactions were missing. > > See attached screenshot. This shows a transaction on 14/03/2023 where the > number is T-25-U8 but the reference contains T-89-VETS, and similarly for > the transaction below it. The T-25-U8 payment was made on 01/03/2023 (1 > March 23), but was missing after the import. The transaction with T-89-VETS > in the reference shouldn't have had a number yet, as I hadn't entered it. > This looks like the transaction with T-89-VETS has overwritten the T-25-U8 > transaction, except for the num. > > I make daily backups, so I looked at a backup from a couple of days ago > and the original T-25-U8 transaction on 01/03/23 (1 March 23) was there. So > it looks like the cvs import sometimes overwrites some transactions. > > I have looked at https://bugs.gnucash.org/ for bugs with the word > "import" covering the last year and can't see anything that looks like this > and I have checked the release notes for 4.13 and see no mention of a bug > fix for something like this. > > Has anyone else seen anything like this? Is there anything I could be > doing wrong when importing the csv file? > > David > -- > David Whiting > -- David Whiting _______________________________________________ gnucash-user mailing list [email protected] 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.
