In which bank account should Stripe transactions appear in Xero?

In the Payment Service Settings within Xero, make sure you select the bank account that you have attached in Stripe for the Stripe transactions.

You can confirm or change the bank account on the Payouts page of your Stripe dashboard:

How can I reconcile payments in Xero?

Xero will usually match the bank payments with Stripe payments and fees that are automatically recorded in Xero when an online invoice is paid. You will have to click OK to accept the match.

However, if a match is not suggested, you can use the Find & Match option to locate the transactions. This article outlines more information on reconciling payments in Xero:

https://central.xero.com/s/article/Reconcile-Stripe-payments

What are the key fields or information Xero looks up from Stripe to do auto reconciliation?

When a Stripe payout is imported into your bank account in Xero, Xero queries the transactions associated to that payout and then matches them to the Xero invoices using the Stripe charge IDs (ch_XXXX).

Auto reconciliation is available only if the Stripe account has set up an automatic (not manual) payout schedule. Additionally, auto reconciliation only works when your one Stripe account is integrated in one organization within Xero. It is not supported if your one Stripe account is integrated in multiple Xero organizations.

Is there a Stripe feed?

Yes. You can set up a direct feed to automatically import your transactions into Xero. Once connected, transactions import from the most recent payout only.

For full details, see: https://central.xero.com/s/article/Stripe-direct-feeds