Ron, SInce your problem seems to originate from importing data, it may help to fix that problem first if possible. What form is the data you ar importing in(OFX, CSV. etc) . It sounds as though your problem was with matching the records of the same transaction in import of our checking account and credit account data. There are two separate steps in the import matcher, identifying transactions which may already exist in your data file and the assignment of the account for the second entry for the transaction being imported. It pays to check that the import matcher has correctly or not matched to existing transactions before completing the import. You can fine tune the data matching procedure which has two windows in the user preferences Edit->Preferences- >Import. There is a 4 day window within which transactions with dates within that window are assigned a high probability of a match and a 14 day window where if the matching dates are outside the window the match is assigned a low probability. The probability of a match also depends on how well other data for the transactions match. I have had problems in the past particularly with mismatching dates on regular transactions if they repeat within the 14 day window or if they are outside the window but the other data matches extremely well. Dates on hand entered data can sometimes also differ considerably from when the bank records for the transaction depending on how quickly the transaction is cleared by the bank. Electronic clearance has reduced a lot of these problems. Sometimes changing these date thresholds carefully can eliminate problems if you have clearly identified date matching difficulties.
I have also found that importing the checking/bank accout record for a given month before importing the credit account data usually works better and then reconciling both accounts once the data for eachof them has been imported for that month. In the import matching process you can examine the possible matches the program has assigned and override the programs choices. It is usually only payments made from the checking account to the credit card that have to be matched along with any transactions manually entered before importing Try to identify whether the importing problem is importing data which should have been matched to existing transactions resulting in duplicated transactions or whether transactions which should have been imported are being rejected resulting in missing transactions for a given account. David Cousens On Tue, 2024-09-17 at 12:12 -0400, Ronald Solomon wrote: > I am using gnucash 5.6 I entered my credit cards by hand, I could not > get > the import to work consistently, I entered them a month at a time > then > balanced them with the statement and reconciled each month. > I then entered my checking account. in the same fashion, each month > is > balanced and reconciled. I got this month's credit card statement and > went > to enter when I saw the credit card account ending total was wrong, I > pulled up the old statement and I pulled up the statements back to > the 1st > of the year and it was wrong back to January. That was the problem I > was having with importing I would have a balanced and reconciled > account, > and the import would go back and change figures taking forever to > fix. At > first glance it appears some if not all of my deposits are missing. > Is this a bug? or am I doing the entering in the wrong order credit > cards > then checking information. > _______________________________________________ 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.
