Does anyone have any experience of suiteapps where you can match a bank statement transaction to an open invoice and automatically create the payment record, close the invoice, and reconcile the payment to the bank statement?

Nope, but it sounds like an interesting one to write 🙂

We use Bank of America's BillPay - which kinda does that for vendor bill payments... not on the invoice/customer payment side

Fi-Span has built a bank connector and transaction reconcile suiteapp. https://finovate.com/fi-span-to-partner-with-jp-morgan-chase/

@Sam-I-Am - do you know specifically which features are built into Netsuite Banking service thing

I was one of the development adviser for this application, yes this application is full featured does touches every aspect of banking in real time within NS. You can contact @fkrauthan for more info.