How to Sync Stripe Subscription Renewals to QuickBooks with N8n

Workflows > New > Trigger Nodes > Stripe

Set up Stripe webhook trigger

Configure N8n to receive webhook notifications when Stripe subscriptions renew. This creates the foundation for real-time invoice creation in QuickBooks.

1. 1Click the + button to add a new workflow
2. 2Select 'Stripe Trigger' from the trigger nodes list
3. 3Choose 'Webhook' as the trigger type
4. 4Copy the generated webhook URL from the node panel

Stripe Dashboard > Developers > Webhooks

Configure Stripe webhook endpoint

Register your N8n webhook URL in Stripe's dashboard to receive invoice.payment_succeeded events. This ensures Stripe sends renewal notifications to your workflow.

1. 1Log into your Stripe dashboard and navigate to Developers > Webhooks
2. 2Click 'Add endpoint' button
3. 3Paste your N8n webhook URL into the endpoint URL field
4. 4Select 'invoice.payment_succeeded' from the events list
5. 5Click 'Add endpoint' to save

N8n > Stripe Trigger > Authentication

Add webhook signature verification

Secure your webhook by verifying Stripe's signature. This prevents unauthorized requests from triggering invoice creation.

1. 1Copy the signing secret from your Stripe webhook endpoint page
2. 2Return to N8n and click on the Stripe Trigger node
3. 3Paste the signing secret into the 'Webhook Secret' field
4. 4Toggle 'Verify Webhook Signature' to enabled

Logic Nodes > IF

Filter for subscription renewals only

Add a filter to process only recurring subscription payments, not one-time invoices. This prevents creating QuickBooks invoices for non-subscription charges.

1. 1Click the + button after your Stripe Trigger
2. 2Select 'IF' from the logic nodes
3. 3Set condition to 'data.object.subscription' 'is not empty'
4. 4Add second condition 'data.object.billing_reason' 'equals' 'subscription_cycle'

Drop this into an n8n Code node.

// Convert Stripe Unix timestamp to QuickBooks date format
{{ new Date($node['Stripe Trigger'].json['data']['object']['period_start'] * 1000).toISOString().split('T')[0] }}
// Check if customer exists before creating invoice

// Convert Stripe Unix timestamp to QuickBooks date format
{{ new Date($node['Stripe Trigger'].json['data']['object']['period_start'] * 1000).toISOString().split('T')[0] }}

// Check if customer exists before creating invoice
{{ $node['Stripe Trigger'].json['data']['object']['customer_email'] ? $node['Stripe Trigger'].json['data']['object']['customer_email'] : '[email protected]' }}

Nodes > QuickBooks > Credentials

Connect QuickBooks credentials

Authenticate with QuickBooks Online API to enable invoice creation. N8n needs OAuth access to write invoices to your accounting system.

1. 1Add a QuickBooks node after the IF node's 'true' branch
2. 2Click 'Create New' next to Credential for QuickBooks
3. 3Select 'OAuth2' authentication method
4. 4Click 'Connect my account' and authorize N8n in QuickBooks
5. 5Select your QuickBooks company from the dropdown

QuickBooks Node > Resource & Operation

Set QuickBooks operation to create invoice

Configure the QuickBooks node to create invoices with the correct operation type. This determines what data structure N8n expects for the invoice creation.

1. 1In the QuickBooks node, set Resource to 'Invoice'
2. 2Set Operation to 'Create'
3. 3Toggle 'Additional Fields' to show more options
4. 4Set 'Include in Annual Tax Report' to true for MRR tracking

QuickBooks Node > Customer Fields

Map customer data from Stripe to QuickBooks

Link the Stripe customer information to your QuickBooks customer records. This ensures invoices are created under the correct customer account.

1. 1Click in the Customer field and select 'Add Expression'
2. 2Enter expression: {{$node['Stripe Trigger'].json['data']['object']['customer_email']}}
3. 3Set Customer Email to the same expression
4. 4Set Customer Name to {{$node['Stripe Trigger'].json['data']['object']['customer_name']}}

QuickBooks Node > Line Items

Configure invoice line items

Map subscription details to invoice line items including amount, description, and tax settings. This creates the actual billable items in QuickBooks.

1. 1Scroll to Line Items section and click 'Add Line Item'
2. 2Set Description to {{$node['Stripe Trigger'].json['data']['object']['lines']['data'][0]['description']}}
3. 3Set Amount to {{$node['Stripe Trigger'].json['data']['object']['amount_paid'] / 100}}
4. 4Set Income Account to your recurring revenue account ID
5. 5Toggle 'Taxable' based on your tax requirements

QuickBooks Node > Invoice Details

Set invoice dates and terms

Configure invoice timing to match your subscription billing cycle. This ensures proper MRR recognition in your accounting periods.

1. 1Set Invoice Date to {{$node['Stripe Trigger'].json['data']['object']['period_start']}}
2. 2Set Due Date to {{$node['Stripe Trigger'].json['data']['object']['period_end']}}
3. 3Set Terms to 'Net 0' since payment is already collected
4. 4Add Reference Number: {{$node['Stripe Trigger'].json['data']['object']['id']}}

Node Context Menu > Error Handling

Add error handling for failed syncs

Implement retry logic for API failures or rate limits. This prevents lost invoices when QuickBooks or Stripe APIs are temporarily unavailable.

1. 1Right-click the QuickBooks node and select 'Add Error Handling'
2. 2Choose 'Continue on Fail' option
3. 3Add a 'Wait' node after error output with 30 second delay
4. 4Connect Wait node back to QuickBooks node for retry
5. 5Set maximum retries to 3 attempts

Stripe Dashboard > Webhooks > Test

Test with sample webhook data

Validate your workflow using Stripe's webhook testing tool. This confirms field mapping and QuickBooks integration work correctly before going live.

1. 1Return to Stripe dashboard > Webhooks > Your endpoint
2. 2Click 'Send test webhook' button
3. 3Select 'invoice.payment_succeeded' event template
4. 4Click 'Send test webhook' to trigger your N8n workflow
5. 5Check N8n execution log for successful QuickBooks invoice creation

Workflow Header > Activation Toggle

Activate workflow for live subscriptions

Enable the workflow to process real subscription renewals. Your automation will now create QuickBooks invoices automatically when customers are billed.

1. 1Click the toggle switch at the top of your N8n workflow
2. 2Verify the workflow status shows 'Active' with a green indicator
3. 3Monitor the execution log for the next few subscription renewals
4. 4Check QuickBooks for new invoices matching your Stripe renewals

Drop this into an n8n Code node.

// Convert Stripe Unix timestamp to QuickBooks date format
{{ new Date($node['Stripe Trigger'].json['data']['object']['period_start'] * 1000).toISOString().split('T')[0] }}
// Check if customer exists before creating invoice

// Convert Stripe Unix timestamp to QuickBooks date format
{{ new Date($node['Stripe Trigger'].json['data']['object']['period_start'] * 1000).toISOString().split('T')[0] }}

// Check if customer exists before creating invoice
{{ $node['Stripe Trigger'].json['data']['object']['customer_email'] ? $node['Stripe Trigger'].json['data']['object']['customer_email'] : '[email protected]' }}