Article from Xero re integration and payment and reconciliation:

https://developer.xero.com/documentation/api-guides/handling-payment-processor-receipts-in-xero

MindBody Example

https://support.mindbodyonline.com/s/article/ka032000000bo2BAAQ/How-do-I-match-my-MINDBODY-payments-with-my-bank-feed-in-Xero?language=en_US

Summary

1. Create a Clearing Account in Xero, to accept transaction
2. inTennis to push invoices to Xero
3. inTennis push payments to pay the invoices in Xero, against the Clearing Account
4. With the bank feed, just create a ” receive money transaction, coding this to the clearing account”
5. Periodically (e.g.  once a month), create a manual journal to ensure the fees are catered for, hence leaving a 0 balance in the clearing account:

For example, there’s $10 fee (includes GST) in this month, we create a manual journal:

Clearing Account Credit $11

Bank Charges Debit $10

GST Debit $1

see https://help.xero.com/ManualJournals to create an manual journal