Thank You all for getting back to me! You all have mentioned importing, and I did start that way however, it was not stable. I entered all of the transactions by hand, first I did the credit cards and then the Checking account. Before I entered the checking account I had balanced them and reconciled each credit card each month. When I entered the checking account data I balanced and reconciled each month. I did not look at the credit cards. When I went to enter the new credit care statements is when I found the deposits were missing! Do I need to enter the checking data before the credit cards?
Thanks in advance, Ron On Tue, Sep 17, 2024 at 4:13 PM David Cousens <davidcousen...@gmail.com> wrote: > 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. > -- Ron Solomon DC Integrative Health PHMA PA Phone 252 671 2306 Fax 252 69310684 The reason you have a headache is not that you need more aspirin. _______________________________________________ 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.
