A2X Payout Reconciliation and Automated Audit Documentation (Make.com)

1. **Establish Webhook Connection**: Create a new Scenario in Make.com. Add a 'Custom Webhook' module. Copy the URL and paste it into A2X under Settings > Notifications/Webhooks to trigger when a settlement is 'Posted'. 2. **Initialize Variables**: Use a 'Set Multiple Variables' module to parse the A2X payload, specifically extracting the `SettlementID`, `Total_Sales`, and an array of `Fee_Lines`. 3. **Validate Chart of Accounts**: Add a QuickBooks Online 'Search for Objects' module. Map the incoming transaction category from A2X to the 'Name' field in QBO to ensure the ledger exists. 4. **Handle Missing Accounts**: Add a 'Router' after the search. If the search returns 0 results, route to a QuickBooks 'Create an Account' module to dynamically generate the missing ledger (e.g., a new Shopify App fee). 5. **Aggregate Line Items**: Use an 'Iterator' to loop through the A2X transaction lines (Sales, Fees, Tax). Then, use an 'Array Aggregator' to format these into the specific nested JSON structure required by the QBO 'Create a Journal Entry' module (Debit/Credit lines). 6. **Create Journal Entry**: Add the QuickBooks Online 'Create a Journal Entry' module. Map the aggregated array to the 'Line' field. Use the A2X `SettlementID` as the 'DocNumber' to prevent duplicates. 7. **Fetch Source Documentation**: Add an A2X 'Get an Export File' module (or use 'HTTP: Get a file' with the settlement PDF URL provided in the webhook payload). 8. **Attach to Entry**: Add a QuickBooks Online 'Create an Attachment' module. Map the `JournalEntry ID` from Step 6 to the 'Attachable' reference and upload the file buffer from Step 7. 9. **Configure Error Handling**: Right-click the QuickBooks modules and select 'Add Error Handler' (Break or Rollback). Configure a notification via Slack or Email to alert the accounting team if a mapping fails.