API for automated payment reconciliation