Hello! Has anyone been able to get Match Bank Data via SuiteQL? We have bank account transactions coming via Fispan that we would like to access via SuiteQL.

As far as I know, they still haven't made this data available through SuiteQL. I don't know why. It gets asked about regularly.

Bank reconciliation data through SuiteQL is pretty limited; you can query transaction and bankstatementline tables but the matching relationships aren't well exposed. Most teams end up using RESTlets or saved searches for bank rec data instead of pure SuiteQL.

You can solve by automating the match process against clean source data before it ever hits NetSuite, so the reconciliation step is just a review, not a hunt. Check out Blue Onion, could be a good help.

Thank you