Hi there, @JPBabyRange.
I’m here to lend a hand in reconciling your bank account to match the payroll check.
In order to reconcile the account accurately, you'll need to based transactions on the cleared one on your bank and not the uncleared. Since the date you initiated the payment is all that matters.
What you can do is to check off the items that cleared the bank on the statement and leave the other's unchecked upon reconciling.
For guidance, here's a great resource that you can check since you'll be reconciling: Reconcile Hub.
In case you'll encounter any issues when reconciling, visit below links which you may find helpful:
You can read through this article for more details in troubleshooting reconciliations:
If there's anything else that I can help you with, please don't hesitate to add a comment below. Have a nice day.