This has been one of your most requested features for Silver Siphon. Now you can choose which Stripe data to import into Xero.

This makes reconciliation totally customisable to your business, and much easier.

An example use (which comes up all the time) is to detect GST on Australian purchases. Do to this you could map the description as

{charge.description} – {card.country}

This would enable you to set up a bank rule where if the description contains the country, code the transaction to GST Payable. Otherwise, code to no GST payable.

To set up field mapping, scroll down to the bottom of the Services page and look for the link “Configure field mapping for Stripe”.

Click the “Stripe Fields” button to customise the two fields that can be imported to Xero – Customer and Description.

Below is a list of fields currently available. Bear in mind that not all of these fields will always have data. It depends on your set up. Have a look in your Stripe account at which fields are populated before setting up field mapping.

Field Mapping Example

{card.name} – Name on the credit card e.g. John Smith

{card.country} – Country on the credit card. Useful for setting up bank rules for GST or other tax

{card.address.country} – Billing address Country

{card.address.state} – Billing address State

{customer.id} – Stripe Customer ID. This is a unique ID and not a meangingful name.

Here’s some good news! Silver Siphon now works with Stripe Connected accounts at the tick of a box. Now you can stop bugging us.

Just kidding. We like being bugged about potential new features ’cause that’s how Silver Siphon keeps getting better.

So if you have a Stripe Connect account and want to start getting your data into Xero, here’s how to do it.

Step 1

On the Services page, scroll all the way down the bottom and tick the box that says “Only import stripe connect transactions”

The one with the arrow

That’s all. No more steps.

Instead of looking for Stripe payments, Silver Siphon will look for “application fees” and suck in that information. This is usually all that is required for your own bookkeeping. The rest of the transaction data (like charges and fees) apply to the connected account.

Out of the box, whenever Stripe clears funds to your main back account, the result looks like this:

Stripe to Xero Default Behaviour – Dummy Data

These amounts can be hundreds of transactions rolled up into a single line item. These include transactions, Stripe fees, refunds and anything that affects your balance. If you need to reconcile these items against different accounts or invoices within Xero, you’re in for a hard time. You have to:

Dump all your data out of Stripe

Open it in Excel

Format it in a way Xero accepts, or write a macro to do it quickly

Import to Xero

Line up the columns

Hope everything worked

Obviously this gets to be a real pain when you have to do it every week or month.

Silver Siphon essentially wipes out this task, and does it all for you. The result looks like this:

Stripe to Xero Bank Feed – Dummy Data

It looks just like a regular bank feed, and even gives you the information you need to generate bank rules against customers so that Xero can automatically match transactions. Then all you have to do is hit the green OK button to complete the reconciliation.

If every Stripe fee will be reconciled against the same account in Xero, in Silver Siphon simply check the box to roll up all fees into a single line item each day.

Hit the button below to sign up for your 14 day trial and get set up with Stripe Bank Feeds!

Now, every time of Stripe transaction is automatically synced to Xero every day, just like a normal bank account.

These include:

Transactions

Fees

Refunds

Bank transfers

This makes it incredibly easy to reconcile your Stripe transactions inside of Xero, as you can set up bank rules on everything that comes in.

We try to get the most data possible into Xero to make it simple to set up bank rules which get the reconciliation right every time. To do this, Silver Siphon looks at the credit card transaction itself, the customer behind the transaction and any descriptions added within Stripe to build a descriptive transaction.

Having now processed over 100,000 transactions, we’re extremely confident in Silver Siphon and will leave Beta in a couple of days!