Users are attempting to reconcile a future dated transaction in the current bank rec. using these steps.
- Dated manual journal entry for 2/1 when they had intended to enter 1/31.
- They were performing the Jan bank rec. so the bank rec as of date was set to 1/31 as expected.
- They changed this date to 2/1 so that the manual entry dated 2/1 would show.
- They checked the reconcile box on the 2/1 entry.
- They then changed the bank rec as of date back to 1/31.
- They wanted to know why the bank rec stopped including the 2/1 entry in the calculation, even though they had checked the box for it.
You can only reconcile transactions from the as-of-date and earlier. Once you changed the date back to 1/31, the 2/1 transaction no longer fit into that range, and so it was excluded from the bank rec calculation.
In this situation, the options are to
- Delete and re-enter the manual entry for the correct date.
- Reconcile as of 2/1 instead of 1/31.