Automated Multi-Channel Financial Reconciliation (A2X to NetSuite) (n8n)

1. **Initialize Webhook**: Create a 'Webhook' node in n8n. Set the HTTP Method to 'POST' and copy the Production URL into the A2X 'Custom Export' or Notifications settings. 2. **Configure A2X Credentials**: In n8n, create a new 'Header Auth' or 'OAuth2' credential for the A2X API to allow the workflow to fetch full payout line items if the webhook payload is summarized. 3. **NetSuite TBA Setup**: In NetSuite, create an 'Integration Record' (Check 'Token-based Authentication'). Create a 'Service Role' with 'Journal Post' permissions and assign it to a 'User'. Generate the Token ID and Secret. 4. **Credentialing in n8n**: Add a 'NetSuite ERP' node. Input your Account ID (e.g., TSTDRV12345), Consumer Key/Secret, and Token ID/Secret. 5. **Data Transformation**: Add a 'Code' node (JavaScript). Map the A2X account codes to your NetSuite Internal IDs for the Chart of Accounts. Use logic like `if (item.type === 'Sales') return 450;` to ensure binary data is converted to NetSuite-friendly JSON. 6. **Subsidiary Lookup**: Use an 'IF' node or a 'Merge' node to verify that the A2X marketplace (e.g., Amazon UK) matches the correct NetSuite Subsidiary ID and Currency to prevent posting errors. 7. **Handle Batches**: Use the 'Split In Batches' node if processing large payouts with hundreds of line items to avoid NetSuite's request size limits. 8. **Post Journal Entry**: Configure the 'NetSuite' node to 'Create Journal Entry'. Map the `lines` array from your Code node to the `lineList` in the NetSuite node using n8n expressions. 9. **Duplicate Prevention**: Add a 'No-Op' or 'Filter' node that checks for an existing External ID (the A2X Payout ID) in NetSuite before posting. 10. **Post-Process Update**: Add an 'HTTP Request' node to send a callback to A2X or an internal database marking the settlement as 'Posted-to-NetSuite' with the NetSuite Internal ID. 11. **Error Handling**: Create an 'Error Trigger' workflow. Connect it to a 'Slack' or 'Email' node to notify the accounting team if a transformation fails or if a NetSuite period is closed.

| A2X Field | NetSuite Field | Transformation / Expression | | :--- | :--- | :--- | | Settlement ID | External ID | `{{ $json["id"] }}` (Unique Constraint) | | Payout Date | Trandate | `{{ DateTime.fromISO($json["date"]).toFormat('yyyy-MM-dd') }}` | | Account Name | Account (Internal ID) | `{{ $node["Mapping"].json[$json["a2x_code"]] }}` | | Amount (Positive) | Debit | Required if Amount > 0 | | Amount (Negative) | Credit | Required if Amount < 0 (Absolute Value) | | Currency | Currency | `{{ $json["currency"] == 'GBP' ? 2 : 1 }}` (NS Internal ID) | | Marketplace | Class / Department | Use n8n `Switch` node to map Channel to Segment |

• **Rate Limiting**: NetSuite's REST Web Services/SuiteTalk API limits concurrent requests. Use n8n's 'Wait' node or 'Execute Workflow' with a queue if processing multiple payouts simultaneously. • **Date Formats**: NetSuite is highly sensitive to date formats. Always use a 'Date & Time' node or Luxon in a 'Code' node to format A2X dates to `YYYY-MM-DD`. • **Closed Periods**: If the A2X payout date is in a closed NetSuite accounting period, the node will error. Use a 'Try/Catch' logic in n8n to route these to a 'Pending Approval' custom record instead. • **Incomplete Mappings**: Ensure every A2X transaction type has a corresponding NetSuite GL account mapping in your 'Code' node; otherwise, the balance will not net to zero, and NetSuite will reject the Journal Entry.

- [ ] **Test Webhook**: Trigger a test payout from A2X and ensure n8n receives the JSON payload. - [ ] **Validate Mapping**: Use the n8n 'Execution' view to confirm credit and debit totals match the A2X total. - [ ] **Dry Run**: Post to a NetSuite Sandbox environment first and verify the Journal Entry Status is 'Unapproved' or 'Approved'. - [ ] **Check Authentication**: Ensure the NetSuite TBA token hasn't expired and the role has 'Web Services Only' disabled for testing. - [ ] **Error Path**: Intentionally break a mapping and ensure the n8n Error Workflow triggers a notification.