A fully automated financial pipeline where every sale from any channel is transformed into a Sales Receipt or Invoice in QuickBooks. This ensures customer records are deduplicated, tax codes are applied correctly based on geography, and stock levels remain synced between the warehouse and the balance sheet.
The Problem
Multi-channel sellers often face manual data entry errors and 'disconnected' inventory when revenue is captured across Amazon, eBay, and Shopify but accounting lags behind. This leads to inaccurate tax reporting, mismatched customer records, and lack of real-time visibility into Cost of Goods Sold (COGS).
The Outcome
A fully automated financial pipeline where every sale from any channel is transformed into a Sales Receipt or Invoice in QuickBooks. This ensures customer records are deduplicated, tax codes are applied correctly based on geography, and stock levels remain synced between the warehouse and the balance sheet.
Step-by-Step Guide
1. **Create Workflow & Webhook Node**: In n8n, start with a 'Webhook' node. Set the HTTP Method to POST. This URL will be placed in your Multi-Channel tool as the 'Order Created' notification endpoint.
2. **Configure Credentials**: Go to the 'Credentials' tab in n8n and add 'QuickBooks Online OAuth2'. Follow the prompt to authorize n8n to access your QuickBooks company file.
3. **Transform Data (Set Node)**: Add a 'Set' node to map the incoming JSON from the Webhook into clean variables. Use expressions like `{{ $json.body.order_total }}` to normalize fields before they hit QuickBooks.
4. **Search for Existing Customer**: Use the 'QuickBooks' node with the 'Customer' resource and 'Get All' operation. Use a filter expression: `DisplayName = {{ $node["Set"].json["customer_name"] }}` to check if they exist.
5. **Branching Logic (IF Node)**: Use an 'IF' node to check the length of the results from the search step. If `{{ $node["QuickBooks"].json.length }} === 0`, route to a 'Create Customer' node; otherwise, proceed to the next step.
6. **Create Sales Receipt**: Connect to a 'QuickBooks' node, select 'Sales Receipt' and 'Create'. Map your fields using n8n expressions. Ensure the 'Line Items' are mapped by toggling the 'Expressions' mode for the item list to handle multiple products in one order.
7. **Tax & Discount Processing**: Use the 'Code' node (JavaScript) if complex tax calculations or multi-currency conversions are required before sending the final payload to QuickBooks.
8. **Inventory Adjustment**: Add another QuickBooks node to 'Update' an Item. This allows you to decrease the 'Quantity on Hand' based on the quantity sold in Tool A.
9. **Global Error Handling**: Create a separate workflow with an 'Error Trigger'. In your main workflow, go to 'Settings' and select this error workflow. This ensures that if the QuickBooks API is down, you are alerted via Slack or Email immediately.