My experience with this sort of reconciliation in the past was with Xero, and the platform would match bank debits with open invoices, and if I accepted it then it would link the bank debit with the invoice directly