Once you reconcile an account ALL transactions should be ticked off and there should not be transactions sitting there unreconciled.
If there is, then you need to go back into the Reconciliation and choose to reconcile to the same date as the “Last reconciled date”, with the Closing Balance entered the same as the Opening Balance.
Once the Reconciliation opens up you need to Tick the box “Hide Transactions after the Statements End Date” (at the top right of the reconciliation). This will leave you with all of the Uncleared transactions that shouldn’t be there as the account has been reconciled to that date.
Use the “FIND” window and/or the SUPPLIER AND/OR CUSTOMER CENTER WINDOWS (usually a mixture of all of these) to look up each entry by AMOUNT and/or by NAME.
The unreconciled transactions are either going to be:
- Double entries – in which case they should be deleted.
- Paid by Petty Cash – in which case you should change the Account to the Petty Cash Account rather than the Bank Account
- Paid by Credit Card – in which case you will need to delete the payment and re-enter it as a Credit Card type expense (or Bill Pmt)
- Dated wrong – in which case you should correct the date (should be to a more current unreconciled period)
- Paid from a personal account – in which case you should change the account to the correct account.
Beware of double entered Bill Payments that have been applied correctly to a Bill that has been entered in Reckon. If you come across this it has probably been double entered with the other transaction being a “Write Cheque” type of transaction. The “Write cheque” type of transaction will have been the one reconciled. You need to delete the reconciled “Write Cheque” transaction, NOT the Bill Payment. This will then throw out the reconciled balance. You then need to tick off the correct Bill Payment and re-reconcile the account at the previously reconciled date.
Alternately you can delete the Bill Payment, but if you do this you will need to also delete the Bill as well, otherwise you are leaving the unpaid (and never to be paid) bill sitting in Reckon (which affects the BAS and tax as he is on an Accruals basis).
You should NOT use this second option for any regular suppliers who you usually enter bills for. It is important you keep up the consistency. Don’t sometimes enter a bill and bill payment and sometimes enter a Write Cheque transaction for the same supplier or this is the sort of problem you end up with (not to mention a heck of a mess in the Payables Report). Generally the first option of deleting the “Write Cheque” payment (which should never have been entered in the first place) and re-reconciling is the option you should use.