![]() ![]() Of course, depending upon the signs of the errors, the magnitude of (A+B) may be smaller than either A or B. You see that there is a difference of amount (A+B) between your MMEX balance and the bank's balance, but no matter how hard you try, you probably won't find a transaction with the amount of (A+B). There might be two or more missing transactions that were not imported, or there might be be two separate corrupted transactions that have incorrect values that are "off" by amounts A and B respectively. One of the difficulties in tracking down this kind of discrepancy is that there might not be a single problem to find. ![]() I already know how to look for duplicates. It seems to me that after that, looking for only the withdrawl transactions that are less than or equal to the missing balance would be a good place to start, and then trying to find how a combination of this add up to the missing balance might shed some light on it or.one could left join the unique id's to find the missing transactions in either using the same date range for both data sets MMEX and csv. So how does one tell if they need to look at the csv or the MMEX transactions, the withdrawls or the transfers or the deposits, to find out what is missing? The csv file also has unique values for each transaction, and this is useful to find out if a transaction has accidently been imported twice provided it is also imported. The qfx file, from my bank, can be converted into a csv file and be filtered, using excel or anything else that can read that file format. The software I am using for this uses an SQL Backend (Money Manager Ex) which makes it easy to query for missing / duplicate transactions. ![]() My first thought on this matter, is that if the balance is off by a certain amount, one or more missing transaction should add (withdrawl or deposit) to the missing amount.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |