Reconciling your Stripe Bank feed in Xero

SubSync will replicate every invoice created in Stripe into Xero when operating in detailed mode. These invoices are created according to the mapping defined in SubSync allocating revenue to the appropriate accounts, manage taxes, assign tracking categories etc.

Once an invoice is paid in Stripe, a corresponding payment is created in Xero against the invoice. 

Because of the way the integration works, it is worth noting how / what you should be reconciling in your Stripe bank feed in Xero, as it can catch some users out.

Your stripe bank feed in Xero will show all transactions on your stripe account, Xero will automatically recommend matching transactions based on the date, value and contact. 

This example shows where a Stripe invoice has been matched against the payment created by SubSync. 

Xero's reconciliation recommendation may match based on just a single one of either the date, value or contact. 

In these cases, it is possible that Xero recommends an unpaid invoice rather than a payment for a SubSync created invoice. 

Users should not reconcile any payment in the Stripe bank feed against an unpaid Xero invoice.

If a user does reconcile a transaction in the Stripe bank feed against an unpaid invoice, the process will mark the invoice as Paid in Xero, and in turn SubSync will mark this invoice as paid in Stripe.

In the diagram below you can see that Xero has matched based on an unpaid invoice. You will notice the text ‘Payment’ is not present and the symbol is also different.

In the case of 'out of band' payments, i.e. when an invoice is paid outside of Stripe via EFT or similar, it will need to be reconciled against the bank feed where the money is received (I.e. not the Stripe bank feed). This process will then correctly mark the Xero invoice as paid, and SubSync will also mark this invoice as paid in Stripe.