Using the Auto-Reconcile Historic Transactions feature
If you just came over to ISP from a different system, you might be concerned about your first bank reconciliation in ISP. It might not be practical to go back several years and reconcile your data in ISP month by month.
If you have never done a reconciliation before and you have over 200 unreconciled transactions, you will see a button called Auto-Reconcile Historic Transactions at the bottom of the page. Please note that this button will only show if both criteria are met.
The Auto-Reconcile Historic Transactions button assumes that your data is correct up to the date you specified. For your first reconciliation to work smoothly, go back to the bank statement where all transactions are deposited. In other words, go back to the bank statement where you don’t have any outstanding checks. Going back three months should work most of the time. If you can auto-reconcile through that date, then you should only have a couple of months to manually reconcile.
What if everything appears to have cleared, but my bank statement doesn’t match the Register in ISP?
In this case, add a bookkeeping transaction. Finding the source of the discrepancy would be ideal, but if that’s not practical, add a bookkeeping transaction.
What if I have an uncashed check or two?
Temporarily change the date of the uncashed check to after the date of your reconciliation. Then use the Auto-Reconcile button, then change the date back to the correct date. The point here is to remove it from the Auto-Reconcile window, reconcile, then change the date back.