A fully automated financial workflow where every A2X settlement triggers a balanced, categorized Journal Entry in NetSuite, mapped to the correct Subsidiaries, Departments, and Classes for instant reconciliation.
The Problem
Ecommerce payouts from marketplaces like Amazon or Shopify are complex aggregates of sales, refunds, and fees. Manually reconciling these into NetSuite's General Ledger is time-consuming and prone to human error, specially when dealing with multi-subsidiary environments.
The Outcome
A fully automated financial workflow where every A2X settlement triggers a balanced, categorized Journal Entry in NetSuite, mapped to the correct Subsidiaries, Departments, and Classes for instant reconciliation.
Step-by-Step Guide
1. **Authenticate A2X**: In Zapier, create a new Zap and select A2X as the Trigger app. Choose 'Settlement Finalized' as the event. Connect your A2X account using your API key.
2. **Setup Trigger Filter**: Use 'Filter by Zapier' to ensure the Zap only continues if the 'Status' from A2X equals 'Posted'. This prevents draft or pending settlements from hitting your books.
3. **Map NetSuite Account Codes**: Add a 'Formatter by Zapier' step (Utilities -> Lookup Table). Map the A2X Transaction Types (e.g., 'Amazon Commission') to your internal NetSuite Account Internal IDs (e.g., '405').
4. **Authenticate NetSuite (TBA)**: Choose NetSuite as the Action app and 'Create Journal Entry' as the event. You must use Token-Based Authentication (TBA). Input your Account ID, Consumer Key, Consumer Secret, Token ID, and Token Secret.
5. **Configure Journal Header**: Map the 'Settlement Date' to the 'Tran Date' field. Select the correct 'Subsidiary' using its Internal ID. Set 'Posted' as the status.
6. **Build Journal Lines**: Under 'Line Items', use the data from the A2X payout. Map the NetSuite Account ID (from your Lookup Table step), Amount (Debit/Credit logic), and Memo (Settlement ID).
7. **Assign Segments**: Map A2X 'Marketplace' or 'Region' fields to NetSuite 'Class' or 'Department' fields to maintain granular reporting.
8. **Enable Error Handling**: Click the '+' after the NetSuite step and add a 'Path' or 'Filter' to catch 'false' success triggers. Alternatively, use 'Zapier Manager' to monitor for task failures.
9. **Close the Loop**: Add a final A2X action 'Update Settlement' to write the NetSuite Journal Internal ID back to the A2X notes for easy cross-referencing.
10. **Test & Publish**: Run a test with a recent settlement. Verify the Journal Entry balance (Debits = Credits) in NetSuite before turning the Zap on.