The Tiller add-on can alert you when a potential match for a manually added transaction flagged for reconciliation is added to your sheet when you turn on the Auto Reconcile trigger.
The trigger will present a dialog when you open your Tiller spreadsheet if there are new transactions that match transactions waiting to be reconciled, and ask you if you want to reconcile them.
How to do it:
- Open the Add-ons menu at the top of your Google Sheet.
- Choose Tiller > Business > Reconcile Auto Trigger