I started using the FE NXT Treasury Reconciliation module back when we received the notice that the database view would end. I noticed right away FE-NXT did not provide the checks and deposits totals that the Database View did and the Pre-Reconciliation was no longer available. This was always quick way to see if I selected an item I should not have or didn't select an item I should have, before proceeding.
Now, this is my workaround if I am using FE-NXT:
After I select all the checks, I open the Database View and confirm that the amount equals the "checks amount" on my bank statement.
After I select all the deposits, I open the Database View and confirm that the amount equals the "deposits amount" on my bank statement.
Before I Finalize it, I open the Database View and run the Pre-Reconciliation Preview Report to scan for items that don't look like they belong, and fix anything needed.
If everything looks fine, I go back to NXT, Finalize the Report and Print the Reconciliation Report. (I like the FE-NXT report better).
Now if you added the Check and Deposit totals and Pre-Reconciliation Report to FE-NXT, life would be grand!👩🦰😊 (A Bonus would being able to select a range of cancelled checks)
I would love it if it was further broken out by transaction type - computer check, EFT check, deposit, adjustment-payment ... and especially adjustment-deposit, since this is what RE NXT entries show as in the bank rec! Or maybe its own category. I know there's a work-around by filtering on that journal, but the whole filtering process is cumbersome, too - if there was a static/collapsible sidebar or at the top it would be less of a nuisance.