How to sync Stripe subscriptions to QuickBooks with Power Automate

My flows > + New flow > Automated cloud flow

Create new automated cloud flow

Go to make.powerautomate.com and sign in with your Microsoft account. Click 'My flows' in the left sidebar, then the blue '+ New flow' button. Select 'Automated cloud flow' from the dropdown menu. Name your flow 'Stripe Subscription Renewal to QuickBooks'.

1. 1Click 'My flows' in the left navigation
2. 2Click the blue '+ New flow' button
3. 3Select 'Automated cloud flow'
4. 4Enter flow name: 'Stripe Subscription Renewal to QuickBooks'

Flow builder > Choose trigger > Search connectors

Add Stripe webhook trigger

In the trigger selection screen, search for 'Stripe' in the connector search box. Select the Stripe connector, then choose 'When an invoice payment succeeds' trigger. This fires when Stripe processes a successful subscription renewal payment.

1. 1Type 'Stripe' in the connector search box
2. 2Click the Stripe connector tile
3. 3Select 'When an invoice payment succeeds' trigger
4. 4Click 'Create' to proceed

Stripe trigger > Sign in

Connect to Stripe account

Click 'Sign in' in the Stripe trigger box. Enter your Stripe account credentials when prompted. Power Automate will redirect you to Stripe's authorization page where you'll grant access to invoice and subscription data.

1. 1Click 'Sign in' in the Stripe connector
2. 2Enter your Stripe email and password
3. 3Click 'Authorize access' on Stripe's permission page
4. 4Wait for redirect back to Power Automate

Flow builder > + New step > Control > Condition

Add condition to filter subscription invoices

Click '+ New step' below the Stripe trigger. Search for 'Condition' and select the Control connector's Condition action. This filters out one-time payments and only processes recurring subscription invoices.

1. 1Click '+ New step' below the Stripe trigger
2. 2Search for 'Condition' in the action search
3. 3Select 'Condition' from Control connector
4. 4Click on the left value box

Add this expression in a Compose action before QuickBooks to handle currency conversion and create a clean invoice reference. Paste this in the formula bar when configuring the Compose action inputs.

{
  "customer_email": triggerBody()?['customer']?['email'],
  "amount_dollars": div(triggerBody()?['amount_paid'], 100),

{
  "customer_email": triggerBody()?['customer']?['email'],
  "amount_dollars": div(triggerBody()?['amount_paid'], 100),
  "billing_period": concat(
    formatDateTime(triggerBody()?['lines']?['data']?[0]?['period']?['start'], 'MMM d'),
    ' - ',
    formatDateTime(triggerBody()?['lines']?['data']?[0]?['period']?['end'], 'MMM d, yyyy')
  ),
  "invoice_reference": concat('Stripe-', triggerBody()?['id']),
  "formatted_date": convertTimeZone(
    triggerBody()?['lines']?['data']?[0]?['period']?['start'],
    'UTC',
    'Eastern Standard Time',
    'yyyy-MM-dd'
  )
}

Condition > Choose a value > Dynamic content

Configure subscription filter condition

In the condition's left value box, click 'Dynamic content' and select 'Subscription' from the Stripe trigger outputs. Set the operator to 'is not equal to'. In the right value box, type 'null'. This ensures the invoice has an associated subscription.

1. 1Click the left value box in the condition
2. 2Select 'Subscription' from Dynamic content
3. 3Change operator to 'is not equal to'
4. 4Type 'null' in the right value box

Add this expression in a Compose action before QuickBooks to handle currency conversion and create a clean invoice reference. Paste this in the formula bar when configuring the Compose action inputs.

{
  "customer_email": triggerBody()?['customer']?['email'],
  "amount_dollars": div(triggerBody()?['amount_paid'], 100),

{
  "customer_email": triggerBody()?['customer']?['email'],
  "amount_dollars": div(triggerBody()?['amount_paid'], 100),
  "billing_period": concat(
    formatDateTime(triggerBody()?['lines']?['data']?[0]?['period']?['start'], 'MMM d'),
    ' - ',
    formatDateTime(triggerBody()?['lines']?['data']?[0]?['period']?['end'], 'MMM d, yyyy')
  ),
  "invoice_reference": concat('Stripe-', triggerBody()?['id']),
  "formatted_date": convertTimeZone(
    triggerBody()?['lines']?['data']?[0]?['period']?['start'],
    'UTC',
    'Eastern Standard Time',
    'yyyy-MM-dd'
  )
}

Condition > If yes > Add an action > QuickBooks Online

Add QuickBooks connection in Yes branch

Click 'Add an action' inside the 'If yes' branch of the condition. Search for 'QuickBooks' and select the QuickBooks Online connector. Choose 'Create invoice' action to generate the recurring invoice in your accounting system.

1. 1Click 'Add an action' in the 'If yes' branch
2. 2Search for 'QuickBooks' in the connector search
3. 3Select 'QuickBooks Online' connector
4. 4Choose 'Create invoice' action

QuickBooks action > Sign in > Intuit authorization

Authenticate QuickBooks connection

Click 'Sign in' in the QuickBooks action. You'll be redirected to Intuit's authorization page. Select your QuickBooks company from the dropdown and click 'Authorize' to grant Power Automate access to create invoices and customers.

1. 1Click 'Sign in' in the QuickBooks connector
2. 2Select your company from the dropdown
3. 3Click 'Authorize' on Intuit's page
4. 4Wait for redirect back to Power Automate

Create invoice > Customer field > Enter custom value

Map customer information

In the QuickBooks 'Create invoice' action, click the 'Customer' field dropdown. If the customer exists in QuickBooks, select from the list. For new customers, click 'Enter custom value' and map Stripe's customer email or name using dynamic content.

1. 1Click the 'Customer' dropdown in Create invoice
2. 2Select 'Enter custom value' at the bottom
3. 3Click 'Add dynamic content'
4. 4Select 'Customer Email' from Stripe trigger data

Create invoice > Line > Add new item

Configure invoice line items

Scroll down to the 'Line' section in the QuickBooks action. Click 'Add new item' to create an invoice line. Map 'Description' to Stripe's plan name, 'Amount' to the invoice total, and set 'DetailType' to 'SalesItemLineDetail' for proper accounting.

1. 1Click 'Add new item' in the Line section
2. 2Map 'Description' to Stripe's 'Lines Plan Name'
3. 3Map 'Amount' to Stripe's 'Amount Paid'
4. 4Set 'DetailType' to 'SalesItemLineDetail'

Create invoice > TxnDate and DueDate fields

Set invoice date and due date

In the invoice date fields, map 'TxnDate' to Stripe's 'Period Start' using dynamic content. This aligns the QuickBooks invoice date with the subscription billing period. Set 'DueDate' to the same value since subscription payments are processed immediately.

1. 1Click 'TxnDate' field and add dynamic content
2. 2Select 'Period Start' from Stripe trigger
3. 3Click 'DueDate' field
4. 4Select 'Period Start' again for immediate payment

Flow builder > Save > Test > Manually

Test and activate the flow

Click 'Save' at the top right to save your flow. Then click 'Test' and select 'Manually' to trigger a test run. Process a test subscription renewal in Stripe to verify the invoice appears correctly in QuickBooks with all mapped fields.

1. 1Click 'Save' in the top right corner
2. 2Click 'Test' next to Save
3. 3Select 'Manually' test option
4. 4Process a test renewal in Stripe to trigger the flow