If you use Stripe to invoice customers and would like to use ScaleXP to automate your deferred revenue schedule, ScaleXP allows you to replicate Stripe Invoices in Xero and QuickBooks or, alternatively, to replicate Stripe invoices into ScaleXP and journal in bulk into Xero or QuickBooks.

For more information on invoicing to Xero or QuickBooks in bulk, see Stripe<>ScaleXP Integration - Create invoices directly into ScaleXP. 

For details on creating invoices directly into Xero or QuickBooks, see below.

First, Connect to Stripe

To enable ScaleXP to transfer invoices from Stripe to Xero or QuickBooks, go to Load Data (top bar)>Connections (left side bar) >Stripe>Add integration.

Select the Stripe account linked to your company and scroll down to Connect.

Return to Load Data>Connections.  Select Configure in the Stripe box.

Once the connection has been created, follow Steps 1 - 5 below to complete the setup process.

Step 1 - Select Accounting System import

In the top dropdown menu, "Import Stripe Invoices to:" select "Accounting System".

Step 2: Map Products

Select Map Products (top button).

Select a Default Account/Product (dropdown menu, top left) and then Save (bottom right button).

The default product mapping is required as a minimum setup. 

Once mapped, any new Stripe invoices will go to this account/product unless otherwise mapped (see below).

Next, map each individual Stripe product to the Xero account or QuickBooks Item Code, using the drop down menus.

Make sure to Save (using the button in the bottom right corner of the screen).

Useful Tip: Unmapped accounts will use the default account.  This gives you the flexibility to map the important accounts and leave others to use the default.  This can be very useful if you have many Stripe products.

Note: If you need to change your Xero accounts or QuickBooks items, go to that platform to update them.  Once that is done, just Sync the changes into ScaleXP.

Step 3: Map Coupons

Map your coupons or discounts to the associated accounts in Xero or QuickBooks.

Step 4: Map Tax Rates

STEP 4:  Select Map Tax Rates.  Match each of your Stripe tax rates to a Xero/QuickBooks tax rate.

Step 5: Map Classes/Tracking Codes

See Stripe - How to automate Xero tracking codes or QuickBooks classes from Stripe metadata for more information on how to map metadata from Stripe into Xero Tracking Codes or QuickBooks Classes.

Step 6: View in your accounting system

QuickBooks: invoices will appear in QuickBooks as authorised.  No further action is required.

Xero: Invoices will appear in Xero as 'Draft', meaning that they must be reviewed and approved.  

Once these five steps are complete, the setup process is finished- well done!

Note that Stripe invoices with nil value are not imported into Xero or QuickBooks.

Updating for new products

Important - when new products and coupons are added in Stripe, these need to be  mapped in ScaleXP before an invoice using them is created in order to capture all the mapping automatically. 

Just select Refresh Products (top right).  Complete the mapping as outlined in Steps 2 and 3 and Save. 

Note that the "last synced" message on the Stripe integration refers to the last sync date for mapping, not invoicing syncing. Invoices will be synced to ScaleXP and QuickBooks or Xero as soon as created in Stripe.

Xero Bank Reconciliation

Hint for Xero users - you will probably want to set up your Stripe account as a bank account in Xero or QuickBooks to make balance sheet reconciliation easier. 

Read more in Stripe <> Xero Integration - Bank Reconciliation.