Making a 25 Year Old Checking/Savings Account Match On-Line
My checking and savings account for many years have always been reconciled manually. I did not download the transactions. Today with a copy, I've connected On-Line and downloaded the transactions.
The results:
I have over 100 transactions that are "Matched". These seem to be no problem.
I have almost 500 transactions that are "New". These will result in multiple issues. Most of these are due to the downloaded names (Payee) being different than the (Payee) that are already in my register (therefore duplicates). Others go in my register with no category, no memo.
Ideally, I would like to simply NOT ACCEPT any of these transactions, but I don't know how to do that as a batch mode (they go back to 2022- to the current date). I only see the option to "Accept All Match" items, but I don't see how to delete/ignore all "New" downloaded transactions.
If I accept all of them as is, I will have to add a onetime balance adjustment (not a big deal). I hate to do this because all of the duplicate entries into the register are not only unnecessary, it will also mess up all my reports.
What are my options.
Note: Best time to do this is at the end of the month when reconciling.
Best Answer
-
Have a good backup handy!
You may be able to:
- Accept All
- Sort the register by Order Entered using the Actions gear option. Note that Order entered is distinct from Date/Order Entered.
- From that sort it is somewhat ease to select the contiguous transactions and delete a mass at one time, though I would likely not try all 500 at once.
- You could also move all those to a second temporary account if you wanted to make further checks for completeness.
0
Answers
-
Have a good backup handy!
You may be able to:
- Accept All
- Sort the register by Order Entered using the Actions gear option. Note that Order entered is distinct from Date/Order Entered.
- From that sort it is somewhat ease to select the contiguous transactions and delete a mass at one time, though I would likely not try all 500 at once.
- You could also move all those to a second temporary account if you wanted to make further checks for completeness.
0 -
Well, that's a feature that I did know existed. I had to play with it a few times to make sure I understood it. I was able to take care of … maybe 90-95% then had to Reconcile both accounts.
I think it worked pretty well and was faster than I thought. I had to Verify "Yes" many times but got it done. I guess, for the most part, I will not know if any other registers (accounts) were impacted.
I appreciate the quick response. Thanks again
0