Xero is an amazing platform, that allows you to connect with Stripe and take payments. If you accept payment via Stripe and need help with reconciliation, you must follow the guidelines below. Once you have collected the payment in Stripe, Stripe will transfer the bulk funds into your bank account. From there, you must match the payments against the sales invoices you raised from Xero.
See Our Packages
Payment Received in Xero:
By default, it looks like this, when Stripe transfers appear in Xero
If you are processing multiple invoices per day, this sum is made up of all of those invoices, subtracting Stripe fees.
Step 1
Click the Find & Match button or the link at the top right of a bank statement line (money received)
Step 2
It will display a list of transactions/invoices that can be matched, and tick all the relevant invoices/transactions that are part of the corresponding bank transfer. As you do this, they will appear in the bottom box.
You might have to log in to your Stripe account to get the breakdown of the invoices.
And from there, you will have to choose the relevant transaction to see the breakdown.
Step 3
When you have selected them all, the total will be out by the Stripe fee amount for the day. At this point, you should double check the fees in your Stripe dashboard to ensure everything matches with what you’ve just done in Xero.
Step 4
Then, click the adjustments button in the bottom right-hand corner and select “Bank Fees”.
Enter in all the usual transaction fields as shown below. If you don’t have a “Stripe Fees” account set up, just use “Bank Fees”. For the amount in the right-hand column, it needs to match the red text next to “Total is out by”.
Once the totals match, the Reconcile button will go green and allow you to reconcile all of the invoices you matched.
Are you looking for professional tech-savvy tax advisors and accountants in the UK to guide you? Contact us now!
