We issued a handful of sequential cheques in identical amounts in September for increases to our rent.

When I did the November bank reconciliation, I mistakenly marked cheque #1 as cleared, when in fact it was #2 that had been cashed.

This wouldn't have been an issue - I would have just cleared #2 when #1 was cashed the following month.

Except that #1 has since been lost and I need to reissue it.

If I reverse cheque #1 and reissue it as cheque #3, this still leaves pesky #2 hanging around in my reconciliation.

If I reverse cheque #2 and reissue is as cheque #3, this solves my problem... but I'm sure it's not best practice since this is not what's actually happening.

What would be best practice in this case? Or am I just looking to overcomplicate the situation?

The landlord doesn't care which month the cheque is paying, and both cheques are for the same amount, so this is really just so that our books are correct regarding cheque numbers.